Download Multiple Historical Stock Data From Yahoo Finance To Excel Using Python

From the previous tutorial, I covered how to download historical data of a company to a CSV file, but some of the viewers wish to export multiple historical data to an Excel spreadsheet to keep all the data in one place. In this tutorial, I will be showing how to export multiple historical data to an Excel spreadsheet in Python.

Ready to invest? Checkout Robinhood
-------------------------------------------------------------------

Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
🔑Venmo: @Jie-Jenn

Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#DownloadStockData #DownloadHistoricalData #Python #StockAnalysis

[MarvinRader]

Thank you so much for making this video and sharing your code. This is exactly what I was trying to do. I've tried to search the internet for this, and found dozens of sites with code that did not do what I was trying to do. It was awesome to find your video, where you clearly tell us how to do this, and provide working code. I'm going to look into signing up for Patreon so I can support your work. I'm hoping your Youtube videos are found by more people like me, it would be a great help to all of us who want to make use of Python and other useful code to do everyday task efficiently.

[ravisarogi]

Thank you very much. This is a great video. Is there a way where I can store a long list of tickers and then have the code pick up the tickers from there rather than specifying them in the code itself. Asking because I work with many tickers and it be a problem yo provide all the tickers in the code itself.

[stellolight]

Hey, thanks for the great video, it's really helpful! I am pretty new to this, is there any way to save this excel file in one sheet and have another column with respective ticker symbols? Also, if I wanted to add another column for the industry what would I need to do?
I appreciate the knowledge that you're sharing!

[lifestylewithchels]

Hi, thanks for this. Very useful. I was wondering, is it possible to extract the market cap data from Yahoo Finance for Apple to Excel for analysis? If so, any tips on how to go about doing this using Python?

[allee]

Thank you. I am looking for a way to get the historical data high, low, with timestamp. Is there any way to get it? Thanks

[merkhet]

Did anyone run into rate limits if they were trying to download from a large number of tickers?

[amazon]

I get HTTPError:Not found error, Please help

[HuntBlatz]

Hi. I am getting an error. Can someone help?
I set xlwriter as in Jie's example: xlwriter = pd.ExcelWriter('stockprices.xlsx', engine='openpyxl')

After the for loop, on the save statement, xlwriter.save(), I get the following error: 'OpenpyxlWriter' object has no attribute 'save'

I changed the engine to xlsxwriter, and then, I get a similar error: 'XlsxWriter' object has no attribute 'save'

I have just installed VS Code, python 3.11.4, and
pandas 2.1.2

xlsxwriter 3.1.9
openpyxl 3.1.2

Any thoughts?

[ariboy]

Thank you for the video, however I am getting this error message. Can you please assist on how I can fix this?

File in http_error_default
raise HTTPError(req.full_url, code, msg, hdrs, fp)

HTTPError: Not Found

[albertonava]

I am trying to use the code, but an error told me "ModuleNotFoundError: No module named 'pandas'", can you help me?