What a PnL calendar shows
A list of trades tells you what happened one trade at a time. A profit and loss calendar for trading groups the same records by date, so you see the shape of the month instead of a long column of numbers.
| Part of the calendar | What it tells you |
|---|---|
| Each day's amount | Net result of everything closed that day |
| Colour of the day | Positive, negative or flat at a glance |
| Weekly total (optional column) | Whether one bad day wiped out a good week |
| Monthly total | Your monthly PnL, the figure to compare month to month |
| Winning and losing days | How many days ended up and how many ended down |
The calendar does not explain why a day was red. It tells you which days to open and read in detail, which is often the hardest part of reviewing your own trading.
Profitday is a monthly PnL calendar: you log what the trade was for, the amount and an optional note, and each day shows its result in colour with deposits and withdrawals kept apart. Get it on Google Play
What to count on each day
Decide the rules once and keep them. A calendar that mixes methods from week to week is hard to compare.
- Closed trades only. Count a trade on the day it was closed. Open positions move every day and would make past days change after the fact.
- Net of costs. Use the result after commissions, spreads and swap or funding charges, the amount that actually reached your balance.
- Deposits and withdrawals kept apart. Money you add or take out is not profit or loss. Mark those days separately so a deposit does not look like a winning day.
- One calendar per account or activity. If you trade forex and also resell goods, keep separate calendars, or at least separate totals, so one does not hide the other.
- Your own time zone. Pick the date in the time zone where you live and stick to it, so a late-night trade does not jump between days.
How to build a profit and loss calendar
On paper or in a spreadsheet
- Draw a seven-column grid for the month, starting on Monday or Sunday, whichever you use for your trading week.
- At the end of each trading day, write the net amount in that day's box with a plus or minus sign.
- Colour the box: green for a positive day, red for a negative day, nothing for a flat day or no trades.
- Add an eighth column for the weekly total.
- At month end, add up the monthly total and count the winning and losing days.
In a spreadsheet, keep the raw daily figures in a separate list (date and amount) and build the grid from that list with a SUMIF on the date. Conditional formatting can then colour the cells. Typing amounts straight into the grid works for a month or two, but it gets hard to total by year.
Writing amounts so they still fit
Large amounts crowd a small calendar box. Shorten them the same way every time, for example 7,400 as 7.4K. Keep the sign on the amount as well as the colour: colour alone is easy to misread, and some people print or view the calendar in black and white.
Reviewing your monthly PnL on the calendar
At month end, spend ten minutes on these questions. Each one comes straight from the grid.
| Question | What to look for |
|---|---|
| Where did most of the loss come from? | One or two deep red days, or many small ones |
| Do red days come in runs? | Two or three losing days in a row, then a bigger loss |
| Is there a weekday pattern? | The same weekday red in several weeks |
| What happened after the best day? | A loss the next day can point to oversizing after a win |
| How big is the worst day against the monthly total? | A single day larger than the whole month's profit |
Worked example: a month with 12 green days averaging +80 and 8 red days averaging −95 ends at 12 × 80 − 8 × 95 = 960 − 760 = +200. If one of those red days was −400, removing it would have turned the month into +600. That tells you where to look first: what was different about that day.
Comparing months
Lay three or four monthly calendars side by side. Compare the monthly totals, the number of winning days and the size of the worst day. A month with fewer trading days but a similar total can be a better month, because it carried less exposure to get there.
Sharing a calendar without sharing the numbers
Many traders post their month as an image. If you prefer not to show your account size, share the colours only, or shortened amounts, rather than exact figures. A grid of green and red days still shows your consistency without revealing your balance.
Keep the calendar without the spreadsheet work
In Profitday the monthly total, winning and losing days and win rate sit at the top of the calendar, and you can turn the month into an image that shows exact amounts, short amounts or colours only.
Get it on Google PlayiPhone version coming soon
More guides
- Daily Profit and Loss Tracker: A Simple Spreadsheet LayoutSet up a daily profit and loss tracker in Excel or Google Sheets: the columns you need, per-trade or one total per day, formulas for running totals, and common mistakes.
- Trading Win Rate Formula: By Trade or By Day?Win rate = winning trades ÷ total trades × 100. How counting by day differs from counting by trade, how to treat break-even results, and what win rate leaves out.
- How to Calculate Portfolio Return With Deposits and WithdrawalsSeparate deposits and withdrawals from profit, then work out your return three ways: simple, Modified Dietz and time-weighted, with one worked example.
- Reselling Profit Tracker: Work Out Real Profit Per FlipHow to track reselling profit: the costs to subtract from each sale, profit margin vs ROI, a simple tracker layout, and how to see your profit by day and by month.
Published by Zoranta, the developer of Profitday.