2
$\begingroup$

I remember having seen that somewhere, I can't find it any more. Anyone knows how can I get all the list of stocks on Yahoo finance.

Or even all american stocks, maybe Russell 1000/2000/3000...

$\endgroup$
3
$\begingroup$

BATS has a nice downloadable file: http://batstrading.com/market_data/listed_symbols/

There's a CS and XML. They have 7,000 stocks in that list. Good stocks, not OTC.

| improve this answer | |
$\endgroup$
  • $\begingroup$ that's a cool one, it doesn't have non US, or I couldn't find non-us. But I still accepted the answer since I only mentioned Russell index. Anything similar for the rest of the world? (UK, Australia ...) $\endgroup$ – Charbel May 25 '16 at 15:38
  • $\begingroup$ No that I've found. US Markets have the best data sources due to popularity. $\endgroup$ – Allen Maxwell May 26 '16 at 21:30
  • 1
    $\begingroup$ After downloading the csv I only have 359 symbols though $\endgroup$ – hipoglucido May 4 at 17:42
2
$\begingroup$

For American stocks: if you are using Python 3, you can first, from a terminal, do

pip install get-all-tickers

then

from get_all_tickers import get_tickers as gt

list_of_tickers = gt.get_tickers()
# or if you want to save them to a CSV file
get.save_tickers()

Alternatively, you can clone the file from https://github.com/shilewenuw/get_all_tickers/blob/master/get_all_tickers/tickers.csv

| improve this answer | |
$\endgroup$
2
$\begingroup$

You can get a list of tickers for free using Finnhub's API.

You just need to request a free API key.

Check out the following documentation: https://finnhub.io/docs/api#stock-symbols

| improve this answer | |
$\endgroup$
1
$\begingroup$

Yahoo Closed its API, we are also downloading manually all the symbols for our use. Also we are sharing it wil all on https://github.com/stockdatalab/YAHOO-FINANCE-SCREENER-SYMBOLS-AND-HISTORICAL-DATA. you can download from above link.

Google Yahoo both not providing symbol list any more also Google providing historical data only for one year of any company.

| improve this answer | |
$\endgroup$
0
$\begingroup$

YQL seems to fail at queries with like '%AM%' and also there is no other way to get list of all stock symbols. but i think this can do the trick..

select * from yahoo.finance.industry where id in (1,2,3....260)

this will give you list of companies and there symbols. start with select * from yahoo.finance.industry where id in (112) and see if it works.

| improve this answer | |
$\endgroup$
  • $\begingroup$ can you give me an example of how to use YQL? is that using a link of some sort? $\endgroup$ – Charbel Dec 29 '16 at 11:07
0
$\begingroup$

I have found this tool: https://github.com/Benny-/Yahoo-ticker-symbol-downloader

It uses the search api https://finance.yahoo.com/_finance_doubledown/api/resource/searchassist;searchTerm=s6s?device=console&returnMeta=true

| improve this answer | |
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.