bloomberg

  1. J

    Pause Macro Until File is Downloaded and Opened

    Hello: I have the below macro which pulls in an excel file from the Bloomberg application. Microsoft excel does not stop processing the VBA. I need the macro to stop until the file named "grid*.xls" is opened, and then start again so I can copy and paste the data. Please advise - been stuck...
  2. C

    Starting a Bloomberg excelsheet via VBScript

    Hello, first of all I'm a rookie in programming with Visual Basic. My purpose is to programme the following tool: It should open a particular Excel-workbook (WB1) at 12 o'clock, copy values of a few cells and write them into a further workbook (WB2) with current time and date. Then it should...
  3. L

    Bloomberg Message / Excel

    Hi guys, I'm a bit newbie in VBA but I'm sure that this macro will be straightforward for you guys. I got a basic Excel spreadsheet named "Tester". I just want to check in my bloomberg window named "3-Bloomberg" the ISINs beginning by "XS" or "US" followed by 10 figures/letters. The macro...
  4. J

    Sending Bloomberg messages with Excel

    Hello, I imagine that this could be relatively complicated but here it goes anyway. I have a list of people on excel who are automatically emailed by a macro that I already have when their clients contract is expiring. Right now, I have the macros to automatically send these emails via...
  5. D

    Excel tab intermittently printing all blank pages (excel 2010 32-bit)

    Hello, I have a worksheet, 1 tab of which needs to be printed once a day. Once every week or 2 it will all blank pages. This happens no matter which printer I send it to, but I can't reproduce it on a different computer. If I close excel and re-open it the document prints fine. The document has...
  6. K

    Bloomberg currency/date question

    I need Bloomberg to import a historical price into excel for a specific date and currency. So far, I've got it to find the date I need using the below formula: =(BDH(A2,"PX LAST","12/17/2014","12/17/2014")) (A2 contains the ISIN code) But I need it to pick up a specific currency too. For...
  7. M

    ModelOff 2014 - starts 25th October!

    Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...
  8. J

    Excel macro to get data from Bloomberg

    Hey! I have the following macro that loops through 100 tickers in sheet 1, gets the trades for each, pushes each ticker's trades to sheet 2 to create a list of all trades. The problem is that I just get a #N/A requesting data for each ticker. This seems to be a wider problem with fetching...
  9. J

    Excel loop question - bloomberg

    I need to create a sheet will all trade executions there has ever been on a certain exchange. The exchange does not have a lot of activity. I have a bloomberg function that fetches all the trades there has ever been on the exchange for specific tickers. However, it only does so for that one...
  10. R

    VBA - Include Wait for Bloomberg's Calculations

    Hi, Using VBA, I've made an automating process where it takes values from the MasterSheet (Opened workbook) and save as pdf based on the name of Cell(row,2) value. I need to put a delay in this process as my excel is linked with Bloomberg Terminal, and excel requires 15 seconds for Bloomberg to...
  11. K

    Refresh All Bloomberg Data using Macro or VBA

    Hi guys, I attempted doing this by recording the macro but the macro doesn't read me clicking onto Bloomberg Refresh Data Button. How can I do this using VBA? Thanks a bunch.
  12. S

    VBA Bloomberg Link Batch Refresh problem

    Hi I am running some analytics on a long list of stocks. The idea is to cut out 30 tickers per iteration, run the analytics and copy/paste the results and move on to the next batch. I have about 600 individual tickers so this process will repeat 20+ times. However, I am having difficulties...
  13. 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...
  14. M

    Possible to create a macro that changes formulas?

    Good Morning, I have an excel sheet that uses the Bloomberg Ad-in. We need this sheet to be "live" (which uses one formula) and historical (a different formula) the two formulas look like this: Live: =BDP("ticker","px_last") Historical: =BDH("same ticker","px_last",date,date) *all of the...
  15. M

    Need to detect a value from within a formula in another cell

    using =BDS(..."cols=6;rows=69") as my formula, I would like to pull just the number 69 and enter it into another cell. This number, 69, is automatically populated within the formula. To clarify, the number, 69, is not the resulting output in the cell... it's part of the formula. Also, this...
  16. Jon von der Heyden

    Sleep API vs OnTime

    Hi I believe I know the answer to this but I need to be absolutely sure before testing on bloomberg terminal. Bloomberg method RefreshAllStatic data doesn't suspend execution therefore any code called directly after this method is called is likely to be executed before the refresh is complete...
  17. solitude

    Name errors with excel addin loaded through VBScript

    I'm trying to run some excel macros through VBScript. The code also uses Bloomberg addin. Now, I know that VBScript by default switches addins off so in the script I have lines that add Bloomberg addin. Problem is - while debugging, I get 'NAME' errors in cells that use Bloomberg functions...
  18. 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...
  19. Q

    Code to write formula with a cell reference

    I have a worksheet with hundreds of Bloomberg formulas in it that I need to change regularly. I only need to change the date information, everything else stays the same (see the formula below). What I'd like to do is enter a new date in a cell and run a macro to change all the previous dates to...
  20. Q

    Code to write formula with a cell reference

    I have a worksheet with hundreds of Bloomberg formulas in it that I need to change regularly. I only need to change the date information, everything else stays the same (see the formula below). What I'd like to do is enter a new date in a cell and run a macro to change all the previous dates to...

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