Download prices for 43 Sector ETFs and form optimized portfolios on Excel

Download prices for 43 Sector ETFs and form optimized portfolios on Excel

40:43 |

Related Videos

Use Excel to graph the efficient frontier of a three security portfolio

Use Excel to graph the efficient frontier of a three security portfolio

How to show your work on Excel

How to show your work on Excel

An intuitive method for solving a simple linear programming problem on Excel using Solver

An intuitive method for solving a simple linear programming problem on Excel using Solver

Two ways to download stock prices from Yahoo Finance to Excel now that it's behind a paywall.

Two ways to download stock prices from Yahoo Finance to Excel now that it's behind a paywall.

Graph the efficient frontier and capital allocation line for a three stock portfolio using Excel.

Graph the efficient frontier and capital allocation line for a three stock portfolio using Excel.

Calculate the Payback Period in 30 seconds!

Calculate the Payback Period in 30 seconds!

Easily calculate Beta using historical stock data on Excel

Easily calculate Beta using historical stock data on Excel

Excel Lambda functions which easily calculate portfolio expected return and standard deviation

Excel Lambda functions which easily calculate portfolio expected return and standard deviation

Screen for gold! Easily create a custom stock screener using the powerful Excel filter function.

Screen for gold! Easily create a custom stock screener using the powerful Excel filter function.

Income statement calculations in Excel. Demonstrates Excel goal seek as an algebra alterative.

Income statement calculations in Excel. Demonstrates Excel goal seek as an algebra alterative.

Use Excel to calculate MSE, MAD, SSE, tracking signal, and control limits on forecasts.

Use Excel to calculate MSE, MAD, SSE, tracking signal, and control limits on forecasts.

Present Value (PV) of different cash flows on Excel

Present Value (PV) of different cash flows on Excel

How to Show your Work on the Mini-cases

How to Show your Work on the Mini-cases

material requirements plan using lot-for-lot ordering on Excel

material requirements plan using lot-for-lot ordering on Excel

Beta, the risk-free rate, and CAPM. Calculate the expected return of a security on Excel.

Beta, the risk-free rate, and CAPM. Calculate the expected return of a security on Excel.

How to submit your Excel homework

How to submit your Excel homework

Download stock price history and calculate expected return, standard deviation, covariance on Excel

Download stock price history and calculate expected return, standard deviation, covariance on Excel

Simple linear regression with forecast adequacy calculations on Excel

Simple linear regression with forecast adequacy calculations on Excel

Microeconomics: how to graph quantity supplied and quantity demanded versus price on Excel.

Microeconomics: how to graph quantity supplied and quantity demanded versus price on Excel.

Calculate Beta, R-squared, expected return and more on a 5-security portfolio using Excel

Calculate Beta, R-squared, expected return and more on a 5-security portfolio using Excel

© 2024 Tubidy