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, 2022 in Others by Kithuzzz
• 38,000 points
2,912 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, 2022 by narikkadan
• 63,600 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, 2022 in Others by narikkadan
• 63,600 points
1,154 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, 2022 in Others by narikkadan
• 63,600 points
604 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, 2022 in Others by narikkadan
• 63,600 points
786 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 Nov 25, 2022 in Others by narikkadan
• 63,600 points
1,913 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, 2022 in Others by narikkadan
• 63,600 points
4,898 views
0 votes
1 answer

My VBA Addin creates a custom ribbon tab, but should only be visible for intended workbooks

The RibRefresh sub's logic is overly convoluted ...READ MORE

answered Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
1,442 views
0 votes
1 answer

Excel Desktop - Office.context.document.settings.get() didn't working

You need to call the saveAsync method of the Office.Settings interface ...READ MORE

answered Feb 24, 2023 in Others by narikkadan
• 63,600 points
480 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,740 points
1,246 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, 2022 in Others by narikkadan
• 63,600 points
629 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, 2022 in Others by narikkadan
• 63,600 points
1,458 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