I think Tradelog does e mini futures from IB statements. If you have a different broker, I don't know. In any event, you don't have to report every futures trade to the IRS like you do with stocks. The IRS form for futures profit or loss just has space for your results for the year. You can attach copies of your monthly summary statements to the back of return for backup.
Anyone have any experience with it (Tradelog)...with respect to...RJT, or other brokerages (other that IB) ? About to switch to RJT, so I'm particularly interested in them. TIA skyfisherman
I have been using an export to Quicken for tracking stock trades. IB has just added that capability for stocks. I have also written a short macro in Excel to parse the data from an IB report into Quicken format (QIF file). I have recently started trading the ES, unfortunately Quicken does not handle futures transactions. I have been exporting the IB daily reports, fixed width delimited, into an excel spreadsheet. Has anyone here been successful with matching buy/sell trades in excel? Anyone want to share their experiences?
I match them by cutting and pasting. When I started the thread I hoped that someone may have written a visual basic routine to do the matching and be willing to share it. So far no takers. I am pretty sure it could be done using Microsoft Access, or another good database program, but unfortunately I am not up to the task.
I see that IB data can now be exported to Quicken. Does Quicken match the trades and generate a profit/Loss statement?
I have written an Excel macro that does basic trade matching (stocks only). You can download the spreadsheet from http://www.ingenit.com/iblog/
dufferdon, Not quite. Quicken will give you a list of trades that you can match against. E.g. you bought ABC at several prices and sold ABC at several price. As soon as you start accepting the SELL orders Quicken will list all the buys and you get to match the exact shares you want the sell order to correspond to. No typing required - just select with the mouse. Works well for me. One more thing: Quicken 2002 has "short sales" built in. Quicken 2001 does not (you get a dialog box every time you sell before you buy). Unfortunately, at present IB exports to the older Quicken 2001 without a specific short sales, so you will have to fix those entries yourself. IB supposedly is aware of the issue, per a previous post on Elite.
From IB's web site I can see the monthly trade report, but how do I download it so I can import it to tradelog?
You save the monthly report as a ".txt" file, naming it something that corresponds to the month/year and then Import it to Tradelog with the Import button.