How to calculate portfolio draw down in MS Excel?

  Рет қаралды 1,456

Profectus Academy

Profectus Academy

Күн бұрын

In this video, you will learn how to calculate the maximum drawdown of a portfolio, both in absolute terms as well as in percentage terms.
You will learn two approaches the calculate the drawdown
- Iterative approach
- Matrix approach
You will also learn to make them dynamic using the new Scan function.

Пікірлер: 4
@gowthamdhanasekaran3908
@gowthamdhanasekaran3908 2 жыл бұрын
Excellent!
@sidhantismful
@sidhantismful 2 жыл бұрын
Excellent explanation! Thank you
@ProfectusLearning
@ProfectusLearning 2 жыл бұрын
Glad it was helpful!
@RajeshBhuin-ju7ld
@RajeshBhuin-ju7ld 2 күн бұрын
How 3570 become 19.43%?
When and how to use Scan() and Reduce() functions in MS Excel? | Build dynamic cork screw models
18:06
When and how to use Scan() and Reduce() functions in MS Excel? | Build dynamic cork screw models
Profectus Academy
Рет қаралды 1,7 М.
Calculate Maximum Drawdown Without VBA | GME Example
8:20
Calculate Maximum Drawdown Without VBA | GME Example
Brainy Finance
Рет қаралды 7 М.
Smart Sigma Kid #funny #sigma #comedy
00:25
Smart Sigma Kid #funny #sigma #comedy
CRAZY GREAPA
Рет қаралды 14 МЛН
THEY WANTED TO TAKE ALL HIS GOODIES 🍫🥤🍟😂
00:17
THEY WANTED TO TAKE ALL HIS GOODIES 🍫🥤🍟😂
OKUNJATA
Рет қаралды 17 МЛН
Worlds smallest 4K headset 😎 Visor.com #tech #vr #technology #virtualreality #insideout2
00:15
Worlds smallest 4K headset 😎 Visor.com #tech #vr #technology #virtualreality #insideout2
Immersed
Рет қаралды 79 МЛН
Вечный ДВИГАТЕЛЬ!⚙️ #shorts
00:27
Вечный ДВИГАТЕЛЬ!⚙️ #shorts
Гараж 54
Рет қаралды 14 МЛН
Maximum Drawdown Explained + Calculate & Visualize in Excel
6:03
Maximum Drawdown Explained + Calculate & Visualize in Excel
Tactile Trade
Рет қаралды 26 М.
When and how to use ByRow and ByCol functions in MS Excel
14:07
When and how to use ByRow and ByCol functions in MS Excel
Profectus Academy
Рет қаралды 1,7 М.
Create dynamic debt amortization schedule with just one function using Lambda
10:13
Create dynamic debt amortization schedule with just one function using Lambda
Profectus Academy
Рет қаралды 3,2 М.
How to Calculate Drawdowns ? | Ep 96 | WeekendInvesting Daily Bytes
15:44
How to Calculate Drawdowns ? | Ep 96 | WeekendInvesting Daily Bytes
WeekendInvesting
Рет қаралды 3,4 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
5 Excel Secrets You'll Be Embarrassed You Didn't Know
Excel Campus - Jon
Рет қаралды 89 М.
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
6 Excel Tools Most Users Never Think to Use (Files Included)
MyOnlineTrainingHub
Рет қаралды 102 М.
How to Calculate Maximum Drawdown with an Excel Formula
8:04
How to Calculate Maximum Drawdown with an Excel Formula
Trading Heroes
Рет қаралды 10 М.
The Man Who Solved the World’s Hardest Math Problem
11:14
The Man Who Solved the World’s Hardest Math Problem
Newsthink
Рет қаралды 400 М.
Historical Method: Value at Risk (VaR) In Excel
5:01
Historical Method: Value at Risk (VaR) In Excel
Ryan O'Connell, CFA, FRM
Рет қаралды 28 М.
Drawdown calculation.
4:24
Drawdown calculation.
Mystic Wealth
Рет қаралды 11 М.
Smart Sigma Kid #funny #sigma #comedy
00:25
Smart Sigma Kid #funny #sigma #comedy
CRAZY GREAPA
Рет қаралды 14 МЛН