Can you please make the column headers in the Import Ticks dialogue selectable to match the data.Something like this:Having to manually edit large amounts of tick data just to match your format is very time consuming and tedious...It also needs to support header names in the .csv that don't match the MT5 <DATE> <TIME> <BID> <ASK> <LAST> <VOLUME> syntax.I've just spent hours trying every .csv editor I can find and they either crash with such large files or can't do the editing required.I thought pyspread was going to work but it's crashing as well...Unless you know of a .csv editor that can quickly and reliably work with 700MB files?thanks :)p.s. It would be good if you could add Post Voting, Polls, and Sub-Forums for topics like this.
Thanks Sergey,This place badly needs some sub-forums and stickies, no way I would have found that, and I did search beforehand...
That should definitely be a feature. If you know python you can make simple scripts to transform your data. Here's an example of formatting true-fx to mql using python
import os, csv
True-FX tick-data to MQL format:
Run in the same directory as the
files to be transformed.
files = [f for f in os.listdir('.') ]
for f in files:
if '.csv' in f and 'MQL' not in f:
with open(f) as csv_in, open('MQL-'+f,'w') as csv_out:
tick_reader = csv.reader(csv_in, delimiter=',')
for row in tick_reader:
row = (lambda d:d[:4]+'.'+d[4:6]+'.'+d[6:8])(row)
row = row[9:]