Bloomberg to Excel

1

1morelevel

New member
Joined
Jun 18, 2026
Messages
0
Reaction score
0
Anyone know how to code or otherwise get a certain page from Bloomberg to Excel? For instance, NIM, new issue monitor, if I want a spreadsheet to automatically pull in the security identiers of all issues displayed on this page, how can I do it?
 
higgmond Wrote:
——————————————————-
> Drag the thumb pin in the upper right corner over
> to Excel.
Yeah…automate that process. Any ideas?
 
NYCGorilla Wrote:
——————————————————-
> this is something very basic man, take the primer
> course
HELP HELP is no help.
 
I need a dynamic list not a static list. Importing data on a static list of securities, such as the S&P 500 is easy. I need a list that changes constantly.
HELP HELP tells me its impossible
 
NYCGorilla Wrote:
——————————————————-
> this is something very basic man, take the primer
> course
Care to enlighten?
 
Not sure specifically what you’re going for, but I get dynamic spreadsheets in excel via the excel add-in for Bloomberg. Can be downloaded from the Bloomberg software support site.
 
You can write code in Excel to pull from bloomberg (have to be at a terminal), and then use a macro to hardpaste the values.
Here’s a cell that pulls swap data:
=’C:\blp\API\dde\blph.xla’!blpsh2($A15,$B$14,$B$13,”c”)/100
There’s courses available, as my roll dog G-Rilla said.
 
You can link Excel to bloomberg to have the data be pulled in dynamically.
Obviously you didn’t try “Help Help” since that brings up a chat window and they would’ve told you the same thing. Only they would’ve told you much nicer than I did.
 
You must log in or register to reply here.
Back
Top