Jira & Confluence 
Bitrix24 Trading journal · P&L · win rate · Excel
Trading journal spreadsheet — calculate P&L, win rate, equity, and strategy results
Short answer. Record entry, exit, quantity, side, strategy, and fees once. Trade log: long and short entry, exit, quantity, fees, dates, strategy, and notes (Trades sheet).
- Review the journal every seven daystype the date
Check your own case.
A review rhythm, not a market forecast or deadline.
Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.
Lida, Layers template assistant
A journal is useful when every trade follows the same definitions.
Reconcile first; interpret the win rate only after costs and losing trades are present.
Deadlines
The rules, with the source
| What | Deadline | Source |
|---|---|---|
| Trade log | Long and short entry, exit, quantity, fees, dates, strategy, and notes | Trades sheet |
| Performance | Net P&L, return, outcome, win rate, average win/loss, profit factor, and equity curve | Dashboard |
| Strategy review | Trades, wins, win rate, net and average P&L by named setup | Strategy Analysis |
Formulas use price difference × quantity − fees. Verify contract multipliers, currency, taxes, borrow costs, and brokerage treatment for your instruments.
Step by step
What to do, in order
1
Record
Enter one row per trade; leave Exit blank while a trade remains open.
2
Reconcile
Match closed trades and fees to the brokerage statement before relying on totals.
3
Review
Compare setups, largest losses, rule adherence, and notes; do not treat past results as a forecast.
Questions
How does the spreadsheet calculate P&L?
Long P&L is (exit − entry) × quantity − fees; short P&L reverses the price difference.
How is win rate calculated?
Winning closed trades divided by all closed trades. Breakeven trades are not counted as wins.
Can I leave a trade open?
Yes. Leave Exit blank and the P&L, outcome, and holding-days cells remain blank.
Does it include an equity curve?
Yes. Running net P&L is added to the editable starting balance and charted by trade number.
Is this investment advice?
No. It is an educational recordkeeping workbook and does not recommend trades, securities, or strategies.
Other documents
Keep the papers in one place
Letters, receipts and notices in one folder you can share with family or a lawyer. The templates and the editor are free; Layers is free for up to 20 people.
Educational recordkeeping only — not investment, tax, accounting, or brokerage advice. Past results do not predict future performance.