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

• Highest and Lowest value over a dynamic period
• Market Rule based on the Crossover Between Stock Close prices and their Moving Average
• NYSE Advances and Declines
• High to low stock pattern for the close price
• Keltner Channel Market Composite
• Relative Momentum Index
• CBOE S&P 500 BuyWrite Index
• TSP Sentiment Survey - Percentage of Bullish and Bearish Traders
• Triple Period Indicator
• R Squared of a Trading System Equity Curve
• More trading objects...

Fundamental Analysis

• Historical Index Composition
• Business Outlook Survey diffusion indexes
• UK Economic Data - Average Earnings Index
• Initial Jobless Claims - Historical data
• Extensive Fundamental Data for U.S. Stocks
• Producer Price Index - PPI
• Insider trading data
• FOMC meeting dates
• Earnings Surprise Strategy
• Percentile Rank of PEG, Price/Free Cash Flow and Price/Sales
• More trading objects...