Wrong values exporting MT4 data to EXCEL via DDE

carmensilvia 2016.02.28 04:55

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

Damian Mateusz Dziadosz 2016.02.28 11:16 #1

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.

Working with Excel (tools, Comma instead of dot Examples: Superposition and Interference

Damian Mateusz Dziadosz 2016.02.28 14:37 #2

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.

[WARNING CLOSED!] Any newbie From theory to practice Calculating Pip Size and

carmensilvia 2016.02.28 14:48 #3

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

Damian Mateusz Dziadosz 2016.02.28 15:25 #4

carmensilvia:

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

:) Glad to hear that.

New comment