Yahoo Finance Quote Data Gaps for Shanghai-Listed Stocks
Summary
The document describes an inconsistency in Yahoo Finance data access for Chinese equities: a legacy quote endpoint returned values for a Shenzhen-listed symbol but missing values for Shanghai-listed symbols, even though a separate historical-data endpoint showed records for a Shanghai listing. It is a practical data-ingestion troubleshooting question rather than a trading strategy.
Responses point to alternative access methods, including a later JSON quote interface and scraping a customized Yahoo Finance page after creating a field view. These suggestions reflect the APIs and site behavior reported at the time, including a note that current quotes for Shanghai symbols still failed in 2016. The examples establish that results differed by endpoint and exchange suffix, but they do not demonstrate reliability, completeness, or continued availability. Researchers should treat the approaches as historical workarounds and independently check current data access, terms, and coverage before relying on them.
Key ideas
- Yahoo Finance quote and historical-data endpoints can behave differently for the same Shanghai-listed stock.
- The examples report valid legacy quote data for a Shenzhen symbol but missing quote fields for Shanghai symbols.
- A response suggests trying a JSON quote interface for Shanghai listings.
- Another historical workaround is to configure a quote view and scrape its displayed fields.
- The reported API behavior is time-specific and does not establish current reliability.
Tags
Full text
# Yahoo Finance API # Yahoo Finance API Have been looking for ways to down load stock price data using Yahoo Finance on Chinese Stocks. Symbol that ends with .SS = stock listed in Shanghai, .zz = stock listed in Shenzhen This link http://finance.yahoo.com/d/quotes.csv?s=000625.sz&f=snohgl1v returns 000625.SZ CHANGAN AUTOMOBIL 12.4 12.8 12.4 12.69 9787354 This link http://finance.yahoo.com/d/quotes.csv?s=600600.SS&f=snohgl1v returns 600600.SS 600600.SS N/A N/A N/A 0 N/A I have done a few tests and and .SZ stocks return valid data but not for .SS stocks. However using this link "table.finance.yahoo.com/table.csv?s=600600.SS" the data is clearly there. Really confused as to why this is the case. Anyone has any ideas? ## Answer by weidongxu (score 3) https://quant.stackexchange.com/a/36075 As for now, below API would give a nice JSON response: ``` https://query1.finance.yahoo.com/v7/finance/quote?lang=en-US®ion=US&corsDomain=finance.yahoo.com&fields=symbol,longName,shortName,priceHint,regularMarketPrice,regularMarketChange,regularMarketChangePercent,currency,regularMarketTime,regularMarketVolume,quantity,averageDailyVolume3Month,regularMarketDayHigh,regularMarketDayLow,regularMarketPrice,regularMarketOpen,fiftyTwoWeekHigh,fiftyTwoWeekLow,regularMarketPrice,regularMarketOpen,sparkline,marketCap&symbols=000001.SS,600600.SS ``` ## Answer by Mark (score 2) https://quant.stackexchange.com/a/24397 Yahoo Finance current quote API still does not work for SS stocks as of Feb 2016. I ended up scraping data from the UI: - Login to Yahoo Finance - Create view (in my case v3) with fields you'll need http://finance.yahoo.com/quotes/view/new?symbols=000001.SS&from_view_id=v3 - Construct URL with your comma separated symbols (200 max) and new view version, such as http://finance.yahoo.com/quotes/000001.SS,600000.SS,600004.SS,600005.SS/view/v3 - I'm using ruby watir to get the data I need into a csv file..
Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)
This summary was written by Stratmill's research agent from the original; it is not a copy of the source.