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.

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

Search This Blog

9/16/2014

Datastream: create list from range and find the historical beta

How to find betas and how to download them?
Not many databases offer this possibility, but Datastream does.

Without getting into the finer details of programming and constructing beta's it is possible to perform downloads with pre-made betas.
This post will show you how.
(assuming you are familiar with the basic functions of Datastream)

Uploading a list of companies
(e.g. from Stoxx 50)


















Press option Create from range. Next either store locally (the very computer you are working on) or upload to remote server (enabling to work with any computer with Datastream in the world)
Uploading will result in the following pop up








memorize the list code L#H23098 (in this case)

Go to Time series menu.
Either use button for locally stored list

or use the rule to write down the memorized list name







Next: finding the Beta
The BETA is defined as the measure of an asset's risk in relation to the market (often an index). 
The higher the beta, the better, as a rule as it shows the times return on an investment (simplified)

Use the button right under the orange datatypes button

















I have searched for beta. For a DataStream calculated historical beta take the second one.
Take note of the expression behind the name and code.
REGB#(LN#(Li)/LAG##(x(Li),1M)),LN#(X/LAG#(X,1M)),60M)
Select desired beta











Result. Historical betas.



















To those interested: this post goes deeper into the matter (Blog Mark Bruyneel)

No comments:

Post a Comment