OpenBB-finance/OpenBB · error · OpenBBError

Last price must be provided for options filtering, and was n

Error message

Last price must be provided for options filtering, and was not found in the data.

What it means

Raised by the options processing/filtering helper when the resolved last_price is None. The value comes from 'underlying_price or options.underlying_price.iloc[0]' - so it fires when no underlying_price argument was passed AND the first row of the DataFrame's underlying_price column is None. Moneyness filtering needs the spot, so it aborts.

Source

Thrown at openbb_platform/extensions/derivatives/openbb_derivatives/options/options_router.py:166

    if isinstance(data, OptionsChainsData):
        df = data.dataframe
    elif isinstance(data, DataFrame):
        df = data
    elif isinstance(data, dict) and all(isinstance(v, list) for v in data.values()):
        df = DataFrame(data)
    elif isinstance(data, list):
        if all(isinstance(d, dict) for d in data):
            df = DataFrame(data)
        elif all(isinstance(d, Data) for d in data):
            df = DataFrame([d.model_dump(exclude_none=True, exclude_unset=True) for d in data])  # type: ignore

    options = DataFrame(df.copy())

    last_price = underlying_price or options.underlying_price.iloc[0]  # type: ignore

    if last_price is None:
        raise OpenBBError(
            ValueError(
                "Last price must be provided for options filtering, and was not found in the data."
            )
        )

    if target not in options.columns:  # type: ignore
        raise OpenBBError(f"Error: No {target} field found.")
    if "dte" not in options.columns:  # type: ignore
        options.dte = (options.expiration - datetime.today().date()).days  # type: ignore

    calls = options.query(f"`option_type` == 'call' and `dte` >= 0 and `{target}` > 0")  # type: ignore
    puts = options.query(f"`option_type` == 'put' and `dte` >= 0 and `{target}` > 0")  # type: ignore

    if oi:
        calls = calls[calls["open_interest"] > 0]
        puts = puts[puts["open_interest"] > 0]

    if volume:

View on GitHub (pinned to 3e071fcc2c)

Solutions

Pass underlying_price explicitly to the call.
Backfill the column before processing: df['underlying_price'] = df['underlying_price'].ffill().bfill().fillna(spot).
Use a provider/date combination that returns a populated underlying_price.
Pre-validate: v = df.get('underlying_price'); require v is not None and not pd.isna(v.iloc[0]).

Example fix

# before
res = process_options(data=df, moneyness=5)  # underlying_price.iloc[0] is None

# after
res = process_options(data=df, moneyness=5, underlying_price=spot)

Defensive patterns

Strategy: validation

Validate before calling

import pandas as pd
col = df.get('underlying_price')
if underlying_price is None:
    if col is None or col.empty or col.iloc[0] is None or pd.isna(col.iloc[0]):
        raise ValueError('underlying_price unavailable; pass it explicitly')

Type guard

def has_spot(df, underlying_price=None) -> bool:
    import pandas as pd
    if underlying_price:
        return True
    col = df.get('underlying_price')
    return col is not None and not col.empty and col.iloc[0] is not None and not pd.isna(col.iloc[0])

Try / catch

try:
    res = process_options(data=df, moneyness=5)
except OpenBBError as e:
    if 'Last price must be provided' in str(e):
        res = process_options(data=df, moneyness=5, underlying_price=get_spot(symbol))

Prevention

Pass underlying_price explicitly whenever moneyness filtering is requested.
Backfill/fill the underlying_price column at ingestion time.
Note NaN spot values pass the None check but poison downstream math - scrub both None and NaN.

When it happens

Trigger: Calling the options filter/processing helper with moneyness filtering on data where the underlying_price column exists but its first value is None (dumped with exclude_none semantics), and no underlying_price argument supplied. Note NaN passes this check (NaN is not None) and fails differently downstream.

Common situations: Providers that include the underlying_price field but leave it None on some rows; historical/EOD payloads missing the spot; user-constructed DataFrames where the column was added but never filled.

Related errors

AI-assisted analysis of OpenBB-finance/OpenBB@3e071fcc2c (2026-08-14). Data as JSON: /api/errors/73631477c318843d. Report an issue: GitHub.