| key |
id |
string(50)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
dataDate |
date* |
=< >= |
Date of the data. |
|
activeAgents |
long(999999) |
|
Number of custodians and lending agents with open transactions. |
|
activeAvailableBOInvQuantity |
long(999999999999999) |
|
Quantity of shares realistically available for borrowing by removing BO On Loan Quantity from Active BO Inventory Value. |
|
activeAvailableBOInvRatio |
decimal{16,4} |
|
Active available quantity divided by 21 day average cash equity trading volume. |
|
activeAvailableBOInvValue |
decimal{20,4} |
|
Value of shares in millions realistically available for borrowing by removing BO On Loan Value from Active BO Inventory Value. |
|
activeBOInvQuantity |
long(1000000000000000000) |
|
As above but expressed in shares not value. |
|
activeBOInvValue |
decimal{20,4} |
|
Current inventory in millions available from beneficial owners less what is deduced to be temporarily restricted from lending, e.g., where securities are held in too small parcels or have been restricted by the beneficial owners (see the FAQs for details of the methodology). |
|
activeBrokers |
long(999999) |
|
Number of brokers with open transactions. |
|
activeUtilisation |
decimal{13,2} |
|
Demand value as a % of the realistically available supply (BO On Loan Value / Active BO Inventory Value). |
|
activeUtilisationByQuantity |
decimal{10,2} |
|
Demand quantity as a % of the realistically available supply (BO On Loan Quantity / Active BO Inventory Quantity). |
|
availableQuantityStability |
decimal{15,5} |
|
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{15,5} |
|
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. |
| 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) |
= |
For equities this is Bloomberg’s ticker symbol combined with the Bloomberg Exchange Code. For fixed income this is a combination of Bloomberg’s ticker symbol for the issuer combined with the Coupon Rate and the Maturity Date. |
| filter_list |
bbgId |
string(100) |
= |
Bloomberg Global Identifier, a unique, randomly-generated 12-digit identifer. |
|
boInvQuantity |
long(1000000000000000000) |
|
Quantity of current inventory available from beneficial owners. For record type 2 this value is implied. |
|
boInvQuantityAdd |
long(1000000000000000000) |
|
Quantity of inventory for existing beneficial owners who did not hold stock and now do. |
|
boInvQuantityDecrease |
long(1000000000000000000) |
|
Change in quantity of inventory for existing beneficial owners who have decreased their inventory. |
|
boInvQuantityIncrease |
long(1000000000000000000) |
|
Change in quantity of inventory for existing beneficial owners who have increased their inventory. |
|
boInvQuantityNew |
long(1000000000000000000) |
|
Quantity of inventory for beneficial owners joining the group. |
|
boInvQuantityRemoved |
long(1000000000000000000) |
|
Quantity of inventory for beneficial owners leaving the group. |
|
boInvValue |
decimal{20,4} |
|
Value of current inventory in millions available from beneficial owners. For record type 2 this value is implied. |
|
boInvValueAdd |
decimal{20,4} |
|
Value of inventory in millions for existing beneficial owners who did not hold stock and now do. |
|
boInvValueConcRatio |
decimal{5,4} |
|
A value between 0 and 1 to measure the distribution of inventory, where a very small number indicates a large number of lenders and 1 indicates a single lender with all the inventory. 0 means there is no inventory for the stock. Derived from a concentration measure based on the sum of squared market shares. |
|
boInvValueDecrease |
decimal{20,4} |
|
Change in value of inventory in millions for existing beneficial owners who have decreased their inventory. |
|
boInvValueIncrease |
decimal{20,4} |
|
Change in value of inventory in millions for existing beneficial owners who have increased their inventory. |
|
boInvValueMarketShareRank1 |
decimal{10,2} |
|
Relative to the total value of BO Inventory, the % held by the lender with the biggest market share. |
|
boInvValueMarketShareRank2 |
decimal{10,2} |
|
Relative to the total value of BO Inventory, the % held by the lender with the second biggest market share. |
|
boInvValueNew |
decimal{20,4} |
|
Value of inventory in millions for new beneficial owners joining the group. |
|
boInvValueRemoved |
decimal{20,4} |
|
Value of inventory in millions for beneficial owners leaving the group. |
|
boOnLoanQuantity |
long(999999999999999) |
|
Quantity of current inventory on loan from beneficial owners. |
|
boOnLoanQuantityAdd |
long(999999999999999) |
|
Quantity of stock on loan for existing beneficial owners who did not lend stock and now do. |
|
boOnLoanQuantityDecrease |
long(999999999999999) |
|
Change in quantity on loan for existing beneficial owners who have decreased their stock on loan. |
|
boOnLoanQuantityIncrease |
long(999999999999999) |
|
Change in quantity on loan for existing beneficial owners who have increased their stock on loan. |
|
boOnLoanQuantityNew |
long(999999999999999) |
|
Quantity of stock on loan for new beneficial owners joining the group. |
|
boOnLoanQuantityRemoved |
long(999999999999999) |
|
Quantity of stock on loan for beneficial owners leaving the group. |
|
boOnLoanValue |
decimal{20,4} |
|
Value of current inventory on loan in millions from beneficial owners. |
|
boOnLoanValueAdd |
decimal{20,4} |
|
Value of stock on loan in millions for existing beneficial owners who did not lend stock and now do. |
|
boOnLoanValueConcRatio |
decimal{5,4} |
|
A value between 0 and 1 to measure the distribution of lender value on loan, where a very small number indicates a large number of lenders and 1 indicates a single lender with all the value on loan. 0 means there is no value on loan for the stock. Derived from a concentration measure based on the sum of squared market shares. |
|
boOnLoanValueDecrease |
decimal{20,4} |
|
Change in value on loan in millions for existing beneficial owners who have decreased their stock on loan. |
|
boOnLoanValueIncrease |
decimal{20,4} |
|
Change in value on loan in millions for existing beneficial owners who have increased their stock on loan. |
|
boOnLoanValueMarketShareRank1 |
decimal{10,2} |
|
Relative to the total value of BO On Loan, the % lent by the lender with the biggest market share. |
|
boOnLoanValueMarketShareRank2 |
decimal{10,2} |
|
Relative to the total value of BO On Loan, the % lent by the lender with the second biggest market share. |
|
boOnLoanValueNew |
decimal{20,4} |
|
Value of stock on loan in millions for new beneficial owners joining the group. |
|
boOnLoanValueRemoved |
decimal{20,4} |
|
Value of stock on loan in millions for beneficial owners leaving the group. |
|
brokerDemandQuantity |
long(999999999999999) |
|
Quantity of current securities borrowed by brokers. NOTE this field is not the full demand picture. Use Total Demand. |
|
brokerDemandQuantityAdd |
long(999999999999999) |
|
Quantity of borrowed stock for existing brokers who did not borrow stock and now do. |
|
brokerDemandQuantityDecrease |
long(999999999999999) |
|
Change in quantity of borrowed stock for existing brokers who have decreased their borrowed stock. |
|
brokerDemandQuantityIncrease |
long(999999999999999) |
|
Change in quantity of borrowed stock for existing brokers who have increased their borrowed stock. |
|
brokerDemandQuantityNew |
long(999999999999999) |
|
Quantity of borrowed stock for new brokers joining the group. |
|
brokerDemandQuantityRemoved |
long(999999999999999) |
|
Quantity of borrowed stock for brokers leaving the group. |
|
brokerDemandValue |
decimal{20,4} |
|
Value of current securities in millions borrowed by brokers. NOTE this field is not the full demand picture. Use Total Demand |
|
brokerDemandValueAdd |
decimal{20,4} |
|
Value of borrowed stock in millions for existing brokers who did not borrow stock and now do. |
|
brokerDemandValueConcRatio |
decimal{5,4} |
|
A value between 0 and 1 to measure the distribution of broker demand, where a very small number indicates a large number of active brokers and 1 indicates a single active broker. 0 means there is no broker demand for the stock. Derived from a concentration measure based on the sum of squared market shares. |
|
brokerDemandValueDecrease |
decimal{20,4} |
|
Change in value of borrowed stock in millions for existing brokers who have decreased their borrowed stock. |
|
brokerDemandValueIncrease |
decimal{20,4} |
|
Change in value of borrowed stock in millions for existing brokers who have increased their borrowed stock. |
|
brokerDemandValueMktShareRank1 |
decimal{10,2} |
|
Relative to the total value of Broker Demand, the % borrowed by the broker with the biggest market share. |
|
brokerDemandValueMktShareRank2 |
decimal{10,2} |
|
Relative to the total value of Broker Demand, the % borrowed by the broker with the second biggest market share. |
|
brokerDemandValueNew |
decimal{20,4} |
|
Value of borrowed stock in millions for new brokers joining the group. |
|
brokerDemandValueRemoved |
decimal{20,4} |
|
Value of borrowed stock in millions for brokers leaving the group. |
| 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 operated by Standard and Poor's, requires CUSIP license. |
|
dataDateTime |
dateTime* |
|
Date time of securities finance mid-day/mid-night publish. |
|
daysToCover |
decimal{19,8} |
|
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{19,8} |
|
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(32767) |
|
S&P Global's Securities Finance Daily Cost of Borrow Score; a number from 1 to 10 indicating the rebate/fee charged by the agent lender based on daily proprietary benchmark rate, where 1 is cheapest and 10 is most expensive. |
|
dimv |
decimal{11,4} |
|
Daily Increased Market Volatility gives high scores to securities that have a high DNS and a high DIPS. With high short interest and a good chance of being a squeeze one can expect short term price volatility in such names and seek to profit from this. |
|
dips |
decimal{7,4} |
|
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%. |
| filter_list |
dividendReq |
decimal{12,4} |
= |
Proportion of a dividend payment a beneficial owner is entitled to should their shares be on loan over a dividend record date, e.g., 85%. |
|
dns |
decimal{7,4} |
|
S&P Global's Securities Finance Daily Negative Sentiment indicator shows the change in the average BO inventory quantity (longs) in relation to the average total demand 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{7,4} |
|
Daily Positive Sentiment gives higher scores to securities with low and unchanging utilization. |
|
dss |
long(32767) |
|
Daily Short Score is a simple score from 0 to 5 based upon the total demand as a % of the shares outstanding. 0 is a proxy for low short interest, 5 is high. The buckets are fixed regardless of country. |
| filter_list |
dxlId |
string(10) |
= |
Unique identifier assigned to every instrument on an exchange level. |
|
inactiveAgents |
long(999999) |
|
Number of custodians and lending agents with inventory but without open transactions. |
|
indicativeFee |
decimal{14,8} |
|
The indicative fee shows the expected borrow cost for a hedge fund on a given day. 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. |
|
indicativeFee1Day |
decimal{14,8} |
|
The 1 day indicative fee 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 7 day 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 indicative rebate shows the expected borrow cost for a hedge fund on a given day. 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. |
|
indicativeRebate1Day |
decimal{14,8} |
|
The 1 day 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 7 day 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. |
|
instrumentId |
long(99999999) |
|
Unique identifier assigned to every instrument. |
|
instrumentName |
string(255) |
|
Name of the security. |
|
instrumentType |
string(100) |
|
Type of Instrument, Equity or Bond. |
|
invRows |
long(32767) |
|
BLANK due to the introduction of new fields that replace this field. The column remains to maintain compatibility with existing workflows. |
| 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 based on the security’s currency denomination from the Market Area field (fixed income only). |
|
lendableQuantityStability |
decimal{15,5} |
|
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. |
|
lendableValueStability |
decimal{15,5} |
|
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. |
|
lenderQuantityOnLoanStability |
decimal{15,5} |
|
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. |
|
lenderValueOnLoanStability |
decimal{15,5} |
|
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. |
| filter_list |
marketArea |
string(255) |
= |
Market classification of security defining the country or currency of trading and security type. |
|
newLoanQuantity |
long(999999999999999) |
|
Number of new securities on loan/borrowed for the day. |
|
newLoanValue |
decimal{22,8} |
|
Value of new securities on loan/borrowed for the day. |
|
openLoanTransactions |
long(9999999999) |
|
Total number of open transactions from Beneficial Owner side only. Custodians typically report a separate transaction for every underlying Beneficial Owner or fund from who the borrow is taken. |
|
pcFreeFloatQuantityOnLoan |
decimal{20,8} |
|
Percentage of free float quantity which is out on loan. |
|
pcFreeFloatValueOnLoan |
decimal{20,8} |
|
Percentage of free float value which is out on loan. |
|
pcIssueValueOnLoan |
decimal{20,8} |
|
The Percentage of issue value which is out on loan. |
|
pcMarketCapOnLoan |
decimal{20,8} |
|
Percentage of Market Cap value which is out on loan. |
|
pcSharesOutstandingOnLoan |
decimal{20,8} |
|
Percentage of shares outstanding which is out on loan. |
|
quick |
string(20) |
|
Security Identification Code Conference; Instrument identifier used in Japan. |
| filter_list |
recordType |
long(255)* |
= |
Flagged 1 or 2. 1 = aggregated values, 2 = values for each separate dividend requirement. |
|
region |
string(100) |
|
Group which defines a set of instruments. |
|
saf |
decimal{14,4} |
|
Simple average fee in bps of stock borrow transactions from hedge funds in this security. |
|
sar |
decimal{14,4} |
|
Simple average rebate in bps of stock borrow transactions from hedge funds in this security. |
|
securitiesLoanTenure |
long(9999999999) |
|
The weighted average number of days from start date to present for all transactions. |
| filter_list |
sedol |
string(7) |
= |
Stock Exchange Daily Official List identifier assigned by the London Stock Exchange, requires SEDOL license. |
|
shortLoanDaysToCover |
decimal{19,8} |
|
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{19,8} |
|
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(999999999999999) |
|
Number of securities on loan/borrowed with dividend trading and financing trades removed. |
|
shortLoanQuantityAsPcOfFreeFloatQuantity |
decimal{19,8} |
|
Percentage of free float quantity out on loan with loans not related to directional short selling removed. |
|
shortLoanQuantityAsPcOfSharesOutstanding |
decimal{19,8} |
|
Percentage of shares outstanding which is out on loan with loans not related to directional short selling removed. |
|
shortLoanValue |
decimal{24,8} |
|
Value of securities on loan/borrowed with dividend trading and financing trades removed. |
|
shortLoanValueAsPcOfIssueValue |
decimal{22,8} |
|
Percentage of issue value out on loan with loans not related to directional short selling removed. |
|
shortLoanValueAsPcOfMarketCap |
decimal{19,8} |
|
Percentage of Market Cap value which is out on loan, with loans not related to directional short selling removed. |
|
shortSqueezeScore |
long(32767) |
|
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(0,32767) |
|
Integer representation of the data date. |
|
totalDemandQuantity |
long(999999999999999) |
|
Total quantity of borrowed/loaned securities net of double counting. |
|
totalDemandValue |
decimal{20,4} |
|
Total value in millions of borrowed/loaned securities net of double counting. |
|
utilisation |
decimal{10,2} |
|
The value of assets on loan from beneficial owners (BO On Loan Value) divided by the total lendable assets (BO Inventory Value), expressed as a percentage. For Record Type 2 this value is implied. |
|
utilisationByQuantity |
decimal{10,2} |
|
Utilization calculated using quantity rather than value figures (BO On Loan Quantity / BO Inventory Quantity). |
|
valueCurrency |
string(3) |
|
The ISO currency code in which monetary values are denominated. |
|
versionFlag |
long(0,127) |
|
Flag to indicate file version (Early vs Final). Early =1, Final =2. |
|
vwafChangeAll |
decimal{14,4} |
|
Change in the average fee for all trades compared to yesterday's average fee for all trades. |
|
vwafChangeDay1 |
decimal{14,4} |
|
Change in the 1 day average fee compared to yesterday's 1 day average fee. |
|
vwafChangeDay30 |
decimal{14,4} |
|
Change in the 30 day average fee compared to yesterday's 30 day average fee. |
|
vwafChangeDay60 |
decimal{14,4} |
|
Change in the 60 day average fee compared to yesterday's 60 day average fee. |
|
vwafChangeDay7 |
decimal{14,4} |
|
Change in the 7 day average fee compared to yesterday's 7 day average fee. |
|
vwafScoreAll |
long(999) |
|
Value weighted average fee for all trades expressed in undisclosed fee buckets 0-5, where 0 is the cheapest to borrow and 5 the most expensive. |
|
vwafScoreDay1 |
long(999) |
|
Value weighted average fee for all new trades on the most recent day expressed in undisclosed fee buckets
0-5, where 0 is the cheapest to borrow and 5 the most expensive. |
|
vwafScoreDay30 |
long(999) |
|
Value weighted average fee for all new trades on the most recent 30 calendar days expressed in undisclosed fee buckets 0-5, where 0 is the cheapest to borrow and 5 the most expensive. |
|
vwafScoreDay60 |
long(999) |
|
Value weighted average fee for all new trades on the most recent 60 calendar days expressed in undisclosed fee buckets 0-5, where 0 is the cheapest to borrow and 5 the most expensive. |
|
vwafScoreDay7 |
long(999) |
|
Value weighted average fee for all new trades over the most recent 7 calendar days expressed in undisclosed fee buckets 0-5, where 0 is the cheapest to borrow and 5 the most expensive. |