BLP ActiveX Beginner

jrcase45 · January 24th, 2007, 11:23 am

I'm an inexperienced programmer who is attempting to use the ActiveX controls for Bloomberg's BLP functionality in VBA for excel. After going through the examples provided by Bloombergs WAPI [Go] page, I am still unable to retrieve data. If possible, could someone post a sample code for a sub that retrieves an equity ticker's "LAST_PRICE" and assigns that value to a variable? I've already activated the correct references ( Bloomberg Data Type Library) and the rest of my code appears to work correctly.Any assistance on this would be greatly appreciated.Thanks.

jrcase45 · January 24th, 2007, 5:18 pm

below is a sample of what i'm attempting to do. prior to the code listed below i take a list of bb equity tickers and place them in an array sTicker. The array AnalystCos recorded the companies in sTicker that are covered by a particular analyst. I would like to save the returned BLP values in another array.Any help would be appreciated.

Andrew · January 24th, 2007, 7:22 pm

Here I posted VBA code that performs a similar action, and I explained the array that it will create.www.wilmott.com/messageview.cfm?catid=1 ... SGDBTABLE=

jrcase45 · January 24th, 2007, 8:44 pm

Andrew,thanks for the help.i may post an additional question or two, but i suspect that your link will be helpful.