CHAINS
Get the complete options chain for a ticker.
Syntax
=OBB.DERIVATIVES.OPTIONS.CHAINS(symbol,[date],[option_type],[moneyness])
Examples
=OBB.DERIVATIVES.OPTIONS.CHAINS("AAPL")
=OBB.DERIVATIVES.OPTIONS.CHAINS("AAPL","2023-01-25")
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| symbol | Text | Symbol to get data for. | True |
| date | Text | The end-of-day date for options chains data. | False |
| option_type | Text | The option type, call or put, 'None' is both (default). Options: call, put. | False |
| moneyness | Text | Return only contracts that are in or out of the money, default is 'all'. Parameter is ignored when a date is supplied. Options: otm, itm, all. | False |