Type IndexConstituent
Type category Entity
Description Constituents of the indices.
Timeseries key id, effectiveDate
Fields
Name Type Filters Description
key id string* = Unique Identifier
timeline effectiveDate date* =< >= Indicative of when the constituent level data is applicable. CLS.SDC file shows the close constituents as of the trading date. ADJ.SDC file shows constituents as of the open of the next index trading date.
alternateClassificationCode string This field is reserved for alternate, product-specific classification schemes. Alternate classifications comprise all sectors not starting with a digit or the letter D
asOfInd string Represents if the file contains close or adjusted close data
audCreatedDate dateTime* Timestamp of the record created in DataBase
awf decimal Additional weight factor as needed for certain methodologies. For methodologies not using AWF, the value will be 1. For ADJ.SDC files, this value represents the end-of-day AWF taking into account adjustments reflected in the next trading day. For PRO.SDC files, this value represents the end-of-day AWF taking into account adjustments reflected in the rebalancing date.
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the data is calculated.
bloombergTicker string Bloomberg ticker, provided on a best effort basis.
capRange string Available for index families with breakdown by a market cap bracket. For example, a stock that is classified to be over $25 billion will have the code RO25B.
company string The name of the constituent.
countryOfDomicile string ISO country/region code that is associated with the constituents country/region of domicile.
countryOfListing string ISO country/region code that is associated with the constituents country/region of exchange.
currencyCode string The ISO currency code in which the closing price of the stock is stated.
cusip string Constituents CUSIP identifier, provided on a best effort basis.
dailyPriceReturn decimal Daily stock % price return in index currency. Calculated as (((End-of-day LOCAL PRICE * End-of-day FX RATE) / (Start- of-day LOCAL PRICE * Start-of-day FX RATE)) - 1). If a stock did not trade on a day but the index FX RATE did, then the return is still impacted by the change in FX RATE.
dailyTotalReturn decimal Daily stock % total return in index currency. Same as the DAILY PRICE RETURN but factoring in any dividends if current day is the dividend ex-date. Calculated as ((((End- of-day LOCAL PRICE * End-of-day FX RATE) + (DIVIDEND * End-of-day FX RATE))/ (Start-of-day LOCAL PRICE * Start- of-day FX RATE)) - 1).
dividend decimal Dividend as reported by the constituent with an ex-date of the current day. Field is NULL if no dividends are issued on that day. Dividend Adjustment (primarily applicable for Japanese and Korean companies) is also reflected in this field.*
djiIndustryCode string Dow Jones Indexes' proprietary industry classification code associated with the constituent.
fileDate date Date on which the file is distributed
fxRate decimal Foreign exchange rate required in order to translate the stocks market value from local to index currency. A stock can have different exchange rates across different families in the event that families close at different time zones.
gicsCode string The Global Industry Classification Standard code associated with the constituent.
growth decimal The growth weight factor associated with the stock.
gvKey string Constituents Compustat permanent company identifier, provided on a best effort basis.
indexCode string Defines the index code that this stock is related to.
indexKey string Defines the index key that this stock is related to. See chapter Index Keys for more information.
indexMarketCap decimal The portion of the constituent's market cap that is part of the index (i.e. INDEX SHARES * LOCAL PRICE * FX RATE).
indexName string Defines the index name that this stock is related to.
indexShares decimal The total number of shares determined and used by the index calculation methodology (i.e. SHARES OUSTANDING * IWF * AWF).
indexWeight decimal The weight of the stock within the parent index. Calculated as the INDEX MARKET CAP of the stock / Sum of INDEX MARKET CAPs of all stocks in the index.
isin string Constituents ISIN identifier, provided on a best effort basis.
iwf decimal The investible weight factor of the stock in the index. A value of 1 = 100% Free Float. For ADJ.SDC files, this value represents the end-of-day IWF taking into account adjustments reflected in the next trading day. For PRO.SDC files, this value represents the end-of-day IWF taking into account adjustments reflected in the rebalancing date.
localPrice decimal The end-of-day closing price of the stock, represented in the local currency of the stock. For ADJ.SDC files, this value represents today's price taking into account adjustments reflected in the next trading day. For PRO.SDC files, this value represents today's price taking into account adjustments reflected in the rebalancing date only for FMC indices, while for weighted indices, the Local Price is as of the next open following the Report Date
marketCap decimal The total unadjusted market capitalization of the stock, representing the SHARES OUTSTANDING * LOCAL PRICE * FX RATE. Value is represented in the currency of the parent index.
mic string Market Identification Code ISO Code of the exchange the constituent is traded on. Provided on a best effort basis.
netDividend decimal Net dividend amount issued by the constituent with an ex-date of the current day (after subtracting taxes and franking). Tax and franking rates used are as of ex-date. Field is NULL if no dividends are issued on that day. Net Dividend Adjustment (primarily applicable for Japanese and Korean companies) is also reflected in this field.*
region string Available for the Global BMI & GIVI families and indicates if the stock is considered part of a developed or emerging market.
ric string Reuters Instrument Code, provided on a best effort basis.
sedol string Constituents SEDOL identifier, provided on a best effort basis.
sharesOutstanding decimal{26,0} The latest number of shares outstanding for the constituent. For ADJ.SDC files, this value represents the end-of-day shares outstanding taking into account adjustments reflected in the next trading day. For PRO.SDC files, this value represents the end-of-day shares outstanding taking into account adjustments reflected in the rebalancing date.
size string Indicates if the stock is classified as a large, mid or small cap stock within the methodology of the index. A stock may be classified as large in one index family, and mid in another. Value is left blank for indices not providing size breakdown.
stockKey long(0,9223372036854775806) Unique S&P Dow Jones Indices identifier. This key will be persistent regardless of other identifier changes.
ticker string Constituents stock ticker, associated with the exchange the constituent is traded on, provided on a best effort basis.
value decimal The value weight factor associated with the stock.
44 rows of 44 total
API Open API Specification