I modified this from code I found elsewhere (but can't remember where). It extracts forex rates from the Yahoo feed. Perhaps you can modify it for stocks?

(You may have to wait up to a minute for the first row to appear once you click 'Start Tracking')

ForexQuery_cy.xlsm