Introduction to Bloomberg  Tags: bloomberg business  

Go to Bloomberg>Import Data

Select Market, ...

Enter the ticker 7267 JP in the  Security identifier box and add it to the Selected securities box

Do the same for cat and for mks LN

Click Next

Type "price" into the Search text box

Add Last Price LAST PRICE to the selected fields box NOTE the green and red arrows indicate that this is a real-time field

Do the same for name, and primary exchange

click next

leave the layout conditions to the default and click finish

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

BU < GO > will take you to Bloomberg University where you can watch online tutorials of how to use the Excel API. NOTE: as of 14 August 2008 the videos show the old interface for the Excel API and may not cover all functionality of the new version.

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