This Excel spreadsheet provides a trading journal for active stock traders. It’s designed for traders who want to track, manage and maximize their performance in an easy-to-use spreadsheet.
This spreadsheet will help you track every single buy and sell in a customizable journal. New trades are easily added, and the spreadsheet suggests a stop-loss (based on the average true range, which every serious trader should know) and buy quantity (based on the initial risk, or 1R). Trades are saved in a historical ledger, and the spreadsheet summarizes all important trading parameters.
The New Trade section lets you specify a trade, including the buy date, ticker symbol, ATR, buy price, and quantity purchased. If you’ve entered the last trading price, the spreadsheet will also suggest a quantity to purchase
When you click the SAVE TRADE button, the trade is entered into the Ledger section. When they’re known, you can enter the sell price, sell commission and close date. The spreadsheet then calculates the realized profit (or loss!), the R-multiple, and several other parameters.