Exporting tick data to excel in MT5

To add comments, please log in or register
toshiorusso86
22
toshiorusso86  

Hi all,

I'm new to MT5 and I'm trying to export tick data to excel so to run a few analyses. If I extract through symbol-->ticks-->request I get a .csv file but it does not include any separators, and it's not easy to separate the data in excel (bid and ask values will end up being in the same column)

Is there any faster way to do this?

Thanks and sorry if it's already been asked!

Antonio

Alain Verleyen
36111
Alain Verleyen  
toshiorusso86:

Hi all,

I'm new to MT5 and I'm trying to export tick data to excel so to run a few analyses. If I extract through symbol-->ticks-->request I get a .csv file but it does not include any separators, and it's not easy to separate the data in excel (bid and ask values will end up being in the same column)

Is there any faster way to do this?

Thanks and sorry if it's already been asked!

Antonio

A csv file without separators ? I seriously doubt it. Please provide such a file to prove it.

Default separator is a <TAB> I think.

toshiorusso86
22
toshiorusso86  
Alain Verleyen:

A csv file without separators ? I seriously doubt it. Please provide such a file to prove it.

Default separator is a <TAB> I think.

Solved! Sorry my bad, put the wrong separator in the text to columns option :))

Thanks a lot

Antonio

To add comments, please log in or register