Metatrader historic data feed into Excel

[JR97]

Does anybody know how to send a request to the metatrader server to historic data? I know it can be done because I'm currently getting the data from alpari into Tradestation 2000i. I just don't know HOW it's done.

My system is primarily in Excel and I'm currently using the VT-Trader API to get the data. Works like a charm, but it's too unstable. Crashes too much and of course the ol' VT connectivity issue is still there. Even on my live account.

Any help is mucho appreciated.


ps... anybody know of any free active x stock charting controls?

[Dave77]

if you have access Interbankfx Trader 3 or 4 go to the top tab on the graphs>tools>history center. Select currency and time period>Export and it will export into excel.

Dave

[scorpion]

Check www.libmaster.com and www.netcontrols.org/nplot/ for free stock chart activex controls. However the most luxurious stockchart control is at www.modulusfe.com/stockchartx/, it's not for free though.

[Rastarr]

You might also want to check out http://ta-lib.org/

Blurb extract:-

TA-Lib is a set of .NET, C/C++, Perl and Excel libraries allowing to analyze stock/future/commodity market data.
Provides technical analysis functions (MACD, RSI, Bollinger Bands etc...).
Flexible support for SQL and ASCII data files.
Support online data feed (like Yahoo!)
Optional abstract interface allowing your code to support new technical analysis functions without any code change!
Java port is in development