IB year end statement

Discussion in 'Interactive Brokers' started by kowboy, Jan 30, 2006.

  1. kowboy

    kowboy

    I notice the IB year end statement is only available in html, unlike the monthly statements.

    Is there a simple way to import the html annual statement into excel without going through another program to line up the data in columns?

    Just thought there might be a way around downloading each monthly statement.

    Thanks for suggestions. Mike

    PS I searched ET for an answer but couldn't find one.
     
  2. MR.NBBO

    MR.NBBO

    Look for the "Please click here for explanation to import your annual statements into MS Excel" Under the year end statement.

    Basically I think you can just open the html (after saving it to Hard drive) in excel......then save it as an excel file.
     
  3. kowboy

    kowboy

    I see what to do. Need to save the satement as a "WebPage, HTML only" instead of a txt or "complete HTM,Html."

    Thanks for the help.

    Mike