ZorantaGuides
Profitday

Profitday › Guides

PnL Calendar: How to Read Your Trading Month Day by Day

A PnL calendar is a monthly grid where each trading day shows that day's net profit or loss, usually green for a positive day and red for a negative one. Blank days had no closed trades. One look tells you how the month went, and a second look shows when it went wrong.

Below: what goes into each day, how to build one on paper or in a spreadsheet, and what to look for when you review the month.

A monthly calendar with green and red day tiles

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 calendarWhat it tells you
Each day's amountNet result of everything closed that day
Colour of the dayPositive, negative or flat at a glance
Weekly total (optional column)Whether one bad day wiped out a good week
Monthly totalYour monthly PnL, the figure to compare month to month
Winning and losing daysHow 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

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.

How to build a profit and loss calendar

On paper or in a spreadsheet

  1. Draw a seven-column grid for the month, starting on Monday or Sunday, whichever you use for your trading week.
  2. At the end of each trading day, write the net amount in that day's box with a plus or minus sign.
  3. Colour the box: green for a positive day, red for a negative day, nothing for a flat day or no trades.
  4. Add an eighth column for the weekly total.
  5. 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.

QuestionWhat 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.

Trading leveraged products such as forex, CFDs and crypto derivatives can lose money quickly, and losses can be larger than the money you deposited. A PnL calendar records results; it does not predict them. This page is general information, not financial advice. See the U.S. SEC's Investor.gov note on day trading.

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.

Profitday

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 Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of Profitday.