|
kmcintyre
Posts: 410
Joined: 8/30/2007
Location: Valley Center, CA
 User Profile |
I want to export trade information into Excel so I can sort by % Return. I want to focus in on the worst performing trades to see what went wrong. I also want to see a distribution of % Returns to get an idea of how many outliers exist, how consistent the performance is, etc.
I thought I saw Ed bring up a report that wasn't Crystal Report generated. It might even have had MFE and MAE stats. But I can't find it...
How can I export trade data and/or get a better report than the PortSim "View Trades"?
Thanks
|
|
LSJ
Posts: 515
Joined: 8/17/2006
Location: Citrus Springs, FL
User Profile |
Have you tried an excel export and pivot table?
In Port Sim you view trades. Then choose export report and select .xlsx from the dropdown.
In the new Excel file you find Pivot table in the menu bar. It then gives you choices to select what you want to see. You can then use the Sort function to group the results the way you want.
|
|
kmcintyre
Posts: 410
Joined: 8/30/2007
Location: Valley Center, CA
User Profile |
You said -
In Port Sim you view trades. Then choose export report and select .xlsx from the dropdown
That is what I needed. Totally didn't see it.
Yes, Pivot Tables are awesome!
Thanks
|