[You can download the Historical Stock Price downloader Python Notebook from the Resources page]
Yahoo Finance recently locked their historical stock prices export function behind their Gold membership paywall. Thankfully, their JSON query is still available. Here's a Python code (in Jupyter notebook format) that pulls and exports the prices into a csv file.
One way to test out the code is to use colab.google. Copy-paste the code into the notebook, edit the tickers and range etc, run it, and you should be able to find the csv file under the files section.
Download the csv file, and the historical closing prices of the stocks should all be there.
For the more advanced users, you might want to generate an executable file that points to your existing Excel or csv file with all the symbols in the top row, and update the file directly with the latest prices when you run the executable. Personally, I just converted it into a python script and wrote a batch file to run it. A double-click on the .bat file and the csv magically appears in the same directory. The python file allows easy edits too, if needed. I find this to be a good compromise between flexibility and convenience.
Hope this is useful! And if it is, do kindly acknowledge the website, and donations are always welcome. Every little bit helps! :)
Comentarios