Abdi-Ranaldo Spread

Calculate the Abdi and Ranaldo (2017) close-high-low bid-ask spread, per asset and period.

The average of the daily High and Low (the mid-range) is a proxy for the efficient price without the spread, while the Close is a trade at either the bid or the ask. The distance of the Close to the mid-range of its own day and to that of the next day both hold half the spread, and their product removes the volatility of the efficient price, which backs out the spread from daily Close, High and Low prices alone, without quote data. Each pair of consecutive trading days gives an estimate and the spread of a period is the average of the estimates within it.

Unlike the Corwin-Schultz spread, the estimator uses the Close as well and needs no adjustment for the overnight return (a weekend or a gap at the open). Like it, the estimate is mostly used where no quotes are available and ranks assets by their spread; for liquid large caps the spread is a few basis points and the estimate is dominated by the volatility, so read it as a relative measure.

For more information about the method, see the following paper:

  • Abdi, F., & Ranaldo, A. (2017). “A Simple Estimation of Bid-Ask Spreads from Daily Close, High, and Low Prices.” The Review of Financial Studies, 30(12), 4437-4480.

The formula is as follows:

\[\eta_{t} = \frac{\ln H_{t} + \ln L_{t}}{2}\] \[\text{Two-Day Spread} = \sqrt{\max(4 \cdot (\ln C_{t} - \eta_{t}) \cdot (\ln C_{t} - \eta_{t+1}),\; 0)}\] \[\text{Abdi-Ranaldo Spread} = \operatorname{Mean}(\text{Two-Day Spreads within the period})\]

Where H, L and C are the daily High, Low and Close of two consecutive trading days t and t+1 of the asset. This is the “two-day corrected” version that the paper uses in its empirical analysis (equation 11): a negative two-day estimate of the squared spread is set to 0 before the square root and the average are taken.

Also known as: close-high-low spread estimator, CHL spread, AR spread.

Abdi-Ranaldo Spread in Python or via the MCP

Install the Finance Toolkit with:

pip install financetoolkit -U

Then call get_abdi_ranaldo_spread as shown below.

from financetoolkit import Toolkit

toolkit = Toolkit(
    ["SNAP", "ETSY", "LYFT"],
    api_key="FINANCIAL_MODELING_PREP_KEY",
    start_date="2025-01-01",
    end_date="2025-06-30",
)

toolkit.risk.get_abdi_ranaldo_spread()

Or, after setting up the Finance Toolkit MCP, ask:

What was the bid-ask spread of Snap, Etsy and Lyft in each month of the first half of 2025, estimated from daily closes, highs and lows with the Abdi-Ranaldo method?

Which returns:

Date SNAP ETSY LYFT Benchmark
2025-01 0.0115 0.0107 0.0084 0.0024
2025-02 0.014 0.0087 0.0176 0.0035
2025-03 0.0117 0.0065 0.0113 0.0053
2025-04 0.0287 0.0116 0.0284 0.013
2025-05 0.0168 0.0112 0.0137 0.0047
2025-06 0.0109 0.007 0.0101 0.0029

Parameters

get_abdi_ranaldo_spread accepts the following parameters.

ParameterTypeDescriptionExample
periodstrThe period to average the two-day spreads over (weekly, monthly, quarterly or yearly). Defaults to “monthly”, as in the paper."weekly"
rollingintAverage the two-day spreads of the last rolling periods instead of one period (e.g. period=’monthly’ and rolling=3 for a three-month spread at every month end). Defaults to None.4
roundingint | NoneThe number of decimals to round the results to. Defaults to None, which uses the rounding of the Toolkit (4 unless set otherwise).2
growthboolWhether to calculate the growth of the spread over time. Defaults to False.True
lagint | list[int]The lag to use for the growth calculation. Defaults to 1.4
standardizeboolWhether to standardize (Z-Score) the result. When combined with growth=True, standardizes the growth values instead of the raw values. Defaults to False.True
show_columnsstr | list[str] | NoneThe columns to keep, a name or a list of names, matched on every column level, or the rows when no column has those names (such as the line items of a financial statement). Names that do not exist are logged, and when none exist the result is returned in full. Defaults to None, which keeps every column.None, which keeps every column
Share