|
PureBytes Links
Trading Reference Links
|
Phillipe,
>Columns :
>A = Base Number
>B = Level
>C = First factor
>D = Percent base
>E = Percent base level
>F = Percent base increase factor
>G = Percent applicable
>H = Target number UP
>I = target number Down
>
>Column Formulas =
>G = D*(1+(E*F))
>H = A*((1+C)+(B*G)))
>I = A*((1-C)-(B*G)))
>
> A B C D E F G H I
>
>1 5000 1 0.05 0.020 0 0.10 0.020 5350 4650
>
>2 5000 2 0.05 0.020 1 0.10 0.022 5470 4530
>
>3 5000 3 0.05 0.020 2 0.10 0.024 5610 4390
>
>My Question is :
>From H3 and I3, what is the math formula for finding back the H2 or I2
>number USING ONLY ANY NUMBERS ON ROW 3
The numbers on row 3 don't tell you anything about the numbers on
other rows, so there is no way to do it UNLESS you know in advance
what the relationship is between all the numbers in each column.
It looks like columsn A, C, D, F are all constants. Columns B and E
increment by 1, and column G increments by 0.002.
If you know that these relationships are true always, simply
substitute B=B-1, E=E-1, and G=G-0.002 for B, E, and G in your
formulas, and you will get the values H2 and H2 from the values in
row 3.
-Alex
|