try changing StochRSI = (rNum/rDen)* 100; to
StochRSI = Nz((rNum/rDen)* 100); Best Regards Rick Osborn ________________________________ From: Pete H <[email protected]> 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 :-)
