I have problem with DDE! I use this technology to exchange data from external application (Metatrade 4 used for currency trading) into Excel.
Problem is very selective! Vast majority of tickers representing trading instruments works fine. But in several cases, there is no way to store link in correct format into the Excel!
My entered link is corrupted after insertion. I mean entered quotation marks ' ' are lost!

Example of working link:
my entry ='MT4'|BID!'[DAX40]' | stored content in the Cell ='MT4'|BID!'[DAX40]' | as you can see entry link = stored content into the Cell | all correct!

Working instruments:
V?běr 1.png

Example of working result
V?běr 3.png


Problematic link:
my entry ='MT4'|BID!'[FTSE100]' | stored content in the Cell ='MT4'|BID! [FTSE100] | as you can see single quotation marks ' ' were lost, Excel removed them of the Cell, DDE link doesn't work! Why??

Problematic instruments:
V?běr 2.png

Example of not working result
V?běr 4.png


Thanks!