sheethall.com

logo

Money

Google sheet

107

Option Tracker

Cost: Free

4.80 (121 ratings)

Options Tracker

This tracker is designed to help you efficiently monitor, analyze, and manage your options trading portfolio. It provides detailed insights into individual trades, portfolio performance, and overall profitability across multiple accounts.


Key Features

Trade Details

  • Columns Tracked:

    • Stock Symbol, Open/Close Date, Expiration Date, Option Type (Call/Put), Buy/Sell Indicator.
    • Key metrics: Stock Price at Date of Contract (DOC), Days to Expiration (DTE), Current Stock Price, Break-Even Price, Strike Price, Premium, Fees, Profit/Loss, Days Held, Annualized Return on Risk (ROR).
  • Separate columns for specific metrics based on trade type:

    • Put Options: Cash Reserve, Margin Cash Reserve.
    • Call Options: Cost Basis per Share.
  • Status and account categorization (e.g., Closed, Open).

Portfolio Summary

  • Account-wise performance breakdown:

    • Open and Closed Profit/Loss.
    • Cash Reserve and Margin Cash Reserve values.
    • Total Fees incurred.
  • Consolidated Totals: Aggregated data for all accounts.

Monthly Option Income

  • Yearly breakdown of monthly income earned from options trades.
  • Tracks income trends across multiple years to help identify profitable periods.
  • Year-to-Date (YTD) totals for quick reference.

Annual Option Income

  • Summarizes total option income earned annually.
About

Creator: Unknown

Follow us on Instagram: @thisismarc22

Update frequency: Quarterly

Creation date: Unknown

Last Update:

Request Free Access

What kind of topic are you interested in? *
First name *
Email *
We are adding new sheets, making updates and sharing new insights by email every week.

That's a bummer! Oh well, you can still follow us on Instagram I guess ❤️