Cheat Sheets

Exchange Codes

The two letter codes you see in combination with a ticker symbol is the exchange code. By default, Bloomberg will use your account preferences to make assumptions about what security you are looking at. If you are looking at stocks traded on exchanges around the world you will need to add the related exchange code.

For example:

Exchange codes
MIC Exchange Name Equity Exchange Code     Composite Code    
Hong Kong Stock Exchange HK n/a
London Stock Exchange (domestic)   LN n/a
New York Stock Exchange UN US
Shanghai Stock Exchange CG CH

See the attached file below for the full list. You can find more information on the different exchanges by entering EPRX <GO> to view exchange profiles.

Excel API Help

In Excel, from the top menubar, go to Bloomberg > Help to see the Help documentation for more assistance in using the API.

Use BBXL <GO> in the Bloomberg terminal to find cheatsheets, pre-programmed spreadsheets, demo-spreadsheets, and explanation of error messages.