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