Introduction to Bloomberg  Tags: bloomberg business  

Go to Bloomberg>Import Data

Select Historical Intraday 

enter tickers cat, dell, ge

Click Next

Select your parameters

Under Market events Select Trade, Bid, and Ask

Under INterval fields select Close NOTE that you must select at least one item from both the Market events and Interval fields to continue

Under Time frame set the dates and times to 2/4/2008 9:00:00 AM to 2/4/2008 12:00:00 PM NOTE you need to unselect the current box to set the end time.

Set your interval size to 10 minutes

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.