bdh

  1. J

    =BDH() Formula shows as #N/A until after the Sub has finished running

    I'm pulling in data from Bloomberg using '=BDH()' formula, however this shows as '#N/A Requesting Data...'. This formula is in the middle of the Subroutine. At the end I am trying to find the sum of values pulled in from Bloomberg using the =BDH formula. My issue is that as the =BDH formula...
  2. N

    Generating table usin bloomberg add in

    Hi. Im quite new to bloomberg and using the excel add in. I have a question regarding WTI Crude Oil, but it can be for any given stock or security. I want to pull out historical data, preferably in a table. I want to see the price of the comdty (CL1) at a given time period, and price at a exact...
  3. E

    BDH Formula in Macro VBA

    Dear community, I would like to build a macro from directly obtaining Bloomberg Data (PX_LAST and OP_INT) for a large set of stock. Has anybody of you already tried to insert the BDH function into a Macro? How did you o it for multiple stocks? Could you create 1 table only? I am sorry fr this...
  4. E

    [Please help ASAP] Using VBA to import BDH from Bloomberg

    Hi guys, I am new to here... I heard this is an amazing forum... Please give me some ideas of how to create this VBA please... I am currently working on the assignment but I got stuck for a long time. The task is to: using VBA to import the closing price (BDH) from a list of equities in...
  5. J

    vba calculation on bloomberg data

    Hi Guys, Urgently need help. I want to know if something is possible or not and if anyone has tried it? I want to find out the high and low of two contract prices by pulling data from bloomberg. Lets say, i want to pull out 30 days of Apple and RIMM stock prices through the vba code, check...
  6. H

    Excel VBA and Bloomberg BDH formulas and dynamic cells in an Excel sheet?

    Hi, I was trying to develop the following Excel VBA code. The main aim is for the code to be able to automatically recognize the dynamic inputs tfor the variables and run the Blooomberg BDH function on the variable values. But it seemed that the "" marks seems to be prohibiting the BDH...
  7. J

    Bloomberg Addins (BDH)

    First off, does anyone know in which Bloomberg Addin is the BDH formula found? Secondly, if possible, I've had a hunt on the internet to no avail, but does anyone know the passwords to the addins? The first point is the most important, the second is just a bonus :) thanks in advance.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top