Automatically Download Stock Price data from Yahoo Finance

Author: TimevalueVideos
99422 View
18m 12s Lenght
414 Rating

A walkthrough on how to write a VBA Macro in Excel to automatically download historical prices for any stock in any date range. **UPDATE** 9/10/16 it seems that Yahoo has reversed their URL for getting the data. The End Date and the Beginning Date have reversed. So if you just swap the locations on the Excel sheet for the dates then it should work fine. The code is available here: https://sites.google.com/site/timevaluevideos/home

Comments

  1. I agree with the positive feedback. Very helpful and clear tutorial. Good job!
  2. try MarketXLS
  3. Hi, is it possible to do it on google finance? as the macro is much different than in yahoo. Could you please make a video on how to do it on google finance and or MSN? as the MSN has the intraday chart. Thank you ver much!
  4. Thank you very much for this. This is VERY helpful.
  5. WOW...great tutorial. Thank you. I did have one quick question. Can you REVERSE the data download in the spread sheet. In other words, can you set up the excel spread sheet to start off with the start date data in cell 1 and end with the end date data at the bottom or end of download in sequential fashion (1,2,3, etc). I have a program that is set up this way and need the data download to load in a reverse fashion than your video explained and demonstrated. Thanks in advance for any help you can provide here.
  6. Is this method working on Mac? Cuase errors always happen no matter what I do.
  7. It showed that I can't import from URL and the error is 1004. I wonder why that happened
  8. Hi, I am currently using the Excel 2016 on Mac, so I am unable to paste the URL as file name. I wonder how can I do this procedure in the 3:00 in the video.
  9. Hi. Thank you so much for this post!
    Is it possible to download the dividend payments in addition to the price data?
    TIA!
  10. very useful
  11. Awesome!, worked perfect. Thanks for posting this.
  12. dude great video,did you now how can i get stock futures data to my blog?thank you and im sorry for my english, i have lost to the internet to looking widget.
  13. Thank you soo much!
    This is awesome!

    Thanks for starting at the beginning and explaining everything as you went through.

    I'm new to macros: if I want to do this for each company in the Dow 30 (on different worksheets), and have only one button which will refresh the set, how might I do that?
  14. awesome
  15. Thank you for your time and explanation. What if I need to get only the last adjusted price for a given period, and the return over this period ? Is there an easy way to solve this issue ?
  16. Why do all the prices download with a bunch of points and I do not get the real stock price?
  17. I have query with respect to the code. Is there an email id on which i can share a file with you and consult?
  18. What about intraday data?
  19. for weekly data, change d to w and m for monthly. is there a way to start a week from a certain day. I would like for it to give me data as of Friday, instead of Monday. how can i get every Friday data as weekly data? thanks in advance!
  20. Great tutorial. Script was working a month ago for me but now it returns a 1004 run time error. I've re written the script but no luck. Any idea why?