Excel Help for Work With Excel And Bloomberg - Most Recent

Excel Help for Work With Excel And Bloomberg in Valuing Investments and Businesses

Work With Excel And Bloomberg

Rate this:

(3/5 from 1 vote)

	Hi, I am going to develop one investment software in which I need to download data from Bloomberg. I can download using 'Bloomberg menubar' on Bloomberg workstation, but I want to do this programmatically by using Bloomberg API and excel VBA. Can anyone help me in this issue?
	Posted by jeevi on 17 Sep 2006

Replies - Displaying 21 to 21 of 21

Order Replies By: Most recent | Chronological | Highest Rated

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

Back

Displaying page 3 of 3

Work with Excel and Bloomberg

Excel Help for Work With Excel And Bloomberg in Valuing Investments and Businesses

Work With Excel And Bloomberg

Excel templates and solutions matched for Work with Excel and Bloomberg: