Link
Description
Easy to use maximum favorable excursion and maximum adverse excursion candlestick chart for past trades built for Sierra Chart trade exports, but trades from any software can be used instead. Clean way to visualize an important element of trade performance.
The high, low, and closing PNL of each trade is represented in the candlestick. This version is static, check back soon for the dynamic release.
How-To Use
Sierra Chart Users:
Just paste copied Sierra trades into Excel file cell A50 of sheet TradeStats. More details here:
- Open Sierra Chart > Trade Tab > Trade Activity Log > [*Trades]
- Select the date range, P/L format, and other desired settings
- Click “Edit” > Copy All
- Open the Excel file provided
- Paste into the highlighted cell A50
- Switch sheets to view the MFA/MAE candlestick bars
Non Sierra Chart Users:
Using extra cells provided, you will need to access the following information from your other trading software:
- Position Max profit
- Position Max loss
- Position Closed PnL
It requires you paste the information from above into the AQ, AR, AS columns as pictured below
Notes
To shorten or lengthen the maximum trades analyzed:
- Right click in the chart found in the TRADES sheet
- Click Select Data
- Under Legend Entries, Series 2, 3, and 4 each need to be selected individually and click Edit as pictured here:
- Change the range set in the Series Values bar. By default it’s to AQ$400, change 400 to any value desired (trade count)
My Official Links
Twitter: https://twitter.com/zigsonthebid
Opensea: https://opensea.io/ziiiggy
Website: https://www.ziiiggy.com/
Gumroad: https://ziiiggy.gumroad.com/