I do a fair amount of futures trading on TOS and as a result I have a large account statement detail listing for the year. I have extracted it to Excel, and would like to manipulate it so I can put opening and closing trades together, keep trade pairs aligned, analyze the mark to market detail, etc. I have started to build some macros to manipulate the data to get it into a better format for analysis. So my question is, has anyone found an off the shelf reporting and analyzing tool for TOS, or maybe shareware? I would guess others have thought of usage of the data that I haven't, so looking to see how others deal with their data at year end (or any other period for that matter).
Thanks,
Thanks,