Hi Bruce,

I'm trying to recreate the volatlity stop in excel, could you share how it is calculated.?

Thanks

Thanks so much, Bruce!

Hi Bruce,

Thank you so much, would it be possilbe to trouble you for a bit more assistance, please.  Could we also convert the following sell signal to Heikin-Ashi as well?

C < L1 AND TrueInRow(C1 > L2 AND C1 < H2, 35) = SinceTrue(C1 > H2, 35)

Thanks again, Bruce, the above formula works great.  Is there a way to convert it for use in Heikin Ashi?  I tried converting it using the standard defintion of Heikin ashi without much success...

(O + H + L +C)/4 > MAX(H1, O1,C1) AND TrueInRow((O1 + H1 + L1 +C1)/4 > MIN(L2,O2,C2) AND (O1 + H1 + L1 +C1)/4 < MAX(H1,O1,C1), 4) = SinceTrue((O1 + H1 + L1 +C1)/4 < MIN(L2,O2,C2), 4)

Any insight is appreciated.

Thanks

Wesley

I&#39;m wondering if there is a more elegant solution than what I&#39;ve written below.  Essentially, what I&#39;m attempting to code is a True or False condition for turning points.

I&#39;m defining the turning point as a candle where today&#39;s close is greater than yesterday&#39;s high (C > H1) and the candle prior to that the Close was below the prior Low (C1 < L2).   

(C > H1 AND C1 < L2) OR

(C > H1 AND (C1 > L2 AND C1 < H2) AND C2 < L3) OR

(C > H1 AND (C1 > L2 AND C1 < H2) AND (C2 > L3 AND C2 < H3) AND C3 < L4) OR

(C > H1 AND (C1 > L2 AND C1 < H2) AND (C2 > L3 AND C2 < H3) AND (C3 > L4 AND C3 < H4) AND C4 < L5)

Here is a link of what I am attempting to accheive using ADBE as an example, the red arrows are the turning points.

The above coding does the job, but was just curious if there was a simpler, more elegant way to code it.

Thanks

https://www.screencast.com/t/YKbbx4zTl

Hi

I need some help, if doable, in TC2000, tryin gto calculate the ratio of today&#39;s retun/yesterday&#39;s 20 day std deviation of return?

• Calculate daily returns as: return = today's close / yesterday's close - 1

• Calculate standard deviation of daily returns over a 20 day window. In quasi-Excel langauge:: stdev = stdev(returns, 20)

• Calculate today's sigma spike: SigmaSpike = today's return / yesterday's stdev

I&#39;m not sure there is a way to do this in TC2000 but thought to ask, since there have been several new versions rolled out recently with updated PCF coding...

If possible, I&#39;d like to replicate the Andrew Abraham trend indicator from the 1998 Stocks and Commodities magazine....

Basicaly, the plot should compare today&#39;s close vs the Daily High in the priior  21 days minu the 21 day ATR and today&#39;s close vs the Daily Low in the prior 21 days plus the 21 day ATR and plot the following

If C > [MAXC.21 - ATR(21) AND MINL.21 + ATR(21)] then plot MAXC.21 - ATR(21)

If C < [MAXC.21 - ATR(21) AND MINL.21 + ATR(21)] then plot MINC.21 + ATR(21)

If neither of the above is true, then plot the previous day&#39;s value.

I am able to create PCF for MAXC.21 - ATR(21) and MINL.21 + ATR(21)] but unsure how to nest them to create condiational statements - if this is even possible.

Any help appreciated.

Thanks

Wesley