My Two Calculators Don't Match

[jdpro]

Hello!

I have two simple calculators.
The first calculates a stop price based on a risk amount entered as per the following example:
a1) Qty 40
a2) Price $31.40
a3) Position Cost (calculated [a1*a2]) $1256.00
a4) Risk Amount $93.46
a5) Stop Price (Calculated [(a3-a4)/a1]) $29.06

The next one calculates a risk amount based on a stop price entered.
b1) Qty 40
b2) Price $31.40
b3) Position Cost (calculated [a1*a2]) $1256.00
b4) Risk Amount (calculated [(b2-b5)*b1]) $93.60
b5) Stop Price $29.06

Why does the risk amount in calculator B not equal that in calculator A when I entered the same stop price? Maybe there's something wrong with my math (highly likely!) or perhaps there's a better way to calculate these values.

Thank you very much and sorry I don't have the xl2bb functionality because it would have made things much easier!

 

[Peter_SSs]

Why does the risk amount in calculator B not equal that in calculator A when I entered the same stop price?

Because you didn't enter the same Stop Price. The Stop Price in the first example is actually 29.0635
Try entering that in b5