Portfolio Risk and Return Analysis with Array Math in Excel | Financial Modeling Tutorials
A financial modeling tutorial on creating a covariance matrix using array math in Excel to calculate portfolio risk and return for analysis of portfolios of 2 stocks and beyond in the Quant 101 data analytics course.
Find all cell key formulas and the video transcript here:
https://factorpad.com/fin/quant-101/p...
Zoom straight to the section you are interested in here:
01:30 - Video Outline
02:00 - Step 1 - Portfolio Calculations Using Arrays
04:56 - Step 2 - Calculate Portfolio Return with Arrays
07:31 - Step 3 - Calculate Portfolio Risk with Arrays
14:15 - Step 4 - Where Are We Headed?
16:04 - Summary
16:49 - Step 5 - Next: CAPM for Expected Returns
Find the outline to the Series here:
https://factorpad.com/fin/quant-101/q...
See what other tutorials are available at:
https://factorpad.com
Happy Learning!
Watch video Portfolio Risk and Return Analysis with Array Math in Excel | Financial Modeling Tutorials online, duration hours minute second in high quality that is uploaded to the channel FactorPad 28 May 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 4,782 times and liked it 57 visitors.
