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,
Various threads on the forum are currently discussing a topic similar to yours. it's an end of year thing. I was hoping we could put them together and get some reviews going. Here is what I found to be the most economical and flexible solution (product wise). I will demo it after the holidays. I am hoping it allows for data exports for even deeper analysis. Www.tradingdiarypro.com Most of the excel shareware is basic trader efficiency calculations but stllll require tedious sorting thru your trades. Too much wasted time. I want to see my performance dtd, wtd, mtd.