Drawdown Calculation or Largest losing streak by value

W

Willygubbins

New Member
Joined
Mar 3, 2017
Messages
3
Hi All, Please help me......

I am looking for an in cell formula to tell me the max value losing streak or drawdown for the the table i have attached the image of.
I have search hi and low and can only find vaalue by value drawdown, drawdown against peak value and losing steak by number of days.

In my table Column C is Daily P&L and Column I is an accumalative P&L.

Many Thanks in advance.

u4O113xL58
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

M
  • Question
Find the Maximum number in a series of Data
2 3
Replies
23
Views
934
awoohaw
awoohaw
C
  • Question
Pivot Table Min and Max values in Column
Replies
0
Views
272
conorrey
C
R
  • Solved
Connect periods with spilled result, where the result is same as the calculated result in previous row
2
Replies
15
Views
160
roelandwatteeuw
R
S
  • Question
Repeating a pivot table many times and changing only one column -- are there more efficient approaches?
Replies
0
Views
159
sschaefer
S
M
  • Question
Automatically Move Row to Another Sheet Based On Cell Value
Replies
6
Views
833
felixstraube
F

Forum statistics

Threads
1,214,832
Messages
6,121,845
Members
449,051
Latest member
excelquestion515

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top