How to find Bloomberg security codes for Bloomberg Excel Add-In?

Hey,

I don't have access to a Bloomberg Terminal. But luckily my brother in law has. I would like to have some historic price data for indices like the ones of the MSCI Family (MSCI World, MSCI Europe and so on). To reduce the workload for him since he has to do it at work I would like to provide him an excel sheet with the formulas (=BDH(Security, Field, Start date, End date, option)) already set up so he just has to open it and save it with the downloaded data. I am struggling to find the security code for all those indices. What would be the code for the MSCI World Index Total Return Net or MSCI World Index Price? How can I find out those codes?

MSCI provides Bloomberg Tickers on their homepage: unfortunately I cannot post links

Also there is a Bloomberg symbol lookup homepage:
unfortunately I cannot post links

If you type in "MSCI World" it only finds ETFs but not the index itself. If you type in "MSCI" it finds at least the MSCI AC Asia Pacific Index (MXAP:IND). If you type in any of the tickers from the MSCI homepage Excel sheet it doesn't find anything. If I type in MXWO as a guess for MSCI World it finds a lot of ETFs but not the index. Same for MXWO:IND, nothing to find.

So the question is, how can I find those securities codes for indices on Bloomberg without having a Bloomberg terminal?

P.S.: Cannot post the full hyperlinks due to forum restrictions.

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (2)

Jul 1, 2018 - 9:40am

The MSCI indices can be tricky to pull. You need certain BBG permissions/entitlements to pull most of them.

To find most of them use: msci world index bloomberg ticker search on google and the xlsx is like the third link. Keep in mind most of these are going to price return only and are going to be denominated in local ccy. you are going to need to convert it to USD if you want a true picture.

Also keep in mind for historical data you need to use the EOD tickers and not the real-time ticker. EOD is the official settlement. excel formula should be something like bdh("DLGAFEJH Index",px_last,start,end)...

"The way to make money is to buy when blood is running in the streets." -John D. Rockefeller
  • 1
Jul 4, 2018 - 9:34pm

Aliquid sunt voluptas sit debitis. Aliquid explicabo ea commodi et autem voluptatum. Labore sit voluptas non expedita voluptates id. Cum non et expedita cupiditate. Quo et nulla ratione pariatur doloribus eos.

Start Discussion

Total Avg Compensation

October 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (39) $363
  • Associates (229) $233
  • 2nd Year Analyst (139) $155
  • 3rd+ Year Analyst (32) $149
  • Intern/Summer Associate (104) $143
  • 1st Year Analyst (504) $135
  • Intern/Summer Analyst (387) $83