serpapi / public-roadmap

Public Roadmap for SerpApi, LLC (https://serpapi.com)
50 stars 3 forks source link

[Google Finance API] Empty results for stocks with numerical ticker and setting `window` param #1898

Closed alexbarron closed 1 week ago

alexbarron commented 1 week ago

While helping a customer with another issue, I noticed that if you try to set a date range for historical stock price data using the window param for a stock with a numerical ticker, the search comes back empty.

My first thought is it was a regional issue, but I've reproduced it across 3 stock markets that use numerical tickers. I've yet to find a letter-based ticker that reproduces the issue.

No window param set returns normally for stock 0005:HKG

Playground

image

Setting window to 5D breaks the search:

Playground

image

Filtering to 5D on Google Finance works as expected:

Actual Google Finance

image

Here are some additional examples from stock markets in Saudi Arabia and Japan that use numerical stock tickers:

https://serpapi.com/playground?engine=google_finance&q=4142%3ATADAWUL https://serpapi.com/playground?engine=google_finance&q=4142%3ATADAWUL&window=5D

https://serpapi.com/playground?engine=google_finance&q=7201%3ATYO&window=5D https://serpapi.com/playground?engine=google_finance&q=7201%3ATYO

Finally for reference, stock markets with letter-based tickers continue to work fine with window set. I tried with stocks in the US, UK, Australia, and Italy. For example:

Playground

image

schaferyan commented 1 week ago

A customer reported this:

Front

aciddjus commented 1 week ago

We have fixed this issue. Our Google Finance API will now return results for stocks with numerical values.

image