| key |
id |
string* |
= |
The unique identifier |
| timeline |
dateOfIndex |
date* |
=< >= |
Indicative of when the reported index level data is
applicable. If an index did not trade on the day of the
file, then the last trade date will be displayed. |
|
adjCount |
long(0,9223372036854775806) |
|
The number of securities that make up the index
portfolio as of the following index trading day taking into
account any additions and/or deletions. |
|
adjDivisor |
decimal |
|
Any adjustments made to the index CLOSE DIVISOR
due to corporate actions, constituent changes or
specific index methodology changes occurring on the
next day are reflected in the ADJ DIVISOR (aka next
day open divisor). The divisor is adjusted to ensure
index levels remain consistent and comparable. Same
as CLOSE DIVISOR if there are no changes. |
|
adjMarketCap |
decimal |
|
The adjusted market capitalization is calculated after
the indexs markets have closed, taking into account
any adjustments being made to the securities (adds,
drops, share changes, growth/value weight changes,
etc.) prior to the start of trading for the following index
trading day. Same as CLOSE MARKET CAP if there
are no changes. |
|
audCreatedDate |
dateTime |
|
Timestamp of the record created in DataBase |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the data is calculated. |
|
change |
string |
|
A symbol will be present to denote any adjustment
made to the divisor based on events effective for the
next trading day. |
|
closeCount |
long(0,9223372036854775806) |
|
The number of securities that make up the index
portfolio at the end-of-day close. |
|
closeDivisor |
decimal |
|
An index divisor is the basis for comparability across
time, and the starting point for adjustments that need to
be made due to changes in the equity composition of
the underlying companies in the index or to corporate
actions that cause changes to the market value of the
stocks in the index. |
|
closeMarketCap |
decimal |
|
The sum of all constituent INDEX MARKET CAPs,
stated in the currency of the index. |
|
dailyReturn |
decimal |
|
Calculated as: [(today's index value / yesterday's index
value)
1]. |
|
fileDate |
date |
|
Date on which the file is distributed |
|
gicsCode |
string |
|
GICS classification code is only provided for indices
defined by a single GICS CODE classification. Value is
NULL if the index is not associated with a GICS code,
or associated with DJI codes, custom sectors and
multiple GICS codes. |
|
indexCode |
string |
|
Code for the index. This field is generally unique
within a file, but not unique across different families. |
|
indexDividend |
decimal |
|
The impact on the index from dividends issued by
constituents with an ex-date of the DATE OF THE
INDEX.
[Sum of (DIVIDEND * INDEX SHARES * FX RATE)] /
CLOSE DIVISOR
Please note that net total return indices account for
taxes by subtracting out taxes from the DIVIDEND
amount. |
|
indexKey |
string |
|
A unique index identifier that also represents
characteristics of the index, e.g. size, sector, currency,
etc. See chapter Index Keys for more information. |
|
indexName |
string |
|
The official name of the index. |
|
indexValue |
decimal |
|
The end-of-day closing value. |
|
isoCode |
string |
|
ISO currency code for the currency in
which the index level data is being reported in and stock
market capitalizations are being normalized to. |