Daily profit and loss tracker: the columns
| Column | Example | Why it is there |
|---|---|---|
| Date | a date in your own time zone | Groups results by day |
| Type | P&L / Deposit / Withdrawal | Keeps money moved in and out apart from results |
| What for | EUR/USD, S&P 500, sneakers | Lets you total by instrument or product |
| Amount | +120 or −45 | The net result, after fees |
| Note | moved stop early | One 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 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 trade | One total per day | |
|---|---|---|
| Time to fill in | Longer if you trade often | A few seconds |
| Win rate | Can count by trade or by day | By day only |
| Totals by instrument | Yes | Only if you split the total |
| Suits | Swing traders, a few trades a day | Scalpers, 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.
- Total P&L for one day (date in cell H2):
=SUMIFS(D:D, A:A, H2, B:B, "P&L") - Total P&L for a month (first day of the month in H2):
=SUMIFS(D:D, A:A, ">="&H2, A:A, "<="&EOMONTH(H2,0), B:B, "P&L") - Total for one instrument (name in H3):
=SUMIFS(D:D, C:C, H3, B:B, "P&L") - Net deposits for the same period: the same SUMIFS with Type set to Deposit, minus the one for Withdrawal
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
| Date | Type | What for | Amount |
|---|---|---|---|
| Day 1 | P&L | EUR/USD | +150 |
| Day 1 | P&L | EUR/USD | −60 |
| Day 1 | Deposit | 500 | |
| Day 2 | P&L | Gold | −90 |
| Day 3 | P&L | EUR/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
- Dropping the minus sign. A loss typed as 45 instead of −45 swings the total by 90. Check the sign before you move on, or use a separate column for gains and losses.
- Counting deposits as profit. Adding money to the account is not a winning day. Give deposits and withdrawals their own Type.
- Using gross results. Commissions, swaps and marketplace fees are real costs. Record the net amount.
- Filling it in from memory at the weekend. Small losses are the first thing forgotten. Enter the day's result the same day.
- Mixing currencies. If you have accounts in different currencies, keep a tab per account rather than adding dollars to rupees.
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.
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 PlayiPhone version coming soon
More guides
- PnL Calendar: How to Read Your Trading Month Day by DayA PnL calendar shows each day's profit or loss in a monthly grid. How to set one up, what to count on each day, and the patterns worth checking at month end.
- 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.