expression help (Drawdown)

[mike02]

Hey,
I have a query set up like this: (comes from internal table "Monthly_Returns")

CompanyName.....Return.....NAV....drawdown
aaa............-0.829......91.71.....xxx (Ignore)
aaa............0.0908.....100.79...Start
aaa............0.001.......100.89
aaa............0.051.......105.99
aaa............0.0666.....112.65
aaa...........-0.0029....125.39
aaa...........-0.0921....125.10
aaa...........-0.0628....115.89
aaa...........-0.0457....109.61
bbb...........-0.0021....99.79....xxx (Ignore)
bbb...........-0.0021....99.58....Start Again
bbb...........-0.0021....99.37
bbb...........-0.0018....99.19
bbb...........-0.0017....99.02
bbb............0.0554.....104.56
bbb...........-0.0514....99.42

The Drawdown formula would be this in excel:
first aaa Is cell A2
=(A3/Max(A$2$:A2))-1
My question is how would you reference the starting point, and for each drawdown value you continue to have you Max list selection growing by one:S
Also, i need it to start over for each Company Name:S
thanks in advance,

[June7]

Don't really understand what you mean by Drawdown and can't figure out the calculation. I tried to create spreadsheet and test formula but it doesn't make sense. Cell A3 is text - company name.

In plain English, what do you want to calculate? What would be the result in the drawdown column?

[mike02]

my apologizes, It should be C not A in the formula, Also, I am calculating the Max Drawdown, Other words the Largest cummulative lost.

[June7]

Should the range be reference to the Return column ($B$2:B2)?

What would be the correct result? Show column with results of calc.

Why is the first record for each company 'ignored'?