帮助创建 YQL 查询来搜索公司
如何创建 YQL 查询以返回来自雅虎财经的公司?
select * from yahoo.finance.quotes where name like "apple"
不起作用。
How can I create a YQL Query that will return me companies from Yahoo Finance?
select * from yahoo.finance.quotes where name like "apple"
Doesn't work.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
要获取任何公司的符号,您可以使用以下网址:
在查询中,您可以传递您想要其符号的任何公司名称。
然后要获取有关该代码的股票详细信息,您可以使用以下查询:
这里您需要在与“s”的比较中传递代码。
因此,要获取苹果股票信息,您需要执行以下操作:
在获取之后苹果的符号:
希望这会有用..快乐编码..
To get a symbol of any company you can use the below url :
here in the query you can pass any company name that you want the symbol for.
And then to get the stock details about that symbol you can use the below query :
here you need to pass the symbol in the comparison with 's'..
So for getting the apple stock information you need to do the following :
and after getting symbol for apple go for :
Hope this will be useful..Happy Coding..
由于很多原因,这行不通。请尝试:
要准确获得您想要的内容,您可以在 where 子句中使用 xpath 进一步过滤。
That won't work for many reasons. Please try:
To get exactly what you want, you could further filter with xpath in the where clause.
我宁愿建议使用 CSV 数据表中的构建并执行以下操作,而不是使用 XPATH:
这两种方法的问题是您需要知道股票代码,因此在本例中为 AAPL。因此,我的答案和其他答案都无法真正满足您通过名称搜索公司的需求。
目前没有比这更多的输入,抱歉。
Instead of using XPATH I would rather recommend to use the build in CSV datatable and to do something like this:
The problem with either approach is though that you need to know the stock symbol, so AAPL in this example. So neither my nor the other answer really fulfills your need in terms of being able to search for companies by name.
Don't have more input than this currently, sorry.