New at Formulas - Can I save a figure for future calculation


F

fatal.lordes

I'm not really sure how to explain this, but I'll do my best.

Cell A1 = 10 - Buy
Cell B1 = 20 - Current
Cell C1 =SUM(B1-A1) <-- which would be 10 - UnProfit
Cell D1 =SUM(B1-(C1*10%)) <-- which would be 19 (10% of 10 is 1, 20
minus 1 is 19) - Trailing Stop
Cell E1 =IF(B1<=D1,"YES") <-- if 20 <= 19 show YES, which it wouldn't
because it's not.

This is fine and works, but what I want to be able to do is store the
amount in D1 somewhere so that, if I change B1 to equal 15, the
formula in E1 is actually working this out on the previous amount in
D1. Make sense?

Eg., If I change B1 to equal 15, I want E1 to do the calculation based
on the previous amount in D1, which is 19, so:

Cell A1 = 10 - Buy
Cell B1 = 15 <-- Previous 20 - Current
Cell C1 =SUM(B1-A1) <-- which would be 5 - UnProfit
Cell D1 =SUM(B1-(C1*10%)) <-- which would be 14.5 (10% of 5 is .5, 15
minus .5 is 14.5) - Trailing Stop
Cell E1 =IF(B1<=D1,"YES") <-- if 15 <= 19 show YES, which it would

But D1 needs to keep storing the immdiately previous figure. So if I
change B1 to 30, it would still store the previous amount of 14.5 and
discard the amount 19.

I hope this makes sense and I hope someone can help.
 
Ad

Advertisements

O

one third

Your question sort of makes sense.

I do not know of a way to hold a value for the next operation. I am
sure there is a way to do it with programming - I can't help you with
that.

You might duplicate row 1 on row 3, and then have E3 compare the value
from B3 to D1.

This means you would have to update two values each time.

You would make B1 the value of B3 and then put your new value in B3.

Unless someone else has a better idea...

Good luck!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top