Solved

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

Posted on 2014-12-18
5
1,539 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 8

Expert Comment

by:Naresh Patel
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:
Naresh Patel earned 500 total points
ID: 40507834
Sorry Wrong Copy

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

Expert Comment

by:Naresh Patel
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 48

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

690 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