HELP FOR EXCEL

 

I am importing data from MT4 to travez of DDE to an Excel spreadsheet. I do real time data on all pairs of divisaspero when I import data from the oil (CL-OCT12) the return I get error
Symbol Bid
CL-OCT12 # VALUE!

someone please tell me how to solve this problem.

 
Guessing here -Excel 'thinks' you are trying to subtract from column CL a value with the name OCT12 or thinks the cell is used in an equation and the recalculate cant understand the contents of the cell.
 
ESPARTANO:

I am importing data from MT4 to travez of DDE to an Excel spreadsheet. I do real time data on all pairs of divisaspero when I import data from the oil (CL-OCT12) the return I get error
Symbol Bid
CL-OCT12 # VALUE!

Where did you get that format. Wrong values exporting MT4 data thru DDE - MQL4 forum

Excel: =MT4|BID!USDCHF

Calc: =DDE("MT4";"BID";"USDCHF";1)

 

the problem arises when data requeris oil (CL-OCT12) in currency pairs no problem, I'm looking for the solution to the oil, there must be a change in the formula for that error.
There will be someone who has solved that problem?

Reason: