Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文
Options Trading Journal Ultimate ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Options Trading Journal Spreadsheet Template for Google Sheets & Excel

Pick the leg you traded and the money works itself out - direction, premium, contract count and fees all folded into one cash flow. The Essentials Options Trading Journal spreadsheet template handles opening and closing legs in both directions so the sign follows the action, nets fees into the result rather than reporting them separately, holds thirty trades on a single log, and shows the net total, the win rate and the number logged on a dashboard. Google Sheets and Excel. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate Options Trading Journal Spreadsheet Template
$29
Essentials Options Trading Journal spreadsheet template - Google Sheets and Excel preview

What's Included

  • Cash flow derived from the leg traded, the premium, the contract count and the fees
  • Opening and closing legs handled in both directions, so the sign follows the action
  • Fees netted into the result rather than reported separately
  • Every trade on a single log
  • Dashboard carrying the net total, the win rate and the number logged
  • Largest single inflow and outflow picked out
  • A chart carrying the same picture
  • A currency dropdown on the Dashboard that relabels money columns across both sheets
  • Step-by-step "How to Use" guide on a tab of its own
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • Cash flow derived from the leg traded, the premium, the contract count and the fees
  • Opening and closing legs handled in both directions, so the sign follows the action
  • Fees netted into the result rather than reported separately
  • Every trade on a single log
Ultimate - $29
  • A Trade Log carrying date opened and date closed on every position
  • Entry and exit cost as total position values, with result and percentage return derived
  • Open positions marked simply by leaving the close date blank
  • Strategy and direction dropdowns that keep the breakdowns consistent
  • Strategy Analysis with total, count, win rate, average result and average return per approach
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials Options Trading Journal Spreadsheet Template for Google Sheets and Excel is a two-sheet workbook that works the cash out of each leg rather than asking you for it, with a How to Use guide on a third tab. It works as an Essentials Options Trading Journal Excel template and an Essentials Options Trading Journal Google Sheets template from the same download. Where the Free build takes the result as a number you supply, this Essentials Options Trading Journal spreadsheet template derives it from the leg you traded, the premium, the contracts and the fees. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Options Trading Journal spreadsheet template

The FinancialAha Essentials Options Trading Journal Spreadsheet Template runs on two working sheets - one you type into, one that reports back - plus the guide. It works in both Microsoft Excel and Google Sheets and here is what the Essentials Options Trading Journal spreadsheet holds.

  1. 01 of 02

    Options Log

    The sheet you type into, a row per trade. Each carries the date, the underlying, whether it was a call or a put, the strike and expiry, and then the part that does the work: which leg it was - opening or closing, bought or sold. That choice decides the direction of the money, so the cash flow follows from the premium, the contract count and the fees without you working out the sign. The convention is the standard one, with each contract standing for a hundred shares of the underlying.

    FinancialAha Options Trading Journal spreadsheet template - Options Log sheet

  2. 02 of 02

    Dashboard

    The journal summarised: the net figure across every row, the win rate, how many positions have closed, and the largest single inflow and outflow. A chart carries the same picture. It is worth knowing how the win rate is read: a round trip is logged as an opening entry and a closing one, but the win rate is taken from the closing leg only, so it counts each closed position once rather than counting rows.

    FinancialAha Options Trading Journal Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering setup, what each column expects, how the cash flow is arrived at from the leg and the fees, and what the colour coding means. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Options Trading Journal Spreadsheet template for Google Sheets

Upload the Essentials Options Trading Journal Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Options Trading Journal Google Sheets template needs no conversion step and the chart survives the trip intact - the cash flow keeps calculating exactly as it does in Excel. The currency dropdown on the Dashboard relabels every money column across both sheets at once.

Essentials Options Trading Journal Google Sheets template setup

A shared copy of the Essentials Options Trading Journal Google Sheets template works where a journal is reviewed by someone other than the person trading, and Sheets version history covers a row edited after the fact. Because the reporting sits on its own tab, the log stays a log.

Sharing the Essentials Options Trading Journal Google Sheet

Day to day the Essentials Options Trading Journal Google Sheet is a single line: date, ticker, type, strike, expiry, the leg, the premium and the fees. Everything on the Dashboard follows from that, so the daily job never involves a calculation.

Also available as:

Essentials Options Trading Journal Spreadsheet template for Excel

The Essentials Options Trading Journal spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Options Trading Journal Excel template directly, with no import step and no compatibility prompt, and the chart is a native Excel chart that redraws as rows go in. There are no macros and no VBA in the file, so it opens without a security warning.

Essentials Options Trading Journal Excel template setup

The same Essentials Options Trading Journal Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials Options Trading Journal spreadsheet download to choose between.

Essentials Options Trading Journal spreadsheet Excel notes

The Essentials Options Trading Journal spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Essentials Options Trading Journal spreadsheet Excel download also opens in Excel for the web, which matters when you move between a work machine and a personal one.

Opening the Essentials Options Trading Journal spreadsheet Excel file

Nothing in the Essentials Options Trading Journal Excel template is version-specific, so this Essentials Options Trading Journal spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Essentials Options Trading Journal spreadsheet template tracks

You log the trade and the sheet works out the money. These are the columns the Essentials Options Trading Journal Spreadsheet Template carries:

Date
the day the trade was placed
Ticker
the underlying stock or fund
Type
call or put
Strike
the strike price per share
Expiry
the contract's expiration date
Action
which leg it was, opening or closing, bought or sold
Contracts
how many were traded
Premium
the premium per contract
Fees
what the trade cost to place
Cash Flow auto
derived, its direction set by the action and net of fees

Compare builds

FinancialAha Options Trading Journal spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free View Spreadsheet Template Essentials This page Ultimate View Spreadsheet Template
Working sheets 1 2 6
Trade capacity 14 30 150
Result per row Entered by you Derived from the leg Derived, with % return
Open and close dates One date One date Both, with days to expiry
Fees counted – Yes Within entry and exit cost
Win rate – Yes Yes, and per strategy
Charts – 1 1
Strategy performance – – Dedicated sheet
Month-by-month P&L – – With a running total
Greeks on open positions – – Delta, gamma, theta, vega
Expiration calendar – – Yes, with premium at risk

The FinancialAha Essentials Options Trading Journal Spreadsheet Template covers two working sheets, and is the build where the sheet does the arithmetic. Against the Free Options Trading Journal Spreadsheet Template, which takes a result you have worked out yourself, this build derives the cash flow from the leg, the premium, the contracts and the fees, then reports a total, a win rate, a trade count and the extremes on a dashboard. Rows here are legs rather than round trips. The Ultimate Options Trading Journal Spreadsheet Template records complete positions with open and close dates, a percentage return on each, performance split by strategy, a month-by-month running total, the Greeks on open positions and an expiration calendar.

Compare the other builds: Free Options Trading Journal spreadsheet template or the Ultimate Options Trading Journal spreadsheet template .

Good to know

Notes on working in the Essentials Options Trading Journal spreadsheet template

  • The action column is what sets the direction of the money, so picking it correctly matters more than any other field on the row.
  • Fees are netted into the cash flow rather than reported separately, which keeps the total honest about what actually reached the account.
  • A round trip is logged as an opening entry and a closing one, but the win rate is read from the closing leg only, so it counts closed positions rather than rows.
  • Sample rows ship formatted. Adding more means extending the totals range as well, which the workbook explains.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials Options Trading Journal spreadsheet. It changes the label only and does not convert the numbers.

How to Use the Essentials Options Trading Journal Spreadsheet Template

1

Enter the trade

Add the date, ticker, whether it was a call or a put, the strike and the expiry.

2

Pick the action

Choose which leg it was - opening or closing, bought or sold. This sets the direction of the money.

3

Add premium and fees

Enter the premium per contract, the number of contracts, and what the trade cost to place.

4

Read the dashboard

The net total, the win rate, the count, and the largest inflow and outflow, with a chart alongside.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Options Trading Journal Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Options Trading Journal Google Sheets template needs no conversion step and the chart survives the trip intact.

Is the FinancialAha Essentials Options Trading Journal Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Options Trading Journal Excel template opens directly in Excel with no import step. The chart is a native Excel chart, and there are no macros or VBA.

Will the FinancialAha Essentials Options Trading Journal spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Options Trading Journal spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

How is the cash flow calculated in the Essentials Options Trading Journal spreadsheet?

From the action on the row. Whether the leg was bought or sold decides the direction of the money, and the premium, the contract count and the fees give the size - so the sign is never something you have to work out yourself.

What does the win rate measure in the Essentials Options Trading Journal spreadsheet?

The share of closed positions that made money, not a share of rows. A round trip is logged as an opening leg and a closing leg, but the win rate is read from the closing leg only, so a position counts once no matter how many legs it took to close. The Ultimate build goes further and logs each position as a single row with both open and close dates together.

How many trades does the Essentials Options Trading Journal spreadsheet hold?

Sample rows ship formatted. More can be added, though the totals range needs extending with them, which the workbook explains.

Are fees included in the Essentials Options Trading Journal spreadsheet?

Yes, netted into the cash flow on the row, so the total reflects what actually reached the account rather than the gross premium.

Does the Essentials Options Trading Journal spreadsheet track open positions?

Not separately - every row is a leg that has been traded. Open positions with a live percentage return and Greeks are what the Ultimate build adds.

How do I open the Essentials Options Trading Journal spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

More Essentials Investing & Trading Templates

Investment Portfolio Tracker

A name beside every ticker and a percentage return on each position, so holdings of very different sizes can be compared. The Essentials Investment Portfolio Tracker spreadsheet template carries 20 holdings, works out market value and gain per position, and puts total portfolio value and total gain on a dashboard with a chart of how the value splits between holdings. Google Sheets and Excel, one file. No macros, no VBA.

$19

Stock Trading Journal

Each of the thirty rows is one side of a trade, so buys and sells are logged apart and the cash flow takes its direction from the side, its size from the quantity and price, and its fees netted in. The Essentials Stock Trading Journal spreadsheet template settles a realised figure on closing rows against what you paid for that ticker, and an open position stays visible as a buy with no sell against it. Two working sheets and a chart, Google Sheets or Excel. No macros, no VBA.

$19

Crypto Portfolio Tracker

Percentage return sits beside value and gain on every one of twenty holdings, so a small position that doubled is tellable from a large one that drifted. The Essentials Crypto Portfolio Tracker spreadsheet template takes coin, symbol, quantity, average cost and current price per row, with a Dashboard carrying total value, total gain, overall return, total cost basis and how many holdings are ahead. Two working sheets and an allocation chart. Google Sheets and Excel. No macros, no VBA.

$19

ETF & Index Fund Tracker

Cost basis against current value on fifteen funds, and the gain, the overall return and each holding's share of the portfolio all follow from that pair. The Essentials ETF & Index Fund Tracker spreadsheet template records the annual charge per fund and weights it by holding size instead of averaging it flat, then reports the whole portfolio on a Dashboard. Two working sheets and an allocation chart. One file for Google Sheets and Excel. No macros, no VBA.

$19
Essentials
Preview
See Investing Ultimate Pack 8 templates included • Save $123

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →