I'm trying to get the beta value for FTSE All share index members for every month between 2010-2019 in datastream excel. How do I do this?
I'm trying to get the beta value for FTSE All share index members for every month between 2010-2019 in datastream excel. How do I do this?
Sorry about the issue that you are facing.
I used the Datastream navigator tool to find a symbol and data type to get the beta value for FTSE all share index members. The symbol is LFTALLSH (FTSE ALL SHARE INDEX) and the data type is 897E (Historic BETA).
Therefore, the formula in Excel should look like this:
=@DSGRID("LFTALLSH","897E","-2Y","-0D","M","RowHeader=true;TimeSeriesList=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")
The output is:
However, please contact the Refinitiv Eikon with Datastream for Office support team directly via MyRefinitv to verify the symbol, data type, and formula.
I hope that this information is of help