Basic information on financial databases: cook books, tips and tricks & economic news

This blog contains schematic easy to grasp - hands on - help in performing searches in economic databases, making work sets and making them inter-exchangeable between the databases.

* Disclaimer. I am not a finance professional. Most posts are the result of personal findings.

All presented images are scaled and can be enlarged to original size (click the picture).

Search This Blog


Datastream: Commonly used dataypes (Time series equities)

Key datatypes
Dividend Yield (DY), Earnings per share (EPS), Market value (MV), Price (adjusted) (P), Price index (PI), Total return Index (RI) , Turnover By Volume (VO)
Datastream dataypes
Dividend Yield (DY), EPS (EPS), Free float number of shares (NOSHFF), Market to book value (MTBV), Market value (MV), Number of shares (NOSH), Price (adjusted) (P), Price index (PI), Strategic number of shares (NOSHST), Total assets (DWTA), Total return Index (RI), Turnover by Value (VA), Turnover By Volume (VO)

DY: The dividend yield expresses the dividend per share as a percentage of the share price. The underlying dividend is calculated according to the same principles as datatype DPSC (Dividend per share, current rate) in that it is based on an anticipated annual dividend and excludes special or once-off dividends. For some countries the dividend used is a forecast.
EPS This is the latest annualised rate that may reflect the last financial year or be derived from an aggregation of interim period earnings. Data is either provided by local sources or Worldscope.
MV Market value on Datastream is the share price multiplied by the number of ordinary shares in issue. The amount in issue is updated whenever new tranches of stock are issued or after a capital change.
P Datatype (P) represents the official closing price. This is the default datatype for all equities.
PI The price index expresses the price of an equity as a percentage of its value on the base date, adjusted for capital changes.
RI This shows a theoretical growth in value of a share holding over a specified period, assuming that dividends are re-invested to purchase additional units of an equity or unit trust at the closing price applicable on the ex-dividend date. For unit trusts, the closing bid price is used.
NOSH This is the total number of ordinary shares that represent the capital of the company.
NOSHST The percentage of total shares in issue held strategically and not available to ordinary shareholders.
NOSHFF The percentage of total shares in issue available to ordinary investors. The total number of shares less the strategic holdings.

MTBV This is defined as the market value of the ordinary (common) equity divided by the balance sheet value of the ordinary (common) equity in the company
VA This shows the value of all trades for a stock on a particular day. The figure is expressed in thousands. Daily figures are adjusted for capital changes; non-daily figures are not adjusted.
VO This shows the number of shares traded for a stock on a particular day.
PE This is the price divided by the earnings rate per share at the required date. For full details of the price and earnings figures used in any particular case, see the price and Earnings per share topics.

No comments:

Post a Comment