Download MetaTrader 5

Wrong values exporting MT4 data to EXCEL via DDE

To add comments, please log in or register
Have you installed MetaTrader 5? Find out more about it!
carmensilvia
16
carmensilvia 2016.02.28 05:55 

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

Damian Mateusz Dziadosz
5738
Damian Mateusz Dziadosz 2016.02.28 12:16  

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
5738
Damian Mateusz Dziadosz 2016.02.28 15:37  

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 2016.02.28 15:48  

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

Damian Mateusz Dziadosz
5738
Damian Mateusz Dziadosz 2016.02.28 16:25  
carmensilvia:

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

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