![]() Potential % Profit: Automated calculation using Entry Price and Projected Target Price. Initial Risk %: Automated calculation using the Entry Price and Initial SL Price. Potential R Profit: Automated calculation based on the projected profit relative to R (from R=1% of SB column). This should always be around 1, as we want to be risking close to the same percentage of capital on each trade (unless your trading plan states otherwise). Potential R Risk: Automated calculation based on your risk and the amount of capital placed into the trade (discussed later) divided by your R calculation from earlier. Initial SL Price: The price of your initial stop loss when you take the trade. Projected Target Price: This is your initial expected profit target for the trade, at the time you take the trade. This will allow the Win Rate to be calculated (shown along the top of the sheet).Įntry Price: Input the entry price of the trade.Īctual Exit Price: Input the actual exit price when the trade is finished. If the trade is a loss, put a “1” in the loss column. Win and Loss: If the trade is a win, put a “1” in the win column. If you do this, update the column heading to reflect what you are risking. If you want to use a different percentage, change the formula from =0.01xC5 to the percentage of your choosing, =0.005xC5 for example (for 0.5%). 1% of the account is the default and a commonly used percentage. ![]() R is how much we are willing to lose per trade. R=1% of SB: Automatically calculates 1% of the starting balance. Starting Balance: The balance in the account at the time of the trade (all cash + current positions). Symbol: The stock symbol you are trading. Below are all the criteria included and what they mean/how to use them.Įntry Date: The day the position is opened.Ĭlosing Day: The day the position is closed. Here is the download for the Swing Trading Trade Log 2023. By tracking separately you may find you trade better in a particular market, and thus may wish to focus more attention and capital there. The Canadian market has less volume and more lower-priced stocks. Ideally, track US and Canadian trades separately they involve different currencies and the markets may act differently. The file has two pages/tabs, one for US dollar trades and one for Canadian dollar trades (change to another market if you like). If you want additional criteria included in the Log, drop a comment and I can possibly update the file to include it, or you can try adding it on your own. This Excel Trade Log is loaded with key metrics that we want to track in our trading. Downloadable Swing Trading Trade Log in Excel for 2023 Loads of features, totally customizable, and minimal effort on your part. If you prefer the hands-on approach, the trade log below is for you. I tried a number of these sites and while they did provide some insight, I didn’t find them very functional or useful, especially since I trade stocks in different currencies and Canadian market functionality is typically limited. These sites also charge a fee, typically $250 to $500 per year. A number of the software-based trade logs don’t support markets outside the US, or functionality is limited. You can often only choose one default currency, which may affect results if you make trades in multiple markets (such as US and Canada). Typically you still need to manually import your trades. This is a viable option…but isn’t without quirks. ![]() There are a number of sites, like TradeMetria, TradersSync, TraderVue, and TradesViz, that allow you to upload your trade history (download it from your broker) and have all the data analyzed for win rate, risk/reward, profitability, and more. Others prefer to use software to analyze their trades. Some people like to track their trades manually, in a spreadsheet or Google document. It is a useful practice to track your trades and statistics related to your trading. Just plug in a few key points about your trades, and the statistics (win rate, expectancy, even position size, and more) are calculated for you. Nearly all the statistical calculations are done for you. Keeping these statistics healthy is pivotal for trading success.īelow is a downloadable swing trading trade log, in Excel format, that you can use to start tracking your trades and statistics….and improving your trading! The formulas can even calculate your ideal position size for you.Ī swing trading trade log is for tracking trades, including basics like entry and exit points, and profitability, but it can also track metrics such as win rate, risk/reward, expectancy, and efficiency. Use this swing trading trade log to highlight weak areas in your trading.
0 Comments
Leave a Reply. |