IB TwsActiveX Compile Error

E

extraMileage

Setting up a new TwsActiveX sheet for IB account.

The API connects just fine and Account Info is also downloaded with no issues on the Account and Portfolio sheets.

However, when I "Request Market Data" (CTRL-SHIFT-R) on the Ticker sheet, I get a compile error: "Argument Not Optional"

The line of code highlighted in the debugger is:

Call Util.ParseComboLegsIntoStruct(Cells(id, Columns(COLUMN_COMBOLEGS).column).value, objTWSControl.m_contractInfo.ComboLegs)

Anybody experience this? Have a fix?

I have not tweaked or edited the file or code in any way.

Thanks!
 
It appears that this object is nothing:

objTWSControl.m_contractInfo

So the contract information is not resolved for some reason.
 
extraMileage, did you ever get this resolved? I am having the same exact issue/error message in the same line of code. Part of the reason to use a ready-made spreadsheet is to avoid dealing with the VBA code.
 
I was unfortunately unable to find a fix and gave up.

Dynamic intra-day pricing is not crucial to my needs, although it's frustrating that it's not working.

Please do share if you find a solution...
 
You must log in or register to reply here.
Back
Top