Sourcing company Betas in Datastream
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.
- 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.
- 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…
How do I reference… a newspaper article in the APA7 style?
If you're using newspaper content in your work, you may be wondering how to reference it. Is it exactly the same as a journal article reference? Well, it's pretty similar. Here's a short guide. To ...
Resource trial: Writefull
Throughout June, Library Services are running a trial for Writefull which provides tools to help with academic writing. Writefull's support includes proofreading, spelling and grammar checking your work. It can also help you craft your ...
Working smarter, cleaner and greener: The future of manufacturing and materials
Everything we own, use or interact with in life starts with a material or materials. But even we in the industry admit that materials are a huge part of what has led us to where ...
Hubert Ovie Madise: My group design project
'Hubert Ovie Madise, what have you been up to the past ten weeks?' The Cranfield School of Water, Energy and Environment (SWEE) Group Design Project (GDP) module - that's what! The SWEE GDP module ...
The importance of big ideas: How small businesses can maximise their impact
Every year the Bettany Centre for Entrepreneurship hosts our annual entrepreneurship conference VentureDay. We are proud to have some small and medium enterprise (SME) owners on staff, including Heni Cloake and Gabriela Pearson, who share ...
How do I access the full-text of Harvard Business Review (HBR)?
This is one of the most frequently asked questions in the School of Management Library, presumably because HBR is such a key management journal and is renowned worldwide. The short answer is via EBSCO Business ...