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...
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...
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...
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...
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...
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...
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...
actuary
amt training
analyst
banking
bloomberg
cfa
competition
corality
excel
finance
financial modeling
intralinks
investments
kaplan
microsoft
microsoft excel
modelling
online
prizes
s&p capital iq
spreadsheets
world
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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 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.