A comprehensive list of all formulas for EXCEL RTD

To add comments, please log in or register
mtharwat
55
mtharwat  

I hope I am posting in the right category. If not pls direct me.

Hello,

I am using Excel RTD from FX Blue Labs from  Pepperstone to connect my Excel 365 (Desktop) to MT4 to get real-time forex data and historical ones.

I need to know how to use the fill handle to fill all the cells without typing the formula in each row.

An example: After connecting MT4 to Excel, I type this formula =RTD("fxbluelabs.excelrtd", ,"Account Number", "@bh,GBPUSD,H4,close,0") to get the current close of GBPUSD H4.

If I change the last number (0) to (1), I will get the previous close.

If I type the formula as =RTD("fxbluelabs.excelrtd", ,"Account Number", "@bh,GBPUSD,H4,close,200") I will get the close of the 200th bar.

Now, the problem is that when I selected the first three or four cells (in a column) with the above formulas and try to use the fill handle, I get the new rows filled the same as the selected row cells. For example, the first column has rows 1st, 2nd, 3rd. If I drag the first column, it is filled in the right order with 4th, 5th, 6th, etc..

But the column with the formulas that are linked to MT4 is not being filled correctly. Excel just repeats the values of those three rows in the second column.

Any solution for this?

Also please, is there any reference material for all the formulas that can be applied by fxbluelabs RTD. The PDFs that are provided by Pepperstone and other brokers who provide this service are not descriptive enough. I feel there are much more the EXCEL RTD can do. I have been searching for many hours and posted my questions in number of Excel and MT4 forums but did not get an answer.

I forgot to add that I am trying to figure the formula to list a group of tradable instruments at once rather than manually retrieving them one by one. The current formula provided in the manual instructions only retrieve the number of instruments available in MT4 market watch but does not retrieve list of all the instruments.

So to get all of the FX currency pairs I currently have to type the formula for each pair. Is there a way to get the list at once with one simple formula? Also, can this same formula be applied to retrieve the close of  H1 time frame for all those currency pairs at once?

Thanks in Advance

Keith Watford
Moderator
18437
Keith Watford  
mtharwat:
So to get all of the FX currency pairs I currently have to type the formula for each pair. Is there a way to get the list at once with one simple formula? Also, can this same formula be applied to retrieve the close of  H1 time frame for all those currency pairs at once?

Look up SymbolsTotal() and SymbolName()

mtharwat
55
mtharwat  
Keith Watford:

Look up SymbolsTotal() and SymbolName()

Hello Keith


Can you please elaborate more.  What formula should I type in "Excel"

I am not knowledgable with MT4 or VBA. I am just trying to figure the right "Excel Formula" based on Excel RTD.

Thanks

Keith Watford
Moderator
18437
Keith Watford  
mtharwat:

Hello Keith


Can you please elaborate more.  What formula should I type in "Excel"

I am not knowledgable with MT4 or VBA. I am just trying to figure the right "Excel Formula" based on Excel RTD.

Thanks

Sorry, I misread your post. I am not familiar with Excel RTD

mtharwat
55
mtharwat  
Keith Watford:

Sorry, I misread your post. I am not familiar with Excel RTD

That's all right 

Thanks for trying

r3365
6
r3365  
mtharwat:

I hope I am posting in the right category. If not pls direct me.

Hello,

I am using Excel RTD from FX Blue Labs from  Pepperstone to connect my Excel 365 (Desktop) to MT4 to get real-time forex data and historical ones.

I need to know how to use the fill handle to fill all the cells without typing the formula in each row.

An example: After connecting MT4 to Excel, I type this formula =RTD("fxbluelabs.excelrtd", ,"Account Number", "@bh,GBPUSD,H4,close,0") to get the current close of GBPUSD H4.

If I change the last number (0) to (1), I will get the previous close.

If I type the formula as =RTD("fxbluelabs.excelrtd", ,"Account Number", "@bh,GBPUSD,H4,close,200") I will get the close of the 200th bar.

Now, the problem is that when I selected the first three or four cells (in a column) with the above formulas and try to use the fill handle, I get the new rows filled the same as the selected row cells. For example, the first column has rows 1st, 2nd, 3rd. If I drag the first column, it is filled in the right order with 4th, 5th, 6th, etc.. 

But the column with the formulas that are linked to MT4 is not being filled correctly. Excel just repeats the values of those three rows in the second column.

Any solution for this? 

// I had the same problem, I worked out that concatenate will work to be able to fill down columns eg. =RTD("fxbluelabs.excelrtd", ,"Account Number", "@bh,GBPUSD,H4,close,"&A1&"") //"&A1&" is the shift period, you could use the same thing for the symbols, account number, and timeframe.

Also please, is there any reference material for all the formulas that can be applied by fxbluelabs RTD. The PDFs that are provided by Pepperstone and other brokers who provide this service are not descriptive enough. I feel there are much more the EXCEL RTD can do. I have been searching for many hours and posted my questions in number of Excel and MT4 forums but did not get an answer.

I forgot to add that I am trying to figure the formula to list a group of tradable instruments at once rather than manually retrieving them one by one. The current formula provided in the manual instructions only retrieve the number of instruments available in MT4 market watch but does not retrieve list of all the instruments.

// to get all symbols I have a column with all the numbers down the side (this relates to the symbols within mt4, if you delete symbols from your watchlist, these will change); then I use the concatenate formula again  =RTD("fxbluelabs.excelrtd", , $D$1, "s"&B4)  //$D$1 is my account number, "s"&B4 is the symbol.

So to get all of the FX currency pairs I currently have to type the formula for each pair. Is there a way to get the list at once with one simple formula? Also, can this same formula be applied to retrieve the close of  H1 time frame for all those currency pairs at once?

Thanks in Advance

Hey mate,

I ran into the same problem a while ago, I got frustrated with the lack of docs and then just started testing different formulas in excel, I'm also using pepperstone. See my // comments above.

I'd be happy to whip up a spreadsheet to show you the formulas that will do what you're after if the above doesn't make sense.

Cheers

To add comments, please log in or register