1. To create an excel template to load fundamental data of a stock trading in NSE and then to automate some analysis.
2. Create a python project for the same
Load Financial data (balance sheet, profit and loss statement, cash flow statement, investor breakdown, financial ratios and peer comparision sheet) from web on button click (from Introduction Sheet). The sources used are moneycontrol and screener.
Relevant Code : The code can be found here
The main() subprocedure is linked to a button click.
Decided to your python to do fundamental analysis instead.
We are going to load only the three financial sheet namely balance sheet , cash flow and profit and loss. Source used is : Money Control.
The functions are present here.