Calculate monthly returns on stocks in Excel | Financial Modeling Tutorials
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/c...
For the Outline to Quant 101 see:
https://factorpad.com/fin/quant-101/q...
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!
Watch video Calculate monthly returns on stocks in Excel | Financial Modeling Tutorials online, duration hours minute second in high quality that is uploaded to the channel FactorPad 29 March 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 64,516 times and liked it 250 visitors.
