Professional options data in your spreadsheet

Full OPRA chains with Greeks, 20+ years of history, IV rank, volatility surfaces and earnings analytics — directly in Google Sheets and Excel.

4.6(226+ reviews)
61k+ downloads
Google SheetsMicrosoft Excel
A1
fx
=SF_OPTIONS_PRO("AAPL", "calls", "2026-08-26", "", "", "", "strike&mid&delta&vega&theta")
ABCDE
1StrikeMidDeltaVegaTheta
2170.0033.950.870.25-0.03
3180.0025.600.790.34-0.04
4190.0018.450.680.42-0.05
5200.0012.800.550.48-0.06
6210.008.350.410.46-0.06
7220.005.100.290.40-0.05
8230.002.950.190.31-0.04
9240.001.620.120.24-0.03
10250.000.860.070.17-0.02
11260.000.450.040.11-0.01

Full OPRA chains with complete Greeks for every strike and expiration. Current chain data is provided on a 15-minute delay.

From formula to dashboard

Build the dashboard you actually want

IV rank, term structure, contract history and current chains with Greeks. No exports, no API keys, no copy-paste — just cell references you can filter and chart like any other sheet.

SheetsFinance options dashboard in Google Sheets

IV rank & term structure

Rank, percentile and IV by period refresh with the sheet - filters are just cell references.

Contract IV history

Chart any contract's implied volatility against the underlying using native spreadsheet charts.

Full chain with Greeks

The full chain at any expiration - bid/ask, sizes, IV and complete Greeks per contract.

Get this free options template →

Start your 15-day SheetsFinance trial to use it in Google Sheets.

What's included

Professional-grade options analytics

Everything from current chains to two decades of volatility history, built for serious research.

20+ yrs
of options history
Full OPRA
US options coverage
40+
metrics per contract
Full OPRA chains
Calls, puts and combined chains for all US-listed options, with contract-level detail and OCC symbols.
Complete Greeks
Delta, gamma, theta, vega, rho and phi on every contract, plus bid/mid/ask implied volatility.
20+ years of history
Historical chain snapshots from any past trading day, with backfilled Greeks on expired contracts.
Contract & strike time-series
Track a single contract or strike across any date range to backtest and study behaviour over time.
IV rank & percentiles
Current and historical IV rank, including batch IV rank across your entire watchlist in one call.
Term structure
IV by period — 10d through 1y — as snapshots or historical time-series.
Volatility surfaces
Full IV surfaces across strike and expiration dimensions – plus historical surfaces going back 20+ years.
Earnings analytics
Implied move, straddle pricing and earnings effect metrics for event-driven strategies.
No code required
Use the in-built Function Generator to build all our options formulas in seconds, without writing a single line of code.
Want to see it in action?

Book a 20-minute live demo and see exactly how SheetsFinance fits your research or trading workflow.

Testimonials

What our community is saying

“Sheets Finance is an incredibly powerful tool. It pulls data seamlessly from SEC filings, ensuring the data is robust and reliable. The institutional-grade mnemonics make navigating and accessing key data points effortless. What really stands out is its high utility — it saves a ton of time, covers a wide range of stocks, and offers great flexibility with customizable options. For anyone serious about financial analysis, this tool is a game changer. Highly recommend”

Romit Fernandes

“Very, very helpful tool. I'm impressed by the consistancy in shape, size, and accuracy of returned data from spreadsheet-driven queries. The creators are also very responsive and helpful if there are any issues.”

Mitch Anthamatten

“SheetsFinance is probably the best Excel add-in one can find for markets data. Democratizes access to pro tools with excellent coverage breadth that continues to grow. Customer support is helpful and responsive. Solid documentation too. Lastly, the pace of product improvement in terms of features or new data coverage is excellent. This vastly improves the value one gets out of the subscription. Can't recommend this enough.”

ZQ Ong

“Great! Simple and effective. Going to use this in all of my investing and trading spreadsheets.”

Devon Lambert

“Gives you all the finance items that google finance doesn't have. At this price, its a steal! If you do any stock analysis using google sheets, Just get it.”

Darren Earn

“This is by far the most impressive tool I've used to do stock analysis as a retail investor. I've spend 100s of hours using dozens of online tools. They all have some sort of benefit, but I've always come back to the idea that it would be much better if I could just access the raw data and then chop it up however I need to to uncover insights about the companies. I finally found a means to do that, and imo it is done in the smartest way possible. Genuinely this is a massive value and an incredibly powerful implementation of what I've been hoping for for so long. Incredible work! Thank you.”

Steve Hampton

“Outstanding”

Carlos Araujo

FAQs

Frequently asked questions

The Options plan covers US-listed equity and ETF options across all US options markets through the official Options Price Reporting Authority (OPRA) feed. Use an underlying ticker or a full OCC contract symbol to request the contracts you need.