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…
Jubilee weekend opening hours for Library services
Library services will change over the weekend of Thursday 2 until Sunday 5 June for the Queen's Platinum Jubilee. Kings Norton Library and Management and Resource Centre (MIRC) Both library spaces will be open for ...
‘Meet the bees’ tour May 2022
When I started working at Cranfield University in March 2021, a couple of the things that I really liked were the amount of green spaces and their dedication to become more environmentally friendly. I’ve never ...
Introducing…. Orbis BankFocus
For anyone researching the financial sector, Orbis BankFocus is a great place to start, providing financial and company data for finance institutions and companies. The service allows you to search for a single company or ...
Me, myself, and anxiety
Then and now I remember the moment very well – I was sat at a desk talking to my boss, pointing out the key elements of a strategic plan. I was in quite a stressful ...
“My Cranfield degree transformed me as a person”
Kalyani Hedge (Management MSc, 2021), is currently working as the Head of Supply Chain, Administration and Legal at Nandu Chemicals Private Limited. We caught up with Kalyani to find out more about her experiences ...
“Studying at Cranfield encouraged me to move out of my comfort zone”
For marketing professional Jim Davies, studying for a part-time MSc in Marketing and Leadership at Cranfield School of Management was the catalyst for making a bold career move after more than a decade spent ...