DDE =MT4|BID!USDCHF works BUT =MT4|BID!USDCHF(£) does not work.Can you help?

 

A DDE function is like this =MT4|BID!USDCHF - ***  and it works great. However, if the symbols from MT4 have (£) then the DDE function must change to this =MT4|BID!USDCHF(£), but when that happens, Excel is confused by the brackets and the £ sign and we get this ***

I never had a problem, because up until now, all data in MT4 never had a special symbol in it, so it was not a problem for Excel. However, this time the symbol includes () and £ and now if you call that data, you must include these special characters. And when you do, it seems that Excel gets confused by the brackets+£.

Any ideas on how to fix this?

Documentation on MQL5: Constants, Enumerations and Structures / Named Constants / Predefined Macro Substitutions
Documentation on MQL5: Constants, Enumerations and Structures / Named Constants / Predefined Macro Substitutions
  • www.mql5.com
//| Expert initialization function                                   | //| Expert deinitialization function                                 | //| Expert tick function                                             | //| test1                                                            |...
Reason: