Many students come to the EDSC asking where they can find specific financial ratios, such as Tobin’s Q, on Eikon Datastream. While not hard to find for those familiar with the Eikon Excel add-on, this might not be immediately intuitive for new users.
When a particular variable is not available in the list of Datatypes, you can use the ‘Expressions’ to find alternative variables, such as financial ratios, via the ‘Expression Picker’ or create your own using the ‘Expression Builder’.
There are two ways to access the ‘Expressions’ button:
1. From the top navigation bar on Excel, under the 'Refinitiv Eikon Datastream' ribbon.
This is a useful way to retrieve the code and view the formula.
2. Or by using the ‘Expression Picker’ button on the Time Series Request form.
This is useful when opting to apply the code to a list of companies within a specific time/frequency.
Once you click on the ‘Expressions’ button, in order to find Tobin’s Q, click on the plus sign next to ‘Datastream’, ‘Ratios’ and ‘Equity Ratios’ on the left-hand side column of the ‘Expression Picker’ tab.
Datastream provides two codes and their respective formulas to calculate Tobin’s Q for individual companies.
The formulas and their descriptions can also be edited using the ‘Expression Builder’ to meet your data needs:
0 Comments.