Filter high and low spikes

This item doesn't contain any downloader, but it contains a script, in the Post-Script, that filters quotes from bad high and low prices. The filtering method consists of guessing which bars had bad intraday ticks that result in big spikes in an historical chart. (The candlestick bar has long shadows). These long shadows are often bad and could results in misleading backtesting results.

The idea of this filter is to calculate the standard deviation of the daily range (high price - low price) and then remove all the shadows from the bars where the range exceeds three standard deviations. This filter could be added to any downloader that downloads quotes data. The filter could be applied to stocks, futures, ETFs, options...

Explanation: A candlestick bar is composed of a body, an upper shadow and a lower shadow. The body is the region between the open and close price. The upper shadow is the region between the open or close and the high price, and the lower shadow is the region between the open or close and the low price.

Technical Analysis

• Geometric Moving Average Indicator
• Coefficient of Variation - Relative Standard Deviation
• Supertrend Indicator
• Keltner Channel Breakout Strategy
• Trading System Template: Position Sizing Techniques
• Camarilla Pivot Points Study
• Avgerage Correlation
• CRB Global Commodity Equity Index
• NYSE, AMEX and NASDAQ 52-week high and low data
• Technical Analysis Continuation Pattern: Descending Triangle Indicator
• More trading objects...

Fundamental Analysis

• Earnings after and before market opens
• Price to Sales Ratio for US Stocks
• Forex News from XE
• Finviz Downloader
• Short selling indicator
• Industry Relative Strength
• Small Business Optimism Index
• Historical Jobless Rate
• Yahoo Historical Buy/Sell Recommendations
• Gross Domestic Product - Historical data
• More trading objects...