[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Missing Data causes formual to fail



PureBytes Links

Trading Reference Links



try changing
StochRSI = (rNum/rDen)* 100;

to

StochRSI = Nz((rNum/rDen)* 100);
 
Best Regards
Rick Osborn



From: Pete H <dryheat3@xxxxxxx>
To: amibroker@xxxxxxxxxxxxxxx
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 :-)



__._,_.___


**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/





Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___