Roll Spread Estimator
Computes Roll's effective spread estimator from a price series: 2 times the square root of the negative serial covariance between consecutive price changes. The intuition, from Richard Roll in 1984, is that the back-and-forth between buying and selling (the bid-ask bounce) creates a negative correlation in very short-term returns, and the size of that correlation reveals the implied spread. When the covariance isn't negative, the estimator is undefined and returns zero. Enter the price series.
Resultado
—
Roll Spread Estimator
Computes Roll's effective spread estimator from a price series: 2 times the square root of the negative serial covariance between consecutive price changes. The intuition, from Richard Roll in 1984, is that the back-and-forth between buying and selling (the bid-ask bounce) creates a negative correlation in very short-term returns, and the size of that correlation reveals the implied spread. When the covariance isn't negative, the estimator is undefined and returns zero. Enter the price series.
The spread hidden in the price zigzag
You can't always see an asset's bid-ask spread directly, but it leaves a clue in price behavior. Every time one trade hits the ask and the next hits the bid, the price jumps up and then down, even without the real value changing. Richard Roll realized, in 1984, that this back-and-forth creates a negative correlation in very short-term returns.
The clever move was to reverse the reasoning: if the bid-ask bounce generates that negative correlation, then measuring the correlation gives back the spread. The formula is twice the square root of the negative serial covariance between consecutive price changes. It's a way to estimate liquidity using only price history, with no need for bid and ask data.
Enter the price series separated by commas. The tool computes the changes, the serial covariance and returns the implied spread. Mind the method's famous limitation: in practice, many real series show positive serial covariance, in which case the estimator is undefined and returns zero, without meaning the spread is truly nil.
Related Tools
Effective Spread (Microstructure)
Computes the effective spread of a trade: twice the distance between the price at which the trade actually executed and the midpoint between the best bid and best ask at that moment. Unlike the quoted spread, which measures the bid-ask difference, the effective spread captures the real cost the investor paid, accounting for where the order actually filled in the book. The result comes in absolute value and as a percentage of the midpoint. Enter the trade price and the midpoint.
Amihud Illiquidity (ILLIQ)
Computes the Amihud (2002) illiquidity measure: the average of the ratio of the absolute daily return to the dollar trading volume, scaled by one million as is convention. The intuition is that, in illiquid assets, a small volume already moves the price a lot — so the higher the ratio, the more illiquid the asset. It's one of the most used liquidity measures in research, since it needs only daily price and volume data. Enter the lists of returns in percent and dollar volumes.
Bid-Ask Spread
Computes the bid-ask spread of an asset: the difference between the ask (sell) price and the bid (buy) price, the midpoint between them and the spread as a percentage of that midpoint. The spread is the invisible cost of trading and a direct measure of liquidity: liquid instruments have a tight spread, illiquid ones a wide spread. As a percentage, it lets you compare the cost across assets of different prices. Enter the bid and ask prices.
The results provided by this tool are for general informational and educational purposes only and do not constitute professional, financial, medical, legal, tax or accounting advice. Always confirm important decisions with a qualified professional and official sources.