Chip Anderson

Commodity Data at StockCharts - Past, Present, and Future

 | 

Today we removed the Open, High and Low data from many of our commodity based indexes like $SILVER and $USD.  Those charts now appear as line charts connecting individual closing points instead of the bar or candlestick charts people saw before.

Some people are not happy with us for making this change.  I understand that frustration.  If there were some other way to fix the issue, we would have done that instead.  Here are the reasons for removing that data:

The number one reason for removing that data is because after a long investigation, we have lost faith in the accuracy of those data points.  As we completed our transition off of the ThomsonReuters datafeed and onto the IDC datafeed, we were forced to take a hard look at the "continuous contract" data we've been receiving from Thomson for years.  In the course of comparing that data to other sources, we noticed large numbers of discrepancies with the Open, High and Low data points.  (The Close data points were reliable however.)

Drilling down into the raw data, we saw that many of the problems occurred because the data was inconsistent with itself.  By that I mean that the closing value was lower than the low or the closing value was higher than the high.  Our system automatically adjusts for those inconsistencies so that crazy looking candles don't show up on the charts but the bar and candlesticks on those charts were often inaccurate.

For example, if we saw an End-of-Day quote where the Open was 10, the High was 11, the Low was 9, and the Close was 7 (i.e. lower than the low) what should we do?  Do we move the Low down to 7?  Do we move the Close up to 9?  Do we throw it all out?  It's pretty much a lose-lose situation regardless of what we choose.

Unfortunately, what we discovered this week is that lots of the Open, High and Low values for our EOD commodity based indexes were having that exact problem occur frequently and the problem had been going on for some time.

As long-term subscribers know, accuracy is a big deal with us here at StockCharts.  We work very hard to provide data and calculations that are as accurate as possible.  Faced with the reality that large amounts of our EOD commodity data was incorrect, I decided to have it removed rather than continue to potentially mislead people.

That difficult decision was made easier by the fact that we have always been up-front with people about the nature of our commodity based indexes.  Specifically, our support area has contained the following warning for years:

"We do provide end-of-day charts of certain commodity indexes.  Those charts are based on the non-tradeable "continuous" contract for each commodity.  They are designed to help equity traders understand the mid- and long-term directions of various commodities for help with making decisions about trading equities.  They are not designed for actual futures trading."

We have been very careful over the years to never bill ourselves as a commodities web site.  We are an equities web site.  We are not FuturesCharts.com; we are StockCharts.com.  We do not have access to a full commodities data feed and we have never provided charts or data for actual commodities contracts.

Given those warnings and the end-of-day nature of our commodity charts, I was hopeful that this issue would not affect many people.  Given the proper mid-to-long-term perspective, a close-only chart and a OHLC chart provide you with the same general information about the direction and performance of an index.

For example, many people do what John Murphy suggests and use Intermarket Performance Charts and Ratio charts to compare indexes.  Both of those charting styles focus on closing values, not Highs and Lows and so that kind of analysis is not affected by this change at all.

The problems occur when people made incorrect assumptions about what our commodity charts were based on and began using them to make commodity trading decisions.  To those people I say the same thing now that I've always said about this matter:  Don't use our EOD commodity charts for making futures trading decisions!

In many ways I believe that removing the Open, High, and Low from those charts is a good thing because it re-reinforces the purpose of those charts and minimizes the chances that they will be misused in the future.

Speaking of the future, what comes next?

It has always been StockCharts.com's intention to add legitimate, tradable futures data to our website at some point.  It is still our intention to do that.  The economics of acquiring and redistributing that data legally is still very challenging however and so we are still unable to provide real futures charts at this time.

That said, we are continuing to look for possible "middle-ground" solutions which would allow us to provide, for example, delayed spot prices for popular commodities.  (The great irony here is that the search for better commodity data is what led us to discover the bad OHL data in our current indexes.)  At this point, we still have not found a solution for commodities data beyond what we currently provide but we are continuing to look.

In summary:

  1. The old commodity data for Open, High and Low was incorrect and has been removed.
  2. Our commodity indexes shouldn't be used for trading.
  3. You can still do trend, performance and ratio analysis of our current commodity charts which is always how we intended them to be used.
  4. Better commodity data will be available at some point in the future but we do not know when.

 

- Chip

Chip Anderson
About the author: is the founder and president of StockCharts.com. He founded the company after working as a Windows developer and corporate consultant at Microsoft from 1987 to 1997. In this blog, Chip shares his tips and tricks on how to maximize the tools and resources available at StockCharts.com, and provides updates about new features or additions to the site. Learn More
Subscribe to Chip Anderson to be notified whenever a new post is added to this blog!
Great transparent action! Keep up the great work!
I agree with the comments above - keep it accurate and transparent, good work.
A >massive< thumbs down for the data providers. Not being able to provide a correct high, low, opening and closing value is beyond mind boggling. African exchanges can do that! It's simply so backward that I'm speechless!
Leave it to ThomsonReuters... SC is probably better off not even paying the higher cost of dealing with commodity charts, since commodity traders would be (or should be!) using contract-specific charts, which they can get from their brokerage platforms. And there seems to be so much variation among different websites and their continuous contract charts - better to keep the focus on doing what you're already doing - producing outstandingly clean and accurate equity charts. Or, just limit the continuous contract commodity charts to weekly and/or monthly, for both bar and point & figure. Or perhaps instead of using continuous contract charts, how about spot market charts for the precious metals and currencies - provided they are reasonably priced.
I came close to becoming a member . I like what you have done but I need to find another provider of Gold Silver candlestick. Thank you for your honesty
Almost any computer can find data numbers like highs and lows within a series. I agree with you that false numbers are no good to anyone. thomasonReuters data feed should be ashamed at there lousy performance, If I were you I would ask for a partial refund from them. If they caused you a lawsuit because of lousy data numbers would they offer to pay your lawyer bills,,, no I don't think so. You need a discount from them of some sort. Thank you for your honesty and your expalination, I understand your reasoning.. I must say, I really do appreciate candlesticks over a straight line, but I won't give up on your stock charts they are simply the best. Thanks again
I really, really, really miss the candlesticks, although I get it. I'll be glad when they reappear ;) RESPONSE: We're working hard on getting replacement data that is accurate.
Well done and thanks for your decision. I have known about this for years and actually pointed it out several times years ago. All I got back were machine programmed answers. I have since done my own personal data gathering for years and then make my own charts from that. I am glad to see that finally there are industry leaders that are noting the data fraud and pointing fingers are the correct culprits.
I can follow your clear arguments - thanks for that. Anyway I'm missing the daily candlesticks for commodities very much. I have been trading commodities (f.ex. silver) with the help of your charts - and it was pretty good... So I hope, that you will find s.th. else very quick. Cheers from Germany Roland
Thanks for your transparent and open action. I have long noticed this exact problem, and wondered about this and other discrepancies between various data providers. Sadly, for many reasons, it is getting more and more difficult to believe that markets actually serve as a price discovery mechanism. I hope SC will be able to locate an honest and accurate data provider sometime in the future, and reinstate the use of candlesticks for commodities. I wish you success !
comments powered by Disqus