As an alternative to a commercial system like Tradelog, it's easy to simply export the trades from TWS (using File->Export Reports and save with a .txt extension). The resulting semicolon-delimited file can then be imported into Excel (File->Open, select Files Of Type: Text, find your file, follow the wizard).
You can get more ambitious if you want, though:
I wrote a conversion program that processes the raw .rpt execution reports, extracting more from them than the TWS export. I wrote some VBA in my trade spreadsheet that imports the files for me. When the daily email statements come in, Eudora calls a perl script that pre-processes it and moves it to a specific directory, where I can then import it with some more VBA code into my spreadsheet to stick the commissions in and verify the balance.
I do some manual work in the spreadsheet to correlate opening and closing orders for my own stats, but am working on automating that too. OTOH, it's probably good to spend some time on reviewing trades manually.
You can get more ambitious if you want, though:
I wrote a conversion program that processes the raw .rpt execution reports, extracting more from them than the TWS export. I wrote some VBA in my trade spreadsheet that imports the files for me. When the daily email statements come in, Eudora calls a perl script that pre-processes it and moves it to a specific directory, where I can then import it with some more VBA code into my spreadsheet to stick the commissions in and verify the balance.
I do some manual work in the spreadsheet to correlate opening and closing orders for my own stats, but am working on automating that too. OTOH, it's probably good to spend some time on reviewing trades manually.