Type IntradaySellside
Type category Entity
Description Intraday Sellside
Timeseries key id, fileTimeStamp
Fields
Name Type Filters Description
key id string(100)* = The id field uniquely identifies the entity record.
timeline fileTimeStamp dateTime* =< >= Date and Time of the data.
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 Bloomberg’s exchange Ticker symbol with the Bloomberg Exchange Code. For fixed income, it combines Bloomberg’s 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
filter_list ciqTradingItemId long(0,2147483647) = 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.
filter_list dataDate date = Date of the data.
filter_list dxlId string(10)* = DXL unique identifier assigned to every instrument on an exchange level
instrumentName string(255) Security description.
instrumentType string(100) Type of Instrument, Equity or Bond.
intradayDepth decimal{14,8} Intraday Quantity on Loan as a ratio of settled Quantity on Loan from latest available publish.
intradayLenderQuantityOnLoan long(0,9000000000000) Quantity of Intraday loans from Lenders, expressed in shares.
intradayLenderValueOnLoan decimal{14,2} Value of Intraday loans from Lenders, expressed in USD.
intradayLoanCount long(0,9000000000000) Count of Intraday Loans
intradayQuantityOnLoanVsCash long(0,9000000000000) Quantity of Intraday Loans vs. Cash Collateral, expressed in shares.
intradayQuantityOnLoanVsNonCash long(0,9000000000000) Quantity of Intraday Loans vs. Non Cash Collateral, expressed in shares.
intradayQuantityOnLoanVsOpen long(0,9000000000000) Quantity of Intraday Loans with Term type Open, expressed in shares.
intradayQuantityOnLoanVsTerm long(0,9000000000000) Quantity of Intraday Loans vs. Term, expressed in shares.
intradayRecallQuantity long(0,9000000000000) Quantity of Intraday Loans recalled by the Lender, expressed in shares.
intradayRecallValue decimal{14,2} Value of Intraday Loans recalled by the Lender, expressed in USD.
intradayRerateQuantityOnLoan long(0,9000000000000) Quantity of Intraday Loans flagged as a Rerated Transaction, expressed in shares.
intradayRerateValueOnLoan decimal{14,2} Value of Intraday Loans flagged as a Rerated Transaction, expressed in USD.
intradayReturnCount long(0,9000000000000) Count of Intraday Returns
intradayShortLoanQuantity long(0,9000000000000) Intraday Quantity on Loan with loans not related to directional short selling removed, expressed in shares.
intradayShortLoanValue decimal{14,2} Intraday Value on Loan with loans not related to directional short selling removed, expressed in USD.
intradayValueOnLoanVsCash decimal{14,2} Value of Intraday Loans vs. Cash Collateral, expressed in USD.
intradayValueOnLoanVsNonCash decimal{14,2} Value of Intraday Loans vs. Non Cash Collateral, expressed in USD.
intradayValueOnLoanVsOpen decimal{14,2} Value of Intraday Loans with Term type Open, expressed in USD.
intradayValueOnLoanVsTerm decimal{14,2} Value of Intraday Loans vs. Term, expressed in USD.
filter_list isin string(12) = International Securities Identification Number. An international code that identifies a securities issue.
isoCountry string(2) ISO Country code
isoCurrency string(3) ISO Currency code (fixed income only)
liveAvailableQuantity long(0,9000000000000) Indication of overall Quantity of lendable securities not currently on loan/borrowed, on an Intraday basis. Based off settled Available Quantity from the latest available publish, less net Intraday Lender Quantity on Loan (Loans - Returns), expressed in shares.Please note, this metric is designed to be an indication, and might not always be a precise quantity. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live quantity.
liveAvailableValue decimal{16,2} Indication of overall Value of lendable securities not currently on loan/borrowed, on an Intraday basis. Based off settled Available Value from the latest available publish, less net Intraday Lender Value on Loan (Loans - Returns), expressed in USD.Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live value.
liveLenderQuantityOnLoan long(0,9000000000000) Indication of overall loans from Lenders, on an Intraday basis, based off settled Lender Quantity on Loan from the latest available publish, plus net Intraday Lender Quantity on Loan (Loans - Returns), expressed in shares.Please note, this metric is designed to be an indication, and might not always be a precise quantity. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live quantity.
liveLenderValueOnLoan decimal{16,2} Indication of overall loans from Lenders, on an Intraday basis, based off settled Lender Value on Loan from the latest available publish, plus net Intraday Lender Value on Loan (Loans - Returns), expressed in USD.Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live value.
liveQuantityOnLoan long(0,9000000000000) Indication of overall Quantity on Loan, on an Intraday basis, based off settled Quantity on Loan from the latest available publish, plus net Intraday Quantity on Loan (Loans - Returns), expressed in shares.Please note, this metric is designed to be an indication, and might not always be a precise quantity. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live quantity.
liveShortLoanQuantity long(0,9000000000000) Indication of overall Short Loan Quantity, on an Intraday basis, based off settled Short Loan Quantity from the latest available publish, plus net Intraday Short Loan Quantity (Loans - Returns), expressed in shares.Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live quantity.
liveShortLoanValue decimal{16,2} Indication of overall Short Loan Value, on an Intraday basis, based off settled Short Loan Value from the latest available publish, plus net Intraday Short Loan Value (Loans - Returns), expressed in USD. Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live value.
liveUtilization decimal{14,8} Indication of overall Utilization, on an Intraday basis, based off settled Lender Value on Loan from the latest available publish plus net Intraday Lender Value on Loan (Loans - Returns), divided by settled Lendable Value from the latest available publish. Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live value.
liveUtilizationByQuantity decimal{14,8} Indication of overall Utilization, on an Intraday basis, based off settled Lender Quantity on Loan from the latest available publish plus net Intraday Lender Quantity on Loan (Loans - Returns), divided by settled Lendable Quantity from the previous dataset date.Please note, this metric is designed to be an indication, and might not always be a precise quantity. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live quantity.
liveValueOnLoan decimal{16,2} Indication of overall Value on Loan, on an Intraday basis, based off settled Value on Loan from the latest available publish, plus net Intraday Value on Loan (Loans - Returns), expressed in USD. Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a Live value.
marketArea string(255) Market classification of security defining the country or currency of trading, security type.
pcIntradayLoansStartT decimal{14,8} Percentage of all intraday loans where Start Date is equal to Trade Date.
pcIntradayLoansStartT1 decimal{14,8} Percentage of all intraday loans where Start Date is equal to Trade Date +1.
pcIntradayLoansStartT2 decimal{14,8} Percentage of all intraday loans where Start Date is equal to Trade Date +2.
pcIntradayReturnsToStartT decimal{14,8} Percentage of all intraday returns where Start Date is equal to Trade Date.
pcIntradayReturnsToStartT1 decimal{14,8} Percentage of all intraday returns where Start Date is equal to Trade Date +1.
pcIntradayReturnsToStartT2 decimal{14,8} Percentage of all intraday returns where Start Date is equal to Trade Date +2.
quick string(20) Security Identification Code Conference; instrument identifier used in Japan.
region string(100) Group that defines a set of instruments.
returnQuantity long(0,9000000000000) Quantity of shares returned to lenders from intraday transactions, expressed in shares.
returnValue decimal{14,2} Value of shares returned to lenders from intraday transactions, expressed in USD.
filter_list sedol string(7) = Stock Exchange Daily Official List identifier assigned by the London Stock Exchange, requires SEDOL license.
timeSeriesId long(0,2147483647) Integer representation of the data date.
tradeQuantity long(0,9000000000000) Quantity of shares on loan received from intraday transactions, expressed in shares. Trades can be pending or settled (same day). Representative of intraday demand to borrow securities.
tradeValue decimal{14,2} Value of shares on loan received from intraday transactions, expressed in USD. Trades can be pending or settled (same day). Representative of intraday demand to borrow securities.
vwaf decimal{14,8} Value weighted average fee for all intraday trades (multiply by 100 for %, 10000 for bps).
vwar decimal{14,8} Value weighted average rebate for all intraday trades (multiply by 100 for %, 10000 for bps).
61 rows of 61 total
API Open API Specification