PDA

View Full Version : Bloomberg BDH Formula and VBA



boyvn91
03-09-2012, 06:38 PM
Hi guys,

First of all, I have to say this is amazing forum. After hours of searching, I have found many useful information here.

Currently, I am doing my dissertation, which involves the uses of Bloomberg function BDH to recall the historical prices of equities (=BDH(BDP(Security,Field,Start Date,End Date))

But I am experiencing a problem, I have a list of a thousand announcements (day 0) and I need to collect the data around that date (-170 to +40).

The problem with the BDH function is that the result consists of two columns so I could not do in the usual convention (drag the formula).

I need a VBA code that can put the first BDH formula in a cell (e.g. A1), and the next formula in the cell C2 for example so that it can leave a space for the result.

Can anyone help me?

Kenneth Hobs
03-09-2012, 09:29 PM
Show the formulas for a few cells so that we can see the pattern.