IB API error

Discussion in 'Trading Software' started by lejmorro, Mar 25, 2008.

  1. lejmorro


    I am trying to get into the IB API for Excel, primarily for loading Option Chains for live analysis.
    In their sample program (TwsDDEbeginner.xls, Options Trader worksheet), GetQuote and LoadChains are failing due to an overflow error in makeid(), specifically

    id = (Date - 37000) * 1000000 + (Time * 1000000)

    Has anyone customised makeid() successfully?

    BTW, thanks to all you traders out there for ET.