EYEGUY Icon    Posts: 1543 Joined: 12/12/2003 Location: BALDWINSVILLE, NEW YORK  User Profile | For those of us who don't know about the Insert...Recommended Pivot Tables function of Excel here is what I did. First I exported the Trades in my Portfolio Simulation in .xlsx form - this is Data Only. Note that this data includes both the Market State and the Strategy: Then I opened the Excel file thus generated and highlighted all the data (this might be unnecessary but it worked). I went to Insert....Recommended Pivot Tables and chose one of the recommended formats and voila: What a truly great Excel function! Thanks for pointing it out to me. Tom Helget [Edited by EYEGUY on 3/15/2018 11:31 AM]  Attached file : Equity Trades Report.PNG (67KB - 2036 downloads) Attached file : Excel Insert....Recommended Pivot Tables.PNG (265KB - 2006 downloads) |
