is their a way to log a price at a specific time into excel, script or something
What i am trying to do is set up excel DDE server to fill a cell at a specific time
Quote:
Originally Posted by Kurka Fund
Here is a script that I wrote for MT.... when you run it, it creates a csv file called "KCaptureTheMajors.csv" in your mt > files directory. You can open this file with Excel to do price analysis.
the file contains OHLC pricing for the EURUSD, USDJPY,USDCHF,GBPUSD going back to the start date you select on whatever timeframe you want.
you have to make sure that you have the history data loaded in the platform. Hope you find it usefull.
There are some limitations however.... mainly if you want to look back a year with one munite data for some reason metatrader will only create files with 65390 rows of data in it. so if you multiply 65390 by your time frame thats as far back as you can look.
Please feel free to make as many modifications as you would like....but if you do post them here for everyone.
Also I would suggest that you run it on the EURUSD.
|