Free download · 15 columns, all formulas included

A free excel trading journal that gets options P&L right

This is a working excel trading journal you can download and use today. It has two sheets: Trades, where you type each fill, and Summary, which calculates your win rate, profit factor, expectancy and average R automatically. It ships with 10 example trades already filled in so you can see how the numbers behave before you enter your own.

What is inside

• Trades sheet with 15 columns: date, ticker, side, qty, multiplier, entry, exit, fees, gross P&L, net P&L, risk, R, setup, exit reason and notes
• Gross P&L, net P&L and R are live formulas. Everything else is typed by you
• Formulas filled down to row 201 and blank-guarded, so empty rows stay empty
• A multiplier column that handles shares (1) and option contracts (100) correctly
• Summary sheet with trades closed, wins, losses, win rate, net P&L, average win, average loss, average win / average loss, profit factor, expectancy per trade, average R and fees paid
• A by-setup table using SUMIF and COUNTIFS. Type your own setup names and see net P&L, trade count and win rate for each one
• 10 worked example trades with real computed figures, so you can check the formulas against known output

Ten worked trades, and what they show

The file ships with 10 example trades. The Summary sheet reads them as 10 closed trades, 6 wins and 4 losses, a 60% win rate, and a net P&L of +$253.90. That looks like a working system. Then you read the next line: average win $313.87, average loss -$407.33. The average loss is larger than the average win, which is why profit factor is only 1.16 and expectancy is +$25.39 per trade. The by-setup table shows where the money actually went. Breakout made +$936.90 over 6 trades at a 66.7% win rate. Fade lost -$683.00 over 4 trades at a 50% win rate. One setup is funding the other, and the headline win rate hides it. Fees paid across the 10 trades were $25.60. That is the point of the file: it shows you the numbers you would rather not look at.

Why the multiplier column matters

Most free trading journal spreadsheets assume every position is a stock. They calculate P&L as (exit minus entry) times quantity. That works for shares. It is wrong by a factor of 100 for a single option contract, because one contract controls 100 shares.

This file has a multiplier column. Type 1 for shares, 100 for an option contract. The gross P&L, net P&L and R formulas read that cell, so an options trade and a stock trade can sit in the same sheet and both come out right. If you have ever looked at a generic template and wondered why your options P&L was off by two zeros, this is the fix.

What the summary actually tells you

The Summary sheet is all formulas. It counts your closed trades, splits them into wins and losses, and calculates win rate, net P&L, average win, average loss, the ratio between them, profit factor, expectancy per trade, average R and total fees paid. Nothing is typed there. It reads the Trades sheet.

The by-setup table is the part most templates leave out. It uses SUMIF and COUNTIFS against the setup column, so you type your own setup names once and the sheet shows net P&L, trade count and win rate for each. That is how you find out which of your setups is carrying the account and which one is quietly giving it back.

The honest trade-off: it is manual

A spreadsheet does not connect to your broker. You type every row yourself: date, ticker, side, quantity, multiplier, entry, exit, fees, risk, setup, exit reason. If you trade often, that is real work, and it is the main reason people abandon journal spreadsheets after a few weeks.

If you want the same metrics without the typing, TickerReplay imports your fills and calculates them for you. If you only want the file, that is fine too. The download is free, there is no email required, and the formulas are visible so you can audit or change any of them.

Common questions

Is this excel trading journal really free?

Yes. You download the .xlsx file and use it. There is no email required, no trial and no locked sheet. The formulas are visible and editable.

Does it work for options trades?

Yes. The multiplier column is set to 100 for an option contract and 1 for shares, so the P&L and R formulas calculate both correctly in the same sheet. It handles single-leg options. Spreads and rolls need to be entered as separate rows or adjusted manually.

Does it import trades from my broker?

No. This is a manual spreadsheet. You type each row yourself. If you want automatic import, TickerReplay does that, but the file itself does not connect to any broker.

What is the R column and why is it sometimes blank?

R is your profit or loss divided by the risk you took on the trade. The risk column is typed by you, not derived from entry and stop. If you leave risk blank, R stays blank. That is deliberate: the sheet will not guess your risk for you.

Can I add my own setups to the by-setup table?

Yes. Type your setup names into the setup column on the Trades sheet. The Summary table uses SUMIF and COUNTIFS, so it picks up whatever names you use and shows net P&L, trade count and win rate for each.