DDE Symbol

Can I feed MC with a symbol from Excel using Universal DDE? Are there instructions anywhere?

Its actauly order book stuff from TWS but i figured as there are 5 levels on the bid and 5 on the ask it would be easier to take them into excel first to sum them.

Yes, you can find a tutorial at

http://tssupport.com/products/multichar ... _Excel.htm

Please write back if you need assistance.

Thanks,

That looks like it will work.

To cut out a link in the chain could i do something similar straight from IB? As I say it is order book /Depth of market info I want and I dont think MC supports that directly at the moment?

Cheers,
Nick.

Could you please tell the DDE request that will return this kind of data, we'll take a look.

=acnt|mktDepth!id0?price?0_BID
=acnt|mktDepth!id0?price?1_BID
=acnt|mktDepth!id0?price?2_BID
=acnt|mktDepth!id0?price?3_BID
=acnt|mktDepth!id0?price?4_BID

=acnt|mktDepth!id0?price?0_ASK
=acnt|mktDepth!id0?price?1_ASK
=acnt|mktDepth!id0?price?2_ASK
=acnt|mktDepth!id0?price?3_ASK
=acnt|mktDepth!id0?price?4_ASK

Are the Depth Links.

I could not get this working via Excel...maybe I misunderstand something.

I have these 10 links I sum them and generate a ratio for bid/ask in excel. I then try and link this cell (The summed one) into MC. It returns an error. Any idea?

Cheers,
Nick.