We added some filtering capabilities to Transactions & Realized Transactions. The idea was help avoid time consuming downloads to excel to analyze specific behaviot. Below please see a screenshot of the filters for realized transactions. Here are some examples of the filtering you can do :
See only the realized transactions that lost 50% or more by entering -50 in “Max Pct”
See only the realized transactions that were triggered by a specific sell rule
See only the positions that were closed in 60 days or less by entering 60 in “Max Days”
It would be a good addition if you could exclude certain notes. Like Gain% which would exclude sells just because the stock had a large gain. I do not always catch these on my first run through the spreadsheet.
Alternatively, it would be good if more than one rule could be included. E.G., Note contains SellRule 1, SellRule 2,…Including “no sell rule” or blank. This would be a way to exclude Gain% (and other rules).
I would like to see the excel download feature when set to (daily) actually buy/sell each position daily rather than aggregate the trades from buy/sell if held for more than one day. This would allow for better analysis and table comparisons across multiple strategies so that the days line up on the download. If this feature already exists, pls suggest the settings. Thanks.
