I am trying to overturn my own stock counter using the Yahoo Finance API.
While it's easy to get a bunch of data (via XML or JSON) by providing a ticker character:
SELECT * FROM yahoo.finance.quotes WHERE symbol="RBS.L"
(See the results here and click "test").
I am struggling to find a way to find stocks that match a specific set of criteria. For example, say I want to grab a list of stocks whose price is greater than 20
SELECT symbol FROM yahoo.finance.quotes WHERE Bid > 20.00
The request fails with the following message:
Cannot find required keys in where clause; got 'Bid', expecting required keys: (symbol)
as can be seen here .
Am I trying to do this? Is there a way to write a query string to get what I'm looking for? Or there is a much simpler service that can help me.
Amazing any help you guys can give me.
source share