Contract High (On Demand)
Returns the contract high price (highest price since the option was listed) for an option contract using QuoteMedia's on-demand data service.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| Option (OCC) | SYMBOL+YYMMDD+C/P+STRIKE | AAPL240315C00170000 |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | OCC-format option symbol |
Notes
- This is the highest price the option has traded at since listing
- Different from daily high price
- Useful for understanding option's price history
Syntax
=QM_ContractHigh(Symbol)Examples
=QM_ContractHigh("AAPL240315C00170000")=QM_ContractHigh("MSFT240419P00400000")=QM_ContractHigh(A1)When to Use
- Analyze option price history
- Identify support/resistance levels
- Compare current price to historical high
- Options trading analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need daily high price | High() or QM_High() |
| Need full option chain | QM_GetOptionChain() |
| Need contract low | QM_ContractLow() |
Common Issues & FAQ
Q: Why is contract high much higher than current price? A: Options can lose significant value as:
- Time decay (theta) erodes premium
- Underlying moves against the option
- Implied volatility decreases
Q: Is this the daily high or all-time high? A: This is the all-time contract high since the option was listed, not the daily high.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?