| 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 Topic | Post Reply Login |
Work With Excel And Bloomberg | Rate this: (3/5 from 1 vote) |
 | Hi, 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 jeevi on | ||
| Replies - Displaying 1 to 10 of 21 | Order Replies By: Most recent | Chronological | Highest Rated |
| Rate this: (3/5 from 1 vote) 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 sandra on |
 | Rate this: (3/5 from 1 vote) 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 nocturn on |
 | Rate this: (3/5 from 1 vote) Refer the post here for how to do this. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Rate this: (3/5 from 1 vote) 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 agnes.valentine on |
| Rate this: (3/5 from 1 vote) |
| Posted by colinreds on |
| Rate this: (3/5 from 1 vote) 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 jjme88 on |
| Rate this: (3/5 from 1 vote) 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 edgar_fun on |
| Rate this: (3/5 from 1 vote) |
| Posted by coppershen on |
 | Rate this: (3/5 from 1 vote) 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 friedrich on |
| Rate this: (3/5 from 1 vote) 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 TonyP on |
| Displaying page 1 of 3 | Next |