Find Low of Bar the Last Time a Condition Was True

(login for full post details)

I want to be able to search back on a chart to find the last time that a condition was TRUE. One condition I was searching for is below.

PPS()."BuySignal" is true and close is greater than MovAvgExponential("length" = 200)."AvgExp"

The reason I am searching backwards is to find out what the low of that bar would be...

If that is possible, can I check what the low of the bar before the condition was... - 1 bar?

Basically, is there code to help me pinpoint a bar and determine facts about it? open, close, etc.

Thanks for your help!
EK

(login for full post details)

@EKTrade what trading platform?

(login for full post details)

Sorry. TD Ameritrade / thinkorswim

(login for full post details)

EKTrade

Sorry. TD Ameritrade / thinkorswim

Ok, I don't use that platform so I can't advise, but I have moved your question to the ThinkOrSwim thread - you should have better chances to get a reply here.

Good luck.

(login for full post details)

Its a bit awkward, but you reference the previous value using a positive offset, but mark the candle condition with a negative one.

Hope this helps,
Jay

Code

def condition = PPS()."BuySignal" is true and close is greater than MovAvgExponential("length" = 200)."AvgExp";

AddChartBubble(condition, high, "Prev Low: " + low[1], Color.CYAN);

AddChartBubble(condition[-1], low, "Bar Low: " + low, Color.GRAY, up = No);

(login for full post details)

Thank you. That works great for putting the indicator on the chart. How would I use this date in a formula? I want to look back and find the low of the code below.

PPS()."BuySignal" is true and close is greater than MovAvgExponential("length" = 200)."AvgExp"[-1], low;

I am missing a couple of things though. I am trying to setup an autosell feature based on price falling below the code that you provided. Do you know how to best write that? I can't find code that references the present price. I found EntryPrice () to calculate other formulas, but I want to sell based on present price... not close from 1 bar ago.

Appreciate the feedback!
EK

(login for full post details)

I think you're asking how to capture the low value for use on the current bar. The general idea is to store it, overwrite it anytime the condition is true, otherwise use the stored value.

Code

def condition = PPS()."BuySignal" is true and close is greater than MovAvgExponential("length" = 200)."AvgExp";
AddChartBubble(condition, high, "Prev Low: " + low[1], Color.CYAN);
AddChartBubble(condition[-1], low, "Bar Low: " + low, Color.GRAY, up = No);

def lastCondLow = if condition then low[1] else lastCondLow[1];
def LastBar = !IsNaN(open) and IsNaN(open [-1] );
AddChartBubble(LastBar, high, "Last Cond Low: " + lastCondLow, Color.YELLOW);

(login for full post details)

That worked like a charm! Much appreciated... I put up a different post a minute ago... if you can take a look at that. You'd really be helping me out. Again, thanks a lot!

Find Low of Bar the Last Time a Condition Was True

Discussion in ThinkOrSwim

Find Low of Bar the Last Time a Condition Was True