MT4 to Excel through Excel RTD (Finally!) | Page 23 | 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!)

  • #441
  • Mar 7, 2021 5:58am Mar 7, 2021 5:58am
Quoting garfield75
{quote} All started at the same time. S-2 & S-3 combined has given 5% over 2/5 Weeks, It is a very good return by itself. S-1 is currently stealing the thunder.

Is strategy 1, the one you have previously mentioned with Stochastics? If so, how many pairs do you apply it on?
  • #442
  • Mar 8, 2021 12:56am Mar 8, 2021 12:56am
Quoting mtharwat
{quote} Is strategy 1, the one you have previously mentioned with Stochastics? If so, how many pairs do you apply it on?
These are pairs for Strategy 1. Stochastics related one is S-3

 

  1. gbpjpy
  2. gbpnzd
  3. audjpy
  4. cadjpy
  5. gbpcad
  6. gbpaud
  7. gbpchf
  8. gbpusd
  9. nzdjpy
  10. usdcad
  11. eurcad
  12. euraud
  13. eurusd
  14. eurnzd
  15. audusd
  16. eurgbp
  17. nzdcad
  18. usdchf
  19. usdjpy
  20. nzdchf
  21. audnzd
  22. audcad
  23. audchf
  24. cadchf

Trading is SIMPLE not EASY.
  • #443
  • Mar 8, 2021 4:47am Mar 8, 2021 4:47am
Quoting garfield75
{quote} These are pairs for Strategy 1. Stochastics related one is S-3 gbpjpy gbpnzd audjpy cadjpy gbpcad gbpaud gbpchf gbpusd nzdjpy usdcad eurcad euraud eurusd eurnzd audusd eurgbp nzdcad usdchf usdjpy nzdchf audnzd audcad audchf cadchf
so what is strategy 1 about if it is ok to explain it.
  • #444
  • Mar 8, 2021 5:06am Mar 8, 2021 5:06am
Quoting mtharwat
{quote} so what is strategy 1 about if it is ok to explain it.
Strategy 1 is a combination of currency strength and directional trend trading.
Trading is SIMPLE not EASY.
  • #445
  • Edited 8:33pm Mar 8, 2021 8:10pm | Edited 8:33pm
I opened a new account dedicated only for EAs testing so trades can be tracked without influencing my manual live account.
I advise anyone to do the same and allocate an account for EAs only.
If one applies more than one EA/Strategy, there are tools to do this work and give you the performance of each EA separately. I think FXBLUE Labs has something to offer but have not checked it yet.

The account is in FF forex factory explorer. It does not show anything yet as there are no open trades.

-----

The strategy rules:
A dashboard for SMA 5 in both Daily and H4.
Trade the pairs that are mostly bullish against mostly bearish in Daily/H4.
In M15, I need a crossover of SMA7 and SMA21 in the direction of H4 and Daily.
For long: Price is above SMA7 and a fresh crossover occurred in the previous bar.
Stop Loss/Target profit are in percentages of Price.
Max open trades are 3

I have not analyzed price action and wanted to see the performance with these simple rules in a mechanical way. In the future, I intend to do my analysis and influence my decisions.

I created the EA based on these rules and assigned the direction for longs only or short only. Max trades are 6 and max long and short trades are three each. When the dashboard changes its color or the pairs themselves go into consolidation or big losses are encountered, I will close the trades and wait for a new signal/bias.

----

Here is a screenshot of the dashboard:
Attached Image (click to enlarge)
Click to Enlarge Name: SMA 5.png Size: 36 KB


The pairs I chose to trade based on the Dashboard:

USDJPY Long
CADJPY Long
AUDUSD Short
AUDCAD Short
NZDUSD Short

All trades are run on a server.

----

Will update
  • #446
  • Mar 9, 2021 5:47am Mar 9, 2021 5:47am
Guys I need help, I don't know how to formulate this
this is the formula I use for computing the percentage of a currency pair
=RTD("fxbluelabs.excelrtd",,AD3,CONCATENATE("@bh,",J18,",","60",",","Close",",","0"))
=RTD("fxbluelabs.excelrtd",,AD3,CONCATENATE("@bh,",J18,",","60",",","Close",",","1"))
Then =(I10-I9)/I9*1 to get the Percentage

I want to do is save or record the Value of the 1H Candle, when it finish forming it will record or save the percentage on a cell then a new 1H Candle is forming which is place on another cell, so each 1H candle have 1 Cell, it is also based on GMT Time, I want to know the Percentage of a currency pair based on 1H Candle, so basically for Daily Candle Percentage it is the same with 24 of 1H Candle when combined

Please I need help, thank you for the response!
Attached Image (click to enlarge)
Click to Enlarge Name: d8d9f662f1d5efea3330ca366001f572.png Size: 44 KB
  • #447
  • Mar 9, 2021 9:31am Mar 9, 2021 9:31am
Quoting Camo
HI Garfield. Thanks for the reply. I agree it can be hit and miss and yes I do run it 24/5. I think the issue is two fold being: 1) Excel RTD seems to clag out if the aggregate of the RTD data takes more than 2 milliseconds to calculate. 2) my model only really starts skipping a beat during the NY start when volume kicks in. The problem is that once it gets in the loop it won't stop. I took 816 trades in four hours on Friday lol. In am attempt to remedy the situation I have 1) reduced the throttle time to 0.05% of the standard throttle. 2) put in...

Hi Camo,
did the timer/wait code resolve your issue?
In my excel, I use timestamp check, update a cell with trade execution time for specific FX pair and then I check in VBA if the time diff is less than 30 Min from previous trade for the pair then to ignore the setup.

Cheers
Trading is SIMPLE not EASY.
  • #448
  • Mar 10, 2021 3:17am Mar 10, 2021 3:17am
Quoting garfield75
{quote} Strategy 1 is a combination of currency strength and directional trend trading.
Currency Strength is based on what?
My experience with MADASH was good. A good t tool on FF for currency strength and directional trend.
However, I am single symbol user and prefer to trade based on Momentum rather than trend or competitor's strength.
Practice makes a person perfect
  • #449
  • Edited 3:51am Mar 10, 2021 3:29am | Edited 3:51am
Quoting simnz
{quote} Currency Strength is based on what? My experience with MADASH was good. A good t tool on FF for currency strength and directional trend. However, I am single symbol user and prefer to trade based on Momentum rather than trend or competitor's strength.
The way I measured strength was by making 8 groups of main currency families.

Example:
Eur family
EU, EJ, Echf, Eaud, Enzd, Ecad, EG,

I did not use MA for trend.

Strength was based on minimum pip ticks.
Example: GBPJPY is the symbol to trade
GBP is the family

If I say 5 pips ticks from at least 5 members from GBP family are in the same direction pushing up GBP as a the family then enter buy of GBPJPY .
Entry logic based only on strength of the Family. If all 7 family members join hands and push the family then the expectation is that family member GBPJPY will go up.
Practice makes a person perfect
  • #450
  • Mar 10, 2021 6:36am Mar 10, 2021 6:36am
Quoting mtharwat
{quote}
... There are also a couple of products that communicate between Excel and MT4.. One is designed for coders and developers in which it can read and write to Excel (Two way). For example, you create an indicator in Excel then you can see it in MT4. But this product requires programming knowledge. There is another product that is very easy to use for any excel user to trade directly from excel without any VBA with simple syntaxes. This product can retrieve all indicators from MT4. However, it differs from EXCEL RTD in that the previously...
That all sounds really interesting. Could you please PM me to tell me the names? I am new and haven't gotten competent with the interface yet to start a PM.
  • #451
  • Mar 10, 2021 10:31am Mar 10, 2021 10:31am
Quoting Revsss
Guys I need help, I don't know how to formulate this this is the formula I use for computing the percentage of a currency pair =RTD("fxbluelabs.excelrtd",,AD3,CONCATENATE("@bh,",J18,",","60",",","Close",",","0")) =RTD("fxbluelabs.excelrtd",,AD3,CONCATENATE("@bh,",J18,",","60",",","Close",",","1")) Then =(I10-I9)/I9*1 to get the Percentage I want to do is save or record the Value of the 1H Candle, when it finish forming it will record or save the percentage on a cell then a new 1H Candle is forming which is place on another cell, so each 1H candle...

Guys pls notice my post
  • #452
  • Mar 11, 2021 1:12am Mar 11, 2021 1:12am
Quoting Revsss
{quote} Guys pls notice my post

Hi,
I am sorry for my late reply. I got caught with trading, testing EAs, family, and few other things. D:

To record a value from a dynamic changeable cell to a static cell is a VBA thing which is not my area of expertise. I was looking for something like this before and it only worked when I manually change the value. However, Garfield had a solution to send a message through telegram. If you search for 'Telegram' in this thread, you will find it.

Regarding a VBA to do this task, I personally have tried and searched a lot but could not find a solution.

Your second option is to use the same formulas by going back to candle no24 and drag fill the percentage formula. However, the only problem would be wasting too many data requests for each pair.

May I ask, why are you looking precisely for the range of each hour to construct the Daily Range?
  • #453
  • Mar 11, 2021 7:23am Mar 11, 2021 7:23am
Quoting mtharwat
{quote} Hi, I am sorry for my late reply. I got caught with trading, testing EAs, family, and few other things. D: To record a value from a dynamic changeable cell to a static cell is a VBA thing which is not my area of expertise. I was looking for something like this before and it only worked when I manually change the value. However, Garfield had a solution to send a message through telegram. If you search for 'Telegram' in this thread, you will find it. Regarding a VBA to do this task, I personally have tried and searched a lot but could not...
Thanks for the response! can you give me the formula for the second option? I don't know other formula.. Thanks!

I know someone that use the same Idea on tracking down how many percentage or PIPS of a currency pair move based on the 1H Candle, its just let you know possible reversal or strength of the currency in a given period of time or market session
  • #454
  • Mar 11, 2021 7:29am Mar 11, 2021 7:29am
Quoting Revsss
Guys I need help, I don't know how to formulate this this is the formula I use for computing the percentage of a currency pair =RTD("fxbluelabs.excelrtd",,AD3,CONCATENATE("@bh,",J18,",","60",",","Close",",","0")) =RTD("fxbluelabs.excelrtd",,AD3,CONCATENATE("@bh,",J18,",","60",",","Close",",","1")) Then =(I10-I9)/I9*1 to get the Percentage I want to do is save or record the Value of the 1H Candle, when it finish forming it will record or save the percentage on a cell then a new 1H Candle is forming which is place on another cell, so each 1H candle...
are you able to create a dummy/mockup in Excel how you think this will work and attach it here.
Trading is SIMPLE not EASY.
  • #455
  • Mar 11, 2021 7:34am Mar 11, 2021 7:34am
Quoting garfield75
{quote} are you able to create a dummy/mockup in Excel how you think this will work and attach it here.
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
Attached Image (click to enlarge)
Click to Enlarge Name: 05e8a665b3bc9347bf73d134158b0160.png Size: 227 KB
  • #456
  • Mar 11, 2021 7:43am Mar 11, 2021 7:43am
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}
How well do you know excel or formulas or excel RTD to start creating an excel-like that? Do you have advance knowledge to work on it or are you expecting members here to do the heavy lifting for you?
Trading is SIMPLE not EASY.
  • #457
  • Mar 11, 2021 8:06am Mar 11, 2021 8:06am
Quoting garfield75
{quote} How well do you know excel or formulas or excel RTD to start creating an excel-like that? Do you have advance knowledge to work on it or are you expecting members here to do the heavy lifting for you?
I am new to excel RTD, I am just asking if anyone has any Idea how to formulate it cuz I don't know how, and no I didnt expect members to do it for me, I am just asking, so whats the purpose of this group? I though its to help each other on how to use Excel RTD? If that's what you think, then don't waste your time bothering my post then
  • #458
  • Edited 8:49am Mar 11, 2021 8:29am | Edited 8:49am
Quoting simnz
{quote} The way I measured strength was by making 8 groups of main currency families. Example: Eur family EU, EJ, Echf, Eaud, Enzd, Ecad, EG, I did not use MA for trend. Strength was based on minimum pip ticks. Example: GBPJPY is the symbol to trade GBP is the family If I say 5 pips ticks from at least 5 members from GBP family are in the same direction pushing up GBP as a the family then enter buy of GBPJPY . Entry logic based only on strength of the Family. If all 7 family members join hands and push the family then the expectation is that family...

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 to the topic:

I found a nice EA building tool that is totally free and hence, it won't be an advertisement. It is from Algo Wizard. If mods are reading and objecting me mentioning the name, I can delete it. Anyway, this tool is better than the commercial tool I have already purchased as it allows conditioning orders based on indicator values from other pairs. The only drawdown is that it allows one single time frame. So I cannot for example get Daily and H4 values for all EUR pairs. Only one-time frame for strength/basket groups.

There is a bit of a learning curve on how to use it but nevertheless, it would allow testing any (CSM logic) in MT4/MT5/Tradestation.

I need to delve into it a bit more.

----------------

At the same time, I am looking for indicators that have the ability to get values from other indicators in MQL4 so I can upload it to my EA building tool (the commercial one) but could not find a reliable one. I think I can use the before mentioned free tool for creating signals based on currency strength but prefer for the time being if there is something that has already been coded.

--------------
  • #459
  • Mar 11, 2021 8:39am Mar 11, 2021 8:39am
Quoting simnz
{quote} Currency Strength is based on what? My experience with MADASH was good. A good t tool on FF for currency strength and directional trend. However, I am single symbol user and prefer to trade based on Momentum rather than trend or competitor's strength.
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.
Attached Image (click to enlarge)
Click to Enlarge Name: dea167aad7c3a9454c1ab52cdb9c8a67.png Size: 176 KB
Trading is SIMPLE not EASY.
  • #460
  • Mar 11, 2021 8:47am Mar 11, 2021 8:47am
Quoting Revsss
{quote} I am new to excel RTD, I am just asking if anyone has any Idea how to formulate it cuz I don't know how, and no I didnt expect members to do it for me, I am just asking, so whats the purpose of this group? I though its to help each other on how to use Excel RTD? If that's what you think, then don't waste your time bothering my post then
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? Sorry can't help more as it's really difficult to understand your question.

Cheers
0 traders viewing now