Using the BETA in Datastream

In an earlier post I explained how to get a historical, changing, BETA for equities from Datastream. Using the specific formula it is not that difficult. If you need to get the BETA for a larger selection of equities in one go I explained in a follow-up post how excel can be used to easily combine the formula with different equities (and even markets,) should you wish to do this.

What I may not have explained clearly is, that you can not upload the list of formulas like you would a regular upload of a list of equities. If you try to do this and then use the list the Datastream software is unable to handle this search request and will display as the end result error messages like:
$$”ER”, E200, EXPRESSION TOO LONG

or:
$$”ER”, E100, INVALID CODE OR EXPRESSION ENTERED.

The only way to use a list of equities and download a historical BETA, is using the Request Table (RT) option. Just copy the list of formulas in this and it should work. Here you see an example how the RT should look:

The download result will look as follows:

NB: A Request Table search will also allow you to use different time frames for different formulas/equities for instance if you want to do an event study using Datastream. You can download an example Request table here.

Email

%d bloggers like this: