Work with Excel and Bloomberg

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