The Bloomberg terminal has a strict monthly data downloading limit (exporting data to Excel). Patrons should NOT download data without first speaking to a Pardee reference librarian. Questrom students can download data using the nine other terminals in the Hariri Building (Questrom School of Business): two in the Open Access Lab (Room 328) and seven in Room 402A (the Bloomberg lab). Additionally, students can use the Screenshot function to capture data without affecting the data downloading limit. This function enables students to email screenshots to themselves. Students can take multiple screenshots in order to capture the data that they need.
DAPI <GO> Bloomberg Excel Add-In Menu - Provides information on Bloomberg formulas and functions.
Bloomberg Formula Syntax:
BDH (Bloomberg Data History) downloads the historical data for a selected security and time frame.
BDP (Bloomberg Data Point) downloads data to a single cell in the Excel spreadsheet. This formula is used for only one security and one field.
BDS (Bloomberg Data Set) downloads descriptive data to the Excel spreadsheet and uses multiple cells.
Step 1: Click on Spreadsheet Builder.
Step 2: Click on Historical Data Table then click on the Next button.
Step 3: For Example - SPX 500 Index
Type the ticker symbol (SPX) in the All Securities box. Click on SPX Index to select the index. Click on the Next button.
Step 4: Type Last Price in the All Fields box. Click on Last Price PX_Last. Click on the Next button.
Step 5: Select the date range. Click on the Next button.
Step 6: Click on the Finish button.
Step 7: Historical prices for the S&P 500 Index will be downloaded into Excel.