How do I get all the VALID tickers for Yahoo Finance? #1699
Replies: 19 comments 1 reply
-
|
@kabonker I have same question, currently using symbols scraped from EODData . You can select the exchange you want and pull all tickers from each page of the alphabet (all of this is selectable from URL so easily scrapable). I haven't run the whole list yet but will post it once I do. Can post scraper code to GitHub in meantime and update this comment with link. |
Beta Was this translation helpful? Give feedback.
-
|
I created a list of about 4000 tickers.. but would be cool if we just had a list in this library that is some how synced with yahoo finance, so everyone doesn't have to do it manually themselves. |
Beta Was this translation helpful? Give feedback.
-
|
Agreed, need to compile the list first. May not be publicly available anywhere on Yahoo finance site though so brute force is only solution. BTW can you post your list? |
Beta Was this translation helpful? Give feedback.
-
|
@kabonker is this the source you used? |
Beta Was this translation helpful? Give feedback.
-
|
@kabonker I found out this website which has all the tickers [last updated 2017]. So you can use that. This Excel spreadsheet was updated in September 2017. It is broken down into eight sheets, one each for:
That’s 245784 ticker symbols in total. |
Beta Was this translation helpful? Give feedback.
-
|
Dude that is awesome... Scotty we will need more power!!!! https://youtu.be/QYqXSlPmMJs?t=10 |
Beta Was this translation helpful? Give feedback.
-
|
FYI this file says "2017".. been 3 years. Must be missing a ton of companies. Anyone have an updated list? |
Beta Was this translation helpful? Give feedback.
-
|
I am interested in this one as well. One other problem is that I get a lot of tickers as not existing/delisted/deleted. This is obviously an issue. If a ticker was live in 2017 but the company has been delisted since then and therefore the ticker is not valid then there is no consistent way of creating accurate historic stock universes for backtesting. To make this a bit dramatic, Enron would not appear in any of the universes because it doesn't exist today however if you were doing live trading you would have obviously included it at the time (and taken the hit if you were long). In a technical jargon, the survivorship bias is massive. I guess this is why it pays to have professional grade data. That said, this is better than nothing for small projects. |
Beta Was this translation helpful? Give feedback.
-
|
Does someone know a python-module that can obtain the ticker list? |
Beta Was this translation helpful? Give feedback.
-
|
Maybe someone can just write a simple program going through the alphabet
for 4 chars and make a list of all the successful calls, then write it
out..
that would be nice. Could just run it once a quarter.. like COIN would
be new. Then spit out the full list and the incremental so we know the
new ones..
…On Wed, Apr 28, 2021 at 5:21 AM DimitriBolt ***@***.***> wrote:
Does someone know a python-module that can obtain the ticker list?
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#402 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AKKMVJIVOIFIIH5E3A4A5Y3TK7HRPANCNFSM4POMVK4A>
.
|
Beta Was this translation helpful? Give feedback.
-
|
Information from https://finviz.com/screener.ashx?ft=4 and package from https://pypi.org/project/pyfinviz/. See the code below. (You can add more than 10 pages if you want all the tickers...) I am not an expert in python. So if you know how to optimise this code, please show me how! Thank you! Have a nice day! :) `from pyfinviz.screener import Screener page = 10 screener = Screener(pages=[x for x in range(1, page)]) list_ticker = [] print(list_ticker)` |
Beta Was this translation helpful? Give feedback.
-
|
How many should there be? I can scrape 10,000 when looking for ALL tickers, just not sure if I got them all because they claim to have 90,000+ edit: And that goes for Stocks, Mutual Funds, ETFs, and Indicies (all have more than 10k results, but I can only get 10k of them). |
Beta Was this translation helpful? Give feedback.
-
|
It is a lot. It is quite a challenge keeping them all straight because
some get de listed and companies can change their ticker....
…On Thu, Jan 13, 2022 at 3:34 PM shullaw ***@***.***> wrote:
How many should there be? I can scrape 10,000 when looking for ALL
tickers, just not sure if I got them all because they claim to have 90,000+
—
Reply to this email directly, view it on GitHub
<#402 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AKKMVJKMPV5U3BKSEDN6233UV4ZMHANCNFSM4POMVK4A>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
You are receiving this because you were mentioned.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Hey everyone, any updates on retrieving all tickers from Yahoo finance. Also does anyone know any good APIs for retrieving FX options data. Thanks |
Beta Was this translation helpful? Give feedback.
-
|
You can use the screeners available at the Yahoo finance site: https://finance.yahoo.com/screener/ |
Beta Was this translation helpful? Give feedback.
-
|
How about https://api.nasdaq.com/api/screener/stocks?tableonly=true&download=true |
Beta Was this translation helpful? Give feedback.
-
|
Over 7400 this is a good list. maybe nasdaq.com will keep the api active? |
Beta Was this translation helpful? Give feedback.
-
|
A daily updated csv file of all US-listed equities (stocks and ETFs) is available from alphavantage.co for free. You don't even need to get the (free) API key for it. Just query the following URL and you will be served. https://www.alphavantage.co/query?function=LISTING_STATUS&apikey=demo |
Beta Was this translation helpful? Give feedback.
-
|
Hi everyone, Is there a fresh solution to this?....to query yfinance and (1) list all symbols/tickers...and then (2) filter where quoteType = ETF ? |
Beta Was this translation helpful? Give feedback.
-
I keep getting errors on some tickers, and Is there a quick way to see all the tickers they support?
Is there a function to call? Or a page to go to?
thanks
john
Beta Was this translation helpful? Give feedback.
All reactions