Introduction to Bloomberg  Tags: bloomberg business  

Go to Bloomberg>Scenario Builder

Drill down Fixed Income>Yield Analysis - General [YA]>Bid

Notice that when you highlight some of the fields in the right hand box its definition appears in the box below.

Deselect the checkbox next to Bid Yield to Next Call

Click Next

In the Field Calculation Customization screen click on the empty box in the right hand Value column next to Next Settlement Date and enter 2/29/2008

Do the same for Bid Price and enter 100

Click Next

For Security identifyer enter CT10 in the Govt Market sector and try CL5.18 in the Corp Market sector

Click Next

Under Input cells to provide overrides select SAme for all securities

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.