Option premium is the price a buyer pays a seller for an options contract, which grants the right (but not the obligation) to buy or sell the underlying at the strike price. Premium equals intrinsic value plus extrinsic (time) value, and it is quoted per share, so one standard contract costs the premium times 100. Six factors drive it: stock price, strike price, time to expiration, implied volatility, interest rates, and dividends. The premium sets your cost, breakeven, and maximum loss as a buyer, or your income as a seller. This guide explains each factor and how to pull premiums into Excel with MarketXLS.
What Is Option Premium?
Option premium is the current market price of an options contract. When you buy an option, you pay the premium. When you sell (write) an option, you receive the premium. The premium is quoted on a per-share basis, so for a standard contract covering 100 shares, the total cost is the premium multiplied by 100.
For example, if an AAPL call option has a premium of $5.50, the total cost to buy one contract is $5.50 × 100 = $550.
You can retrieve current option premiums in Excel using MarketXLS:
=QM_Last("@AAPL 260321C00200000")
Formula documentation: QM_Last
This returns the last traded price for a specific AAPL call option. To generate the option symbol dynamically:
=OptionSymbol("AAPL", "2026-03-21", "C", 200)
Formula documentation: OptionSymbol
This produces the formatted symbol @AAPL 260321C00200000 that you can then use with =QM_Last() to get the premium.
Premium = Intrinsic Value + Extrinsic Value
Every option premium consists of two components:
| Component | Definition | Example |
|---|---|---|
| Intrinsic Value | The amount by which the option is in-the-money (ITM) | Stock at $150, call strike at $140 → $10 intrinsic value |
| Extrinsic Value (Time Value) | The portion of the premium above intrinsic value, reflecting time remaining and volatility | Total premium $14 minus $10 intrinsic = $4 extrinsic |
Out-of-the-money (OTM) options have zero intrinsic value — their entire premium consists of extrinsic value.
Intrinsic Value Explained
Intrinsic value represents the real, tangible value of an option if it were exercised immediately. It is straightforward to calculate:
- Call option intrinsic value = Current Stock Price − Strike Price (if positive; otherwise 0)
- Put option intrinsic value = Strike Price − Current Stock Price (if positive; otherwise 0)
For example, if AAPL is trading at $180 and you hold a call option with a $170 strike price, the intrinsic value is $10. You can verify the current stock price with:
=Last("AAPL")
Formula documentation: Last
Or from QuoteMedia on demand (real-time on the Advanced and Business plans, 15-minute delayed on Standard):
=QM_Last("AAPL")
Formula documentation: QM_Last
For a streaming quote that updates automatically, use =QM_Stream_Last("AAPL").
Moneyness and Intrinsic Value
| Moneyness | Call Option | Put Option | Intrinsic Value |
|---|---|---|---|
| In-the-Money (ITM) | Stock price > Strike price | Stock price < Strike price | Positive |
| At-the-Money (ATM) | Stock price ≈ Strike price | Stock price ≈ Strike price | Zero or near zero |
| Out-of-the-Money (OTM) | Stock price < Strike price | Stock price > Strike price | Zero |
Extrinsic Value (Time Value) Explained
Extrinsic value is the portion of the option premium that exceeds the intrinsic value. It reflects two primary factors:
- Time remaining until expiration — more time means more opportunity for the stock to move favorably
- Implied volatility — higher expected price swings increase the probability of a profitable outcome
Extrinsic value is at its maximum when an option is at-the-money and decreases as the option moves deeper in-the-money or further out-of-the-money.
Time Decay (Theta)
Time decay is the erosion of an option's extrinsic value as expiration approaches. This decay is not linear — it accelerates as expiration nears, particularly in the final 30-45 days. This concept is quantified by the Greek letter Theta.
- Theta measures the daily rate at which an option loses value due to time passage
- At-the-money options have the highest theta
- Options sellers benefit from time decay; options buyers are hurt by it
For example, an option with a theta of -0.05 will lose approximately $0.05 per day in value, all else being equal. Over a 30-day period, that's $1.50 of time decay — a significant consideration for options buyers.
The Six Factors That Influence Option Premium
Option premiums are driven by six interconnected factors. Understanding each one helps you make better trading decisions:
1. Current Stock Price
As the underlying stock price changes, so does the option premium. Call premiums increase as the stock rises (moving them more in-the-money), while put premiums increase as the stock falls.
Track the stock price:
=QM_Last("AAPL")
Formula documentation: QM_Last
2. Strike Price
The relationship between the strike price and the current stock price determines intrinsic value. ITM options have higher premiums than OTM options because they already have intrinsic value.
3. Time to Expiration
More time until expiration means more extrinsic value. An option expiring in 6 months will have a higher premium than an identical option expiring in 1 month, because there is more time for a favorable price move.
4. Implied Volatility
Implied volatility (IV) is the market's expectation of future price movement. Higher IV leads to higher premiums for both calls and puts. IV is arguably the most important factor for options traders because:
- IV can change independently of the stock price
- Buying options when IV is low and selling when IV is high is a fundamental strategy
- IV tends to spike before earnings announcements and major events
5. Interest Rates
Higher interest rates increase call premiums and decrease put premiums slightly. This effect is measured by the Greek Rho and is generally small for short-dated options but becomes more significant for longer-dated contracts.
6. Dividends
Expected dividends reduce call premiums and increase put premiums. This is because dividends reduce the stock price on the ex-dividend date, making calls less valuable and puts more valuable.
Check dividend information with MarketXLS:
=DividendYield("AAPL")
=DividendPerShare("AAPL")
=DividendFrequency("AAPL")
Formula documentation: DividendYield, DividendPerShare, DividendFrequency
Option Greeks and Their Impact on Premium
Option Greeks are mathematical measures of how an option's premium changes in response to various factors. Here is a comprehensive overview:
| Greek | Measures | Impact on Premium | Range |
|---|---|---|---|
| Delta (Δ) | Sensitivity to stock price change | Call: +$0.01 to +$1.00 per $1 move; Put: -$1.00 to -$0.01 | Calls: 0 to 1; Puts: -1 to 0 |
| Gamma (Γ) | Rate of change of Delta | Higher gamma = Delta changes more rapidly | Always positive |
| Theta (Θ) | Time decay per day | Reduces premium daily; accelerates near expiration | Usually negative for buyers |
| Vega (ν) | Sensitivity to 1% IV change | Higher vega = more premium change per IV shift | Always positive |
| Rho (ρ) | Sensitivity to interest rate change | Small effect; increases calls, decreases puts | Positive for calls, negative for puts |
You can analyze options with full Greeks data using MarketXLS:
=QM_GetOptionQuotesAndGreeks("AAPL")
Formula documentation: QM_GetOptionQuotesAndGreeks
This function returns the complete option chain with all Greeks, allowing you to evaluate Delta, Gamma, Theta, Vega, and Rho for every strike and expiration.
Delta in Practice
Delta is the most widely used Greek. For a call option:
- Delta of 0.50 (ATM) means the option gains $0.50 for every $1 increase in the stock
- Delta of 0.80 (deep ITM) means the option behaves almost like the stock
- Delta of 0.20 (far OTM) means the option has limited sensitivity to stock moves
Delta can also be used as a rough probability estimate — a 0.30 delta call has approximately a 30% chance of expiring in-the-money.
Theta in Practice
Theta is critical for understanding time decay:
- ATM options have the highest theta
- Options sellers (premium collectors) benefit from theta decay
- The last 30 days before expiration see the most rapid time decay
- Weekly options have extremely high theta relative to their premium
Vega in Practice
Vega measures volatility sensitivity:
- Longer-dated options have higher vega
- ATM options have the highest vega
- When implied volatility increases by 1%, an option with vega of 0.15 will see its premium increase by $0.15
- Buying options before earnings (when IV is expected to rise) can benefit from vega expansion
How to Calculate Option Premium
The Black-Scholes Model
The Black-Scholes model is the most widely used framework for calculating theoretical option premiums. It takes five inputs:
- Current Stock Price (S) — use
=Last("AAPL")to get this - Strike Price (K) — the chosen exercise price
- Time to Expiration (T) — expressed as a fraction of a year
- Risk-Free Interest Rate (r) — typically the Treasury bill rate
- Volatility (σ) — historical or implied volatility
The Black-Scholes formula for a European call option is:
C = S × N(d₁) − K × e^(−rT) × N(d₂)
Where:
- d₁ = [ln(S/K) + (r + σ²/2) × T] / (σ × √T)
- d₂ = d₁ − σ × √T
- N() is the cumulative standard normal distribution function
While the math is complex, the practical takeaway is simple: Premium = Intrinsic Value + Time Value, and the Black-Scholes model provides a theoretical framework for determining fair time value.
The Binomial Model
The Binomial model breaks time into discrete intervals and models the stock price as moving up or down at each step. It is more flexible than Black-Scholes because:
- It can handle American-style options (early exercise)
- It accounts for dividends at specific dates
- It provides a step-by-step visualization of how option value evolves
Monte Carlo Simulation
Monte Carlo simulation generates thousands of random price paths and averages the option payoff across all paths. It is best for:
- Complex, multi-factor options
- Path-dependent options (Asian, barrier, lookback)
- Situations where no closed-form solution exists
How to Analyze Option Premiums in Excel with MarketXLS
MarketXLS pulls option chains, contract prices, and Greeks into Excel. Options data is end-of-day on the Standard plan and real-time on the Advanced and Business plans. Here is a practical workflow:
Step 1: Pull the Option Chain
=QM_GetOptionChain("AAPL")
Formula documentation: QM_GetOptionChain
This returns the complete option chain for AAPL, including strikes, expirations, bid/ask prices, volume, open interest, and implied volatility.
Step 2: Get a Specific Option Premium
First, generate the option symbol:
=OptionSymbol("AAPL", "2026-03-21", "C", 200)
Formula documentation: OptionSymbol
Then get its current price:
=QM_Last("@AAPL 260321C00200000")
Formula documentation: QM_Last
Step 3: Analyze Greeks
=QM_GetOptionQuotesAndGreeks("AAPL")
Formula documentation: QM_GetOptionQuotesAndGreeks
This provides Delta, Gamma, Theta, Vega, and Rho for the entire option chain, letting you evaluate time decay rates, volatility sensitivity, and price sensitivity for every contract.
Step 4: Check Historical Prices
=QM_GetHistory("AAPL")
Formula documentation: QM_GetHistory
Use historical data to backtest how option premiums have behaved during similar market conditions. Historical price data helps you understand typical ranges and set realistic expectations for your trades.
Step 5: Evaluate Fundamentals
Combine options analysis with fundamental data to make more informed decisions:
=PERatio("AAPL")
=Revenue("AAPL")
=MarketCapitalization("AAPL")
Formula documentation: PERatio, Revenue, MarketCapitalization
Option Premium Strategies for Different Market Conditions
Bullish Market — Buy Calls
When you expect a stock to rise, buying call options lets you profit from the upside with limited risk (your maximum loss is the premium paid). Look for:
- Options with 30-60 days to expiration for a balance of cost and time
- Delta between 0.40-0.60 for a good balance of cost and sensitivity
- Moderate implied volatility to avoid overpaying for premium
Bearish Market — Buy Puts
When you expect a decline, buying puts provides downside protection or speculative profit. The premium is your cost of "insurance."
Neutral Market — Sell Premium
When you expect the stock to stay in a range, selling options (covered calls, cash-secured puts, iron condors) allows you to collect premium and benefit from time decay.
High Volatility — Sell Premium
When IV is elevated (such as before earnings), premiums are inflated. Selling options captures this elevated premium, and if IV drops after the event, the options lose value quickly — benefiting the seller.
Low Volatility — Buy Premium
When IV is historically low, options are cheap. Buying options before an expected volatility increase can be profitable as premiums expand.
Common Mistakes When Evaluating Option Premium
- Ignoring implied volatility — Two options with the same intrinsic value can have vastly different premiums due to IV differences
- Underestimating time decay — Buying short-dated OTM options often results in rapid premium erosion
- Overlooking the bid-ask spread — Wide spreads effectively increase your cost and reduce your potential profit
- Focusing only on price, not probability — A cheap option premium does not mean a good trade if the probability of profit is very low
- Not considering dividends — For stocks with upcoming ex-dividend dates, call premiums may be lower than expected
Option Premium vs Option Value: What Is the Difference?
| Aspect | Option Premium | Option Value |
|---|---|---|
| Definition | Market price of the contract | Theoretical fair price |
| Determined By | Supply and demand in the market | Mathematical models (Black-Scholes, etc.) |
| Changes | Continuously during trading hours | Based on model inputs |
| Purpose | What you actually pay or receive | What the option "should" be worth |
| Discrepancy | Can be overpriced or underpriced | Provides a benchmark for comparison |
When the market premium is higher than the theoretical value, the option may be overpriced — a potential selling opportunity. When the premium is lower than theoretical value, it may be underpriced — a potential buying opportunity.
Frequently Asked Questions (FAQ)
Q: What is option premium in simple terms?
Option premium is the price you pay to buy an options contract. It gives you the right (but not the obligation) to buy or sell a stock at a specific price before a certain date. Once paid, the premium is non-refundable — it is the cost of entering the trade.
Q: Why do option premiums go up when volatility increases?
Higher volatility means there is a greater chance the stock will make a large move, increasing the probability that the option will become profitable. Since options provide the right to buy or sell at a fixed price, more potential price movement makes that right more valuable, driving premiums higher.
Q: How does time decay affect option premium?
Time decay (theta) erodes the extrinsic value of an option every day. The effect accelerates as expiration approaches, especially in the last 30 days. This is why options sellers prefer short-dated options — they capture rapid time decay — while buyers prefer longer-dated options for more time value.
Q: Can option premium be negative?
No, option premium cannot be negative. The minimum value of an option is zero. However, the return on an option trade can certainly be negative if the premium you paid is lost entirely (the option expires worthless).
Q: What is a good option premium to pay?
There is no universal answer. A "good" premium depends on the implied volatility percentile (is IV currently high or low relative to history?), the time to expiration, and your strategy. Some traders use a rule of thumb such as buying options when IV is in the low part of its historical range and selling when it is in the high part; this is a guideline, not a guarantee of profit.
Q: How do I track option premium changes in Excel?
Using MarketXLS, you can track option premiums (real-time on the Advanced and Business plans) with =QM_Last("@AAPL 260321C00200000") for specific contracts, or pull the entire option chain with =QM_GetOptionChain("AAPL"). Set up a spreadsheet to refresh periodically and track premium changes throughout the trading day.
Q: Does option premium include commission?
No, the option premium is separate from brokerage commission or trading fees. The premium is the market price of the option contract itself. Commissions and fees are additional costs charged by your broker.
Q: Why is the option premium different from what the Black-Scholes model says?
The Black-Scholes model provides a theoretical value based on assumptions (constant volatility, no dividends, European exercise). Real market premiums reflect supply and demand, upcoming events (earnings, dividends), and market sentiment, which can cause premiums to deviate from theoretical values.
Summary
Option premium is the price of an options contract, consisting of intrinsic value (the in-the-money amount) and extrinsic value (time value plus volatility premium). Six key factors drive option premiums: stock price, strike price, time to expiration, implied volatility, interest rates, and dividends. The option Greeks (Delta, Gamma, Theta, Vega, Rho) measure how premiums change in response to each factor. Models like Black-Scholes, Binomial, and Monte Carlo provide frameworks for calculating theoretical option values. With MarketXLS, you can analyze option premiums directly in Excel using functions like =QM_GetOptionChain(), =QM_Last(), and =QM_GetOptionQuotesAndGreeks(). Get started with MarketXLS to access comprehensive options data and analytics in your spreadsheet.