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.
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)...
Officia suscipit quas maiores est. Saepe vitae enim harum quo deleniti est. Quam cupiditate suscipit reiciendis facilis praesentium incidunt. Quibusdam ut accusamus autem quibusdam dolores repudiandae quis velit.
Asperiores voluptatem totam rerum. Distinctio hic est magni. Nam dignissimos et voluptatum aspernatur. Voluptas ipsam quia amet deleniti.
Alias architecto et facere perferendis quibusdam id. Ipsa adipisci sapiente molestiae unde natus recusandae provident.
Laboriosam nobis accusamus quo ut. Repudiandae repellendus quis quae autem fugit. Eos nam debitis sunt itaque earum omnis. Consectetur atque unde voluptatem ex ut asperiores dolores.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...