Search results
Results From The WOW.Com Content Network
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.
build a url with an ISIN for yahoofinance (or an equally fast provider) map the ISIN to the relevant ticker symbol. any other method to retrieve data from yahoofinance e.g. open-source libs. other sources of live trading information, most importantly present prices. Thanks.
Without an impartial body to allocate the symbols it is really not worth much, IMHO. The difficulty in naming financial instruments lies not so much with exchange traded instruments like equities. That is rather simple: Take the exchange's own ticker symbol and then add some self-invented identifier to denote the market place.
The problem that I am encountering is that a large part of the symbols that are listed in this file do not exist on Yahoo Finance. This leads to a lot of unnecessary processing, because the yfinance API runs into a lot of errors, which are handled recursively.
For example, Microsoft's (MSFT) closest competitor is generally seen as AAPL. While IBM, RedHat also make (server) operating systems, I wouldn't say they are as closely linked as, say, GOOG and AAPL to MSFT. So the specifics matter a lot. Another example, Dominos Pizza (DPZ) and McDonalds are both fast foods.
I've been using this API called Stock Coverage from unibit. It covers around 70,000 stocks from 49 exchanges. Though I'm not sure if it is the most updated. A few recent IPOs can be found in the list. The ticker standard seem to complies with Yahoo's and it works with many of the other APIs in their site.
Pick the one you are interested in and answer their silly robot barrier "puzzle" and download the csv file, in which the ticker symbol is the first column. Edit: With TTR_0.20-3 from r-forge, the list appears more complete than with the prior version: require(TTR) SYMs <- TTR::stockSymbols() #Fetching AMEX symbols... #Fetching NASDAQ symbols...
I'm using pandas_datareader.data.DataReader and I need to list every ticker available to fetch information from, using yahoo as data source.
In some cases, the Ticker may be the same as the Symbol of that specific site and I get the correct ISIN, however, in other cases it is not the same and it provides other ISIN which is not the one that matches the Yahoo Ticker. If I scrape other financial websites, there is a 50/50 chance of getting the correct ISIN for the Yahoo Ticker.
I think the stock exchanges post something similar. This is the tedious part: you can use the established company name to ticker search which is difficult to parse or this other search that gives everything on a given result. I use the second search.