Solved

Bloomberg API (How to automatically click Refresh on Bloomberg Ribbon in Excel)

Posted on 2014-12-18
5
1,144 Views
Last Modified: 2015-01-16
Hi,

I am using Bloomberg Anywhere API to pull data into excel. Some fields are real - time so they update automatically and for some fields (which are not real time) i need to hit refrest on the Bloomberg Ribbon. Is there a way to automate this? So maybe a VBA code which will hit refresh every 30 seconds.

Thanks,
0
Comment
Question by:awesomejohn19
  • 3
5 Comments
 
LVL 8

Expert Comment

by:itjockey
ID: 40507827
Hi,

I have ready file ...see it is working for you or not.


Thanks
RT-Final-WIP---Copy.xlsm
0
 
LVL 8

Accepted Solution

by:
itjockey earned 500 total points
ID: 40507834
Sorry Wrong Copy

See attached
RT-Final-WIP---Copy.xlsm
0
 
LVL 8

Expert Comment

by:itjockey
ID: 40507884
or you can select auto refresh while creating BB wizard i.e. check auto refresh option while creating BB formula.

Some thing like this "=BRB("NZ1 Index","OPEN,HIGH,LOW,LAST_PRICE,VOLUME","12/18/2014 9:00:00 AM","","BarTp=T","BarSz=1","Dts=S","Sort=A","Quote=C","UseDPDF=Y","cols=6;rows=377")"

Where you can replace "NZ1 Index" with your Ticker.


Thanks
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40553112
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question