Contract Low (On Demand)
Returns the contract low price (lowest 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 lowest price the option has traded at since listing
- Different from daily low price
- Useful for understanding option's price history
Examples
=QM_ContractLow("AAPL240315C00170000")=QM_ContractLow("MSFT240419P00400000")=QM_ContractLow(A1)When to Use
- Analyze option price history
- Identify support levels
- Compare current price to historical low
- Risk analysis for options positions
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need daily low price | Low() or QM_Low() |
| Need full option chain | QM_GetOptionChain() |
| Need contract high | QM_ContractHigh() |
Common Issues & FAQ
Q: Why might the contract low be very low or near zero? A: Options can trade at very low prices when:
- Near expiration with no intrinsic value
- Far out-of-the-money
- Low implied volatility periods
Q: Is this the daily low or all-time low? A: This is the all-time contract low since the option was listed, not the daily low.
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?