Import Symbol List: Difference between revisions

Latest revision as of 14:58, 6 June 2024

This tool allows importing text files that contain a list of symbols and their parameters, instead of manually adding symbols one by one.

Preparing a Text File

Your text file must contain a Symbol Name column and may also contain Symbol Root (necessary if it doesn't match Symbol Name), Description, Exchange, and Category.

Each field should be separated by a delimiter: comma, semi-colon, space, tab, or other character.

Symbol Name, Description, Exchange, Category
XYZ, XYZ Corporation, NYSE, Stocks
ABC, ABC Company, NASDAQ, Stocks
ESU9, S&P E-mini, GLOBEX, Futures

The column order does not matter. However, each column must contain the same type of data.
In the example above, the second field of every row must be “Description”. The third field of every row must be "Exchange".

Symbol Description cannot be longer than 63 characters.

Importing a Symbol List

To import a list of symbols, in QuoteManager click the Import Symbol List button or go to File → Import Symbol List:

Use the Browse button to find the file on you machine and open the text file.
Enter the Start Import at Row number.
For example, if the first row in the text file contains column names instead of symbol parameters, start the import at row 2.
Set delimiters and qualifiers
- In Set Data Delimiters, select delimiters used in the text file.
- Check the Treat Consecutive Delimiters as One box to consider consecutive delimiters the same as one delimiter. If this box is checked, consecutive delimiters will not be considered as an empty field.
- Select the Text Qualifier
  For example, the text field is in double quotes (e.g., “MSFT”). If the double quote text qualifier is selected, MultiCharts will recognize that the user wishes to import MSFT without the quotes.
Use the drop down lists to assign the column names to the columns in the text file. If a column is missing in the file, set it to None.
Select Missing Parameters.
- In the Select Data Source drop down list, select the data source for the symbols.
- If the Exchange and Category columns were not previously assigned to a column in the text file, then use the Exchange and Category drop-down lists to specify the information.
Click Finish to import symbols into QuoteManager.

@@ Line 1: / Line 1: @@
-Import Symbol List enables the user to import a text file that contains a list of symbols and their parameters.
+This tool allows importing text files that contain a list of symbols and their parameters, instead of manually adding symbols one by one.
-The feature allows the user to import a list of symbols into QuoteManager quickly instead of manually adding the symbols one by one.
+== Preparing a Text File ==
-== Preparing the Text File ==
+Your text file must contain a '''Symbol Name''' column and may also contain '''Symbol Root''' (necessary if it doesn't match Symbol Name), '''Description''', '''Exchange''',''' and '''Category'''.<br>
-The text file may contain the following fields per row: Symbol Name, Symbol Root, Description, Exchange, and Category.  Of these fields, only the Symbol Name field is required.  Symbol Root shall be added in case if it is different from the Symbol Name. QuoteManager will prompt the user for the missing information during the import process.  The missing fields can also be entered manually into QuoteManager one by one after the symbol is imported.
+Each field should be separated by a delimiter: comma, semi-colon, space, tab, or other character.
-<br>
-Each field should be separated by a delimiter.  The delimiter can be a comma, semi-colon, space, tab, or other character.
-<br>
+<div class="example">
-An example of the contents of a text file is shown below:
-<br>
 {|
-Symbol Name, Description, Exchange, Category
+'''Symbol Name, Description, Exchange, Category'''
-<br>XYZ, XYZ Corporation, NYSE, Stocks
+<br>'''XYZ, XYZ Corporation, NYSE, Stocks'''
-<br>ABC, ABC Company, NASDAQ, Stocks
+<br>'''ABC, ABC Company, NASDAQ, Stocks'''
-<br>ESU9, S&P E-mini, GLOBEX, Futures
+<br>'''ESU9, S&P E-mini, GLOBEX, Futures'''
-<br>…
 |}
-<br>
+</div>
-The order of the columns do not matter.  However, each column must contain the same type of data.
+The column order does not matter. However, each column must contain the same type of data.<br>
+In the example above, the second field of every row must be “Description”.  The third field of every row must be "Exchange".
-In the example above, the second field of every row must be the “Description” field.  The third field of every row must be the "Exchange" field.
+<div class="note">Symbol Description cannot be longer than 63 characters.</div>
-<div style="background-color: #adffd8;"> '''Note:''' Symbol Description cannot be longer than 63 characters.</div>
+== Importing a Symbol List ==
-== Importing a Symbol List ==
+To import a list of symbols, in [[QuoteManager]] click the '''Import Symbol List''' button <img src="https://www.multicharts.com/trading-software/images/3/31/Import_Symbol_List.png" width="24"> or go to '''File → Import Symbol List''':
-<br>
+# Use the '''Browse''' button to find the file on you machine and open the text file.
-To import a list of symbols:
+# Enter the '''Start Import at Row''' number.<br>For example, if the first row in the text file contains column names instead of symbol parameters, start the import at row 2.
-# Open '''QuoteManager''' window
+# Set delimiters and qualifiers
-#* see [[:Category:QuoteManager#Opening QuoteManager|how]]
+#* In '''Set Data Delimiters''', select delimiters used in the text file.
-# Select '''File''' in the main menu and then select '''Import Symbol List'''.  The Import Symbols Wizard window will appear.
+#* Check the '''Treat Consecutive Delimiters as One''' box to consider consecutive delimiters the same as one delimiter.  If this box is checked, consecutive delimiters will not be considered as an empty field.
-# Use the '''Browse''' button to select the text file.  Select '''Next'''.
+#* Select the '''Text Qualifier'''<br>For example, the text field is in double quotes (e.g., “MSFT”).  If the double quote text qualifier is selected, MultiCharts will recognize that the user wishes to import MSFT without the quotes.
-# In the '''Start Import at Row''' number box, enter the row number to start the import.  Select '''Next'''.<br>For example, if the first row of the text file contains header names instead of symbol data, then start the import at row 2.
+# Use the drop down lists to assign the column names to the columns in the text file. If a column is missing in the file, set it to '''None'''.
-# In '''Set Data Delimiters''', select the type of delimiter used in the text file.
+# '''Select Missing Parameters.'''
-# Select the '''Treat Consecutive Delimiters as One''' checkbox to consider consecutive delimiters the same as one delimiter.  If this box is checked, consecutive delimiters will not be considered as an empty field.
+#* In the '''Select Data Source''' drop down list, select the data source for the symbols.
-# Choose the text qualifier from the '''Text Qualifier''' drop down list.  Select '''Next'''.<br>For example, if a text field can have double quotes around it (e.g., “MSFT”).  If the double quote text qualifier is selected, then MultiCharts will recognize that the user wishes to import MSFT without the quotes.
+#*If the '''Exchange''' and '''Category''' columns were not previously assigned to a column in the text file, then use the '''Exchange''' and '''Category''' drop-down lists to specify the information.
-# Use the drop down lists to assign the column names to the columns in the text file.  Select '''Next'''.
+# Click '''Finish''' to import symbols into QuoteManager.
-# In the '''Select Data Source''' drop down list, select the data source for the symbols.
-# If the '''Exchange''' and '''Category''' columns were not previously assigned to a column in the text file, then use the '''Exchange''' and '''Category''' drop-down lists to specify the information.
-# Select '''Finish'''.  The symbols will be imported into QuoteManager.
-<br>
 [[Category:Managing Data]]
+[[Category:QuoteManager]]