Automatically Download Stock Metrics data from Yahoo Finance

This video will cover how to automatically pull in stock metrics data for a list of ticker symbols. There are at least 75 different metrics that you can pull in to compare stocks to each other.

Some examples are EBITDA, Open price, Closing Price, 52 week high and low, P/E Ratio, PEG, Volume, and a ton more!

The list of metrics (and the entire Excel file) can be found here:

To book me to work on your financial projects or analysis, go here:

To follow my company on facebook go here:

To subscribe for more videos like this, go here:
Video Rating: / 5

You may also like...

20 Responses

  1. Avik Kundu says:

    Can anyone help?Following the above I am being being able to pull data from NASDAQ, but unable to pull data from NSE, which is one of the Indian stock exchanges. It is returning with N/A

  2. abhineet ranjan says:

    sir, please tell me one thing that can I retrive live data from yahoo finance because I am going to made a android app so for this I require live data to display in my app. please reply fast because I need help. thank you.

  3. Tao Ji says:

    How can I pull the "name" of FB from finance yahoo? It has a comma in their name. It will trigger strange errors. Help me !

  4. daniel billings says:

    i recently started trading options and joined a trading group. In that group one of the moderators uses a spreed sheet to trade along with charts. Yesterday the market was choppy but looked like a good short. This guy took one look at his spreed sheet and said to go long and with-in 1 min it broke out! Every time he's in the room he uses his spreed sheet to trade from. I use T.O.S for charting and it works great but id like to be able to see that type of detail in the price action. Will this work with FOREX, COMMODITIES AND INDICES OPTIONS?

  5. Wilfred Monteiro says:

    great stuff

  6. Jamie Goodell says:

    Is this limited to about 200 rows? And is there a way to set it up with out deleting the old data first?

  7. Jamie Goodell says:

    Thanks for the video! I was able to make everything work following the video. My question is how do i add Sector and Industry data for each ticker/stock? I have 3 metrics selected to download and tried manually entering the sector and Industry info after my last metric. When i do this all my metrics get bunched up back into column C. What is the simplest way to add Sector and Industry to each ticker i enter? Manual entry is ok as long as I only have to do it once. Once i add a ticker i never delete it, just add more tickers from time to time.

  8. ScrappytheDog says:

    Very Helpful. Thanks!

  9. Ray Baterina says:

    Great Tutorial!

    Some may want something more simplified. BUT there are others that need a little more sophistication especially when you want to change the look of your report for Execs.

    You've just made a report that much more flexible. Thanks!

    Good job on the VB skills!

    I haven't done this stuff in a long time and you're tutorials totally helped me in a pinch with my reporting!


  10. Bey Melamed says:

    Great tutorial, thanks

  11. nitesh sharma says:

    Hi Sir Need One Help in setting up and excel where it Pulls data from nse Data Automatically , and Fits the same into camrilla equationa and refreshes the same at certain fixed time . Its a humble request plsssssssssssss , if you need i can send some specimen links

  12. Mike Johns says:

    Is it possible to add open price to the query?
    Thanks for the help setting this up in excel

  13. 5mcdon4 says:

    I copied the code exactly, when i got to " 'importing data to c6" again this was copied perfectly, yet when i run the macro get get a "Run-time error '1004' = Application-defined or object-defined error "

    please could someone assist me with why this is?
    Here is how i have my code set up, maybe there's someone simple I've missed. I am based in UK but used the US tickers in the video, but i don't think that should affect it.

    'import data to c6
    With ActiveSheet.QueryTables.Add(Connection:="URL;" & tickerstring, Destination:=Range("c6"))
    .BackgroundQuery = True
    .Refresh BackgroundQuery:=False
    End With

    Many thanks in advance

  14. Crystal Yin says:

    Great video! Thank you very much for the help

  15. K sing says:

    I was wondering is there a way to stop it from automatically change the width of the columns? Because once I pull the data, the columns changes to a random width. Thanks in advance

  16. Holden Smith says:

    I want to do hundreds of stocks at once. Is there a way to do this using your methods in the video?

  17. Tyler Boring says:

    Whenever I tried to dump a large list of tickers under the Ticker Title , an error code of 400 came up? Any thoughts?

  18. Komodo says:

    Hi, thank you for your video, it is clear and understandable. Can you or somebody else please help with an issue I have. I would like to import data from Yahoo Finance, but having in columns other financial data, such as closing price (or adjusted closing price), on a daily frequency level, and a return over a chosen period. Will this be possible ?

  19. Alicia Loughlin says:

    Hi, When I create the macro (or even use yours) it adds an extra column for every decimal place even though I have clearly not done that in the recording. Any suggestions … or help? Thanks.
    .TextFileTextQualifier = xlTextQualifierDoubleQuote
    .TextFileConsecutiveDelimiter = True
    .TextFileTabDelimiter = True
    .TextFileSemicolonDelimiter = False
    .TextFileCommaDelimiter = True
    .TextFileSpaceDelimiter = False
    .TextFileColumnDataTypes = Array(5, 1, 1, 1, 1, 1, 1)
    .TextFileTrailingMinusNumbers = True
    .Refresh BackgroundQuery:=False

  20. Denis Boutcha says:

    I got a question, is there a way to pull weekly and monthly data like Open, High, Low, Close and Volume?

Leave a Reply

Your email address will not be published. Required fields are marked *

Skip to toolbar