Initiate Bloomberg Api From Excel Vba Code: Work with Excel and Bloomberg Excel help response (18 Sep 2006)

Excel Help for Initiate Bloomberg Api From Excel Vba Code in Valuing Investments and Businesses

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 Full Post

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

Initiate Bloomberg API from Excel VBA code

Excel Help for Initiate Bloomberg Api From Excel Vba Code in Valuing Investments and Businesses

Initiate Bloomberg Api From Excel Vba Code