Options Trading Journal Spreadsheet for Excel & Google Sheets
Track calls, puts, spreads and iron condors by position, with DTE and premium analytics
Price: ₹549 (one-time purchase)
Format: ZIP (XLSX + PDF)
Delivery: Instant download after payment is confirmed.
Category: Trading Journals
Description
Options P&L is easy to misread when a trade has two or four legs. This journal records every leg, rolls legs with the same Position ID into one position, and measures what each strategy and expiry window really returns after fees. An options trading journal for Excel and Google Sheets. Log each leg, group spreads and condors into positions, and see results by strategy, days to expiry, call or put and side. WHO IT'S FOR Options traders who buy calls and puts, sell premium, or trade spreads, strangles and iron condors on equity or index options. WHAT'S INSIDE • Options Trading Journal workbook, blank — Excel XLSX, 8 tabs (280 KB) • Sample workbook with 97 fictional rows — Excel XLSX (295 KB) • Quick Start Guide — PDF, A4, 6 pages (1.2 MB) • README with contents, license and support — TXT HOW IT HELPS • Trade Log with 500 rows for calls and puts, strikes, expiries, premiums, contracts and fees • Contract multiplier per row (default from Settings), so it works for 100-share and other contract sizes • Multi-leg positions with a Position ID; win rate, R and drawdown count each position once • Automatic gross and net P&L, risk, R, premium credit or debit, DTE and DTE bucket • Dashboard with 20 metrics and breakdowns by strategy, DTE, call or put, side, weekday, emotion and mistake • Monthly results, equity curve and drawdown charts • Daily and weekly review sheets HOW TO USE 1. Download and unzip the file. 2. Open Options-Trading-Journal-Blank.xlsx in Excel, or upload it to Google Drive and choose File > Save as Google Sheets. 3. Fill in the Settings sheet (account, rules and lists). 4. Add one row per entry in the Trade Log. Type only in the soft-gold cells. 5. Review the Dashboard, Monthly and Charts tabs, and use the review sheets. COMPATIBILITY Microsoft Excel 2019 or newer (including Microsoft 365), Google Sheets and LibreOffice Calc. No macros or add-ins. GOOD TO KNOW This is a manual tool: it does not connect to any broker or data feed. Educational record-keeping tool only, not financial advice; it does not predict or guarantee any result. Sample data is fictional. LICENSE Personal use. You may edit the files for your own records but not resell, share or redistribute them.
What's included
- Options Trading Journal workbook, blank — Excel XLSX, 8 tabs (280 KB)
- Sample workbook with 97 fictional rows — Excel XLSX (295 KB)
- Quick Start Guide — PDF, A4, 6 pages (1.2 MB)
- README with contents, license and support — TXT
- Single ZIP download (1.2 MB)
Frequently asked questions
Does it handle spreads and iron condors?
Yes. Enter each leg on its own row with the same Position ID. The journal adds the legs together and counts the trade once.
What multiplier should I use?
Most US-listed equity options use 100. Set your default on Settings, or type a different multiplier on any row.
How do I record an option that expired or was assigned?
Expired worthless: Exit Premium 0. Assigned or exercised: enter the intrinsic value at expiry as the Exit Premium.
Does it calculate Greeks or connect to my broker?
No. It is a manual journal for recording and reviewing trades. It does not fetch prices or calculate Greeks.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and save it as a Google Sheets file. Excel 2019+ and LibreOffice also work.
Can I share it?
No. The license is for personal use only.
Tags: options trading journal, options journal spreadsheet, options trade tracker, iron condor tracker, credit spread journal, trading journal excel, trading journal google sheets, 0dte journal, options p&l tracker, trade log, options trading