A financial modeling tutorial on calculating stock returns monthly from sources such as Yahoo Finance including stock prices, stock splits and corporate actions like special dividends in Quant 101.
For the full video script plus formulas see:
https://factorpad.com/fin/quant-101/calculate-stock-returns.html
For the Outline to Quant 101 see:
https://factorpad.com/fin/quant-101/quant-portfolio-management.html
Zoom to the specific sections here:
01:55 Step 1 - Our Sample Data Set
03:57 Step 2 - Which Return Calculation is Appropriate?
05:06 Step 3 - The Daily Process
11:35 Step 4 - Pricing Sources
15:06 The Math
15:44 Exercise 1 Daily Prices
18:05 Exercise 2 Regular Dividends
19:52 Exercise 3 Special Dividends
20:52 Exercise 4 Splits
22:33 Summary
23:06 Step 5 - Next: Return Distributions
See what else you can learn here:
https://factorpad.com/
Happy Learning!
11 Comments