Number of days above 20dma

Optuma Scripting
1

Another tricky one for me. How do I find the number of days price has been above the 20dma since the last cross?

ma20 = MA(BARS=20, CALC=Close);
cond = CLOSE() CrossesAbove ma20;
knt = MagicFormulaUsing(cond);
knt

knt should be ‘x’ days from the cross until the current day. The attached image should show knt=15 (or 14 ignoring the crossing day).

Thanks. Andy

SPY.png
SPY.png1878×927 45.9 KB

2

Hi Andy,

The function you’re looking for is TIMESINCESIGNAL. Here it is in your code:

// Andy #55261 Close Above 20MA, Days 
ma20 = MA(BARS=20, CALC=Close); 
cond = CLOSE() CrossesAbove ma20; 
//knt = MagicFormulaUsing(cond); 
knt = TIMESINCESIGNAL(cond,UNIT=Days, FIRSTSIGNALONLY=False); 
knt

You can show the result in a SHOWVIEW or, if you only want the number of days since the last cross you can use CHART ELEMENT, both shown in the following screenshot:

20191102 Andys script

Cheers

Trevor

 

3

Thanks Trevor! Works great.

4

Here are some more TIMESINCESIGNAL examples:

https://forum.optuma.com/topic/timesincesignal-formulas/