Christopher Quill – Calculating Expected Portfolio Volatility
Video length: 35 Minutes
Supplemental to Jason McDonald’s Video Lesson “Ratcheting Portfolio Risk with Small and Mid-Caps,” is Chris Quill’s Spreadsheet class that shows viewers how to implement the Small and Mid-Cap strategies outlined by Jason and how to calculate and manage the risk of a portfolio utilising the downloadable Spreadsheet tools that Chris uses. The Spreadsheet that accompanies this Video can be reverse engineered by viewers and is explained in a very logical step by step process by Chris. When adding Small and Mid-Caps to any portfolio there is higher volatility and opportunity to get higher returns, however this also comes with inherent hidden dangers and risks that Retail Traders rarely have an appreciation and understanding of and how to calculate properly. Chris does an excellent job in showing how to account for these risks by building on Jason’s Video lesson and showing the viewer how this works in practice with real numbers. Viewers can download the supplementary spreadsheet to this Video and keep it forever. This is an extremely valuable data resource and can be used to synthesise portfolio opportunity and risk across the Market Cap spectrum for all Traders and Investors in Equities. Chris also displays how to go and get the real data to populate the sheets so Retail Traders can have this skillset and resource for the rest of their lives.
After being part of the team at Ruffer Asset Management in London that generated the number one Japanese Equity Fund Returns Globally, Christopher Quill joined the Institute as head of Statistics and Research. Known by his colleagues and Traders at the Institute as “Mr Excel,” Chris’ expertise lies in managing Big Data and building then breaking down complex Statistical Models and Spreadsheets that simplify processes so that anyone can understand and use his resources.