In this tutorial we will automate financial analysis in excel.
- We will use Python to achieve that.
- The full code is available in Jupyter notebook
- This will Automate Financial Analysis in Excel
In this video you will learn
- How to create multiple sheet excel sheets for financial analysis
- How to get financial statements online
- We will get 10+ years of income statement
- We will get 10+ years of cash flows
- Then we will use Revenue, Earnings Per Share (EPS) and Free Cash Flow (FCF)
- We will calculate the percentage change (growth) from year to year.
- Then we will export it to Excel
- We will create a double chart for each of the 3 datasets
Get the Jupyter notebook here:
https://www.learnpythonwithrune.org/c…
Subscribe: https://www.youtube.com/c/LearnPythonwithRune/featured
#python #excel