Exporting to Excel
The Bloomberg Data API, or DAPI, allows you to export market data into an Excel spreadsheet. Open Microsoft Excel on the Bloomberg terminal. Click the "Bloomberg" tab on the toolbar at the top of the page.
Click the "Data Navigation" button to bring up the data wizard. The data wizard allows you to search for and download securities data within Excel. Simply type in the ticker for the security you are interested in.
On the toolbar,
- Use the "settings" button to adjust your data parameters.
- Use the "Drag into Excel" button to export your data into Excel.
- Use the 'View All" button to view the data in a larger screen.
There are many more ways to import and analyze Bloomberg data in Excel. For more information, watch the Bloomberg API training video or check out the help guide on this page.