Chip Anderson

New Feature: Uploading Ticker Symbols from a Spreadsheet

 | 

During the last ChartCon conference in Seattle, one of the most common pieces of feedback I got was "Is there any way to upload a list of ticker symbols into a ChartList from Excel?"

By the end of the conference, I was promising everyone that we'd add that feature to the site "very soon."

It turns out that "very soon" means... today!

We're pleased to announce the Beta test version of our new "Add Symbols -Upload" feature for Basic and Extra members that want to insert symbols from a spreadsheet into one of their StockCharts ChartLists.

You'll find this new feature on the "Edit" view page of any ChartList.  It's in the "Add Symbols" box.  Here's a screenshot:

UploadScreenShot

The new feature is inside the blue box.

Step One: Create/find a spreadsheet with a column of ticker symbols that you want to import into a ChartList.  Note: A ChartList cannot hold more than 500 ticker symbols.  You can use Excel or any program that can create CSV files.

Step Two: Copy and paste that column of ticker symbols into the first column of a new spreadsheet.  Note: Make sure the column doesn't have any heading and that there aren't any black rows in the middle of the list.

Step Three: (Optional) Add "Descriptions" for each symbol into the second column of that spreadsheet.

Step Four: Save that new spreadsheet to your harddisk in "Comma Separated Variable (CSV)" format.

Step Five: Log onto StockCharts and either create a New ChartList or view one of your existing ChartLists in "Edit" view.

Step Six: Click the "Choose File" button in the "Add Symbols" area.

Step Seven: Select your newly saved CSV file from your hard disk.

Step Eight: Click "Upload"

Step Nine: Review the preview of your import and fix any problems that get reported, then click "OK"

Step Ten: Stand back as the magic happens!

When the dust clears, you should have default format charts in your ChartList for each of the ticker symbols in your spreadsheet.

If you have any problems with our Beta test version of things, please let our Support Team know.

Enjoy!

- 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!
This is great! It worked perfectly. Thanks chip, this is exactly what I wanted.
Awesome, Thank you!!!!
Excellent!! I've been waiting for this for some time.
comments powered by Disqus