Fundamental Analysis
- Using fundamental analysis to pick stock to outperform market in the long term (>2 years)
Compare performance with Mutual Index Fund such as Vanguard
(1) Getting basic Company Info, from some free online data provider
(2) Downloading earning report each quarter, and extract useful data (revenue, cost, opex, etc)
(3) Extracting any public alternative data related to the company, if available
(4) Automating finance model building with help of Python
(5) Generating reports for fundemental analyst
There are a lot of rooms of application of automation/AI/big data approach to fundamental analysis, but you need to have really good understanding of financial modeling before getting Python to help you
(1) Need to understand webscraping.
https://blog.hartleybrody.com/guide-to-web-scraping/
(2) Need to operate with docx/pdf/excel, as well as basic NLP for information extraction.
Python with Docs: https://automatetheboringstuff.com/chapter13/
NLP: https://www.youtube.com/watch?v=nfoudtpBV68&list=PL4LJlvG_SDpxQAwZYtwfXcQr7kGnl9W93
(3) This one is very tricky, but typically a combination of webscraping/data extraction if you are not working in institution and not buying data from vendor
(4) Financial Modeling and Valuation, here are two introductory texts:
https://www.amazon.co.uk/Investment-Banking-University-Second-Acquisitions/dp/1118472209
https://www.bookdepository.com/Investment-Valuation-Aswath-Damodaran/9781118130735
(5) Well, if you know how to do (1) to (4), (5) should be now a piece of cake
https://github.com/nikolamilosevic86/FinAnalyzer
[What is Discounted Cash Flow] (https://www.investopedia.com/terms/d/dcf.asp)
Use Excel to build DCF model 6 steps building dcf model. DCF Model
https://pythonprogramming.net/getting-stock-prices-python-programming-for-finance/
https://towardsdatascience.com/stock-prediction-in-python-b66555171a2
I still dont know what is the different between ETF and Mutual Index Fund, after reading the explaination from Investopedia