Exporting the price history from a MetaTrader chart to Excel could not be easier. Just follow the steps below:
1. Open a chart
2. Click File, then Save As
3. Change the file name to whatever you wish. Make sure to leave the file type as ASCII Text *.csv
4. Push save
5. Double click on your saved file.
.csv is a file format known as Comma Separated Values. Excel supports this format, which makes it the easiest method for exporting prices into a spreadsheet.
thank you very much!
You’re welcome!
Thank you.
Hi
I am using meta trader 5 and I have problem sending to excel 2016, when I open the file I see all the data in one column and separation is not correct.
I set the region setting to , also but still it is not right
I’m not sure – that’s pretty hard to diagnose from a blog comment.
Olá, boa tarde. Obrigado pela sua dica, consegui baixar os dados. No entanto não estou sabendo identificar pelas colunas o quais são os preços de abertura, fechamento, max e min. Você sabe quais colunas são?
The order should be Open, High, Low, Close.
Thanks a lot, I’ve been asking myself how to do this
You’re welcome!
Mast Sirji….will it update in Real time ?
hola, muchas gracias. me podrias explicar las 5 ultimas columnas porfavor. te lo agradeceria.
las 5 ultimas columnas que aparece en el archivo exportado.