0

I'm looking to get live values for stock indexes, such as the Dow (DJIA) or Hang Seng Index (HSI).

These need to be generated from a (configurable) set of index symbols, and saved to VBA variables without any interaction with the sheets. Ideally this would be from Bloomberg, or Yahoo if need be (though any other source would be ok too, as long as it's live).

I understand this is a simple task, though I can't find any direct way of doing it- only examples of getting option price or stock data etc. I understand I start with a reference to the Bloomberg API, but I can't seem to get further than this.

Thanks for your help

Michael Mathews
  • 21
  • 1
  • 6

2 Answers2

1

If you want to retrieve live data using the Bloomberg API, you need to be a Bloomberg subscriber ($$$). As you also mention Yahoo, which is free, I suspect it is not what you want.

assylias
  • 321,522
  • 82
  • 660
  • 783
0

This isn't a simple task.

You'll need to initiate an HTTP GET request for http://www.google.com/finance?q=GOOG, and parse the return string you self.

The HTTP Request is sent with this code:

     Set HttpReq = CreateObject("MSXML2.ServerXMLHTTP")
     HttpReq.Open "GET", "http://www.google.com/finance?q=GOOG", False
     HttpReq.send
     MsgBox HttpReq.responseText
Uri Goren
  • 13,386
  • 6
  • 58
  • 110
  • Thanks Uri, that's a big help- data 15 mins delayed but way better than nothing. I wondered if there is a way to do this more directly, using a Referenced library (as in http://www.vbafin.com/Bloomberg-data-download-vba-code.php )? Thanks again. – Michael Mathews Jul 29 '12 at 16:57