Steven Miller
2010-10-09 21:08:06 UTC
Hey,
For those of you who knows the Bloomberg API, I'm trying to replicate
the BDH functions functionality. For those of you not familiar with
this Excel Bloomberg UDF, it retreives historical data of e.g. a stock
within a specified date interval, and then puts the appropriate amount
of data in the right amount of cells under the cell in which the
formula was entered - for example, if the user were to enter
=BDH("Microsoft Equity", "PX_LAST", 01/31/2010, 02/28/2010) the
function would retrieve historical data from between dates 01/31/2010
and 02/28/2010 - it would put the first date on top and all subsequent
data points in the cells below.
So far I've found no way of returning values to other than the cell
that the formula was entered into. How can this be done? If the
Bloomberg developers can, I'm guessing it is somehow possible for all
of us :)
Thanks guys,
For those of you who knows the Bloomberg API, I'm trying to replicate
the BDH functions functionality. For those of you not familiar with
this Excel Bloomberg UDF, it retreives historical data of e.g. a stock
within a specified date interval, and then puts the appropriate amount
of data in the right amount of cells under the cell in which the
formula was entered - for example, if the user were to enter
=BDH("Microsoft Equity", "PX_LAST", 01/31/2010, 02/28/2010) the
function would retrieve historical data from between dates 01/31/2010
and 02/28/2010 - it would put the first date on top and all subsequent
data points in the cells below.
So far I've found no way of returning values to other than the cell
that the formula was entered into. How can this be done? If the
Bloomberg developers can, I'm guessing it is somehow possible for all
of us :)
Thanks guys,