从Yahoo Finance获取数据

问题描述

我阅读了有关YQL的文章，但是我不明白如何为所有公司获取一些简单的数据(例如公司报价，市值，股价等)?

I read about the YQL, but I didn't understand how can I get some simple data (like company ticker, market cap, stock price, etc.), for ALL COMPANIES?

还有一个问题，如何获得YQL可以查询的所有Yahoo Finance表及其字段?

And an additional question, how can I get all Yahoo Finance tables and theirs fields that can be queried by YQL?

推荐答案

对于第一个问题，您真的无法通过YQL进行任何查询来获取所有公司的数据.它更倾向于为较小的查询获取数据. (即不会为您提供整个Yahoo! Finance数据库的完整数据转储.)

To your first question, you can't really do any query through YQL to get data for all companies. It's more oriented towards obtaining data for a smaller query. (I.e., it's not going to give you a full data dump of the whole Yahoo! Finance database.)

第二个问题是如何开始探索Yahoo! YQL中的财务表:

To your second question, here's how you can get started exploring the Yahoo! Finance tables in YQL:

1. 从 YQL控制台
开始
2. 确保在左上角已选中显示社区列表"
3. 在搜索字段中键入finance
4. 您将看到所有Yahoo Finance表格(约15张)

1. Start at the YQL Console
2. In the upper left corner, make sure Show Community Tables is checked
3. Type finance in the search field
4. You'll see all the Yahoo Finance tables (about 15)

然后您可以尝试以下示例查询:

Then you can try some example queries like the following:

更新2016-04-04:以下是当前屏幕快照，显示了显示社区表"复选框的位置，必须单击该复选框才能查看以下财务表:

Update 2016-04-04: Here's a current screenshot showing the location of the Show Community Tables checkbox which must be clicked to see these finance tables:

这篇关于从Yahoo Finance获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！