# How To Build A Covered Call Spreadsheet

> Build a covered call tracker in Google Sheets, formula by formula — and download our free example sheet to start tracking your positions today.

Source: https://www.marketdata.app/sheets/options/how-to-build-a-covered-call-spreadsheet/

---

(image: Covered call payoff profile: the combined position breaks even at 95, rises to a profit of 5.00 at 100, and stays flat above it, while losses continue below 95.)

-   [Options Data](/topics/data/options/)
-   [Options in Google Sheets](/topics/sheets/options/)
-   [Tutorials](/tutorials/)

Build a covered call tracker in Google Sheets, formula by formula — and download our free example sheet to start tracking your positions today.

-   Last updated September 1, 2026

Most of the popular brokers (such as [TD Ameritrade](https://www.tdameritrade.com/) and [Robinhood](https://robinhood.com/)) **don’t make it easy to track your covered calls**. Popular metrics for covered call traders such as cost basis reduction and daily theta are not available through most brokers. And to make it worse, each time you roll a call option or sell a new one, the broker considers it a new position, instead of a modification of your existing covered call position. Most covered call sellers use a spreadsheet to keep track of all their trades. And with Market Data’s [Google Sheets Add-On](/sheets/), it’s easier than ever to track covered calls in a spreadsheet.

## See A Covered Call Tracker In Action

The Market Data Add-On will let you **see the value of any covered call position**, whether its **active or historical**. This means you can track all your current covered calls, previous covered call trades, or even backtest a covered call idea to see if it’s a valid strategy.

[How To Track A Covered Call Options Position In Google Sheets in A Single Cell](https://youtube.com/watch?v=X9G0qGDsiNk)

## Covered Call Spreadsheet Formula Cheat Sheet

Use this cheat sheet of formulas to quickly build out your own covered call spreadsheet. These formulas are all prepared with real-life covered call examples for Apple, so you can try this yourself in Google Sheets after installing the Add-On. Just replace the option symbol with your own and you’ll be ready to track your calls.

### Real Time Quotes

-   Real-Time Call Quote
    -   `=OPTIONDATA("AAPL271217C00250000")`
-   Real-Time Level 1 Call Quote With Complete Bid/Ask Data
    -   `=OPTIONDATA("AAPL271217C00250000","all")`
-   Current Value Of An Open Covered Call Position (100 Shares In AAPL – Closing Value Of Your Call)
    -   `=100*STOCKDATA("AAPL")-OPTIONDATA("AAPL271217C00250000")`

### Historical Quotes

For the historical quotes, just change the dates to the dates that you need. The first date is the starting date and the second date is the end date. When there is just a single date, that will give you the quote for a single specific day in the past.

-   Historical Call Quote From A Single Day
    -   `=OPTIONDATA("AAPL271217C00250000","price","8/25/2026")`
-   Historical Call Quote From Multiple Days
    -   `=OPTIONDATA("AAPL271217C00250000","date,price","8/03/2026", "8/31/2026")`
-   Historical Full Level 1 Call Quote With Complete Bid/Ask Data Over Multiple Dates
    -   `=OPTIONDATA("AAPL271217C00250000","all","8/03/2026", "8/31/2026")`
-   Historical Value Of A Covered Call Position (100 Shares In AAPL – Closing Value Of Your Call)
    -   `=100*STOCKDATA("AAPL","close","8/05/2026")-OPTIONDATA("AAPL271217C00250000","price","8/05/2026")`