TWSDDE.XLS:file format is not valid

oatman

Senior member
2,879 22
I've been playing around with IB's API and have copy/pasted some data into Excel which is not updating. Thought I'd have a look at their demo spreadsheet and get this error. It's something to do with SYLK (symbolic link) file format.
I don't know what they're talking about :cheesy: or what I'm supposed to do.
Any help in plain English please.
 

mutantcar

Active member
123 0
oatman,

I'm using Excel 2000, so I've saved the TWS sample as Excel 5.0. Some of the features may be lost doing this. If you want to know which ones let me know, I'll try & send you the help page which lists them.

This seems to work though. Put your user name in cell D5. Select a cell like A15, and click 'Request Market Data'. Make sure you're logged in to TWS, I think you need 'Configure - API - Enable DDE Clients' ticked as well. You should get data from I5:S5. Quite nice actually. Haven't had much time to play with it myself.

Let us know how you get on.

Cheers,

Mute.
 

Attachments

  • twsddexl5.xls
    169.5 KB · Views: 672

oatman

Senior member
2,879 22
Thanks mute, I've tried your attach and I get
"Filename is not valid" error.
I might have a different Excel somewhere, I'll have a look around in my pile of CDs :rolleyes:
 

mutantcar

Active member
123 0
Hmm, works for me? I'd email it to you, but that's down at the moment!

Probably better off with Excel 97 or later. Let me know if you want me to email it to you when Virgin sort me out.

Mute.
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock