Hi everyone, I have found historical rates for ten years with 1min interval from http://www.forexite.com/
But I cant use those data in metatrader because its data format is different. Its like USDJPY,20010103,000300,114.43,114.43,114.43,114.43,4
Can someone please show me a way to convert it to make suitable for reading by metatrader?
The USDJPY part at the beginning should be removed and date format must be changed. And please dont offer to use excel to change it because
1. I dont know programmin and even excel
2. Excel cant open the file because its very big; like 150mb. Number of lines of excel isnt enough even for 1 year data.
For the ones who know programming I am attaching an excel file which I found in another forum to convert variables for historical data. But I couldnt suceed in working that. If someone shows how to use it, its even better, because it converts anything to anything.
But I cant use those data in metatrader because its data format is different. Its like USDJPY,20010103,000300,114.43,114.43,114.43,114.43,4
Can someone please show me a way to convert it to make suitable for reading by metatrader?
The USDJPY part at the beginning should be removed and date format must be changed. And please dont offer to use excel to change it because
1. I dont know programmin and even excel
2. Excel cant open the file because its very big; like 150mb. Number of lines of excel isnt enough even for 1 year data.
For the ones who know programming I am attaching an excel file which I found in another forum to convert variables for historical data. But I couldnt suceed in working that. If someone shows how to use it, its even better, because it converts anything to anything.
Attached File(s)
_Convert HST to CSV V2_95_eng.xls
106 KB
|
476 downloads