TrendSpider members can copy and paste our ChartLists into a Watch List.


To import our ChartLists into TrendSpider:


First, locate the ChartList of interest on our site and download the Excel version.


Next, you will need to make a few edits to the Excel file in order to ensure compatibility with TrendSpider. First, you will need to delete the header row, if applicable, and delete any columns beyond Column A. The list should now be limited to ticker symbols and will look like this:


TrendSpider does not support Excel file import; however, ticker symbols separated by comma can be copied and pasted. We'll need to use a few Excel formulas to accomplish this.


First, select cell B1. Enter the following formula exactly as written:

=A1&","


You should now see the symbol with a comma in cell B1. Copy cell B1 and paste down Column B for every ticker symbol. 

You should now see the list of ticker symbols, each followed by a comma, in Column B. Next, select cell C1. Enter the following formula exactly as written:

=CONCAT(B:B)


You should see the entire list of ticker symbols, separated by commas, in cell C1. Now, copy cell C1. This is the format that you will paste into TrendSpider.


How to Create a Watch List in TrendSpider (Source)


Click the "Widgets" button. 


Click "Watch Lists." 


Click the three horizontal dots to delete, edit, or create a new Watch List. 


Paste the ticker symbols that you previously copied in Microsoft Excel (cell C1). Click Save. You should now see the symbols listed in your Watch List.


Complete!