Stock quotes from Yahoo into Excel (VBA) – Macro included

Here is a little video on how to get a macro into Excel which downloads the current stock price of any ticker symbol available on Yahoo! Finance and updates …
Video Rating: 5 / 5

3 thoughts on “Stock quotes from Yahoo into Excel (VBA) – Macro included

  1. Eric Hampton

    Thanks for the share! I’ve been trying to figure this one out for a while
    now. Can we pull Revenue and EPS numbers from Yahoo as well? 

  2. Cody Guluk

    Hi Rene,

    I couldn’t get the macro to work as you have it copied here. I found your
    thread on financial-modelling.net and used the URL in the code you posted
    there, it solved my problem:

    strURL = “http://download.finance.yahoo.com/d/quotes.csv?s=” & strTicker & _
    “&f=l1″

Comments are closed.