Sourcing company Betas in Datastream
10/12/2019

Datastream provides current Betas and pre-formatted expressions to calculate historical betas for quoted companies around the world. In order for Datastream to display Beta calculations, at least 2½ years of data are required. Data is not held historically although it is possible to use formulae to calculate historic Betas.
Current Betas
- From the menu options choose ‘Static Request’. A search form will appear.
- Click on the orange ‘Find Series’ button beside the top search box. This will take you into the Navigator where you can search for the company you want. Type the name of the company in the search box, e.g. BP, and select the correct company from the options displayed.
- Next click on the ‘Datatypes’ button. Ensure ‘Equities’ is displaying in the drop down box to the left of search box and type in “Beta”
- Click on ‘Search’ and from the options displayed select ‘Beta (WS) – WC09802’.
- Leave the date box empty.
- Click on Submit and the latest beta value will be displayed.
- Results can be transferred to Excel.

Historical Betas
- This time, select ‘Time Series Request’.
- Click on the orange ‘Find Series’ button and follow the steps above to find the company you need.
- Then click on the ‘Expression Builder’ icon – below the orange Datatypes button. You will be taken to the Expressions page.

- Make sure that Expression Picker tab in the top left hand corner is selected.
- In the Search For boxes choose ‘Any’ and then enter beta. Click on Search and a list of relevant expressions will be displayed.
- Select BETA, MONTHLY, 5 YEARS by clicking on the code ‘458E’
- Enter your time period, e.g. -2Y, and frequency e.g. Quarterly.
- Click on ‘Submit’ and your values will be displayed.
- Results can be transferred to Excel.

Datastream is accessible on-campus in the School of Management via the VMWare application. Please ask if you need any assistance.
If all of this sounds a little complicated and scary, why not have a read of our Beginner’s guide to sourcing a company Beta too.
If you have any questions on Datastream or on sourcing financial data, please contact MIRC staff for more information.
Feature image from Pixabay. Available at: https://pixabay.com/photos/business-stock-finance-market-1730089/
Categories & Tags:
Leave a comment on this post:
You might also like…
Sign up to our ‘Making your research open access’ webinar – 9 February
Do you know your green from your gold? What are publisher deals, and how can they help you? My paper acknowledges UKRI funding, do I need to do anything special? What does an author accepted ...
How the Executive Logistics and Supply Chain Management MSc improved my career outlook
Hear from Harrison Jnr Ilodiwe, Executive Logistics and Supply Chain Management MSc, on his student experience at Cranfield. Why did you choose to study the Executive Logistics and Supply Chain Management MSc at Cranfield ...
Engineering problem to solve? Let Knovel help you find a solution
Did you know that Knovel provides you with more than just eBooks? Knovel is a key database for many engineering, mechanical and materials courses here at Cranfield University, and contains content from an extensive range ...
Working on your group project? We can help!
When undertaking a group project, typically you'll need to investigate a topic, decide on a methodology for your investigation, gather and collate information and data, share your findings with each other, and then formally report ...
Words matter – a conversational Integrated Vehicle Health Management lexicon
There are many well established barriers to successful digital transformation which prevent full realisation of desired benefits. It is generally recognised that only 30% of digital transformation efforts deliver these results. One of the ...
Library support for new research students
Welcome! We are very excited to welcome you to Cranfield, and we are looking forward to supporting you throughout your research degree. We are always happy to help you – all you need to do ...