Home > Forum Home > Valuing Investments and Businesses > Work with Excel and Bloomberg Share

Work with Excel and Bloomberg

Excel Help for Work With Excel And Bloomberg in Valuing Investments and Businesses


Forum TopicPost Reply Login

Work With Excel And Bloomberg

Rate this:
(3/5 from 1 vote)
ConfusedHi,

I am going to develop one investment software in which I need to download data from Bloomberg. I can download using 'Bloomberg menubar' on Bloomberg workstation, but I want to do this programmatically by using Bloomberg API and excel VBA. Can anyone help me in this issue?
 Posted by on
 
Replies - Displaying 1 to 10 of 21Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
Hello,

I am working with Historical Example for  v3Com API Data Control of Bloomberg.

I encounter two problems:
First, when I pass a list of securities the output I get is limited to 10 and second I have difficulty to modify start and end data to be equal to Now or to Now -7 (for a week ago).

Can someone share experience?

Thanks in advance

 Posted by on
Fedup
Rate this:
(3/5 from 1 vote)
Hi,
I want to create an excel sheet which automatically downloads Merrill Lynch FI Indizes to Excel (the fields are named MLI fields f.eg.: "MLI_DATE"... I actually did this before but do not recognize ist anymore ; ) Maybe someone knows how to do this and can help me...

(I remember that it starts with transforming the date and then needs to excel cells to download the actual data...)

thanx ; )!
 Posted by on
Happy
Rate this:
(3/5 from 1 vote)
You can use web queries in Excel to download market data from the Bloomberg web site, Yahoo Finance, and Google Finance.

Refer the post here for how to do this.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Hi Jeevy and everybody..


Does anybody know how to extract data from the bloomberg website into ms. excel without being a member (paying $1800 per month)?


Well, I am a final year Business Administration student and am currently working on my bachelor degree thesis. I desperately need to extract historical data of some countries' market indices (year 2007) to complete the thesis.. And for sure, I do not have $1800 to have access to the data..


Could anybody help me, please? please.. Any comment or recommendation for the solution is deeply appreciated.

My email address is [email protected], just in case anybody would like to give any recommendation or solution.

Many thanks in advance.


Regards,
Agnes Valentine 
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Hi, I am using a simple IF formula in excel with dates that are bloomberg links, the IF formula will nor work correctly when using the bloomberg linked dates and will not work correctly if i copy and paste values and trim the cells...can anyone help on this what seems to be a formatting issue....thanks
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Hi is there a place i can download developer documentation for the bloomber ActiveX control?

Basically i am trying to use it to retrieve data for a 150 or so instruments using the .Subscribe method but i am not sure on the syntax for handling over ide and override values??

does anyone have an examle of this?
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Good morning

I have just a simple question. I'm wrtiting a VBA code with the BLPH function and I do not know to which variable type should I link =bLPH()

I try to assign to a cell in excell but there is an error message"Object Required".

If someone can give me a hint
Thanks

 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
does any one can tell me how to get a bloomberg activeX document? I really want to use bloomberg activeX in javascript, but I only have a C API document. please tell me how to download this document, or paste your sample code to me. thanks.
 Posted by on
Gratefulhi

I want to retrieve historical data on index members and related weights from bloomberg in excel. however, the function objBloomberg.BLPGetHistoricalData does not accept the field reference "INDX_MEMBERS" or s.th. similar.

does anyone know how to circumvent this problem and how to download such data using excel / vba ?

thank you

friedrich
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Hi,

I think my problem is similar to the above listed one, but I'm pretty new to VB and so didn't make too much sense of the replies - apologies if this is going back over old ground.

I have a spreadsheet that contains a macro that is intended to open up another sheet that contains a bunch of =blp Bloomberg formulas and then use that data in the first sheet.  My problem is caused by the time lag on opening the 2nd sheet before the cells populate with data (they go to N/A and populate after something like 15-20 seconds).  I can't figure out how to make the cells populate faster or the macro to wait for the data to come through.

First off I tried the VB Wait command, but that seems to pause everything, including the =blp formulas.  I figure I need to use the DDEInitiate etc functions, but really aren't too sure how they work...

Any help would be appreciated.
 Posted by on
 Displaying page 1 of 3 

Excel templates and solutions matched for Work with Excel and Bloomberg:

Solutions: OLAP Reporting Resource Management Construction Cost Estimation Employee Shift Scheduling Complete Trading System Financial VBA Code Password Recovery Business Planning Templates Index Numbering and Logging Real Time Stock Quotes Charting Tools Compare Files Worksheet Analysis Separate Data Video Tutorials Dimensional Analysis and Measurement Construction Schedule Templates Workbook Search File Navigator Merge Data Ranges Batch Printing Training Templates Six Sigma Templates Random Sampling Dashboard Training with Examples Work Efficiency Add-ins
Categories: Excel Productivity Time Saving