Find Low of Bar the Last Time a Condition Was True

March 5th, 2021, 04:16 PM

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

March 5th, 2021, 04:43 PM

@EKTrade what trading platform?

March 6th, 2021, 09:15 PM

Sorry. TD Ameritrade / thinkorswim

March 7th, 2021, 05:30 AM

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.

March 8th, 2021, 01:00 AM

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);

March 9th, 2021, 12:58 AM

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

March 9th, 2021, 01:56 AM

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);

March 10th, 2021, 01:18 AM

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