Question for experienced Excel users...

Quote from dwl603:

ok now you se where J12 is, you see how it is -504? so
k12 = negative 420 meaning i was stopped out, now the problem is if J12 goes higher than -400, K12 will revert back to being J12, i want K 12 to lock once J12 goes over -400 to represent a stopout.

the equation i have for K12 is =IF(J12<=-400,-420,J12)

attachment.php
More...

As mentioned above, small variation:
=If(k12=-420,-420,if(j13<=400,-420,j13))
This locks in -420 once it has been triggered, no matter what happens to the J column (going up whatever) after.
Just drag that down to as many k cells
as you want.

Cheers.
 
Quote from dtrader98:

As mentioned above, small variation:
=If(k12=-420,-420,if(j13<=400,-420,j13))
This locks in -420 once it has been triggered, no matter what happens to the J column (going up whatever) after.
Just drag that down to as many k cells
as you want.

Cheers.
More...

by J13 do you mean J12??? if so and thats the equation thank you so much i really appreciate it! thx alot for your time!

-Dan

Doesnt seem to work now everything equals -420

ok now sems to work will check tomorrow thx alot for your time!!!!
 
Quote from dtrader98:

This is about as clear as I can make it, without you attaching the actual excel file, and having me modify it.

2zyyiz9.jpg


GL.:)
More...

It appears to work thx alot! if not i will send you the sheet tomorrow....
 
P.S. earlier posts had small typo,
=If(k12=-420,-420,if(j13<=400,-420,j13))
should have been j13<= -400 not +400
that is likely why all the cells were -420.
Current jpg I posted has correct formula.

Glad to see it works for you.
 
Quote from dtrader98:

P.S. earlier posts had small typo,
=If(k12=-420,-420,if(j13<=400,-420,j13))
should have been j13<= -400 not +400
that is likely why all the cells were -420.
Current jpg I posted has correct formula.

Glad to see it works for you.
More...

yeah it seems to work great.... the other problem was that it should be j12 instead of j13, i am doing it sideways not on a cell below....

i will need a couple days to figure out wether or not it actually locks but im not gonna lie im doing hail mary's and wearing my lucky boxers so that i just dont get stopped out on any position :)

anyways thx asgain!!!

-Dan
 
aah.. looking over the posts again, I think I may have misinterpreted your description. I think (correct me if I"m wrong) that you are updating the variable cell "I", dynamically in real-time, and want the j value threshold functions to track, then lock on that dynamically changing cell, once the threshold is triggered? That is why I think you kept referring to the adjacent J cell, and not the prior J cell, no? In which case, the earlier posters understood your request better.

Two ways to solve:
1) I assume you must be using vba to dynamically update the cell "I", in which case you can create a latch function in vba to do what you want. This is the better approach and does not require extra columns/cells.
2) If you want to keep it in excel, you must create an additional adjacent cell, "K", to serve as a counter/register that will hold your latch value. One other cell, (K1) will be used to reset it Follow the instructions on the image i attached. If you want to update multiple cells, just copy the formulas down.

dt98
m8phrn.jpg


P.S. I used cells "I/J/K" in this example, instead of "J/K", but I think you can follow.
 
You must log in or register to reply here.
Back
Top