IB API: excel problem

TraDaToR

TraDaToR

Hello,

I have a weird problem with excel tonight. I wrote a macro on a new spreadsheet last WE and contrary to my former spreadsheets, the API create data links( tik ) only if the id is 1,10,100,1000,10000.... It doesn't work for all other id numbers.

I have been watching options and cells format but can't find what is different from my former spreadsheets. The id is in a cell formula like : "=myname|tik!id8?bid"

I was just hoping someone got this problem before cause i don't see where the problem is.

Thanks in advance.
 
what version of excel are you using and how are your macro/security settings? Do you run antivirus?

Do you have a list of the IDs and what they mean? (on the IB website)?

Seems like you have an extra paramater in there - the first part in the DDE/RDP link is ="some executable program"

DDE/RDP links are all the same, =BDP(TICKER,BID), =TOS|BID!TICKER, etc.

What is "=myname|tik!id8?bid"? Where is the ticker? What is the executable? Shouldn't it be =TIK|then something?

remember these are written for excel not the other way around so every firm's RDP links are all geared to excel.

Also - Excel 2007 handles RDP/DDE links much better than 2003.
 
Thanks Winston,

The problem has been resolved. Excel was treating the number after the id as a string and only ids corresponding to string numbers( 1, 10 which means 2, 100 which means 3) worked. It was a mess to get it back to normal through cells formatting and paste special. I don't even know which manip got it back...LOL

The piece of code I copied was just to show an example. It's the command to display the bid of an instrument you already requested datas in an other cell.
 
You must log in or register to reply here.
Back
Top