Bloomberg excel add-in BDH

0 votes

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

1

Oct 10 in Others by Kithuzzz
• 20,660 points
44 views

1 answer to this question.

0 votes
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.
answered Oct 11 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
37 views
0 votes
1 answer

Add some word to all or some rows in Excel?

Solution: Select All cells that want to change. Right ...READ MORE

answered Nov 11 in Others by narikkadan
• 37,660 points
20 views
0 votes
1 answer

How to add check symbol in excel cell SXSSFSheet java

Try this: import java.io.FileOutputStream; import org.apache.poi.xssf.streaming.*; class CreateSXSSFUnicode { public ...READ MORE

answered Nov 13 in Others by narikkadan
• 37,660 points
20 views
0 votes
1 answer

How to add text on new page in word doc via excel vba

First start with: objDoc.Range.Insertafter vbCr & Chr(12) & ...READ MORE

answered 6 days ago in Others by narikkadan
• 37,660 points
16 views
0 votes
1 answer

Get Code Isin from Bloomberg with Excel formula

In answer to the follow-up, BQL is ...READ MORE

answered Oct 29 in Others by narikkadan
• 37,660 points
139 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
450 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
395 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,367 views
0 votes
1 answer

Excel - add all X in column and then multiply

Use countif for the count then multiply ...READ MORE

answered Oct 1 in Others by narikkadan
• 37,660 points
45 views
0 votes
1 answer

Add a shape to a specific cell in Excel

When you use SORT() or data->sort on ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
47 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP