Click here to Login




How to Create a List of Ticker Symbols

Updated on 2010-12-07





The sharing server already contains more than 65 list of symbols, including symbols for U.S. and Major Stock Exchanges, Major world indices, ETF, Forex, Options and Futures Markets.

To add symbols of a specific market to your account, you simply need to download the corresponding trading item from the website then double click on it to open a small form in QuantShare Trading Software. In this form, you can choose to add the ticker symbols to the current account or to a new one. Make your choice and you are done.

If you have your own list of ticker symbols or have downloaded a list from the web, you can add this list in QuantShare very easily. In the next paragraph, we will show you how to do that.


How to add a list of ticker symbols

Your symbols may contain the ticker name, descriptive name, currency, sector, market, index... You can use a spreadsheet such as excel to create and manipulate this list and when you are ready to insert the data into QuantShare, simply export the list in CSV format (Each line represents a symbol and symbol's information is separated by a unique character such as a comma or a semi-colon).

In QuantShare, select "Symbol" then "Create a list of symbols from a file". Type the separator character (Depending on the format of your CSV file - Usually the separator is a semi-colon) then Click on "Load file" and select your ticker symbols list.

The grid may contain one or several columns where each column displays information about a specific symbol. If your data looks like "A;Agilent Technologies;NYSE;Electronic", then the first column contains the ticker name, the second one the company title, the third one the company's market and the last one the company's industry.

You will notice that the first line is empty and of a different color. This is because this line determines the type of the column. Remember our last example: The first column is the ticker name, so simply double click on the first cell of the first row and select "Name". In the second cell, select "fullname", then "market" and finally in the last cell select "industry".

The next step would be to click on the "Create List" button and then confirm that you want to create the list. You will be invited to enter the list name and save it.

Now select "Symbol" then "Add-Remove from a list of symbols". Click on "Select List" to select the previously created list, and then click on "Add" to add the ticker symbols, with the additional information, to your database. Notice the "Remove" button; this allows you to delete symbols that exist in a list of ticker symbols from an existing database.


How to share the ticker symbols list

Your list of symbols is also ready to be shared. You simply need to select "Tools" then "Sharing Server", select your item then click on the "Share Selected Item" button.

By the way, here is a very nice web page where you can get ticker symbols for all markets in the world and for different asset types (Commodity, Currency, Equity, Indices, ETFs, Mutual Funds, Bonds, Options, Futures...).












no comments (Log in)

QuantShare Blog
QuantShare
Search Posts




QuantShare
Recent Posts

Create Graphs using the Grid Tool
Posted 1400 days ago

Profile Graphs
Posted 1505 days ago

QuantShare
Previous Posts

QS Trading Software: Global Script
Posted 5091 days ago

Stock Market Prediction
Posted 5119 days ago

How to search for a trading item
Posted 5140 days ago


More Posts

Back







QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright © 2024 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.