Surface Forecast

The "surfaceForecast"dataType returns forecasted surface values for an underlying. This is useful when you want to compare the market's current surface to the modelled forward surface across the same delta grid.

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

=SF_OPTIONS_PRO(symbol, "surfaceForecast", expirationDate, "", tradeDate, "", metrics, options)

• symbol is the underlying ticker symbol, for example "AAPL".

• dataType must be "surfaceForecast".

• expirationDate can be used to target a specific expiry in YYYY-MM-DD format, as an Excel date serial or Google Sheets date formatted cell.

• tradeDate is optional and requests a historical forecast snapshot when supplied. Use YYYY-MM-DD format, an Excel date serial or Google Sheets date formatted cell.

• metrics selects which forecast surface fields to return. Leave blank or use "all" to output the full dataset. Use gridOnly to return just the forecasted volatility grid. Chain specific fields together with & such as "expirDate&stockPrice&riskFreeRate&vol25&vol50&vol75". 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 the underlying ticker symbol you want to analyze, for example "AAPL".

Data Type (dataType)

Use "surfaceForecast" to return the forecasted surface for the selected underlying.

Expiration Date (expirationDate)

Use expirationDate when you want the forecast tied to a particular expiry. Enter it in YYYY-MM-DD format or as an Excel date serial.

Trade Date (tradeDate)

tradeDate is the historical moment-in-time date for the forecast snapshot when you want historical forecast data. Use YYYY-MM-DD format, an Excel date serial or Google Sheets date formatted cell.

Metrics (metrics)

To output only the forecasted volatility grid (Expiration Date and Forecast Vol 0 - Forecast Vol 100) enter gridOnly. This is useful for charting purposes.

The available surface forecast metrics are:

• All ("all")

• Ticker ("ticker")

• Expiration Date ("expirDate")

• Stock Price ("stockPrice")

• Risk Free Rate ("riskFreeRate")

• Forecast Vol 0 ("vol0")

• Forecast Vol 5 ("vol5")

• Forecast Vol 10 ("vol10")

• Forecast Vol 15 ("vol15")

• Forecast Vol 20 ("vol20")

• Forecast Vol 25 ("vol25")

• Forecast Vol 30 ("vol30")

• Forecast Vol 35 ("vol35")

• Forecast Vol 40 ("vol40")

• Forecast Vol 45 ("vol45")

• Forecast Vol 50 ("vol50")

• Forecast Vol 55 ("vol55")

• Forecast Vol 60 ("vol60")

• Forecast Vol 65 ("vol65")

• Forecast Vol 70 ("vol70")

• Forecast Vol 75 ("vol75")

• Forecast Vol 80 ("vol80")

• Forecast Vol 85 ("vol85")

• Forecast Vol 90 ("vol90")

• Forecast Vol 95 ("vol95")

• Forecast Vol 100 ("vol100")

• Trade Date ("tradeDate")

• 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 - Pull the current surface forecast for all expirations, volatility grid only

=SF_OPTIONS_PRO("AAPL", "surfaceForecast", "", "", "", "", "gridOnly")

Example 2 - Pull the full forecast grid

=SF_OPTIONS_PRO("AAPL", "surfaceForecast", "2026-01-16", "", "", "", "gridOnly")

Example 3 - Pull a historical forecast snapshot

=SF_OPTIONS_PRO("AAPL", "surfaceForecast", "2026-01-16", "", "2025-10-01", "", "expirDate&vol10&vol25&vol50&vol75&vol90")