SheetsFinance Docs
Options

IV Rank Time-series

šŸšØ Important:SF_OPTIONS_PRO() requires an active Options subscription. If you only have access to the standard options dataset, use SF_OPTIONS() instead or upgrade on our Pricing page.

Use this workflow when you want a historical time-series of ivRank data for a single symbol between a tradeDate and an endDate. This is useful for charting how current IV, rank, and percentile changed across a defined period.

For a complete function overview, parameter guide, and dataset map, see Options.

=SF_OPTIONS_PRO(symbol, "ivRank", "", "", tradeDate, endDate, metrics, options)

  • symbol is a single ticker symbol such as "AAPL".

  • dataType must be "ivRank".

  • tradeDate sets the historical start date. Use YYYY-MM-DD format, an Excel date serial or Google Sheets date formatted cell.

  • endDate sets the historical end date. Use YYYY-MM-DD format, an Excel date serial or Google Sheets date formatted cell. It must be after tradeDate.

  • metrics selects which IV rank fields to return. Leave blank or use "all" to output the full dataset. Chain specific fields together with & such as "tradeDate&iv&ivRank1m&ivRank1y&ivPct1y". See the full list of available metrics in the Metrics section below.

  • options allows additional output formatting or sorting options. Options can be chained together with &.

Parameters

Symbol (symbol)

Use a single underlying ticker symbol such as "AAPL".

Data Type (dataType)

Must be set to "ivRank".

Trade Date (tradeDate)

For this page, tradeDate is the start date of the IV Rank time-series. Use YYYY-MM-DD format, an Excel date serial or Google Sheets date formatted cell.

End Date (endDate)

For this page, endDate is the end date of the IV Rank time-series and must be after tradeDate. Use YYYY-MM-DD format, an Excel date serial or Google Sheets date formatted cell.

Metrics (metrics)

The available IV rank metrics are:

  • All ("all")

  • Ticker ("ticker")

  • Trade Date ("tradeDate")

  • IV (30 Days) ("iv")

  • IV Rank 1M ("ivRank1m")

  • IV Percentile 1M ("ivPct1m")

  • IV Rank 1Y ("ivRank1y")

  • IV Percentile 1Y ("ivPct1y")

  • Updated At ("updatedAt")

Options (options)

Use options for output formatting modifiers. Chain multiple options together with &.

Formatting options:

  • "NH" removes the header row.

  • "-" reverses the output order.

Examples

Example 1 - Track one-year IV rank over time, all metrics

=SF_OPTIONS_PRO("AAPL", "ivRank", "", "", "2025-01-01", "2025-03-31")
Options IV Rank Time-series Example 1

Example 2 - Track an IV ranking over time, reverse order for charting with selected metrics

=SF_OPTIONS_PRO("AAPL", "ivRank", "", "", "2026-01-01", "2026-03-31", "tradeDate&ivRank1m&ivPct1m&ivRank1y&ivPct1y", "-")
Options IV Rank Time-series Example 2

Was this helpful?