ViewTube

ViewTube
Sign inSign up
Author thumbnail

FactorPad

Financial Modeling Tutorials - Quantitative Portfolio Management | Quant 101

51,517 views
27 items
Last updated on Sep 17, 2018
public playlist 
Launch your investing career with the help of a series of financial modeling tutorials in Excel. Download a free 4-stock data set and learn equity portfolio management and risk management from an expert.
FactorPad
Learn Quantitative Investing in Excel | Financial Modeling Tutorials
7:40
Learn Quantitative Investing in Excel | Financial Modeling Tutorials

FactorPad
Learn to Manage Stock Portfolios in Excel | Financial Modeling Tutorials
17:54
Learn to Manage Stock Portfolios in Excel | Financial Modeling Tutorials

FactorPad
Install Excel Data Analysis ToolPak and Solver Add-In | Financial Modeling Tutorials
17:26
Install Excel Data Analysis ToolPak and Solver Add-In | Financial Modeling Tutorials

FactorPad
Stock Return Calculations: arithmetic and geometric | Financial Modeling Tutorials
18:30
Stock Return Calculations: arithmetic and geometric | Financial Modeling Tutorials

FactorPad
Calculate monthly returns on stocks in Excel | Financial Modeling Tutorials
23:26
Calculate monthly returns on stocks in Excel | Financial Modeling Tutorials

FactorPad
Stock return frequency distributions and histograms in Excel | Financial Modeling Tutorials
18:04
Stock return frequency distributions and histograms in Excel | Financial Modeling Tutorials

FactorPad
An admittedly flawed history of stock markets and investment strategies
39:55
An admittedly flawed history of stock markets and investment strategies

FactorPad
Calculate four measures for stock risk analysis in Excel - Financial Modeling Tutorials
24:51
Calculate four measures for stock risk analysis in Excel - Financial Modeling Tutorials

FactorPad
Calculate stock portfolio returns and turnover in Excel | Financial Modeling Tutorials
20:57
Calculate stock portfolio returns and turnover in Excel | Financial Modeling Tutorials

FactorPad
A faster way to calculate portfolio risk, and remember it too | Financial Modeling Tutorial
16:49
A faster way to calculate portfolio risk, and remember it too | Financial Modeling Tutorial

FactorPad
Create a covariance matrix and interpret a correlation matrix | Financial Modeling Tutorials
16:45
Create a covariance matrix and interpret a correlation matrix | Financial Modeling Tutorials

FactorPad
Charting stock portfolios with a scatter plot in Excel | Financial Modeling Tutorials
15:41
Charting stock portfolios with a scatter plot in Excel | Financial Modeling Tutorials

FactorPad
Ace your Portfolio Theory exam - MPT and CMT explained
28:31
Ace your Portfolio Theory exam - MPT and CMT explained

FactorPad
Correlation vs Regression for Data Analysis | Financial Modeling Tutorials
18:57
Correlation vs Regression for Data Analysis | Financial Modeling Tutorials

FactorPad
How to interpret Correlation and R-Squared | Financial Modeling Tutorials
15:23
How to interpret Correlation and R-Squared | Financial Modeling Tutorials

FactorPad
Generate and interpret a linear regression in Excel | Financial Modeling Tutorials
18:58
Generate and interpret a linear regression in Excel | Financial Modeling Tutorials

FactorPad
Analyze portfolio performance with linear regression in Excel | Financial Modeling Tutorials
21:20
Analyze portfolio performance with linear regression in Excel | Financial Modeling Tutorials

FactorPad
Time-series analysis of stock return regressions in Excel | Financial Modeling Tutorials
16:21
Time-series analysis of stock return regressions in Excel | Financial Modeling Tutorials

FactorPad
An introduction to Linear Algebra and Arrays in Excel | Financial Modeling Tutorials
17:12
An introduction to Linear Algebra and Arrays in Excel | Financial Modeling Tutorials

FactorPad
The operations of Array Math and Matrix Multiplication | Financial Modeling Tutorials
18:50
The operations of Array Math and Matrix Multiplication | Financial Modeling Tutorials

FactorPad
Portfolio Risk and Return Analysis with Array Math in Excel | Financial Modeling Tutorials
18:06
Portfolio Risk and Return Analysis with Array Math in Excel | Financial Modeling Tutorials

FactorPad
How to find expected return on a stock using the CAPM model | Financial Modeling Tutorials
17:39
How to find expected return on a stock using the CAPM model | Financial Modeling Tutorials

FactorPad
Customize a regression with LINEST and Excel INDEX Functions
19:56
Customize a regression with LINEST and Excel INDEX Functions

FactorPad
Expected return and the Security Market Line Explained | Financial Modeling Tutorials
18:15
Expected return and the Security Market Line Explained | Financial Modeling Tutorials

FactorPad
How to measure expected stock risk and portfolio risk contribution | Financial Modeling Tutorials
19:34
How to measure expected stock risk and portfolio risk contribution | Financial Modeling Tutorials

FactorPad
Stock portfolio risk decomposition into systematic risk and specific risk
16:57
Stock portfolio risk decomposition into systematic risk and specific risk

FactorPad
Linear Regression: SST, SSR, SSE, R-squared and Standard Error with Excel ANOVA
37:31
Linear Regression: SST, SSR, SSE, R-squared and Standard Error with Excel ANOVA