How Can I Add Symbols from a CSV File to a ChartList?


Chartists can add symbols from a csv file in four easy steps. First, create a csv file using Excel, Numbers or another spreadsheet program. Place the symbols in the first column and the names in the second column. Save the file as a CSV file.

Screen Shot 2014-02-13 at 4.30.03 PM


The second step is to choose an existing ChartList of create a new ChartList. In this example, we will create a new ChartList. Users can manage their Chartlists by clicking the Members tab at the top of any web page or clicking the "edit list" link above any SharpChart. Once in the ChartList section, choose "Create New List" and enter a name, such as stocks-top100.

Screen Shot 2014-02-13 at 4.33.16 PM

The page will then refresh and you will be in your new ChartList. The third step is to scroll down to the "Add Symbols" section to find the "Choose File" button. Click this bottom, navigate to your csv file and select it. After the file name appears next to the "Choose File" button, click, "upload" to add these symbols. The page will refresh and you will see the symbols/names for upload. Click "OK" to finish the upload.

Screen Shot 2014-02-13 at 4.35.46 PM

Here is a sample CSV file that contains the top ten stocks for QQQ and the nine sector SPDRs.

Good day and good charting!

Arthur Hill
About the author: , CMT, is a Senior Technical Analyst at He has written articles for numerous financial publications including Barrons and Stocks & Commodities magazine. Focusing predominantly on US equities and ETFs, his systematic approach of identifying trend, finding signals within the trend, and setting key price levels has made him an esteemed technician. In addition to his CMT designation, Arthur holds an MBA from the Cass Business School at City University in London. Learn More
Subscribe to MailBag to be notified whenever a new post is added to this blog!
comments powered by Disqus