Percentage Change Between a range of numbers? Please help :(

[domgilberto]

Hi All,

Hoping this is straight forward for most and would be very appreciative of anyone's help


Please find attached the spreadsheet.

Basic overview:

"Graph 3" - You will see in D3 a cell where I input the number of "Trades" I intend to take per year. This will then be divided by 12 (months) and that number be placed in D4.
D29 is looking at D4 (which I am still finishing this spreadsheet) which focuses on the data in "OUTCOME 3", Column "A".


What I would like:

On "Graph 3" TAB, you will see "Peak Drawdown"; based upon the information above^, I would like to know the percentage change from the highest number and the lowest number within it's range from OUTCOME 3, Column A...

The range is determined by the given number I input to "D3" on "Graph 3", then divided by 12 (months) which is displayed in "D4".

(in this case with the spreadsheet attached, 240 trades = 20 trades average per month = Column A in "OUTCOME 3" - "Range:A2:A21")


Would really appreciate anyone's help!



Thanks!!

[etaf]

are you looking for this as the change

(Max value in range - Min value in range) / min in range

if so then
= ( MAX(INDIRECT("'outcome 3'!A2:A"&D4+1)) - MIN(INDIRECT("'outcome 3'!A2:A"&D4+1)) ) /MIN(INDIRECT("'outcome 3'!A2:A"&D4+1))

Please Login or Register  to view this content.