How do I upload multiple symbols to a ChartList from a spreadsheet?

How do I upload multiple symbols to a ChartList from a spreadsheet?

A great option for adding a large number of symbols to a ChartList at once is to upload the data from a spreadsheet.

Create or Find the Spreadsheet With the Ticker Symbols You Want to Upload

You can use Excel or any program that can create CSV files. If you already have a spreadsheet created, skip to the next step.

  1. Copy and paste a list of ticker symbols into the first column of a new spreadsheet. Note: Make sure the column doesn't have a header row and that there aren't any blank rows in the middle of the list. A ChartList cannot hold more than 500 ticker symbols, so do not try to upload more than 500 to a list.
  2. (Optional) Add Chart Names/Descriptions for each symbol into the second column of the spreadsheet.
  3. (Optional) Add Comments for each symbol in the third column of the spreadsheet.
  4. Save the spreadsheet on your computer in “Comma-Separated Value (CSV)” format.

Upload the Spreadsheet Data to Your ChartList

First, go to the “Your ChartLists” section of Your Dashboard, then select “Edit” from the “View As” dropdown menu next to the ChartList you want to upload the ticker symbols to.

In the “Add Charts to List” section, click on the “Upload CSV” tab. Click the “Choose File” button, and select your CSV file from your computer. Then click the green Upload button.

Once the CSV file has been uploaded, it will show the symbols, descriptions, and comments to be added. Click “OK” to add those symbols to your ChartList.

Note: If there are any symbols in your CSV file that are not in our database, you will not be able to upload the file. In that case, open the file and remove those symbols, then try uploading again.