Connecting dde to page of excel workbook

Questions about MultiCharts and user contributed studies.
jl12
Posts: 197
Joined: 29 Jun 2007
Has thanked: 8 times
Been thanked: 8 times
Contact:

Connecting dde to page of excel workbook

Postby jl12 » 25 Jan 2008

I am trying to connect the dde to ibbrokers sample worksheet, it works fine referencing the first page on a work book but I need to extract data from mother named pages.

I have tried the following syntax in the settings template to connect to the Market depth page and get errors messages in Test.


=EXCEL|MSFT.xls|Market Depth!*

Please could you tell me how to reference a page within the workbook

User avatar
Januson
Posts: 119
Joined: 18 Apr 2007
Location: Denmark

Postby Januson » 27 Jan 2008

Hi..

I'm sorry I cannot answer your question, but apparantly you know something about DDE.

Do you know if I can use DDE to retrieve historical quotes?

dupl
Posts: 158
Joined: 04 Jul 2007

Re: Connecting dde to page of excel workbook

Postby dupl » 10 Jul 2008

I am trying to connect the dde to ibbrokers sample worksheet, it works fine referencing the first page ...

How did you?

Thanks

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

Postby Marina Pashkova » 11 Jul 2008

Hi dupl,

You can contact our customer support reps via LiveChat and they will help you with the settings.

Regards.

bucks
Posts: 3
Joined: 20 Sep 2005
Has thanked: 4 times

Re: Connecting dde to page of excel workbook

Postby bucks » 29 Jul 2008

I am trying to connect the dde to ibbrokers sample worksheet, it works fine referencing the first page on a work book but I need to extract data from mother named pages.

I have tried the following syntax in the settings template to connect to the Market depth page and get errors messages in Test.


=EXCEL|MSFT.xls|Market Depth!*

Please could you tell me how to reference a page within the workbook

Hi, I got same problem.
Does anyone know how to set data source in different sheets in Excel?
For example, I'd like to receive data in R2C1 in Sheet2
I've tried "=EXCEL|[test.xls]Sheet2!R2C1", but didn't work

dupl
Posts: 158
Joined: 04 Jul 2007

Postby dupl » 31 Jul 2008

bucks,

I/we support could not solve it via remote at my PC. It looks like an Excel problem (IB DDE-link problem)...

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

Postby Marina Pashkova » 31 Jul 2008

Hi bucks,

The thing is that IB dde works differently compared to other data providers. We tried making it work with MC several times but it never did - due to the peculiarities of the IB dde link. For now, we don't have a solution (this is why we don't have a template for IB among other dde templates)


Return to “MultiCharts”