title: VBA code to get live stock index values
body: <p>I'm looking to get live values for stock indexes, such as the Dow (DJIA) or Hang Seng Index (HSI).</p>
  
  <p>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).</p>
  
  <p>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.</p>
  
  <p>Thanks for your help</p>