A theta decay calculator shows how much value an option loses per day from the passage of time, all else equal. Theta comes from an option pricing model such as Black-Scholes: a theta of -0.05 means the option is expected to lose about $0.05 per share (about $5 per contract) over the next day. In Excel, MarketXLS returns theta with =opt_Theta(StockPrice, OptionPrice, ExpiryDate, "Call", Strike) or as a column of =QM_GetOptionChain("AAPL"), so you can track time decay across strikes and expirations. This guide explains the math and builds the calculator step by step. It is educational, not investment advice.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
What is theta decay in options?
Theta decay, also known as time decay, is a concept in options trading that represents the rate at which the value of an option decreases as time passes. It plays a crucial role in the pricing of options. This concept reflects the fact that an option’s value is not only determined by the price of the underlying asset, but it also includes the element of time. As an option approaches its expiry date, the probability of it being profitable (in-the-money) decreases, as there is less time for the underlying asset to move in the expected direction. This is why as each day passes, the value of options declines, reflected by the theta.
How do you calculate theta decay?
Theta decay, also known as time decay, is a key concept in options trading. It is essentially a measure of the rate at which an option’s price will decrease over time, assuming that all other factors remain constant. Theta itself is calculated by an option pricing model from the stock price, strike, time to expiration, implied volatility, and interest rate. To measure the decay you actually experienced, subtract the option’s current price from the price you paid and divide by the days held; that realized figure also includes the effect of stock and volatility moves. Be aware that theta decay accelerates as the option’s expiration date approaches.
Is theta Decay daily or hourly?
Theta decay, also known as time decay in options trading, refers to the rate at which the value of an option decreases as time passes. It is technically measured by the Greek letter theta. The decay is not based on a daily or hourly rate. Instead, it is continuous, happening every second of every trading day. However, for practical purposes, traders usually look at it on a daily basis. This is because analyzing it hourly would become too complex and offer little additional benefit. Hence, while theta decay is continuous, it is often observed on a daily basis.
Does theta decay overnight?
Theta, or time decay, refers to the reduction in the value of an option as time approaches its expiration date. The rate of this decay is not constant and does not pause overnight. Even when the markets are closed, theta continues to affect an option’s value, diminishing its worth day by day. This daily erosion of value is why theta is often referred to as a silent killer for options. However, the impact is usually reflected when the market reopens, primarily due to changes in perceived volatility along with time decay.
What is the theta strategy?
The theta strategy is a form of option trading strategy. It’s based on the idea of generating profit from the time decay of options, known as theta decay, which occurs because the value of options reduces as they approach their expiration date. To execute this strategy, traders sell options to take advantage of this decay. It tends to work best when the underlying stays in a range. Selling options is not low risk: losses can be large if the underlying moves sharply against the position.
How to profit from time decay of options?
Profiting from time decay in options involves a strategy called writing or selling options. The concept revolves around the principle that the value of options decreases as time passes, an effect known as time decay, represented by the Greek letter theta. When you sell an option, you want its price to fall so you can buy it back at a lower cost. Investors can sell either call or put options, depending on their market outlook, to exploit time decay. These are referred to as covered calls or cash-secured puts. It is essential to manage risk as option selling can incur significant losses if the market moves against you.
How do you use MarketXLS to calculate Theta decay in options?
MarketXLS calculates option theta in Excel with three functions:
- Current theta for one option:
=opt_Theta(CurrentStockPrice, MarketOptionPrice, ExpiryDate, OptionType, StrikePrice)returns the model theta from the inputs you supply. - Theta for a whole chain:
=QM_GetOptionChain("MSFT")returns the option chain with Greeks, including theta, for each contract (end-of-day on the Standard plan, real-time on Advanced and Business). - Historical theta:
=opt_ThetaHistorical(OptionSymbol("MSFT", DATE(2026,12,18), "Call", 450), TODAY()-1)returns theta for a contract on a past date.
In the Microsoft 365 add-in (Excel on Mac and Excel for the web), prefix functions with mxls., for example =mxls.Last("MSFT"). For details, see /formulas or contact support@marketxls.com.
Summary
Theta decay refers to how options lose value over time. Calculating theta decay requires knowledge of the option’s original price, expiration date, and price at a chosen time. Theta is not based on a daily or hourly rate but instead constantly affects the value of options. The theta strategy profits from time decay by selling options. MarketXLS calculates theta with =opt_Theta(), returns chain-level theta with =QM_GetOptionChain(), and retrieves past theta with =opt_ThetaHistorical(). Risk management is vital when selling options to avoid significant losses.
theta decay calculator
stock market
How Theta Decay Works: The Math Behind Time Value Erosion
Understanding the mathematics behind a theta decay calculator gives you a significant edge in options trading. Theta is one of the "Greeks" — a set of risk measures derived from the Black-Scholes option pricing model — and it quantifies exactly how much value an option loses with each passing day, all else being equal.
The Black-Scholes Framework and Time Value
In the Black-Scholes model, an option's price consists of two components: intrinsic value (the difference between the stock price and the strike price, if favorable) and extrinsic value (also called time value). Theta exclusively erodes the extrinsic portion.
The theoretical theta for a European call option is expressed as:
Theta (call) = −[S × N'(d1) × σ] / [2 × √T] − r × K × e^(−rT) × N(d2)
Where:
- S = current stock price
- K = strike price
- T = time to expiration (in years)
- σ = implied volatility
- r = risk-free interest rate
- N'(d1) = the standard normal probability density function evaluated at d1
- N(d2) = the cumulative standard normal distribution evaluated at d2
For put options, the formula adjusts slightly:
Theta (put) = −[S × N'(d1) × σ] / [2 × √T] + r × K × e^(−rT) × N(−d2)
Why Theta Is Almost Always Negative
Theta is negative for long option positions because time works against the option holder. Every calendar day that passes reduces the probability of a large price move in the underlying asset, which in turn reduces the option's extrinsic value. The only scenario where theta can be slightly positive is for deep in-the-money European put options, where early exercise value considerations come into play.
The Acceleration Curve: Why the Last 30 Days Matter Most
One of the most important concepts any theta decay calculator reveals is the non-linear nature of time decay. Theta does not erode value at a constant rate. Instead, the decay accelerates as expiration approaches.
Consider a hypothetical at-the-money option with 90 days to expiration:
- Days 90–60: The option might lose roughly 15% of its total time value
- Days 60–30: The option loses approximately 25% of its total time value
- Days 30–0: The option loses the remaining 60% of its total time value
This acceleration follows a square-root relationship. Since time in the Black-Scholes model appears as √T, cutting the time to expiration in half does not cut the option price in half — it reduces the time-value component by approximately 29% (1 − √0.5 ≈ 0.293).
This is why experienced options sellers prefer to sell options with 30–45 days to expiration. They capture the steepest part of the theta decay curve while still maintaining enough time premium to make the trade worthwhile.
Daily vs. Calendar Theta
When your theta decay calculator displays a theta value of, say, −0.05, that means the option is expected to lose $0.05 per share (or $5.00 per contract) per calendar day. Some traders convert this to a "trading day" theta by multiplying by 365/252, since the market is only open 252 days per year but theta erodes across all 365 calendar days.
Theta and Implied Volatility: The Hidden Connection
Higher implied volatility means more extrinsic value in the option, which in turn means higher theta. An at-the-money option on a volatile stock like Tesla will have significantly higher daily theta than an equivalent option on a low-volatility utility stock, simply because there is more time value to erode.
This relationship is critical for income-focused traders. Selling options on higher-volatility underlyings generates more theta income per day, but also carries more risk of adverse price movement.
Building a Theta Decay Calculator in Excel With MarketXLS
MarketXLS turns Excel into a theta decay calculator by returning option prices, Greeks, and pricing functions in cells (options data is end-of-day on the Standard plan and real-time on Advanced and Business). Here is a step-by-step guide to building your own theta tracking dashboard.
Step 1: Set Up Your Underlying Asset Data
Start by pulling the current stock price for the underlying asset you want to analyze. In cell B2, enter the ticker symbol (e.g., AAPL). In cell C2, use the MarketXLS function to retrieve the live price:
=Last("AAPL")
Formula documentation: Last
This gives you the last traded price for Apple (15-minute delayed on the Standard plan, real-time on Advanced and Business), which serves as the foundation for evaluating whether options are in-the-money, at-the-money, or out-of-the-money.
Step 2: Generate the Full Option Chain
To view all available options contracts along with their Greeks, use the option chain function in a dedicated sheet:
=QM_GetOptionChain("AAPL")
Formula documentation: QM_GetOptionChain
This populates your spreadsheet with every available expiration date and strike price for AAPL options, including bid, ask, volume, open interest, and — most importantly for our theta decay calculator — the Greeks columns including theta, delta, gamma, and vega.
Step 3: Pull Detailed Greeks for Analysis
For theta on a specific contract, pass its inputs to the theta function:
=opt_Theta(C2, OptionPrice, "2026-06-19", "Call", 200)
Formula documentation: opt_Theta
This returns the model theta for that contract. You can then sort and filter by theta to identify which contracts are experiencing the most rapid time decay.
Step 4: Build Individual Option Tracking
To track a specific option contract, first generate the standardized option symbol. For example, to create the symbol for an AAPL June 2026 $200 call:
=OptionSymbol("AAPL", "2026-06-19", "C", 200)
Formula documentation: OptionSymbol
This returns the OCC-format symbol (e.g., @AAPL 260619C00200000), which you can then use with other MarketXLS functions to pull real-time pricing and Greeks for that specific contract.
Step 5: Create a Theta Decay Tracking Table
Set up a tracking table with these columns:
| Column | Header | Formula Example |
|---|---|---|
| A | Ticker | AAPL |
| B | Stock Price | =Last("AAPL") |
| C | Strike | 200 |
| D | Type | Call |
| E | Expiration | 2026-06-19 |
| F | Option Symbol | =OptionSymbol("AAPL","2026-06-19","C",200) |
| G | Days to Expiry | =E2-TODAY() |
Step 6: Calculate Portfolio-Level Theta
If you hold multiple option positions, sum the theta across all contracts to get your portfolio theta. This tells you how much your entire options portfolio is expected to gain or lose per day from time decay alone.
For options sellers (short positions), portfolio theta is positive — you benefit from time passing. For options buyers (long positions), portfolio theta is negative — time is working against you.
Step 7: Visualize the Decay Curve
Using the days-to-expiry and theta values from your spreadsheet, create an Excel line chart plotting theta against days remaining. This visualization makes the acceleration effect immediately apparent and helps you decide when to enter or exit positions.
Tips for Your Theta Decay Calculator Spreadsheet
- Refresh data regularly: Options Greeks change throughout the trading day as the underlying price and implied volatility shift.
- Track theta over multiple days: Record daily theta snapshots to see how the decay rate is changing for your positions.
- Compare across expirations: Use MarketXLS to pull option chains for different expiration dates and compare the theta values side by side.
- Monitor theta-to-price ratio: Divide the absolute theta value by the option premium to see the daily decay as a percentage of the option's value.
Theta Decay Calculator: Comparing ITM vs ATM vs OTM Options
One of the most valuable uses of a theta decay calculator is comparing how time decay behaves differently depending on an option's moneyness. The table below summarizes the key differences:
| Characteristic | In-the-Money (ITM) | At-the-Money (ATM) | Out-of-the-Money (OTM) |
|---|---|---|---|
| Extrinsic value | Low to moderate | Highest | Moderate to low |
| Theta magnitude | Lower | Highest | Moderate |
| Decay acceleration | Gradual | Steepest near expiry | Can collapse quickly |
| Intrinsic value | Yes (significant) | Minimal or zero | None |
| % of premium lost per day | Low (large intrinsic cushion) | Highest | High (small premium base) |
| Risk for buyers | Lower (has intrinsic floor) | Moderate | Highest (can go to zero) |
| Ideal for sellers | Lower theta income | Best theta income | Moderate theta income, higher win rate |
Key Takeaways From the Comparison
At-the-money options have the highest absolute theta because they carry the most extrinsic value. This is where uncertainty is greatest — the market does not know whether the option will finish in or out of the money, so the time value premium is at its peak.
Out-of-the-money options have lower absolute theta, but a higher theta-to-premium ratio. A $0.50 OTM option losing $0.03 per day is a 6% daily decay rate, compared to a $5.00 ATM option losing $0.08 per day (only 1.6%). This means OTM options can lose their value as a percentage of investment much faster.
In-the-money options have the lowest theta-to-premium ratio because much of their value is intrinsic (not subject to time decay). Only the extrinsic component erodes, making deep ITM options behave more like the underlying stock.
Practical Application for Traders
- Selling premium? Focus on ATM strikes for maximum daily theta income, or slightly OTM strikes for a balance between income and probability of profit.
- Buying options? Consider ITM options (higher delta) to reduce the drag from theta decay on your position.
- Spread strategies? Selling the ATM strike and buying a further OTM strike captures the theta differential between the two, which is the core mechanic behind vertical credit spreads.
Frequently Asked Questions About Theta Decay Calculators
What is a theta decay calculator and why do options traders need one?
A theta decay calculator is a tool that measures how much value an option contract loses each day due to the passage of time. Options traders need this tool because time decay is one of the largest factors affecting option prices, especially in the final 30 days before expiration. By quantifying theta, traders can make informed decisions about when to enter, adjust, or close their positions. A theta decay calculator also helps portfolio managers understand their aggregate daily exposure to time decay across multiple positions.
How accurate are theta decay calculators for predicting actual option price changes?
Theta decay calculators provide theoretical estimates based on current market conditions (implied volatility, stock price, interest rates, and time remaining). In practice, actual option price changes will differ from theta predictions because the underlying stock price and implied volatility also change simultaneously. Theta is most accurate as a predictor when the underlying asset price remains relatively stable and implied volatility does not shift significantly. Traders should treat theta values as one input among several rather than as a precise forecast.
Does theta decay happen on weekends and holidays?
Yes, theta decay is continuous and occurs on weekends, holidays, and after market hours. However, many options pricing models distribute decay across calendar days, meaning the Friday-to-Monday erosion is accounted for in the pricing. Some traders observe that the market "prices in" weekend theta on Friday afternoon, while others believe the adjustment happens Monday morning. In practice, the effect is embedded in the option's price throughout the week. Your theta decay calculator shows a per-calendar-day figure, so weekends are already factored in.
What is a good theta value for selling options?
There is no universal "good" theta value because it depends on the option's premium, the underlying stock's volatility, and your risk tolerance. However, many income-focused traders look for options where daily theta represents 0.5% to 2% of the premium collected. For example, if you sell an option for $2.00 and the theta is −$0.03, the daily decay rate is 1.5%, which many traders consider attractive. Always evaluate theta in the context of the option's delta, implied volatility, and the overall risk-reward profile of the trade.
How does theta interact with the other Greeks (delta, gamma, vega)?
Theta does not operate in isolation. Delta measures directional risk, gamma measures how fast delta changes, and vega measures sensitivity to implied volatility changes. A position with high negative theta (beneficial for sellers) often has high negative gamma (risky for sellers if the stock moves sharply). Similarly, a drop in implied volatility (negative vega exposure) benefits short option positions in the same way theta does. Skilled traders use a theta decay calculator alongside the other Greeks to build positions where the risks are balanced and the daily time decay income compensates adequately for the gamma and vega risks assumed.
Can I build a theta decay calculator in Google Sheets with MarketXLS?
Yes, MarketXLS has a Google Sheets add-on with the same pricing as the Excel version. Function availability differs by platform, so check /formulas for the option chain and Greeks functions you plan to use. See MarketXLS pricing.
Start Building Your Theta Decay Calculator Today
Understanding and tracking theta decay is essential for any serious options trader. Whether you are selling covered calls for income, running iron condors, or simply trying to understand why your long options are losing value each day, a theta decay calculator shows the daily cost of time in each position.
MarketXLS makes building a theta decay calculator in Excel straightforward. With functions like =QM_GetOptionChain(), =opt_Theta(), =Last(), and =OptionSymbol(), you can pull option data, calculate Greeks, and track time decay in one spreadsheet.
Ready to take your options analysis to the next level? Get started with MarketXLS today and build your own custom theta decay calculator in minutes.