ZorantaGuides
Profitday

Profitday › Guides

Daily Profit and Loss Tracker: A Simple Spreadsheet Layout

A daily profit and loss tracker needs only a few columns: date, what the result was from, the amount with its sign, and a note. Everything else (daily totals, monthly totals, winning days) can be calculated from those four.

Here is a layout that works in Excel or Google Sheets, the formulas to go with it, and the mistakes that make a tracker drift away from your real balance.

An open notebook beside a phone, for writing down each day's result

Daily profit and loss tracker: the columns

ColumnExampleWhy it is there
Datea date in your own time zoneGroups results by day
TypeP&L / Deposit / WithdrawalKeeps money moved in and out apart from results
What forEUR/USD, S&P 500, sneakersLets you total by instrument or product
Amount+120 or −45The net result, after fees
Notemoved stop earlyOne line you will want to read later

Keep it to these. Extra columns such as entry price, exit price and setup belong in a full trading journal. A daily gain and loss tracker works because it takes seconds to fill in, so you actually do it every day.

Profitday

Profitday works like this layout on your phone: each record is what it was for, a signed amount and a note, with a large plus/minus switch, and you can enter single trades or one total per day. Get it on Google Play

One row per trade or one total per day

Both work. Pick one and stay with it for at least a month.

One row per tradeOne total per day
Time to fill inLonger if you trade oftenA few seconds
Win rateCan count by trade or by dayBy day only
Totals by instrumentYesOnly if you split the total
SuitsSwing traders, a few trades a dayScalpers, resellers, anyone with many small results

If your broker or marketplace already gives you a daily statement, copying one total per day from it is the fastest way to keep the tracker matched to your account.

Formulas for a daily profit loss spreadsheet

Assume the columns are A (Date), B (Type), C (What for), D (Amount), E (Note), with headers in row 1.

To count winning days, make a second small table with one row per date and the daily total next to it, then use =COUNTIF(range, ">0") for winning days and =COUNTIF(range, "<0") for losing days. Days at exactly zero count as neither.

Worked example

DateTypeWhat forAmount
Day 1P&LEUR/USD+150
Day 1P&LEUR/USD−60
Day 1Deposit500
Day 2P&LGold−90
Day 3P&LEUR/USD+40

Day 1 P&L is +150 − 60 = +90. Day 2 is −90, day 3 is +40. The three-day total is +40, with two winning days and one losing day. The 500 deposit raises the balance but is not part of the +40.

Mistakes that make the tracker wrong

Once a month, compare the tracker's total with the change in your account balance after deposits and withdrawals. If they differ, look for a missing fee or a mistyped sign before the gap grows.

Leveraged trading can lose money fast, and losses can exceed what you deposited. A tracker records your results; it is not a strategy or advice. FINRA's page on frequent intraday trading explains the risks.
Profitday

Track daily results in seconds

Profitday keeps deposits and withdrawals apart from profit and loss and shows each day on a monthly calendar. CSV import and export let you bring over an existing spreadsheet.

Get it on Google Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of Profitday.