bloomberg excel addin

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...

I am having an issue when I am running a macro in a Bloomberg linked excel sheet to capture specific security information and import it into a 3rd party application. 10/26 was the last time I was able to successfully use the sheet. I believe at some point around the 26th excel was updated and...

Every time I try to run the Macro that i have inherited from previous employees here, i get this new run time error. run-time error '-2147221231 (80040111)': automation error ClassFactory Cannot supply requested class when i hit debug it takes me to the following line Dim objDataControl As...

Hi Fellow Excel Mates, Hope you are doing good. I am trying to automate a Bloomberg refresh process but seem to get stuck with a event i.e Bloomberg data refresh. the whole process is broken into 3 parts which runs in loop. a. copies ticker from database b. refresh Bloomberg c. run a analysis...

I am trying to fetch PX_MID from Bloomberg with date filter. But I am getting the same data for every date format I am Using is <tbody> XXXXXXXXXX|ISIN|1|SETTLE_DT|20161027| </tbody> AM I using the correct formula/syntax or does PX_MID supports date filter. Please help.

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...

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...

Hello, I am working with a large amount of data so I created a small example of what I hope to do attached below. My problem is with formatting in Excel and I have been unable to find the right combination of formulas to complete what I am trying to do, hopefully you all can help...

Hi All, I'm pretty new to vba, but I was wondering whether there is a way to use the Bloomberg BDP function twice in one cell. So, =INDEX($AC$4:$KL$4,MATCH(C$288&$B289,$AC$3:$KL$3,0)) outputs this "BPSW010A Curncy" and, =INDEX($D$4:$AB$4,MATCH(B$289,$D$3:$AB$3,0)) outputs this "BPSWA...

I have an Access 2007 database with separate tables each a separate stock with an array of prices by date such as: Table: AAPL Date Price 12/9/2013 $453 12/9/2013 $451 12/9/2013 $464 12/9/2013 $467 etc. I have an Excel 2007 spreadsheet which I would like to...

It seems like it's impossible, but I could just be missing a nested function somewhere...really I have no clue how to get to what I'm looking for. I'm trying to use a formula that if the row matches a series of criteria, will take the sum of a formula applied to the matching row (the formula...

I am trying to create a 'comment' in excel that will show Bloomberg BDP info of whatever cell is highlighted. For example, let's say active.cell = IBM and I 'hover' over IBM. I would want a comment box to pop up showing relevant market data. <code style="margin: 0px; padding: 0px; border: 0px...

Hi All, I am trying to pull data for some structured swaps modeled on bloomberg under the swpm function in my login. I am using the following function =BDP("SL4213RA CORP","SW_OPTION_VEGA","SETTLE_DT=20120531","SW_CURVE_DT=20120531") Now i have two question here 1) I am getting the option vega...