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 https://www.mql5.com/go?link=http://www.libmaster.com and /go?link=http://netcontrols.org/nplot/wiki/index.php for free stock chart activex controls. However the most luxurious stockchart control is at https://www.mql5.com/go?link=http://www.modulusfe.com/stockchartx/, it's not for free though.

[[Deleted]]

You might also want to check out https://www.mql5.com/go?link=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

[[Deleted]]

You can get a MT4 indicator to export live streaming data to .csv files at Connect to MT4 RT Data

It comes free with the trial and you can keep it.

[wringle]

What calculation type is metatrader using when doing a backtest:

Floating point?

Double floting point ?

Integer calculation?

Or is it some other calculation type used?

[mohsinqureshii]

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?

Check this attached for tick collector.