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

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