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
Connecting dde to page of excel workbook
Re: Connecting dde to page of excel workbook
How did you?I am trying to connect the dde to ibbrokers sample worksheet, it works fine referencing the first page ...
Thanks
- Marina Pashkova
- Posts: 2758
- Joined: 27 Jul 2007
Re: Connecting dde to page of excel workbook
Hi, I got same problem.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
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
- Marina Pashkova
- Posts: 2758
- Joined: 27 Jul 2007
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)
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)