Skip to main content

Stock Inspector Tips & Tricks -- fix bad "flash crash" data points

We haven't had another "flash crash" in a while but I still see crazy data points hanging around that can play havoc with stock charts.

When I go to a site like StockCharts.com, for example, and look at an ETF like IGW, the iShares Semiconductor ETF, there is a "flash crash" data point back in May that dips down below $15 on a day when the ETF was trading mostly in the mid-$40's. This data point makes the chart almost unreadable and tends to skew the technical analysis algorithms.

Did you know that if you are using Trade-Radar Stock Inspector, you can fix this wacky data point and get your technical analysis back on track?

You've probably noticed those fields on the right-hand side of the main screen in Stock Inspector. Those fields display the date, the open-high-low-close and volume data for the stock or ETF. Using the arrow buttons on the toolbar, you can sequence through that data and get to any date you choose.

Once you do find the wacky data point, you can click the Edit button on the toolbar and modify the data. To fix the flash crash situation, update Low value of the stock price to a value that is more reasonabke. Click the Save button on the toolbar and you're done.

The next time you look at the chart, it won't be thrown off by some data point out of left field.

One further piece of advice: when you load new data for that stock symbol you should choose a start date after May 2010 so you don't overwrite the data you just fixed.

If you're interested in trying Trade-Radar Stock Inspector, please go to our Download page and take advantage of the free 45-day trial.
Labels:

Comments

Anonymous said…
Appreciate the tip

I wonder how this approach could be made to work when doing a batch download. I have txt file with my holdings in it, but I don't think there is an option to set date ranges when doing a batch download,

Thanks
August 27, 2010 at 7:38:00 AM EDT
Trade Radar Operator said…
Stay tuned! I'm working on a new version that will include an option to set default date ranges.
September 1, 2010 at 10:43:00 PM EDT

Post a Comment

Popular posts from this blog

Time to be conservative with your 401K

Most of the posts I and other financial bloggers write are typically focused on individual stocks or ETFs and managing active portfolios. For those folks who are more conservative investors, those whose main investment vehicle is a 401K, for example, the techniques for portfolio management might be a little different. The news of stock markets falling and pundits predicting recession is disconcerting to professional investors as well as to those of us who are watching our balances in an IRA or 401K sag. What approach should the average 401K investor take? Let's assume that the investor is contributing on a regular basis to one of these retirement accounts. There are two questions that the investor needs to ask: 1. Should I stop putting the regular contribution into stocks? My feeling is that investors making regular contributions are being handed a present by the markets. Every week the market goes down, these investors are lowering their average cost. When markets reco...
7 comments
Read more

The Trouble with Trend Reversal Indicators

Many of us use various trend reversal indicators to time our trades. Our desire is to determine when prices have changed direction so that we can ride the new trend. Why doesn't it always work out? The first reason, of course, is that unforeseen events often drive prices in unexpected directions. That is something we can't change and it often makes all of us technical traders crazy. On the other hand, sometimes an unforeseen event is a prelude to a new trend. A stock spikes up on a what seems to be a one-time piece of good fortune and soon falls back. Does it start making its way back up or does it resume a previous down trend? The conflict within trend reversal indicators is that, though they can definitely tell when prices change direction, they suffer from two problems. One, they often can't determine how significant that move in prices actually will be. Two, they are often lagging indicators. As such, they can be late in providing a signal, sometimes leading the investo...
1 comment
Read more

Brazil - in a bubble or on a roll?

A couple of years ago, no one recognized the real estate bubble even though it was under everyone's nose. Now, analysts and bloggers are seeing bubbles everywhere they look. One of them, they say is in Brazil whose Bovespa stock market index has doubled in the last 12 months. Does the bubble accusation hold water? I don't think so and here are 7 reasons why Brazil is by no means a bubble economy: Exports have held up over the past year thanks to demand from China for Brazil's soya exports and iron ore. This was helped by the the Brazilian government's drive to improve trade links with Asia and Africa. Export diversification, spurred by a more active trade policy and increased focus on "south-south" trade under current president Lula, helped mitigate the decline in demand from OECD (Organization for Economic Co-operation and Development) countries A "sensible" economic framework has been in place since the 1990's. This has included inflation ...
4 comments
Read more