A Stock data reader which get stock data online and write into the Excel workbook. It was developed in Python, by using the library [openpyxl] and [yfinance]
This system was requested from one of my friends. He provided some criteria and list of stock ticker symbol, so I developed this program, which using yfinance to capture market data, and using openyxl to update the Excel workbook, to fulfill the request.
-
Install library [yfiance] (https://pypi.org/project/fix-yahoo-finance/) and [openpyxl] (https://pypi.org/project/openpyxl/)
-
Clone the repository
git clone https://github.com/papatekken/stockReader stockReader -
In root directory of 'stockReader', run following command to start the application, when the application finished the run, a new excel workbook is created with data.
python getStock.py
Created by @papatekken - feel free to contact me!