Click here to Login





How to import your own list of stocks/symbols

Updated on 2011-08-11 08:17:42

Share |

There are different ways to import symbols data/information into QuantShare database.
The simplest way is to use the "Import Symbols from a file" tool.

Steps:

- Get a list of symbols for your favorite market(s) or use the Bloomberg Open Symbology website to download a list of ticker symbols (http://bsym.bloomberg.com/sym/).
- Using the Bloomberg Open Symbology website, you can search by market sector (Equity, Commodity, Currency, Index, Money Market...), asset type (Stocks, Bonds, CDR...), exchange and country. Once you get your list, click on "Excel" to download the list in CSV/Excel format.
- Open QuantShare and select "Symbol" then "Import symbols from a file"
- Click on "Load file" button then select your list of symbols
- Depending on your file format, click on the first row cells and associate each column to a specific symbol field.
Example: Using the list from Bloomberg, I have associated the first column with "fullname" and the second column with "name".

- Click on "Create List"
- Click on "Yes" then type the list name.
- Now, the application will ask you if you want to add symbols within this list to your active/current database. Click yes to complete the process.









one review (Log in)







Other how-to articles




How to import trades into a portfolio





How to import trading data from CSV files





How to backup your databases (EOD, Intraday, Tick and Custom) and trading items





How to import trading items from other accounts





How to add custom position-based metrics to your trading system





How to quickly add several positions to your portfolio





How to associate an index with a list of stocks





How to quickly add a ticker symbol





How to quickly download the most recent EOD data for your stocks







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.