Short Interest

The shortInterest data type returns shares shorted, float shares, and short interest as a percentage of float for a stock. Use SF() for the latest values and SF_TIMESERIES() with the "shortInterest" period for date-bounded history.

Latest short interest data

SF() returns the most recent short-interest observation. The year argument is ignored for this data type.

=SF(symbol, "shortInterest", metric, options)

• symbol is the ticker symbol of the stock (e.g. "AAPL"). Use Symbol Search to find the correct ticker symbol.

• metric selects what to return. Leave blank or use "all" for all metrics, or chain metrics with &, e.g. "date&sharesShorted".

• options adjusts formatting. Available option: "NH" for no header row.

The metric options are:

• All ("all")

• Settlement Date ("date")

• Shares Shorted ("sharesShorted")

• Float Shares ("sharesFloat")

• Short Interest % of Float ("shortInterestPercentage")

shortInterestPercentage is returned as a decimal fraction: 0.25 means 25% of float.

Example - All latest short interest data

=SF("AAPL", "shortInterest")

Historical short interest data

SF_TIMESERIES() returns dated short-interest history, newest settlement date first.

=SF_TIMESERIES(symbol, startDate, endDate, "shortInterest", metrics, options)

• startDate and endDate are optional dates in YYYY-MM-DD format. Omit both to return the full available history. Dates in the future are rejected, and endDate must not be before startDate.

• metrics uses the same options as above and defaults to "all". Chain metrics with &.

• options: "NH" for no header rows, "-" to reverse the output to oldest first, and scale=K|M|B to divide the share counts by thousands, millions, or billions. Scaling applies to sharesShorted and sharesFloat only, never to shortInterestPercentage. Combine options with &, e.g. "scale=M&-".

Example - Short interest history for 2026

=SF_TIMESERIES("AAPL", "2026-01-01", "2026-09-30", "shortInterest", "all")

Example - Shares shorted in millions, oldest first

=SF_TIMESERIES("AAPL", "2026-01-01", "2026-09-30", "shortInterest", "date&sharesShorted", "scale=M&-")