-
Excel and Bloomberg
Hello,
Im hoping someone out there works in the Banking/Financial Services industry.
I have an excel spreadsheet with a list of ISIN's (indicators for bonds) and I want to use VBA to connect to Bloomberg and populate various fields relating to each ISIN i.e. next accrual date, coupon etc
Does anyone know how to do this? Perhaps its a long shot but you never know!
Thanks
Phil
-
I'm not sure if VBA can do that, but I know of this program called iMacros (from iOpus website) which should do the trick.
However I'm no vba expert, so it is possible someone here may be able to come up with a code for that.
-
What is the address of the page with the data?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
The Bloomberg function is "DES" which is what I type in on the terminal after I type in the ISIN. However I want to dot his programmatically, avoiding sendkeys if poss, for many bonds at a time
Thanks
Phil
-
Bloomberg provides an add-in for excel that among other things does what you are asking about. With the add-in, you can create formulas that directly pull in the information from the terminal.
-
Hi Phil,
I have access to Bloomberg at work. In the past I have made similar queries in Excel to retrieve data from the terminal. Even though you can retrieve anything you want from a company ticker, I don't think it works both ways... I mean getting something out of ISIN codes.
I'll need to check that tomorrow to be sure. I'll get back to you.
Julien
-
It is possible actually, my bad. Let's take the case of Citigroup:
In Cell A1 you need to have the ISIN in that form : US1729671016 Equity
In Cell A2 type the formula : =BDP($A2;"NAME")
Now all you have to do is change "NAME" by the field you want.
Cheers.
Julien
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules