| key |
id |
string(50)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
dataDate |
date* |
=< >= |
Date of the data. |
|
activeAvailableQuantity |
long(10000000000000) |
|
Quantity of actively lendable securities in lending programmes not currently on loan/borrowed |
|
activeAvailableValue |
decimal{16,2} |
|
Value of actively lendable securities in lending programmes not currently on loan/borrowed |
|
activeLendableQuantity |
decimal{14,0} |
|
Lendable quantity adjusted to remove lendable which is not being actively made available for lending |
|
activeLendableValue |
decimal{16,2} |
|
Lendable value adjusted to remove lendable which is not being actively made available for lending |
|
activeLendingAgents |
long(100000) |
|
Number of lending agents actively lending this instrument. |
|
activeUtilisation |
decimal{11,5} |
|
Percentage of actively lendable securities in lending programmes which are currently out on loan, calculated as the value of assets on loan from lenders divided by the active lendable value |
|
activeUtilisationByQuantity |
decimal{11,5} |
|
Lender Quantity on Loan divided by Active Lendable Quantity |
|
availableQuantityStability |
decimal{14,8} |
|
The percentage of Available Quantity in stable (low turnover) funds, based on S&P Global's Securities Finance proprietary stability algorithm.
On a quarterly basis, the movement of securities in and out of the funds is evaluated. Funds are flagged as stable if it changes its composition at a low rate in comparison to other funds on a quarterly basis |
|
availableValueStability |
decimal{14,8} |
|
The percentage of Available Value in stable (low turnover) funds, based on S&P Global's Securities Finance proprietary stability algorithm.
On a quarterly basis, the movement of securities in and out of the funds is evaluated. Funds are flagged as stable if it changes its composition at a low rate in comparison to other funds on a quarterly basis |
|
averageTenure |
decimal{12,5} |
|
The weighted average number of days from start date to present for all transactions |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the Price is calculated. |
| filter_list |
bbTicker |
string(100) |
= |
Bloomberg ticker. For equities, it combines Bloombergs exchange Ticker symbol with the Bloomberg Exchange Code. For fixed income, it combines Bloombergs Ticker symbol for the issuer with the Coupon Rate and the Maturity Date. |
| filter_list |
bbgId |
string(100) |
= |
Bloomberg Global Identifier, a unique, randomly-generated 12-digit identifer |
|
borrowerConcentration |
decimal{8,7} |
|
A value between 0 and 1 to measure the distribution of borrower demand. A very small number indicates a large number of borrowers with low borrowed values and 1 indicates a single borrower with all the broker demand. 0 means no borrower demand |
|
borrowerMarketShare1 |
decimal{8,5} |
|
The market share of the broker with the highest borrowed value |
|
borrowerMarketShare2 |
decimal{8,5} |
|
The market share of the broker with the second highest borrowed value |
|
cashpc |
decimal{14,8} |
|
Value on loan against cash collateral as proportion of value on loan |
| filter_list |
ciqTradingItemId |
long |
= |
Unique identifier created by S&P Global Market Intelligence to identify a trading item. |
| filter_list |
cusip |
string(9) |
= |
Committee on Uniform Security Identification Procedures identifier owned by American Bankers Association. This field requires a CUSIP license. Note: CINS (CUSIP International Numbering System) is not supported. |
|
dataDateTime |
dateTime* |
|
Date time of securities finance mid-day/mid-night publish. |
|
daysToCover |
decimal{14,5} |
|
Estimated time to buy back short position, based on current cash market volume. Calculated as the value on loan divided by the 30 trading day cash market turnover, in days. |
|
daysToCoverByQuantity |
decimal{14,5} |
|
Estimated time to buy back short position, based on current cash market volume. Calculated as the quantity on loan divided by the 30 trading day traded volume, in days. |
|
dcbs |
long(100000) |
|
Daily Cost of Borrow Score; a number from 1 to 10 indicating the cost of borrowing this security based on S&P Global's Securities Finance proprietary benchmark rate, where 1 is cheapest and 10 is most
expensive |
|
demandSupplyRatio |
decimal{18,8} |
|
Total on loan as a proportion of total lendable value |
|
dimv |
decimal{11,5} |
|
Daily Increasing Market Volatility indicator combines the change in security lending data (both longs and shorts) and the change in cash market data in order to determine a relative level of volatility. The indicator is based on a scale of 0% to 100% with a high number representing an increased level of
volatility |
|
dips |
decimal{8,5} |
|
Daily Increasing Price Squeeze indicator compares securities lending data (change in inventory quantity and loans) to cash market data (average trade volume and close price) in order to determine the risk of a rapid increase in price (i.e. price squeeze). The indicator is based on a scale of 0% to 100%. |
|
dns |
decimal{8,5} |
|
Daily Negative Sentiment indicator shows the change in the average inventory quantity (longs) in relation to the average loan quantity (shorts) for the security. The scale for this indicator is from 0% to 100%. A high DNS generally reflects negative sentiment (an increasing amount of shorts relative to longs) while a low number shows relatively less negative sentiment |
|
dps |
decimal{8,5} |
|
Daily Positive Sentiment indicator shows the average inventory quantity (longs) in relation to the average loan quantity (shorts) for the security. The scale for this indicator is from 0% to 100%. A high DPS generally reflects positive sentiment (relatively more longs than shorts) while a low number shows negative sentiment |
|
dss |
long(100000) |
|
Score based on the % Shares Outstanding On Loan |
| filter_list |
dxlId |
string(10) |
= |
DXL unique identifier assigned to every instrument |
|
inactiveLendingAgents |
long(100000) |
|
Number of Lending agents with stock to lend but currently not actively lending. |
|
indicativeFee |
decimal{14,8} |
|
The expected borrow cost, in fee terms, for a hedge fund on a given day. This is a derived rate using S&P Global's Securities Finance proprietary analytics and data set.
The calculation uses both borrow costs between Agent Lenders and Prime Brokers as well as rates from hedge funds to produce an indication of the current market rate. It should not be assumed that the indicative rate is the actual rate a Prime Broker will quote or charge but rather an indication of the standard market cost |
|
indicativeFee1Day |
decimal{14,8} |
|
The indicative fee 1 Day shows the expected borrow cost for a hedge fund on a given day based on latest day trades. This is a derived rate using S&P Global's proprietary analytics and data set.
The calculation uses both contributed borrow costs between Agent Lenders and Prime Brokers as well as contributed rates from the hedge fund participants to produce an indication of the current market rate. It should not be assumed that the indicative rate is the actual rate a Prime Broker will quote or charge but rather an indication of the standard market cost. |
|
indicativeFee7Day |
decimal{14,8} |
|
The indicative fee shows the expected borrow cost for a hedge fund on a given day based on trades in last 7 days. This is a derived rate using S&P Global's proprietary analytics and data set.
The calculation uses both contributed borrow costs between Agent Lenders and Prime Brokers as well as contributed rates from the hedge fund participants to produce an indication of the current market rate. It should not be assumed that the indicative rate is the actual rate a Prime Broker will quote or charge but rather an indication of the standard market cost. |
|
indicativeRebate |
decimal{14,8} |
|
The expected borrow cost, in rebate terms, for a hedge fund on a given day. This is a derived rate using S&P Global's Securities Finance proprietary analytics and data set.
The calculation uses both borrow costs between Agent Lenders and Prime Brokers as well as rates from hedge funds to produce an indication of the current market rate. It should not be assumed that the indicative rate is the actual rate a Prime Broker will quote or charge but rather an indication of the standard market cost |
|
indicativeRebate1Day |
decimal{14,8} |
|
The indicative rebate shows the expected borrow cost for a hedge fund on a given day based on latest day trades. This is a derived rate using S&P Global's proprietary analytics and data set.
The calculation uses both contributed borrow costs between Agent Lenders and Prime Brokers as well as contributed rates from the hedge fund participants to produce an indication of the current market rate. It should not be assumed that the indicative rate is the actual rate a Prime Broker will quote or charge but rather an indication of the standard market cost. |
|
indicativeRebate7Day |
decimal{14,8} |
|
The indicative rebate shows the expected borrow cost for a hedge fund on a given day based on trades in last 7 days. This is a derived rate using S&P Global's proprietary analytics and data set.
The calculation uses both contributed borrow costs between Agent Lenders and Prime Brokers as well as contributed rates from the hedge fund participants to produce an indication of the current market rate. It should not be assumed that the indicative rate is the actual rate a Prime Broker will quote or charge but rather an indication of the standard market cost. |
|
instrumentName |
string(255) |
|
Security description |
|
instrumentType |
string(100) |
|
Type of Instrument, Equity or Bond |
|
inventoryConcentration |
decimal{8,7} |
|
A value between 0 and 1 to measure the distribution of inventory. A very small number indicates a large number of lenders with low inventory and 1 indicates a single lender with all the inventory. 0 means no inventory |
|
inventoryMarketShare1 |
decimal{8,5} |
|
The market share of the lender with the highest LendableValue |
|
inventoryMarketShare2 |
decimal{8,5} |
|
The market share of the lender with the second highest LendableValue |
| filter_list |
isin |
string(12) |
= |
International Securities Identification Number. An international code which identifies a securities issue |
|
isoCountry |
string(2) |
|
ISO Country code |
|
isoCurrency |
string(3) |
|
ISO Currency code (fixed income only) |
|
lendableQuantity |
long(10000000000000) |
|
Quantity of stock inventory, available to lend |
|
lendableQuantityStability |
decimal{14,8} |
|
The percentage of Lendable Quantity in stable (low turnover) funds, based on S&P Global's Securities Finance proprietary stability algorithm.
On a quarterly basis, the movement of securities in and out of the funds is evaluated. Funds are flagged as stable if it changes its composition at a low rate in comparison to other funds on a quarterly basis |
|
lendableValue |
decimal{16,2} |
|
Value of stock inventory, available to lend |
|
lendableValueStability |
decimal{14,8} |
|
The percentage of Lendable Value in stable (low turnover) funds, based on S&P Global's Securities Finance proprietary stability algorithm
On a quarterly basis, the movement of securities in and out of the funds is evaluated. Funds are flagged as stable if it changes its composition at a low rate in comparison to other funds on a quarterly basis |
|
lenderConcentration |
decimal{8,7} |
|
A value between 0 and 1 to measure the distribution of lender value on loan. A very small number indicates a large number of lenders with low value on loan and 1 indicates a single lender with all the value on loan. 0 means no value on loan |
|
lenderMarketShare1 |
decimal{8,5} |
|
The market share of the lender with the highest LenderValueOnLoan |
|
lenderMarketShare2 |
decimal{8,5} |
|
The market share of the lender with the second highest LenderValueOnLoan |
|
lenderQuantityOnLoan |
long(999000000000) |
|
Quantity of stock on loan from lenders |
|
lenderQuantityOnLoanStability |
decimal{14,8} |
|
The percentage of Lender Quantity on Loan lent from stable (low turnover) funds, based on S&P Global's Securities Finance proprietary stability algorithm
On a quarterly basis, the movement of securities in and out of the funds is evaluated. Funds are flagged as stable if it changes its composition at a low rate in comparison to other funds on a quarterly basis |
|
lenderValueOnLoan |
decimal{14,2} |
|
Value of stock on loan from lenders |
|
lenderValueOnLoanStability |
decimal{14,8} |
|
The percentage of Lender Value on Loan lent from stable (low turnover) funds, based on S&P Global's Securities Finance proprietary stability algorithm
On a quarterly basis, the movement of securities in and out of the funds is evaluated. Funds are flagged as stable if it changes its composition at a low rate in comparison to other funds on a quarterly basis |
|
marketArea |
string(255) |
|
Market classification of security defining the country or currency of trading, security type |
|
newLoanQuantity |
long(999000000000) |
|
Number of new securities on loan/borrowed for the day. |
|
newLoanValue |
decimal{14,2} |
|
Value of new securities on loan/borrowed for the day. |
|
nextCorporateActionEventDate |
date |
|
Date of the next upcoming corporate action event |
|
nextCorporateActionEventDateTypes |
string(256)[20] |
|
Type of corporate event date, e.g.: Record date, Effective date, Ex-date.
Where there are multiple upcoming corporate actions events for the same date, these will appear in the format of an array/list. |
|
nextCorporateActionEventMeetingDates |
string(128)[20] |
|
Meeting date of the general meeting.
Where there are multiple upcoming corporate actions events for the same date, these will appear in the format of an array/list. |
|
nextCorporateActionEvents |
string(512)[20] |
|
Next upcoming corporate action event.
Where there are multiple upcoming corporate actions events for the same date, these will appear in the format of an array/list. |
|
nonCashpc |
decimal{14,8} |
|
Value on loan against noncash collateral as proportion of value on loan |
|
pcFreeFloatOnLoan |
decimal{11,5} |
|
Percentage of free float value which is out on loan. |
|
pcFreeFloatQuantityOnLoan |
decimal{11,5} |
|
Percentage of free float quantity which is out on loan. |
|
pcIssueValueOnLoan |
decimal{17,5} |
|
Percentage of issue value which is out on loan. |
|
pcMarketCapOnLoan |
decimal{11,5} |
|
Percentage of Market Cap value which is out on loan. |
|
pcSharesOutstandingOnLoan |
decimal{11,5} |
|
Percentage of shares outstanding which is out on loan. |
|
primeBrokers |
long(100000) |
|
Number of prime brokers borrowing this instrument. |
|
quantityOnLoan |
long(1000000000000) |
|
Total quantity of stock on loan, net of double counting |
|
quick |
string(20) |
|
An identification code established by the Securities Identification Code Committee for listed shares and other listed securities in Japan. |
|
region |
string(100) |
|
Group which defines a set of instruments |
|
saf |
decimal{14,8} |
|
Simple average fee of stock borrow transactions from hedge funds in this security (basis points). |
|
sar |
decimal{14,8} |
|
Simple average rebate of stock borrow transactions from hedge funds in this security (basis points). |
| filter_list |
sedol |
string(7) |
= |
Stock Exchange Daily Official List identifier assigned by the London Stock Exchange, requires SEDOL license |
|
shortLoanDaysToCover |
decimal{14,5} |
|
Estimated time to buy back short position, based on current cash market volume. Calculated as the Short Loan Value divided by the 30 trading day cash market turnover, in days. |
|
shortLoanDaysToCoverByQuantity |
decimal{14,5} |
|
Estimated time to buy back short position, based on current cash market volume. Calculated as the Short Loan Quantity divided by the 30 trading day traded volume, in days. |
|
shortLoanQuantity |
long(10000000000000) |
|
Number of securities on loan with with loans not related to directional short selling removed. |
|
shortLoanQuantityAsPcOfFreeFloatQuantity |
decimal{12,5} |
|
Percentage of free float quantity out on loan with loans not related to directional short selling removed. |
|
shortLoanQuantityAsPcOfSharesOutstanding |
decimal{14,5} |
|
Percentage of shares outstanding which is out on loan with loans not related to directional short selling removed. |
|
shortLoanValue |
decimal{14,2} |
|
Value of securities on loan with loans not related to directional short selling removed. |
|
shortLoanValueAsPcOfIssueValue |
decimal{17,5} |
|
Percentage of issue value out on loan with loans not related to directional short selling removed. |
|
shortLoanValueAsPcOfMarketCap |
decimal{14,5} |
|
Percentage of Market Cap value which is out on loan, with loans not related to directional short selling removed. |
|
shortSqueezeScore |
long(100000) |
|
Proprietary model utilizing transaction level data to identify names where short sellers are facing Capital Constraints, and therefore have increased potential to cover positions. Score of 0-10. Most likely to squeeze names have a rank closer to 1, and less likely to squeeze names are closer to 10. A score of 0 indicates negligible capital constraints as this security is not considered as highly shorted. |
|
timeSeriesId |
long |
|
Integer representation of the data date. |
|
transactionCount |
long(1000000) |
|
Number of transactions - all start dates |
|
utilisation |
decimal{11,5} |
|
The value of assets on loan from lenders divided by the total lendable value |
|
utilisationByQuantity |
decimal{11,5} |
|
The quantity of assets on loan from lenders divided by the total lendable quantity |
|
valueOnLoan |
decimal{14,2} |
|
Total value of stock on loan, net of double counting |
|
valueOnLoanVsCash |
decimal{14,2} |
|
Value of stock on loan versus cash collateral |
|
valueOnLoanVsNonCash |
decimal{14,2} |
|
Value of stock on loan versus non-cash collateral |
|
versionFlag |
long(-128,127) |
|
Flag to indicate file version (Early vs Final). Early =1, Final =2. |