Universal DDE to Excel

Questions about MultiCharts and user contributed studies.
cael
Posts: 89
Joined: 06 Sep 2006
Has thanked: 2 times

Universal DDE to Excel

Postby cael » 02 Apr 2007

I was just watching this video,

http://tssupport.com/addons/owndata/movies/excel.shtml

Quotemanager is set to reference demo.xls and rncn format is used as the symbol name. How do you reference a specific sheet?

User avatar
Andrew Kirillov
Posts: 1589
Joined: 28 Jul 2005
Has thanked: 2 times
Been thanked: 31 times
Contact:

Postby Andrew Kirillov » 02 Apr 2007

Dear cael,

To reference a specific sheet in an Excel book you should use syntax as following:

Code: Select all

=EXCEL|'[YourBookName.xls]YourSheetName'!*

cael
Posts: 89
Joined: 06 Sep 2006
Has thanked: 2 times

Postby cael » 02 Apr 2007

Thanks very much.

I am curious how the cell is addressed when no sheet is specifically addressed?

User avatar
Andrew Kirillov
Posts: 1589
Joined: 28 Jul 2005
Has thanked: 2 times
Been thanked: 31 times
Contact:

Postby Andrew Kirillov » 02 Apr 2007

In this case the first sheet in a book is always used.

dupl
Posts: 158
Joined: 04 Jul 2007

Postby dupl » 28 Sep 2007

Hello,

I think did it like the video tut. described, but do not receive data.
I have only Bid Ask quotes.

Please have a look at my screenshots.
Thanks
Attachments
dee1.PNG
dee1.PNG (15.86 KiB) Viewed 454 times
dee2.PNG
dee2.PNG (18.74 KiB) Viewed 458 times

dupl
Posts: 158
Joined: 04 Jul 2007

Postby dupl » 01 Oct 2007

Hello,
I now arranged the Cells in Excel like in the video tutorial, but no quotes in MC, only in Excel.
What can I try else?

Thanks

User avatar
Marina Pashkova
Posts: 2758
Joined: 27 Jul 2007

Postby Marina Pashkova » 03 Oct 2007

Hello,

Try filling out the fields in the DDE template using the following format:

=EXCEL|'[YourBookName.xls]YourSheetName'!*

Let me know if that works.

dupl
Posts: 158
Joined: 04 Jul 2007

Postby dupl » 05 Oct 2007

using the following format:
=EXCEL|'[YourBookName.xls]YourSheetName'!*

i use now (see screenshot):
=EXCEL|'[TWS_id20.xls]sheet2'!*

Is it necessary to receive the quotes in Excel over DDE, or can they also received over ActiveX? So, is it quite immaterial how Excel receives quotes in a cell?

Thanks
Attachments
dee3.PNG
dee3.PNG (29.25 KiB) Viewed 463 times

User avatar
Marina Pashkova
Posts: 2758
Joined: 27 Jul 2007

Postby Marina Pashkova » 08 Oct 2007

Hello,

Occasionally, there are cases when Universal DDE with Excel is quite unstable.

Unfortunately, at the moment our programmers do not have a solution that could help to solve your problem.

Regards.


Return to “MultiCharts”