Call/Put Flag (On Demand)
Gets the call/put indicator for an option contract from QuoteMedia. Returns "C" for calls and "P" for puts.
Symbol Format
Options use OCC (Options Clearing Corporation) format:
- Format:
SYMBOL + YYMMDD + C/P + Strike(8 digits) - Example:
AAPL240315C00170000= AAPL Call, Mar 15 2024, Strike $170
Return Values
| Value | Meaning |
|---|---|
| C | Call option |
| P | Put option |
Notes
- Only works with option symbols
- Useful for validating option contracts
Examples
=QM_CallPut("AAPL240315C00170000")=QM_CallPut("MSFT240315P00400000")=QM_CallPut(A1)=IF(QM_CallPut(A1)="C","Call","Put")When to Use
- Validating option contracts
- Building option analysis sheets
- Conditional formatting based on type
- Data verification
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need option price | QM_Last() |
| Need expiry date | QM_ExpiryDate() |
| Need option Greeks | QM_Stream_Delta(), etc. |
Common Issues & FAQ
Q: Why am I getting an error? A: This function only works with option symbols in OCC format, not stock symbols.
Q: How do I know the option type from the symbol? A: In OCC format, the letter before the strike price indicates: C=Call, P=Put.
Q: Why am I getting #N/A? A: Check that the option symbol is in valid OCC format and .
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?