Download MetaTrader 5

DDE MT4 Excel calculation issue - value error

To add comments, please log in or register
Find out how to install MetaTrader on Linux
Daniel Jurnik
142
Daniel Jurnik 2015.02.04 10:28 

Hello everyone

 

I have some issue with DDE excel spreadsheet. I can't to use the data from table to any calculation. For example, I would like to calculate pip value for USDCHF. So, I use this formula: 10/value of USDCHF. But the result is #VALUE. Is there any solution?

 

Thank you! 

SYED NAUFAL GADDAFI
1401
SYED NAUFAL GADDAFI 2015.02.04 10:44  
Yes. Try widening the column.
Daniel Jurnik
142
Daniel Jurnik 2015.02.04 11:03  

Thank you, but this is not this type of problem.

Carl Schreiber
6592
Carl Schreiber 2015.02.04 11:07  

Post the formula of a cell in Excel that should receive quotes.

It cannot not be =10/value!

Daniel Jurnik
142
Daniel Jurnik 2015.02.04 11:39  
Yes, I know. The formula is simple: =10/C3 , where C3 is value of USDCHF. I think the problem is data type, but I don't know how to adjust. It could be a number.
SYED NAUFAL GADDAFI
1401
SYED NAUFAL GADDAFI 2015.02.04 12:21  

LOL ... It is a number in digits. If you can figure out what is C3 ... presto.


Remember.. calculation always involve with numbers. C3 is not a number.

Daniel Jurnik
142
Daniel Jurnik 2015.02.04 12:45  

I think you don't understand me. C3 (cell) => ='MT4'|BID!USDCHF => value.

 

The problem is that I can't to use this value for any calculation. The result is #VALUE!  

SYED NAUFAL GADDAFI
1401
SYED NAUFAL GADDAFI 2015.02.04 13:08  
Please forgive me when giving little information so that people could answer (very) wrongly (or stupidly).
Carl Schreiber
6592
Carl Schreiber 2015.02.04 13:08  

1) The terminal Help (F1->Search DDE) shows the Excelformula: =MT4|BID!USDCHF   (WITHOUT '' !!)

2) LibreOffice (openOffice)? requires:   =DDE("MT4";"BID";"USDCHF")

3) Have you enabled Terminal -> Tools -> Options -> Server -> Enabled DDE Server?

4) Your spreadsheet allows being updated 'from outside'?

5) You spread-sheet is USA (dec.-point) or EUR (dec.-comma)?

SYED NAUFAL GADDAFI
1401
SYED NAUFAL GADDAFI 2015.02.04 13:12  
I bet one of it (or all). Common newbie mistake.
Daniel Jurnik
142
Daniel Jurnik 2015.02.04 16:07  
1) The terminal Help (F1->Search DDE) shows the Excelformula: =MT4|BID!USDCHF   (WITHOUT '' !!) - I can't to set Excelformula without ''. Excel will not let me. How to do it?
12
To add comments, please log in or register