DDE Setup, Excel MBTrading

Questions about MultiCharts and user contributed studies.
wegi
Posts: 121
Joined: 02 Jun 2009
Has thanked: 5 times
Been thanked: 12 times

DDE Setup, Excel MBTrading

Postby wegi » 02 Jun 2009

Hi,


my broker is MB Trading and i try to receive quotes useing excel and dde.
It works, but i can only store one price and not bid, ask and volume.

Is there a any way to receive and store bid, ask and volume in one symbol in the quotemanager ? maybe my dde setup is wrong ?

i attached two pictures: my excelfile and my dde template.
In the quotemanger the symbolname is: R1C4

thanks !

wegi
Attachments
dde.PNG
(10.41 KiB) Downloaded 309 times
excel.PNG
(28.58 KiB) Downloaded 320 times

wegi
Posts: 121
Joined: 02 Jun 2009
Has thanked: 5 times
Been thanked: 12 times

Postby wegi » 02 Jun 2009

just 5 minutes later i solved my problem:

i just need to "fix" the column in the dde template.

Trade =EXCEL|ExcelSDK.xls!*C2
ask = =EXCEL|ExcelSDK.xls!*C3

the symbolname then is only R1 or R2

but i found out, that dde does not work with office 2000 :(

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

Postby Andrew Kirillov » 03 Jun 2009

It should work in any excel revision. Sometimes r1c1 reference style is disabled so make sure it is working.


Return to “MultiCharts”