Strike (On Demand)
Returns the strike price 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 function uses QuoteMedia's on-demand API
- Data is fetched when the formula calculates
- For real-time streaming data, use the QM_Stream_* functions
Examples
When to Use
- Get strike price from option symbol
- Verify option contract details
- Building option analysis spreadsheets
- Extracting strike from OCC symbols
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need full option chain | QM_GetOptionChain() |
| Find ATM strike for underlying | StrikeNext() |
| Need streaming option data | QM_Stream_* functions |
Common Issues & FAQ
Q: Why am I getting an error? A: Check that the symbol is in valid OCC format:
- 21 characters total
- Symbol + 6-digit date (YYMMDD) + C/P + 8-digit strike
Q: How do I get the OCC symbol?
A: Use OptionSymbol() to generate it from underlying, expiration, type, and strike.
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?