OPTIONCHAIN FORMULA
Big Google Sheets Update!
You can now use the new OPTIONCHAIN
formula to download hundreds of options at once in Google Sheets. With OPTIONDATA
you were limited to a single option in each formula. With OPTIONCHAIN
you can download every option for a single expiration at once. We've worked for 2 months to add some of the best filters available to use together with OPTIONCHAIN.
There are more than 25 columns you can use in the output. Use "ALL" to see them all and then pick just the ones you need. Column output is also ordered in the same order as you input them!
You can get the expiration date you need by using North American date formats "MM/DD/YYYY", a cell reference with a date in sheets, or timestamp format "YYYY-MM-DD". What's perhaps the best feature of the
OPTIONCHAIN
formula? DTE, days to expiration.
You can now use "DTE 30" and get the expiration 30 days from today. Each time you open your spreadsheet this will update giving you an expiration 30 days in the future.Filter the chain by strike, strike ranges, or by logical expressions.
That means you can use "100-200", "100,200", or "<100" in the strike filter to get the exact strikes you want. What's even better? Filtering the strikes by delta.
"DELTA 50" and get the at the money option.And of course you can
limit the chain
to calls, puts, in the money or out of the money options and eliminate the rest. Check out the video tutorial to see the formula in action or read our blog post for a complete tutorial with examples.We Also Finished This Month
- API: Improved performance of real-time data queries.
- API: Added a new strikeLimit parameter to optionchain API call.
- API: Fixed bugs for tickers with different share classes: "BRK.B, PBR.A, etc."