Loading Data From Bloomberg

Dec 3, 2008

I hope there's someone who's familiar with Bloomberg in this forum.

My problem is, I have a template which conducts checks with data extracted a Bloomberg Terminal. I want to ensure that all data has FULLY loaded before I execute the checks.

So is there a way to detect if data is still loading?

Like for example, I need data to load from A1:A100, but data has only populated until A50. In this case I need to know that the other 50 cells are still populating.

View 9 Replies


ADVERTISEMENT

Data Retrieved From Bloomberg

Jan 5, 2009

refer to the picture:

Column H and column X contain dates. If column H = column X, "OK" will be shown. Otherwise "CHECK" would be shown.

The dates are the same, but the problem is, Excel reads column X differently from column H.

I've tried converting both columns to ddmmyyyy and then comparing them, but it doesn't work.

For i = 2 To range("A" & rows.count).end(xlup).row

If Format(Cells(i, 24), "ddmmyyyy") = Format(Cells(i, 8), "ddmmyyyy") Then
Cells(i, 36) = "OK"
Else
Cells(i, 36) = "CHECK"
End If

Next

Is there a foolproof way of doing it?

Column X is data retrieved from Bloomberg, so the format cannot be changed directly.

View 9 Replies View Related

Import Bloomberg Data

Aug 5, 2007

If it is actually not possible to change the way that bloomberg exports the information to excel then i think there might be two potential ways around it...neither of which i am sure how to do...

1) write some sort of macro which takes data from the new workbook, pastes it into the active workbook then closes the newly created workbook. Potential problem here is that whenever it creates a new workbook it has a slightly different name. eg. "abc1" then "abc2" etc.

2) Write some sort of macro which gets a list of companies from bloomberg with upcoming events over the next week, put this into the active workbook and then simply use the bloomberg get functions to fill out the info.

View 2 Replies View Related

Refresh All Bloomberg Data Using Macro Or VBA

Jun 24, 2014

I attempted doing this by recording the macro but the macro doesn't read me clicking onto Bloomberg Refresh Data Button. How can I do this using VBA?

View 1 Replies View Related

Macro To Force Refresh Bloomberg Data

Feb 8, 2007

I have a workbook that pulls in index data from Bloomberg, most data is updated realtime, but one index we track is only updated late at night. I want to write a macro that will refresh all of the data in the worksheet and then save a snapshot of the workbook. I have all the code for saving the snapshot, but getting the data for the one index to refresh is proving difficult. None of the standard ways I know to refresh external data (both Excel commands via tools menu, and Bloomberg specific refresh commands) seem to work on these cells. The only way so far I've found to get these cells to pull in current data is to delete them and rewrite the formulas.

suggestion for a Macro that would force a refresh of this data?

View 7 Replies View Related

Loading Data Into A Text Box

Oct 7, 2009

I have a list of accounts that is constantly changing(could be anywhere from 50-7500) and on that same sheet I have a count formula that will count all the accounts. This sheet is not going to be visible to the user.

On another sheet, I have a form that pops up with some data entery. What I am trying to do is when the form pops up, for the number of accounts to show up in a text box. If anyone could help me with the VBA code id appreciate it. The worksheet name is "Accounts", the cell is T17, and the textbox name is just TextBox1.

View 2 Replies View Related

Loading One Array With Data From Another?

Aug 31, 2013

I have ten customers who have multiple locations where we do work. On ourinvoice I want to use Data Validation (list option) to read the input "CustomerName", and then change the validation list in the "Job Reference" cell accordingly. For example if A1 is the customer name and A2is the "Reference" where the data validation list will be. Customer ABC has 3 locations, XYZ has 5, CompanyD has 4, and so on. The range for thevalidation array is C1:C5. ABC's list oflocations is located at A10:A15, that of XYZ at A16:A20, and Company D atA21:A25 (and so on, for the others). Howcan I load the data validation range (C1:C5) with the correct list from, forexample A16:20 based on A1 being customer XYZ?

View 1 Replies View Related

Loading Data Into Master Sheet Using Daily Reports

Sep 30, 2013

So, I'm trying to create a database, of sorts. I run several reports every morning that leave me with the information I need, but I would like to be able to store them in a master sheet, thus creating a database. That master sheet will be used by my co-workers and, at times, my customers or boss. Add in a few hundred new lines every day and it becomes a task in itself just to keep the spreadsheet up to date, manually. I'm only needing to do this now because the system I use now will be shut down starting next Monday. I (someone who has never had any formal excel training) have been tasked with creating a new way to track orders.

I can create a unique identifier tag for each line, but I don't know how to program or create a macro/equation to be able to filter and replace values in the tag's row, based solely on the tag. The combination of columns A&B in my test report will give me the unique tags. From there, I need columns E-L to be able to be updated from the new reports each morning.

If Sheet 2 contains a list of items that I have updated during the day and wish to place into the master sheet (Sheet1). I don't know the language needed to write the macro and any necessary equations.

My goal is to have my reports dump information into a master sheet, but only replacing/adding onto existing rows and columns that correspond with each other and creating new lines when no pair is found.

I've attached what my report should look like after I've filtered out the unneeded information. It will be this, every day, except with a few hundred more lines.

Imagine Sheet 1 is the master sheet and sheet 2 is the newly uploaded information.

TEST1.xlsx‎

View 5 Replies View Related

Loading Data From Other Spreadsheets - Open 20th Spreadsheet (by Date)

Sep 26, 2013

I have a sheet from which I load data. A normal cell looks like this:

Code:
='...dataOutput[1.csv]1'!E2

I wrote a script however that writes new data into a new sheet every day, and saves it with the name of the date. The obstacle is, that I won't have a sheet for each day (ex: weekends, holidays). For that reason, is it possible for excel to scan a certain folder, and open the 20th file when sorted by date to read from?

View 1 Replies View Related

Excel VBA Pausing For Bloomberg?

Apr 30, 2014

Trying to create a macro where it will begin by inserting today's date into a cell, then pause for roughly 35 seconds while the massive correlation matrix pulls all the correlations of the portfolio in, then takes an output value that is generated in the workbook from the filled correlation matrix (correlation coefficient) and copy's and pastes it in a different cell. Then it repeats this process again using "Today's date - 1" (yesterday's date), waiting 35 seconds again and taking the new output value and copy and pasting it below the previous one.

I know I am not close but here is what I have for code thus far (which does not work properly).

[Code].....

View 4 Replies View Related

API Bloomberg (trying To Use BLP_DATA_CTRLLib.BlpData)

Jul 9, 2009

I have a problem with this this code trying to use BLP_DATA_CTRLLib.BlpData.

Sub MultidayHistory()

Dim objDataControl As BLP_DATA_CTRLLib.BlpData
Set objDataControl = New BlpData
Debug.Print "Formulaire Ouvert"

Dim vtResult() As Variant
Dim arrayFields As Variant
Dim vtSecurities() As Variant
Dim CalculDate As Date ' rien à voir avec cdate
Startd = Range("C10").Value
Endd = Range("C11").Value

arrayFields = Array("PX_LAST", "PX_VOLUME", "SPOT_PRICE", "CHG_NET_1D", "CHG_PCT_1D")
arraySecurities = Array("GLE FP Equity", "SX5P Index")......................

View 2 Replies View Related

How To Add A Bloomberg BDP Function To Lookup Statement

Oct 16, 2012

I need to add a Bloomberg BDP function to my lookup statement. The formula that i'm trying to replicate in VBA is =IF(ISBLANK(h23,"",BDP(H23&" cusip","long_comp_name")). update my macro.

View 9 Replies View Related

Excel Looping With Bloomberg And Pause

Apr 30, 2014

I have an excel workbook right now with a 75x75 correlation matrix. It has 75 stock prices and uses bloomberg to pull in the correlation between each of the holdings. There is a lot of data so it takes roughly 35 seconds for it all to get pulled in from bloomberg. The input value that I can change is the date. The output value is a specific correlation coefficient. Thus, if I input today's date into a cell in the file, it will run the correlation matrix and tell me the correlation between all the holdings using the past year's data. Then it will produce a single output value.

I am now looking to use VBA to make this more robust. What I have been trying to do is have a macro which will -

(1) input the current date into the input cell
(2) have the code wait 35 seconds (and since it is using bloomberg pull in the traditional wait methods do not work because they actually stop the data pull in also)
(3) copy the output value
(4) paste special that value in a different cell
(5) repeat the process but this time use the date from a day before and have the output value copied and pasted to a cell below the previous one.

This loop would continue over 20 times.

Below I have some code that allows me to do this process once but is not looped and I have been stuck trying to make this work with a loop given the bloomberg delay. When I add a loop, it does not wait the 35 seconds I need before doing the whole process again.

[Code] .....

View 2 Replies View Related

Macro To Loop Bloomberg Formula

Aug 21, 2014

i have the following macro that loops through 100 tickers in sheet 1, gets the trades for each, pushes each ticker's trades to sheet 2 to create a list of all trades. The problem is that I just get a #N/A requesting data for each ticker. This seems to be a wider problem with fetching external data from Bloomberg. However, I cannot seem to get a fix for it.

Sub Macro()
On Error Resume Next
Sheet2.Range("B3:E65536").ClearContents

[code]....

View 1 Replies View Related

Bloomberg - Excel Function To Get Information Through ISIN Code?

Apr 15, 2014

, just by using the ISIN code of a Bond in bloomberg, to get in excel:

- Coupon
- Cpn Freq
- Day Cnt
- Maturity

View 1 Replies View Related

Bloomberg BDH Refresh Via Macro Loop Application.Ontime

Dec 10, 2009

Firstly you don't need to know anything about Bloomberg to answer this query, only that Bloomberg has various functions that take time to update.

The code Application.Run "RefreshEntireWorkbook" will update these functions but Application.OnTime (Now + TimeValue("00:00:25")), "RunList" is required to allow them time to get the data from the feed. However this only works if the refresh and wait commands are in a seperate function. So in simplified terms it must go like this in vba:

View 2 Replies View Related

Set The Progress Bar Which Should Indicate The Progress Of The Data Loading?

Mar 28, 2014

Im consolidating datas from muliple excel files to single data base excel file.Am having macro and it is working fine for me.But when am loading data to data base file the excel files are vibrating.To avoid this issue i want to Set the progress bar which should indicate the progress of the data loading.

View 12 Replies View Related

Loading Gif

Nov 28, 2009

I am not sure whether it can show a loading gif in the front when it executes the vba, after the executions , the loading gif will desappear.

for example here is a loading gif :

[url]

View 9 Replies View Related

Error In Loading DLL?

Apr 27, 2009

Over the weekend I did some edits to an Excel file on my home computer. This morning I did some edits to the file on my work computer. When I try to access the VBA code, I get the message "Error in loading DLL", which is error 48.

View 12 Replies View Related

Loading Combo Box

Jun 4, 2009

I am loading my UF combo box based on data in one of my sheets. I want in a way that if I keep adding to my data sheet, it would add with it.

For some reason it is not loading as I wanted to. I have tried as module and as UF code. Again, for some reason it is not loading.

Here is my code

View 7 Replies View Related

Loading An Array

May 15, 2007

I'm trying to load an array with numbers from 3 to SheetCount. If someone wouldn't mind giving me a nudge in the right dirrection, it'd be appreciated.

View 9 Replies View Related

Progress Bar For Loading Userform?

Jun 21, 2014

I have created a Excel userform. Since it has lot of controls, it takes good amount of time to load.

Is there a possibility of displaying a progress bar till the userform is loaded.

Google search has shown me ways to create a progress bar using Excel Forms. However, I am looking for a way to show the progress bar till the main userform is loaded.

View 9 Replies View Related

Loading Email Templates

Aug 17, 2007

I'm trying to achieve: -

I want to create a spreadsheet which will include a column with email addresses in it.

Here's my problem.......

I want users to be able to click on an email address (like a hyperlink) and by doing this open their mail client (in this case Microsoft Outlook) and send an email. I would like the mail client to load a specific template just by clicking on the link from Excel. I'm not sure if this is possible, but there doesn't seem to be many things you can't do on Excel.

View 14 Replies View Related

Combo Box In Userform Not Loading

Apr 24, 2009

The form is not uploading my dropdown box. I know I am missing something in the code, but I am not sure what.

View 4 Replies View Related

Loading A Variable File Name

Dec 5, 2006

I am using the following Macro to load a selected sheet:

Application.Dialogs(xlDialogOpen).Show
Windows("Prototype Worksheet.xls").Activate
Windows("Test Data.xls").Activate
Range("A1:U102").Select
Selection.Copy
Windows("Prototype Worksheet.xls").Activate
Range("A1").Select
ActiveSheet.Paste
Range("A1").Select
Windows("Test Data.xls").Activate
Application.CutCopyMode = False
ActiveWindow.Close

This works fine as long as I load the file named Test Data, lolz, but on the line"Application.Dialogs(xlDialogOpen).Show", I actually select the file to be loaded. how can and what should I change on the line "Windows("Test Data.xls").Activate" to achieve this

and also

at the very end of the macro I want to close the loaded file without the save box coming up.

View 9 Replies View Related

Loading Background Picture

Aug 7, 2008

I have a dropdown box with a few options in it. What I want to do, is have excel load a particular picture, that I have saved on my computer, into the background when a certain option is selected from the dropdown box.

View 9 Replies View Related

Loading MSCAL Programatically

Nov 5, 2008

I am trying to distribute an app that uses MSCAL Control. I am including the MSCAL.ocx file in the setup file and it saves it to a dierectory. However, when the app runs it will not load the activex Control (MSCAL)

Application.VBE.ActiveVBProject.References.AddFromFile("c:Program FileBM ApplicationMSCAL.OCX")

View 9 Replies View Related

Loading Values From Another Sheet

Jul 13, 2006

I've created a sheet to estimate a job project and now I am working on a new sheet to keep track of our estimated totals compared with actual expenses.

What I need is to make a macro that allows you to browse the PC and let the user select the excel sheet where all the Estimate Values are stored. These stored values are pulled up and posted onto the new workbook.

Please pull A1 from the estimate book and put it in B4 of the new workbook

View 6 Replies View Related

Not A Valid Add-in Message Loading Add-in

Aug 28, 2007

I am using the GetSaveAsFilename function to save a file. I have the filefilter as "Excel Add-In (*.xla),xla", however when I save a file this way as an add-in, then try to load that add-in, I get the following error message.

'C:Documents and SettingsUser1DesktopBook3.xla' is not a valid add-in.

Does this mean that the GetSaveAsFilename is not capable of saving a valid xla file?

View 9 Replies View Related

Userform Loading And Finding Range?

Apr 1, 2014

I have created the attached spread sheet to work out and calculate gp on products. Sheets and userform1 are working perfectly how ever userform2 wont load and I believe its something to do with the named range? The idea for this userform was to select a product from combobox1 and then change the price on sheet1 and clear the price on sheet 2 in the different sizes.

Also userform2 i would like to create it so that if any of the fields are left blank it wont change price of selected field in sheet 1 and wont clear selected area in sheet 2.

Finally is there a way on userform1 to shrink the userform size depending on how many sizes are needed?

Attached File : NEW GP CALCULATOR.xlsm‎

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved