MT4 to Excel through Excel RTD (Finally!) | Page 24 | Forex Factory

Options

Go to
Permalinks
Print Thread

Related Instruments

EUR/USD, EUR/JPY, GBP/USD

Similar Threads

Calculating EMA strength like RTD on break free trading 0 replies

MT4 RTD API 0 replies

MT4 export to Excel? 8 replies

How to copy profiles in MT4? How to use Excel with MT4? 7 replies

Integration between excel and MT4 prices 3 replies

Attachments: MT4 to Excel through Excel RTD (Finally!)
Exit Attachments

MT4 to Excel through Excel RTD (Finally!)

  • #461
  • Edited 10:08am Mar 11, 2021 8:54am | Edited 10:08am
Quoting garfield75
{quote} CSM and multiple timeframe trend confluence to create directional bias for the currency trend strength. Next step to create some regression analysis to identify outliers and then take counter-trend trade for mean reversion. {image}
Regression analysis and mean reversion best candidate is EURUSD as per my experience from both spot and futures trading.
Selling future options of not less than 120 days maturity in 1 year can fetch 60% return based on margin deposit.
One contract of EU CME futures options needs $7,000 as margin including 40% cushion capital.
Practice makes a person perfect
  • #462
  • Mar 11, 2021 9:01am Mar 11, 2021 9:01am
Quoting Revsss
{quote} I am sorry I dont understand whats a dummy\mockup in excel, yes I know this will work cuz I know someone that use the same Idea but I don't know the formula to it. Here is the excel that I want to create, It shows how many PIPS that a currency or pair generated during the 1H Candle {image}

I started doing it but wanted to clarify something first:

1-The screenshot you showed is the range of hourly pips rather than a percentage. We already have an (indicator) that can get the range. I think it is something like @Range. For percentages, we can use the @ Range with the current close Range/current low *100 same as in (High-Low)/Low *100.

2-You mentioned a different formula as well which is (Current close -previous close)/the Previous close *100. This will simply give us the magnitude of momentum from one bar to another through the day by tracking closes only.

Anyway, let me know which one you're after (Range in Pips) as in the screenshot, Range as in percentage for each 1-hour bar, or percentage change from one close to another.
  • #463
  • Mar 11, 2021 9:07am Mar 11, 2021 9:07am
Quoting garfield75
{quote} CSM and multiple timeframe trend confluence to create directional bias for the currency trend strength. Next step to create some regression analysis to identify outliers and then take counter-trend trade for mean reversion. {image}
I remember NZDCAD was one of the good candidates.

Nevertheless, mean reversion needs backtesting..
  • #464
  • Mar 11, 2021 9:21am Mar 11, 2021 9:21am
Quoting mtharwat
{quote} Hi Simnz, I wanted to comment on the general idea of Strength trading. Maybe you share my view on how to accomplish this and for others to comment so allow me to think out loud. One of the main things I wanted to accomplish is to "Test at least six months of data" for trading based on any "Logic" for currency strength; let it be: price action, SMA, RSI, CCI, etc... BTW: SMA (1) will be the same as the price itself. So if it is increasing the last three bars in most of the pairs, then we have strength. I can do a dashboard if needed. Back...
I dont use any indictors which can force my brain to depend on for signals and hamper my decision taking ability. I use informaton indicator that generates cv spreadsheet files for virtual (lookback) trading statstics . All indictors that help visual manual trading as well. Thousands of free EA are available. I ignore any EA based on TA . Use only statistic based EAs which use like ADR , YHL or pip height, bar widths to generate entries. I use consecutive candles in M30 TF as providing momentum confirmation.
I dont use any MAs except for establishing trend by RSI only.
You can always find EAs which are like templates that can be adopted for all kinds of possible trade execution situations. You can also find indicators which can easily be embedded in an EA template for signal generation. I am 72 and lack energy .Always looking for time saving devices.
Practice makes a person perfect
  • #465
  • Mar 11, 2021 9:31am Mar 11, 2021 9:31am
Quoting simnz
{quote} I dont use any indictors which can force my brain to depend on for signals and hamper my decision taking ability. I use informaton indicator that generates cv spreadsheet files for virtual (lookback) trading statstics . All indictors that help visual manual trading as well. Thousands of free EA are available. I ignore any EA based on TA . Use only statistic based EAs which use like ADR , YHL or pip height, bar widths to generate entries. I use consecutive candles in M30 TF as providing momentum confirmation. I dont use any MAs except for...
I use EAs to trade dummy on MT4. I trade on IB using manual trading. Dummy trading is to study strategy or sometimes for contrarian trading too. So my trade exlorer reflects experimental trading.
Practice makes a person perfect
  • #466
  • Mar 11, 2021 9:44am Mar 11, 2021 9:44am
Quoting garfield75
{quote} CSM and multiple timeframe trend confluence to create directional bias for the currency trend strength. Next step to create some regression analysis to identify outliers and then take counter-trend trade for mean reversion. {image}
You have a flair for colors and art.
Your dashboard is a piece of art.
Practice makes a person perfect
  • #467
  • Mar 11, 2021 7:24pm Mar 11, 2021 7:24pm
Quoting simnz
{quote} You have a flair for colors and art. Your dashboard is a piece of art.
Thanks. Green or Red visually gives you a very quick overview of the market
Trading is SIMPLE not EASY.
  • #468
  • Mar 12, 2021 4:59am Mar 12, 2021 4:59am
Quoting mtharwat
{quote} I started doing it but wanted to clarify something first: 1-The screenshot you showed is the range of hourly pips rather than a percentage. We already have an (indicator) that can get the range. I think it is something like @Range. For percentages, we can use the @ Range with the current close Range/current low *100 same as in (High-Low)/Low *100. 2-You mentioned a different formula as well which is (Current close -previous close)/the Previous close *100. This will simply give us the magnitude of momentum from one bar to another through...
Yes I am sorry that I did not clarify the picture I send, I am after both of them, Percentage and PIPS values, I can go either of the two, well so to make things easier to understand, I want to know the Percentage of the 1H Candles, yes the formula I mentioned is the only formula I know unfortunately, it only gives data for the current value of the 1H candle, the thing that I want to achieve is to get the Percentage on current to close of the 1H Candle, which saved the percentage when the 1H candle closed, then another 1H candle will form, the formula I mentioned only shows recent 1H candle percentage, when the candle 1H candle close, it generate a new percentage based on the new 1H candle, which did not achieve what I want to happen... thank you for helping me, I am just new to excel and I am sorry...
  • #469
  • Mar 12, 2021 5:35am Mar 12, 2021 5:35am
Quoting kevhill1
{quote} Sorry I have read, and then re-read your questions and I still really don't understand at all what you are trying to do/achieve. If you are looking at comparing the close of each H1 candle over the last 24 hours isn't that more easily done using bar history rather than trying to store away values? To do that create the close of each hour in a diff cell using this =RTD("FXBlueLabs.ExcelRTD", ,"156734", "@bh,EURUSD,H1,close,0"), =RTD("FXBlueLabs.ExcelRTD", ,"156734", "@bh,EURUSD,H1,close,1") etc etc. And then calculate the diff from that?...
Thank you! even you don't understand my questions, you answered my question and its working! thanks
  • #470
  • Mar 12, 2021 6:37am Mar 12, 2021 6:37am
Hello Guys,

Very interesting tread.

I found this youtube channel about this excel strategy. Just share the information. maybe we can take some ideas.

https://www.youtube.com/channel/UCRs...Plu5Fyg/videos



Thank you!
  • #471
  • Mar 12, 2021 5:45pm Mar 12, 2021 5:45pm
Hi Garfield.

Yes it got there in the end after rejigging the code. I also have a time stamp check built in as well. Occasionally it will execute two rather than one as there are a huge number of calculations to perform but I can live with that as my percentage risk is 1% per trade.

Cheers

Camo
  • #472
  • Mar 12, 2021 8:07pm Mar 12, 2021 8:07pm
Quoting urspolar
Hello Guys, Very interesting tread. I found this youtube channel about this excel strategy. Just share the information. maybe we can take some ideas. https://www.youtube.com/channel/UCRs...Plu5Fyg/videos Thank you!
Nice one. Definitely some nice ideas
Trading is SIMPLE not EASY.
  • #473
  • Mar 12, 2021 8:11pm Mar 12, 2021 8:11pm
Had the excel on and off during entire week, when I notice a market bias in the strategy, had to go through a lot of formulas and code to identify the root cause and fix it.
Should be back to normal from next week.
Attached Image (click to enlarge)
Click to Enlarge Name: 7eeb8d8fd8395f2572d352282f5c44a7.png Size: 105 KB
Trading is SIMPLE not EASY.
  • #474
  • Mar 14, 2021 8:29pm Mar 14, 2021 8:29pm
Hello. Subscribed to this thread. May I know how can I run this RTD? It seems like I'm doing it wrong. All of the values are N/A. What to do? Thanks!
  • #475
  • Mar 14, 2021 10:10pm Mar 14, 2021 10:10pm
Quoting iShiHara
Hello. Subscribed to this thread. May I know how can I run this RTD? It seems like I'm doing it wrong. All of the values are N/A. What to do? Thanks!

Use any of the dashboards here in the thread and type your account number in the (Account Cell). That should fix it.
  • #476
  • Mar 15, 2021 8:29pm Mar 15, 2021 8:29pm
There were trades that should have been closed or entered. I tried to log on to my VPS but can not connect to the remote PC Do not understand. Was the virtual PC shut down yesterday night? Or the server went down?

I sent a support ticket to inquire..

Did anyone experience similar incidents with his VPS?
  • #477
  • Mar 15, 2021 8:33pm Mar 15, 2021 8:33pm
Quoting mtharwat
There were trades that should have been closed or entered. I tried to log on to my VPS but can not connect to the remote PC Do not understand. Was the virtual PC shut down yesterday night? Or the server went down? I sent a support ticket to inquire.. Did anyone experience similar incidents with his VPS?
Which service provider are you using for VPS?
I am on Azure and AWS, no issues
Trading is SIMPLE not EASY.
  • #478
  • Mar 15, 2021 9:11pm Mar 15, 2021 9:11pm
Quoting garfield75
{quote} Which service provider are you using for VPS? I am on Azure and AWS, no issues
FXVPSPRO
  • #479
  • Mar 15, 2021 9:41pm Mar 15, 2021 9:41pm
Quoting garfield75
{quote} Which service provider are you using for VPS? I am on Azure and AWS, no issues
If your use will be restricted to MT4 and EAs, would you prefer a more dedicated server for trading or not really? How do they schedule their maintenance/shutdowns i.e(during weekends or during the week, etc..)
  • #480
  • Mar 15, 2021 10:26pm Mar 15, 2021 10:26pm
Quoting mtharwat
{quote} If your use will be restricted to MT4 and EAs, would you prefer a more dedicated server for trading or not really? How do they schedule their maintenance/shutdowns i.e(during weekends or during the week, etc..)
The advantage with AWS and Azure is that I get a barebone Windows machine, which I can configure/install anything. Increase or decrease resources with a click.
Start and shutdown whenever I want. I can manage/control all updates and maintenance.
Based on the server configuration you can run up to 20-25 instances of MT4 on a single machine.

However, it is not cheap. That is my last 6 months spent breakdown by month in USD
Attached Image (click to enlarge)
Click to Enlarge Name: 2565a2a50939613765e7b2dee8f80574.png Size: 26 KB
Trading is SIMPLE not EASY.
0 traders viewing now