Get Code Isin from Bloomberg with Excel formula

Question

If utilizing an Excel formula, is it possible to obtain every Code In that makes up a ticker? On the Internet, I can't find the formula.

Answer 1

In answer to the follow-up, BQL is the best method for obtaining an index's constituents from Bloomberg (Bloomberg Query Language). The Bloomberg toolbar has an option called "BQL Builder," or you can utilize the Function Builder (the syntax is slightly different).

For the OP's question, enter this formula in a cell:

=BQL("members('SPX INDEX')","ID_ISIN")

It will expand and show all the members of the S&P and their ISINs.