Trading Spreadsheet
Trading Diary
All good traders should keep track of their trades in a Trading Diary, and learn from their most profitable and least profitable trades.
You should record:
- Trade number (a chronological list of all trades)
- Date of the trade
- Market/stock type
- Ticker (stock code)
- Long/Short
- Number of Shares
- Entry
- Commissions
- Total (Entry price x number of shares + commission)
- Stop loss point
- Exit Date
- Exit Price
- Commission
- Total (Exit price x number of shares – commission)
- Profit/Loss
- Notes – Any significant notes about the trade.
Excerpt from ‘The Everyday Trader’s Stock Market Education Course’
