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…
Want to improve your reading skills?
Are you starting to wade through the mountains of reading that you have discovered for your project? You've searched the library databases, journals and printed collection and now have a reading list that stretches to ...
What a Mango Scientist Learned from Anthropy 23
Anthropy 23 and the ‘Emerging Leader’ title As a researcher, a setting like Anthropy was quite foreign to me. The conferences I have attended before were scientific/academic gatherings, where people presented data they had gathered ...
The beginning of my Cranfield journey as a Water student.
Joining Cranfield University is a dream come true! I made this decision based on what I had learnt from some of my colleagues from my home country who had studied here, and alumni of ...
Webinars and workshops running in December
Our Library Services staff run a wide range of webinars and in-person workshops to support your work and boost your success at Cranfield. They cover topics including using our databases effectively, referencing, study skills, the ...
World Soil Day 2023, 5 December – showcasing the Cranfield University Soilscapes Viewer tool
UN World Soil Day on 5 December is a vital reminder of the importance of soil in all our lives. Supporting growth of the food we eat; cleaning the water we drink; supporting the foundations ...
Collect your reservations 24/7 from the SOM Library locker
SOM Library customers, did you know that you can reserve items on Library Search and then pick them up at any time of the day or night from our SOM Library locker using your University ...