Overview
The History Tearsheet returns a time series for up to five companies over a window of up to five years, built to be charted. Each row is one company on one date, with the figures you ask for: the closing price and the volume traded, then shares sold short and their value, the percent of free float sold short, days to cover, cost to borrow, shares available to borrow, and the short score. Prices are end-of-day. The short interest figures are daily estimates, modelled from securities-lending data.When to Use
The History Tearsheet is ideal for:- Price against short interest: How a stock’s price moved beside its short interest, days to cover or borrow cost
- Trends: How short interest, borrow cost or lendable supply changed over a period
- Comparisons: The same figures for a handful of companies side by side, over the same dates
- Point-in-time questions: What the price or short interest was on a past date
How It Works
- Call: A call is made to
find_securities(orget_securities) to resolve each company name or ticker - Extract: The
idfield is extracted from each result and used as anrp_entity_id - Call: A single call is made to
bigdata_history_tearsheetwith up to fiverp_entity_idvalues, the figures you need and the window
Parameters
Important Notes
- The window can span at most five years
weekly,monthlyandquarterlykeep the last trading day of each period with that day’s values. Weeks run Monday to Sunday, and a period the window cuts short, the current one included, still has a row- Prices are in one currency, that of the first company given whose currency is known. A company that trades in another currency has empty price cells: ask for it in a separate call
- Prices and short interest can come from different listings of one company: SAP’s prices come from its New York listing, in US dollars, and its short interest from Xetra. The response names both
- When your plan does not include the short interest data, the prices you asked for are returned and the response says which figures were left out. A request for short interest alone is refused
- A company the data does not cover for the figures asked for has no rows, and the response names it
- A daily series over a long window is long: for windows over three months, ask for a weekly or monthly frequency unless every trading day is needed
Data Returned
The response is a short summary, a table of what each column holds, and the series as CSV. The CSV starts withdate and rp_entity_id, then one column per figure, in this order whatever order the metrics were asked in:
Rows are grouped by company, in the order the IDs were given, and each company’s dates run oldest first. An empty cell means no value that day: short interest can have a row on a market holiday, when there is no price.
The structured content carries the same CSV with each company’s name and a description of each column.
mapping names, for each company, the symbol its prices come from (price_symbol) and the listing its short interest comes from (short_interest_listing), each present when its figures are asked for. prices_left_out names any company left out of prices for its currency, and withheld_metrics names any figure your plan does not include.
Example
A weekly series of the default figures, the closing price and short interest, for Spotify (86170D) and Apple (D8442A) over September 2026. Both trade in US dollars:
Practical Tips
Charting Price Against Short Interest
Plot the figures you compare in one chart, with short interest on a second axis, to see how they move together. To compare companies, plot each one’s close as a percentage change from its first day, so their prices share one scale. When measuring how two series relate, correlate their day-to-day changes rather than their levels: two series that both trend look correlated on levels even when they are not.Reading Short Interest
Comparepercent_of_free_float across companies rather than shares_short: a large company can have many more shares sold short and still be far less heavily shorted. days_to_cover says how long short sellers would need to buy their shares back at normal volume, so a rising value with flat short interest means trading volume is falling.
Reading Borrow Cost and Supply
A risingcost_to_borrow together with falling shares_available_to_borrow means borrowing is getting tighter. cost_to_borrow_new_loans covers only loans opened that day, so it shows what borrowing costs now, while cost_to_borrow averages every loan still open.
Choosing a Frequency
Usedaily for windows of a few weeks or when the exact day matters, and weekly or monthly for longer trends. A coarser frequency keeps the response short without changing the values: each row is a real trading day’s figures, not an average.