Our New PRO Service Includes Powerful User-Defined Indexes


Hello Fellow ChartWatchers!

Last weekend's ChartCon conference in Seattle was amazing.  Myself and the other newsletter authors met so many terrific people during the event and the feedback that we are getting from the attendees is extremely positive.  Thanks again to everyone that attended!

We made several big announcements at ChartCon, but the biggest had to be the announcement of our new PRO service.  PRO is a new service for members that want to break through the limitations of our Extra and ExtraRT services.  15-second refresh rate too slow for you?  PRO refreshes every 5-seconds.  1500-pixel charts too small?  PRO goes up to 2500-pixels.  Five user-defined alerts not enough?  PRO users can have 50.  Click here for a complete list of PRO's features and how they compare to our other services.

(Just so you know, PRO is not intended for everyone. If Basic or Extra works well for you then please don't feel compelled to upgrade. Only upgrade to PRO if you really need one or more of PRO's features.)

While PRO has a lot of features to talk about, right now I want to focus in on what I think it its most powerful feature: User-Defined Indexes.

A User-Defined Index is a dataset that you create and maintain.  You enter the data - either by hand or via an spreadsheet upload - and then you can chart it and analyze it using our SharpCharts tool.

So, what can you do with a User-Defined Index?  Here's a partial list of ideas:

  • Create and chart your own Bullish Percent Index
  • Create and chart any other sentiment information you can think of (# of CNBC commercials per day anyone?)
  • Upload and chart economic data from the St. Louis Federal Reserve
  • Upload and chart any of the datasets from websites like
  • Calculate your own technical indicator using Excel formulas and chart the results
  • Eliminate "bad" datapoints from our regular data and chart your corrected version
  • and much, much, much, much more...

Are you starting to get excited?  Before we get too much farther however, I do need to mention that there are some limitations for User-Defined Indexes:

  • Right now, only PRO users can create and use them.  That may change in a year or so after we've made sure that our systems can handle their performance impact. 

    UPDATE: PRO, ExtraRT and Extra members can now create various kinds of User-Defined Indexes.
  • Initially, PRO users can only use one single User-Defined index.  (They can re-use it as often as they want however.)  We plan on allowing PRO users to create several additional indexes at some point in the next couple of months. 

    UPDATE: PRO Users can create up to 30 User-Defined Indexes.  ExtraRT and Extra members can only create one.
  • PRO users can access their data via the special @MYINDEX ticker symbol.  In the future, we will allow PRO users to specify their own ticker symbol and description for their indexes. 

    UPDATE: PRO Users can give their indexes any ticker symbol they want (as long as it starts with "@").  ExtraRT and Extra members can only have one index named "@MYINDEX."
  • User-Defined indexes can only store daily, weekly, monthly, quarterly or yearly data.  They cannot store intraday data.

OK, enough with all the legal-sounding limitations.  Let's see these things in action!

Charting the Quarterly Rate of Change for the US GDP

The St. Louis Federal Reserve maintains a treasure trove of free economic and financial data on its "FRED" website.  Click here to see for yourself.  Included on that site is the quarterly data for the US GDP going back to 1947.  To download that data, go to the FRED website and click on "Real GDP" in the middle of the page, then click on the "Download Data" link that appears on the left side of the page.  Finally, select "Text, Comma Separated" as the "File Format" and click the "Download Data" button to store the CSV file of that data on your computer's hard disk.

Next, assuming you are a PRO member, you'd go to the Member's homepage and click on the "User Defined Indexes" link at the bottom of the "PRO Control Center" part of the page.  If you already had some data in your index, you'd need to clear it out by clicking the "Delete All Data" link.  (This assumes that you have a copy of your old index data stored on your hard disk.)  Then you'd click the "Upload Spreadsheet Data" button, select the CSV file you just downloaded from FRED, and click "Upload".  Finally, if the upload was successful you can click on the "View Chart" link to see @MYINDEX in all of it's glory!


Hmmm...  That doesn't look too impressive does it?  See if you can spot the problem before reading the next paragraph.

The problem is that this is a daily chart however the GDP data from FRED is quarterly data.  (If you spotted that on your own then good for you!)  Let's change the chart settings to Quarterly (another PRO-only feature by the way) and remove all of the default indicators and overlays since we won't be needing them.  We'll also change the chart's Type to "Area", the color to green, and lower the Opacity a smidge to make things look better.  And voila!


There's a GDP chart going back to 1980! Terrific! But wait a second. FRED gave us data going all the way back to 1947.  To see all of that data, we need to change the "Bar" setting in the "Range" area of the chart from 5 to 1.  That will allow SharpCharts to squeeze that extra data onto the left side of our chart.  (We also need to turn off log scaling.)  Here's the result:


Wow, a chart going back to 1947 - that's also a new PRO feature.  Basic and Extra charts can only go back to 1980.

So now, let's add the Rate of Change (ROC) indicator to this chart to see the quarter-to-quarter fluxuations in the GDP. We'll choose "Rate of Change (ROC)" from the Indicator dropdown below the chart and we'll use "2" as the parameter so that we get the quarter-to-quarter change.  Finally, we can choose "Behind Price" for the position so that it is overlaid on top of the GDP plot.  Here's the final result:


Pretty cool huh?  (Check out the dates where the ROC line dips below its dashed zero line.)  We could use any other technical indicators or overlays that we want to in order to further analyze this data.  We could annotate it, store it in a ChartList, and even compare it to $INDU, $SPX or any other ticker symbol.  Powerful stuff!

Finally, keep in mind that I can do the same thing with ANY time-series data that I can somehow get into a CSV file - i.e., anything that I can get into Excel.  I don't know about you, but my mind is still boggling over that.

For more on all the new features we've been introducing over the past week, be sure to read the recent articles in the "Chip Anderson" area of our Blogs section.  I'll be posting more examples of things you can do with User-Defined Indexes in that area in the coming days so check back often.

- Chip

P.S. If you are interested in upgrading to PRO (or seeing how much that would cost), click on the "Your Account" link in the upper right corner of any of our webpages.

Chip Anderson
About the author: is the founder and president of He founded the company after working as a Windows developer and corporate consultant at Microsoft from 1987 to 1997. Since 1999, Chip has guided the growth and development of into a trusted financial enterprise and highly-valued resource in the industry. In this blog, Chip shares his tips and tricks on how to maximize the tools and resources available at, and provides updates about new features or additions to the site. Learn More
Subscribe to ChartWatchers to be notified whenever a new post is added to this blog!
comments powered by Disqus