Thank you Rick, that did the job quite nicely. Pete :-)
--- In [email protected], Rick Osborn <ri...@...> wrote: > > try changing > StochRSI = (rNum/rDen)* 100; > > to > > StochRSI = Nz((rNum/rDen)* 100); > > Best Regards > Rick Osborn > > > > > ________________________________ > From: Pete H <dryhe...@...> > To: [email protected] > Sent: Sat, October 31, 2009 11:27:14 PM > Subject: [amibroker] Missing Data causes formual to fail > > > Drop this formula into a new pane on a daily chart of EWD. > > _SECTION_BEGIN( "Stoch RSI"); > rNum = (( RSI( 13) - LLV( RSI( 13 ) , 8 ))); > rDen = (HHV( RSI( 13) , 8 ) - LLV(RSI( 13 ), 8 )); > StochRSI = (rNum/rDen)* 100; > printf("DTosc: " +MA(StochRSI, 13) +"\n"); > > Plot(MA(StochRSI, 13),"Stoch RSI", colorRed,styleLine) ; > > Plot(MA(C,13) ,"MA 13", colorGreen,styleDot s); > > Plot(RSI(13) ,"RSI", colorBlue,styleDash ed); > _SECTION_END( ); > > Scroll back to 10/29/1996 and notice the plot for the Stoch RSI goes to zero > and stays there for the next couple of years. There are a lot of gaps in the > data, at lest from my vendor. I believe the gaps are causing the Stoch RSI to > drop to zero, but why? This apparently has no affect on the MA of close nor > on the regular 13 period RSI. So what's going on and how do I modify the math > to give accurate results while preventing the Stoch RSI from dropping to zero > due to the missing data? > Thanks. > > Pete :-) >
