Bloomberg excel add-in BDH

Question

Using the BDH function of Bloomberg's excel add-in, I was given a historical database of fund prices covering the years 2000 through November 2020. The issue is that a fund frequently replicates its final price from the time of extintion until November 2020.

For illustration, suppose a fund was terminated in 2015 at a price of 5.25; in this case, the price of 5.25 is displayed from 2015 until nov/2020, which is obviously worthless. I want to know if the parameterization of the BDH function is the issue or if this function always returns data in this manner.

Below is an image of a section of the database

Answer 1

Change an override Fill=P to, for instance, Fill=N/A if you are using one. That will substitute N/A for days without a price rather than utilizing the most recent price.

Additionally, to just include trade days, delete Days with N, W, C, or A from your code or replace it with Days=T.

If you type =BDH() in a cell, select the cell and choose More Functions... in Excel, a popup window including a link labelled "Help on this function" with all the parameters will appear. This will provide you with more information about the overrides.