Excel Add-in: Covariance Matrix Builder

preview_player
Показать описание
Excel can create covariance matrices with the Analysis ToolPak, but not good ones. My add-in for Excel 2010/2013 and Excel 2011 for Mac creates a "live" covariance matrix. Unlike Excel's, it will automatically update if you change the data.

To get a copy of the (free) add-in, go to my blog:

  1. Tim Mayes
  2. Covariance
  3. Covariance Matrix
  4. Excel 2013
  5. Excel 2010
  6. Excel 2011
Рекомендации по теме
Excel Add-in: Covariance 0:09:36

Excel Add-in: Covariance Matrix Builder

Tutorial: Correlation Matrix 0:04:58

Tutorial: Correlation Matrix

Calculating covariance matrix 0:00:59

Calculating covariance matrix using Excel

Variance Covariance Matrix 0:04:31

Variance Covariance Matrix in Excel

Using Excel to 0:04:48

Using Excel to Create a Correlation Matrix || Correlation Matrix Excel

BFIP13: Calculating Sample 0:09:21

BFIP13: Calculating Sample Covariance and Correlation with Excel

Constructing a Variance/Covariance 0:13:18

Constructing a Variance/Covariance Matrix

Correlation Matrix Charts 0:04:48

Correlation Matrix Charts with Excel Data

How to Calculate 0:06:04

How to Calculate a Correlation Matrix in Excel

Covariance Matrix for 0:06:52

Covariance Matrix for Asset Allocation

R2-1. Six Stock 0:10:45

R2-1. Six Stock Portfolio Covariance

Simple Value at 0:11:51

Simple Value at Risk Calculation using the Variance Covariance matrix in Excel

How to build 0:15:34

How to build a stock market sector correlation matrix in excel

Perform Basic Covariance 0:06:59

Perform Basic Covariance Analysis in Excel

Calculating Correlation Coefficient 0:01:56

Calculating Correlation Coefficient Excel

Module 11 p 0:00:37

Module 11 p 4 Correlate and Covariance Matrix

Module 3.2 - 0:13:09

Module 3.2 - Covariance and Correlation in Excel

3.4. Covariance matrix 0:06:15

3.4. Covariance matrix (Module 3. Portfolio optimization)

Covariance and Correlation 0:06:34

Covariance and Correlation in Excel

Covariance and Correlation 0:06:04

Covariance and Correlation Coefficient using Excel

How to Find 0:04:24

How to Find Correlation and Covariance in Excel. [HD]

Covariance excel 0:00:30

Covariance excel

Calculating and Understanding 0:07:39

Calculating and Understanding Covariance (COVARIANCE.S) in Excel

Portfolio of four 0:13:33

Portfolio of four assets: Variance-Covariance Matrix

Комментарии
Автор

My friend thank you so much you saved my project! I have watched other videos from more famous Youtubers but they were useless! You deserve everything your heart desires! Cheers 🥂

kliodrosou
Автор

Hi Tim, you have created a very great tool, however i have 1 question, is there a way for the formula to multiply against trading days without manually changing the formula?
Many thanks

baroona
Автор

hi there question thanks for the add on but will this still work with Mac OS

mattjax