- Bloomberg Excel Add-in Help and Training The Bloomberg Excel Add-in, formally known as Bloomberg API (Application Program Interface), is a tool that delivers Bloomberg data directly into an Excel spreadsheet for custom analysis and calculations.
- Bloomberg Excel Add-In with BLOOMBERG ANYWHERE allows you to use a remote version of Microsoft Excel running on Bloomberg servers. This is a fully functional copy of Microsoft Excel that you can use to interact with Bloomberg API data.
- I have downloaded data to excel using the Bloomberg add-in. I have this data in one sheet in the spreadsheet and I then used paste special to transfer the values only to another sheet in the same workbook.
- THE BLOOMBERG EXCEL ADD-IN Date printed: WHAT IS THE BLOOMBERG EXCEL ADD-IN? //07. Date Calendar: Download data based on a specific date range. For example, you can download daily data between 2/15/16.
Click on the Bloomberg tab along the top of the workbook. Use the Spreadsheet Builder to easily pull data into Excel. The most commonly used template is the Historical Data Table where you will add your securities, whatever data fields you wish to import, and a date range.
The Bloomberg Excel Add-In allows you to download Bloomberg data straight into your Excel spreadsheets so that you can customise them to your liking.
Before you install the Add-In, make sure you have shut down any open Excel spreadsheets.
Click on Start > All Programs.
Select the Bloomberg folder and click on the option ‘Install Office Add-ins’.
An ‘Installing Bloomberg Office Add-Ins’ dialog box will appear. Click on the ‘Install’ option to add the Add-In to your user profile.
Download Excel Add In Bloomberg
To check that it has been installed, open up Excel. You should see Bloomberg appearing as an Excel ribbon heading.
The Bloomberg Add-In is PC-specific, so each time you use a different PC, you need to install it to your profile. Once this is done, Excel transfers should be seamless.
How Do You Download Bloomberg Excel Add In
Please bear in mind however that should you have any problems downloading data into Excel, it may be worth running through the installation process again.
How To Download Bloomberg Excel Add In
As always if you encounter any problems or have any questions, please contact us.