This shows you the differences between two versions of the page.
| Next revision | Previous revision Last revision Both sides next revision | ||
|
chartlists:how_do_i_upload_multiple_symbols_to_a_chartlist_from_a_spreadsheet [2019/07/01 21:26] 127.0.0.1 external edit |
chartlists:how_do_i_upload_multiple_symbols_to_a_chartlist_from_a_spreadsheet [2022/07/22 22:59] betseyp [Upload the Spreadsheet Data to Your ChartList] |
||
|---|---|---|---|
| Line 9: | Line 9: | ||
| You can use Excel or any program that can create CSV files. If you already have a spreadsheet created, skip to the next step. | You can use Excel or any program that can create CSV files. If you already have a spreadsheet created, skip to the next step. | ||
| - | - 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.) | + | - 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 1000 ticker symbols, so do not try to upload more than 1000 to a list.) |
| - (Optional) Add chart names and/or descriptions for each symbol into the second column of the spreadsheet. | - (Optional) Add chart names and/or descriptions for each symbol into the second column of the spreadsheet. | ||
| - (Optional) Add comments for each symbol in the third column of the spreadsheet. | - (Optional) Add comments for each symbol in the third column of the spreadsheet. | ||
| Line 16: | Line 16: | ||
| ===== Upload the Spreadsheet Data to Your ChartList ===== | ===== 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 your desired ChartList. | + | First, go to the "Your ChartLists" section of Your Dashboard, then select "Edit List" from the "View As" dropdown menu next to your desired ChartList. |
| - | 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. | + | Click the green "Add Symbols" button at the top of the page and choose the "Upload CSV" tab. Click the "Browse" button and select your CSV file from your computer. Then, click the green "Upload" button. |
| {{:chartlists:upload2.png?500|}} | {{:chartlists:upload2.png?500|}} | ||