Get Stock Historical Data From Yahoo Finance - English + Cantonese Caption (Eng Narration)

Just make a video on this simple technique to grab stocks historical data from Yahoo Finance.

Brief steps are listed below:

Before using your Jupyter Notebook from Anaconda:
1) Conda install pandas-datareader

When you get into Jupyter Notebook:
2) Import all the libraries (datareader, datetime, matplotlib)
3) define date (start & end) as well as the searching method (e.g. yahoo), refer to videos for details
4) ready for plotting and other coding

Pandas for Finance

This tutorial walks through the Series and DataFrames functionality of Pandas.

This tutorial is suitable for beginners.

http://quant-econ.net/py/pandas.html

Python Working With Excel - Creating Advanced Excel Workbooks

Just found the following article on Python and Excel:

http://pbpython.com/advanced-excel-workbooks.html

This article talks about:

1) create Excel workbook
2) merge Excel workbook
3) insert VBA

Please visit the above page for details.

Hope it helps all learners.