The Bloomberg Excel Add-In is a powerful tool that delivers Bloomberg data and analytics into an Excel spreadsheet on the user’s desktop. To use the Excel Add-In, you must be logged into Bloomberg. Working with the Excel Add-In. Aug 06, 2020 While Microsoft Excel is running: 1. Go to Windows Start button on the taskbar at the bottom of the screen. Expand All Programs. Expand the Bloomberg folder - do not click on Bloomberg app icon (it will simply go to the Bloomberg program) 4. Select 'Install Office Add-In' icon to install the Excel Add-in. Restart Microsoft Excel.
Data extracted through the Excel API is subject to monthly download limits. Please be judicious in downloading data to avoid hitting the limits for yourself and all other users. Once the monthly limit is reached at a terminal, data cannot be downloaded until the start of the next month.
If the monthly limit has been reached on a terminal:
- Report it to Bloomberg: Hit the Bloomberg Help key (F1) twice. Via a chat with the Helpdesk ask them to boost the limit. Bloomberg will ask for the details of the research that caused the overage.
- If you are not sure or do not know what caused the limit issue - please report to it to the Content Development Team, jlcd@librarynetwork.org.
If you need to download large amounts of data:
Download Bloomberg Excel Add-in
- Use the Bloomberg datafeed in EDI instead: https://edi.imf.org/#/.
- Contact Bloomberg to confirm your data retrieval strategy (
<HELP> <Help> to start instant messaging). The Bloomberg terminal already includes many helpful aggregates and analyses; raw data might not need to be downloaded. - Check with the Library (jlcd@librarynetwork.org); they can offer alternatives and/or discuss with Bloomberg on your behalf.