Download with Active X

[Arne Hegefors]

Hello! I download data from the Bloomberg professional (the program not the
website) using DDE. I am told that DDE is not very good and that Active X is
preffered. However I do not know anything about Active X (like where and how
to write the code). Can someone give me a tip about links etc. Preferably if
there is any code examples of how to use Active X for downloading from the
Bloomberg. Any help appreciated! Thanks alot in advance!

 

[Tom Ogilvy]

If an interface for activeX is supported, it should be documented in the
documentation for the bloomberg professional application with sample code on
how to use it.

 

[NickHK]

Arne,
If this app really is ActiveX, then you need to make reference to it in
Tools>References.
You are looking for something like "Bloomberg.tbl/dll" or that 'PhatPipe"
that was mentioned previously. Note the name.
If you find something likely, check the box the box and OK

Then in a code module try
Dim MyBloom As <Space>. When you type the space, you should get a list of
possible options. Find something that matches the file you checked in the
stage above.
Then
Set myBloom=New <same object as you selected above>

Run it and see what happen.

Having said that, I *think* Bloomberg is more geared to DDE than ActiveX
Here's one:
http://www.library.georgetown.edu/bic/help/bloom.htm

But a Google for "Bloomberg DDE Excel" give a few hundred hits.

NickHK

 

[Post Tenebras Lux]

In Bloomberg, type BBXL <GO>. You will see some menu options that refer to
WAPI. You can also type IDOC API <Go> or IDOC ACTIVEX <GO>. You can also
type BU <GO>, find the city you are in, and then look for the relevant
seminars - basic and advanced - on the subject. You can hit the F1 key
twice, and ask their help desk. You can contact the Desktop Build Group
(DBG) who build the model templates and run the seminars. Very useful. Also,
the DDE links are pretty limiting. If you are going to use cell formula, the
RTD format (documented on the BBXL page in Bloomberg), is much more flexible,
if you're not trying to get historical info (i.e. serial dated data).

Documentation has improved, but is still pretty funky. The DBG team are
very helpful. Ask your Rep to help you get in contact with them if you have
any troubles. And NO, I don't work for BBG, I just had to learn the hard way.