使用雅虎财经 API (YQL) 筛选股票

发布于 2024-12-26 19:18:57 字数 978 浏览 1 评论 0原文

我正在尝试使用雅虎财经 API 推出自己的股票筛选器。

虽然通过提供股票代码可以轻松获取大量数据（通过 XML 或 JSON）：（

SELECT * FROM yahoo.finance.quotes WHERE symbol="RBS.L"

查看结果此处并单击“测试”）。

我正在努力寻找一种方法来寻找符合特定标准的股票。例如，假设我想获取买入价大于 20 的股票列表，

SELECT symbol FROM yahoo.finance.quotes WHERE Bid > 20.00

查询失败，并显示以下消息：

Cannot find required keys in where clause; got 'Bid', expecting required keys: (symbol)

可以看出此处。

我想做的事情可能吗？有没有办法编写查询字符串来获取我正在寻找的内容？或者有没有更简单的服务可以帮助我。

我将不胜感激你们能给我的任何帮助。

原文

i am trying to roll my own stock screener using the Yahoo Finance API.

While it is easy to get a heap of data (via XML or JSON) by providing the ticker symbol:

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 which match a certain set of criteria. For instance, say I want to grab a list of stocks whose Bid price is greater than 20

SELECT symbol FROM yahoo.finance.quotes WHERE Bid > 20.00

The query fails, with the following message:

Cannot find required keys in where clause; got 'Bid', expecting required keys: (symbol)

as can be seen here.

Is what I am trying to do possible? Is there a way to write the query string to get what I am looking for? Or is there a much simpler service out there that can help me out.

Would appreciate any help you guys can give me.

分享到QQ

分享到微博