Initiate Bloomberg API from Excel VBA code

Excel Help for Initiate Bloomberg API from Excel VBA code in Valuing Investments and Businesses

Find Excel Solutions

Search the Forums:
	Search
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel

Follow Business Spreadsheets On:

Home > Forum Home > Valuing Investments and Businesses > Work with Excel and Bloomberg > Initiate Bloomberg API from Excel VBA code

Forum Topic

Initiate Bloomberg API from Excel VBA code

Rate this:

(4/5 from 2 votes)

You can probably initiate the Bloomberg API within the VBA code and then make calls based on available functions with the API. A full list of fields available for the Bloomberg API can be found at [http://about.bloomberg.com/software/info_api.html].

An example of initiating and using this once logged in to Bloomberg could be:

VBA Code:

ChNo = Application.DDEInitiate(app:="BLP", topic:="S")

BBQuery = " ' " & ISIN & Corp & ", [RTG_SP] ' "

BBList = Application.DDERequest(ChNo, BBQuery)

Alternatively, you could download the Bloomberg ActiveX control (available from [http://about.bloomberg.com/software/api_tools.html]) and interact with that from within your Excel VBA Code.

Excel Business Forums Administrator

Posted by Excel Helper on 18-Sep-2006

[View the Full Thread for the "Work with Excel and Bloomberg" Topic]

Find relevant Excel templates and add-ins for Initiate Bloomberg API from Excel VBA code in the Excel Business Solutions Directory

Find Excel templates
and add-ins in the
Excel Business Solutions Directory