Home
Shorts

David Johnk

21:58

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

David Johnk

1.4K views

13:05

Simple linear regression with forecast adequacy calculations on Excel

David Johnk

404 views

32:47

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

David Johnk

151K views

20:20

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

David Johnk

147K views

34:57

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

David Johnk

5K views

0:43

My Tesla saved our lives!

David Johnk

365 views

27:20

How to Show your Work on the Mini-cases

David Johnk

250 views

35:56

Bulk Stock Price download, Variance-Covariance Matrix, and Portfolio Optimization with Excel

David Johnk

2.9K views

17:02

Future Value of Multiple Annuities

David Johnk

348 views

4:57

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

David Johnk

471 views

36:39

How to show your work on Excel

David Johnk

698 views

15:22

Downloading stock prices and calculating periodic and average returns using various methods.

David Johnk

508 views

8:01

Answer to an interesting Reddit r/statistics problem I answered on Excel using Monte Carlo analysis

David Johnk

320 views

8:38

Solving for Expected Bond Rate (Unbaised Exectations Theory)

David Johnk

618 views

4:55

Easily make a Lambda function that calculates MSE

David Johnk

410 views