Download MetaTrader 5

Wrong values exporting MT4 data to EXCEL via DDE

To add comments, please log in or register
carmensilvia
16
carmensilvia  

i'm having a problem with format of price... please, help me...

Damian Mateusz Dziadosz
7284
Damian Mateusz Dziadosz  

I had the same problem what i did was simple calculations (multiply, divide...) in other cells to get the correct values. Also you might need use the formula "substitute" changing dots for commas because excel would read dots as part of text. I hope this information helps you.

Damian Mateusz Dziadosz
7284
Damian Mateusz Dziadosz  

I will give you an example based on the picture in the cell "C4" you have the GBPUSD Bid price multiplied by 100000 (it should be 1.38694) so in other cell for example B14 write the next formula =C4/100000

If you would like to make calculations with values that have dots instead of commas you would have to do the next formula =SUBSTITUTE(C3;".";",";1)  the previous formula was based on USDCHF bid price.

Please do not hesitate asking anything else if you still have doubts i will attach pictures

carmensilvia
16
carmensilvia  

Very good, it works! I understand, thanks you very much!

Damian Mateusz Dziadosz
7284
Damian Mateusz Dziadosz  
carmensilvia:

Very good, it works! I understand, thanks you very much!

:) Glad to hear that.
To add comments, please log in or register