IB: Trade record-keeping software.

Discussion in 'Interactive Brokers' started by dufferdon, Sep 19, 2001.

  1. thomas

    thomas

    At the risk of sounding dense, how do I do this?
     
    #31     Dec 28, 2001
  2. ddefina

    ddefina

    Open the monthly report via your browser. Go to File, and then Save As, typing the name you'd like and change the Save As Type to "text" from "HTML" (default normally). Then when you are in TradeLog, and hit the Import button, find the directory where you saved this text file, select the file and click ok. It will ask if you want to import that day, and say yes. Thats it. The import function remembers the directory you used last when finding the text file, so you won't have to find the directory each time.

    When you get this process down it takes about 5 seconds a day.
     
    #32     Dec 28, 2001
  3. thomas

    thomas

    Thank you ddefina. :)
     
    #33     Dec 28, 2001
  4. Just wanted to let everyone know that Igor (Isidoren) has done a tremendous job developing the macros to import and match IB trade data from the monthly reports in Excel. It does exactly what I was looking for when I first started this thread.

    For those that missed it the first time here's the link

    http://www.ingenit.com/iblog/

    Thanks Igor. Your post telling us about this is the single most useful post for me that I have seen on this board.

    Now, is anyone interested in a slightly used version of Quicken 2002:)
     
    #34     Jan 2, 2002
  5. jsmith

    jsmith

    I didn't want to start a new thread but I think this fits right in.

    Shouldn't commission go into the Cost or other basis?
    Why does the IB 1099 put the commission into the Sales Price
    and throwing my numbers ALL off?

    Example for 1 month with 2 trades.

    XLS file with my Calculation:
    Description of Property Date acquired Date Sold Sales Price Cost or other basis Gain or Loss
    Short sale 400 sh. of RAMBUS INC 3/26/01 3/26/01 $9,828.80 $9,669.00 $159.80
    Short sale 100 sh. of RAMBUS INC 3/26/01 3/26/01 $2,457.20 $2,416.00 $41.20
    Short sale 500 sh. of RAMBUS INC 3/26/01 3/26/01 $12,286.00 $12,075.00 $211.00
    200 sh. of CHECK POINT SOFTWARE T 3/30/01 3/30/01 $9,497.50 $9,602.31 -$104.81
    100 sh. of CHECK POINT SOFTWARE T 3/30/01 3/30/01 $4,750.00 $4,801.15 -$51.15
    700 sh. of CHECK POINT SOFTWARE T 3/30/01 3/30/01 $33,250.00 $33,608.08 -$358.08
    100 sh. of CHECK POINT SOFTWARE T 3/30/01 3/30/01 $4,750.00 $4,801.15 -$51.15
    100 sh. of CHECK POINT SOFTWARE T 3/30/01 3/30/01 $4,750.00 $4,801.15 -$51.15
    100 sh. of CHECK POINT SOFTWARE T 3/30/01 3/30/01 $4,750.00 $4,801.15 -$51.15
    100 sh. of CHECK POINT SOFTWARE T 3/30/01 3/30/01 $4,750.00 $4,800.00 -$50.00
    100 sh. of CHECK POINT SOFTWARE T 3/30/01 3/30/01 $4,750.00 $4,800.00 -$50.00
    Sales Price / Cost / Gain
    $95,819.50 $96,175.00 -$355.50

    Monthly Statement Matches the 355.50

    26-MAR-2001 RMBS RAMBUS INC -1000 24.5820 24582.00 -10.00
    26-MAR-2001 P RMBS RAMBUS INC 400 24.1600 -9664.00 -5.00
    26-MAR-2001 P RMBS RAMBUS INC 100 24.1600 -2416.00 0.00
    26-MAR-2001 RMBS RAMBUS INC 500 24.1400 -12070.00 -5.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T 1300 48.0000 -62400.00 -15.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T 200 48.0000 -9600.00 0.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T -200 47.5625 9512.50 -15.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T -100 47.5000 4750.00 0.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T -700 47.5000 33250.00 0.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T -100 47.5000 4750.00 0.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T -100 47.5000 4750.00 0.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T -100 47.5000 4750.00 0.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T -100 47.5000 4750.00 0.00
    30-MAR-2001 P CHKP CHECK POINT SOFTWARE T -100 47.5000 4750.00 0.00
    ========== =========
    -305.50 -50.00

    But the 1099 is off!

    03/26/01 750917106 1000 RMBS SLD RAMBUS INC 24582.00
    03/30/01 M22465104 200 CHKP SLD CHECK POINT SOFTWARE TE 9512.50
    03/30/01 M22465104 100 CHKP SLD CHECK POINT SOFTWARE TE 4750.00
    03/30/01 M22465104 700 CHKP SLD CHECK POINT SOFTWARE TE 33250.00
    03/30/01 M22465104 100 CHKP SLD CHECK POINT SOFTWARE TE 4750.00
    03/30/01 M22465104 100 CHKP SLD CHECK POINT SOFTWARE TE 4750.00
    03/30/01 M22465104 100 CHKP SLD CHECK POINT SOFTWARE TE 4750.00
    03/30/01 M22465104 100 CHKP SLD CHECK POINT SOFTWARE TE 4750.00
    03/30/01 M22465104 100 CHKP SLD CHECK POINT SOFTWARE TE 4750.00

    Total Sales 1099 is $95844.50
    which is $25 more than my calculations.
    It looks like they added commissions for the 2500 shares
    to the Sales Price.

    Isn't the 1099 wrong? Why?
     
    #35     Feb 12, 2002
  6. mgkrebs

    mgkrebs

    .
     
    #36     Feb 12, 2002
  7. I used TradePair ver. 0.3 beta from www.ingenit.com. It worked great. The trick for me was following the directions precisely. Once I did, the thing was great.

    For reference, I also have used TradeLog and really like it, too. But there's a substantial cost difference between the two programs, so if all you're looking for is a way to generate your Schedule D, I'd go with TradePair.
     
    #37     Feb 13, 2002
  8. jsmith

    jsmith

    I used TradePair and I think it worked great but I still
    can't figure out why my 1099 doesn't match my Sales
    from TradePair. By looking over the trades, I figured IB
    adds Commission to the Sales instead of the Cost Basis.

    Does everybody's IB 1099 trades match their Tradelog?
    Shouldn't the Commissions get added to the Cost Basis?

    I was using ver. 2. I'll try it again with ver. 3.
     
    #38     Feb 13, 2002
  9. Ronin

    Ronin

    IB's 1099 does not include commissions when reporting the "Gross Proceeds" from trades. All of my other broker's include the cost of commissions, ie., commissions are deducted from the proceeds. I feel that IB's version is wrong because there is no way for the IRS to know how much we paid for commissions on each transaction. What we report for total sales for 2001 will not match what IB is reporting to the IRS. Makes no sense to me.
     
    #39     Feb 13, 2002
  10. JPB

    JPB

    Tradelog says it now handles wash sales (I didn't elect MTM for this year), does this work well?

    Thanks,

    Johnny
     
    #40     Feb 14, 2002