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…
Systematic Literature Review – Identifying your search terms and constructing your search strings
Our previous posts on the systematic review have looked at getting started and selecting your sources. In this post we will look at the next fundamental stage: Identifying your search terms and constructing your search ...
Navigating the World of Robotics: My Journey at Cranfield University
Hey there, I'm Manideep, and I'm thrilled to share my experience pursuing an MSc in Robotics at Cranfield University. Let me take you through my journey and how Cranfield became the ...
Exploring safer and smarter airports with the Applied Artificial Intelligence MSc group design project
Artificial intelligence (AI) technologies have experienced rapid development in recent years, spanning from large language models (LLMs) to generative artificial intelligence (GAI). These cutting-edge advancements have significantly impacted various aspects of ...
My aerospace manufacturing journey at Cranfield University
Hey there, I'm Abhishek and I wanted to share my journey into aerospace manufacturing, guided by my experiences at Cranfield University. Let's dive into how this remarkable institution shaped my career ...
Changes to Library Services over Easter, 29 March – 1 April
Libraries on the Cranfield site Both Kings Norton Library and the School of Management Library (Building 111, first floor) will be open 24/7 over the Easter weekend. You will be able to use the study ...
How to present well as a group
You will have put a lot of work into your research or project and want to show everyone what you have achieved or discovered, so you need to impart this knowledge as clearly as possible. ...