# How to get historical daily index values from Bloomberg Terminal?

I found a lot of questions asking about index returns and index constituents, however, i'm looking for just daily closing values for certain Total Return indices. (FTSE/MSCI/BBBarclays) - these are not the market indices like S&P500 or DAX...but indices that ETFs are tracking. Edit: Seems like the question needs to be more specific. I didnt think the answer was dependent on the actual Index itself - but maybe it does, so here are the indexes (i also have the bloomberg tickers for each):

• MSCI Eastern Europe ex Russia
• FTSE Emerging Index
• FTSE Developed Asia Pacific ex Japan
• Bloomberg Barclays EM USD Sovereign + Quasi-Sov Index
• Bloomberg Barclays Global Aggregate Corporate
• Markit iBoxx USD Treasuries 10+ Mid Price TCA TRI
• BBerg Barclays World Govt Inflation-Linked Bond Index USD hedged

I can get end of month data from FTSE Russell website like this table below, but I needed daily values for the Total Return.

I will try out the GP command and the BDH functions in Excel API when I get access to the terminal again and try to export the data. Any other suggestions welcome.

• You just have to find the ticker. Problem is "FTSE total return" is not sufficiently precise, there are many many indexes with FTSE and tr in the name. Perhaps FTPTT250 Index is what you want: "FTSE UK Series FTSE 250 Total Return GBP". I looked it up here bloomberg.com/markets/symbolsearch?query=FTSE – Alex C Mar 30 '19 at 23:32
• I have the ticker list, but looking for a way to view the actual daily index values.Example, one of the indexes is BGAUTRUU. – aaaaarrrgghhh Mar 31 '19 at 0:25
• It is just like viewing any index, for example GP BGAUTRUU Index <return> (GP= graph prices. Are you familiar with GP command?) – Alex C Mar 31 '19 at 0:36
• @AlexC thanks, i have previously used GP with ETFs - but it only gave me a graph, and the Export menu only had options to export the picture, not a data table. I'm not in front of the terminal so I will check this with the index and revert. – aaaaarrrgghhh Mar 31 '19 at 7:11
• "HP" for closing levels, "HCP" for closing levels with percentage change. If you want to get a field in the excel api, do something like "FLDS PRICE" and then find the field you want and do "bdh(ticker, field, start date, end date). This info should all be super easily available on the Internet already though, amd if you can't find something if you hit F1 twice quickly in the terminal it will send you to a bbg help chat where you could ask them... – will Mar 31 '19 at 14:09

• Finally got my 1hr slot with th Bloomie - This was the best way to do it for all the indices together in one sheet, so i selected this as the answer. Although Alex C's GP and will's HP method also works! Thank you. My confusion stemmed from the field been called price, instead of 'index value' which is what I was expecting. – aaaaarrrgghhh Apr 5 '19 at 7:54