I have been searching over and over for countless hours until I found "Excel RTD". It is magic! I am able to get up to 500-period bars (depends on your broker) from MT4 history without exporting any data from MT4. Moreover, the current row keeps updating its self until the period is over and then a new row starts on top with the new updating values. Finally!!!

It is an EA that you apply on a MT4/MT5 chart and then open your Excel and type in a formula/s to get OHLC/Volume for current bars and up to 500 bars ago.

The same thing can be applied for most (if not all-need to check) of the indicators in MT4. Even if you have a custom indicator, you just need to know its formula and use what is available. For Example, a cross of RSI with MA is easy to apply because you can get your RSI values and apply a smoothing MA to the RSI column. Even Ketner Channels can be applied.

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

By googling Excel RTD + MT4, you will find many brokers offering this EA. Check if your broker has it or check if any of the other brokers provides the EA in a demo account. I found that my broker (Pepperstone) has this Excel RTD through its "Smart Tools" set of indis/EAs. I was surprised that I did not know it could retrieve history bars. There are other brokers and you will easily find them by searching online.

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

Examples for what I mean:

=RTD("fxbluelabs.excelrtd", ,"account number", "@bh,GBPUSD,H4,close,1") will get you the last close bar. Change the number at the end to 0 and you get current bar. Or change it to 200 and you get bar number 200.

=RTD("fxbluelabs.excelrtd", ,"account number","@rsi,GBPUSD,H4,14,2") will get you RSI value for H4 two bars ago.

Do not panic from these formulas. These are copy-pasted from a long PDF each broker (that has this Excel RTD EA through fxbluelabs) will provide it for you. The PDFs vary from one broker to another with how descriptive they are.

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

Some PDFs:

From peperstone:

From JFD :

From ThinkMArkets:

It is an EA that you apply on a MT4/MT5 chart and then open your Excel and type in a formula/s to get OHLC/Volume for current bars and up to 500 bars ago.

The same thing can be applied for most (if not all-need to check) of the indicators in MT4. Even if you have a custom indicator, you just need to know its formula and use what is available. For Example, a cross of RSI with MA is easy to apply because you can get your RSI values and apply a smoothing MA to the RSI column. Even Ketner Channels can be applied.

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

By googling Excel RTD + MT4, you will find many brokers offering this EA. Check if your broker has it or check if any of the other brokers provides the EA in a demo account. I found that my broker (Pepperstone) has this Excel RTD through its "Smart Tools" set of indis/EAs. I was surprised that I did not know it could retrieve history bars. There are other brokers and you will easily find them by searching online.

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

Examples for what I mean:

=RTD("fxbluelabs.excelrtd", ,"account number", "@bh,GBPUSD,H4,close,1") will get you the last close bar. Change the number at the end to 0 and you get current bar. Or change it to 200 and you get bar number 200.

=RTD("fxbluelabs.excelrtd", ,"account number","@rsi,GBPUSD,H4,14,2") will get you RSI value for H4 two bars ago.

Do not panic from these formulas. These are copy-pasted from a long PDF each broker (that has this Excel RTD EA through fxbluelabs) will provide it for you. The PDFs vary from one broker to another with how descriptive they are.

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

Some PDFs:

From peperstone:

Attached File

Excel-Real-Time-Data.pdf 926 KB | 1,056 download

From JFD :

Attached File

JFD_Excel_RTD_User-guide_EN.pdf 1.2 MB | 575 downloads

From ThinkMArkets:

Attached File

TM-Excel-RTD.pdf 782 KB | 569 downloads