yahoo.finance 相关数据api 的变化(YQL 控制台)吗? [英] Are the yahoo.finance related data api's change (YQL Console)?

问题描述

我正在尝试将 yql 用于雅虎财务数据.我检查了 YQL 控制台上的 Show Community Table，以查看 Yahoo 标签下的数据库.我可以看到它下面的表格，但我没有得到结果这里是这样的:::

I am trying to use yql for yahoo financial data. I checked the Show Community Table on the YQL console to see the database under the Yahoo tag. I can see the tables under it but i am not getting results here it is as follows:::

select * from yahoo.finance.analystimate where symbol in ('YHOO')

select * from yahoo.finance.analystestimate where symbol in ('YHOO')

    {
 "query": {
  "count": 1,
  "created": "2016-03-28T10:25:01Z",
  "lang": "en-US",
  "diagnostics": {
   "url": [
    {
     "execution-start-time": "1",
     "execution-stop-time": "767",
     "execution-time": "766",
     "content": "http://www.datatables.org/yahoo/finance/yahoo.finance.analystestimate.xml"
    },
    {
     "execution-start-time": "771",
     "execution-stop-time": "1821",
     "execution-time": "1050",
     "content": "http://finance.yahoo.com/q/ae?s=YHOO"
    }
   ],
   "publiclyCallable": "true",
   "javascript": {
    "execution-start-time": "769",
    "execution-stop-time": "1823",
    "execution-time": "1054",
    "instructions-used": "5139",
    "table-name": "yahoo.finance.analystestimate"
   },
   "user-time": "1824",
   "service-time": "1806",
   "build-version": "0.2.842"
  },
  "results": {
   "results": {
    "symbol": "YHOO"
   }
  }
 }
}

这里的结果显示为空...有什么改变了吗?我怎样才能知道发生了什么?

here results are shown as empty .. Has something changed? How can I find out what happened?

是否可以使用其他解决方案来获取这些数据?

Is there an alternative solution I can use to obtain this data?

推荐答案

是的，finance.yahoo.com 的 HTML 结构在 2015 年初的某个地方发生了变化，因此 YQL 表的实现需要更新.

Yes, the HTML structure for finance.yahoo.com has been changed somewhere in beginning of 2015, so YQL table implementation needs updating.

请检查以下旨在解决当前未决问题的 GH 拉取请求:

Please check the following GH pull requests which aims to fix the current outstanding issues:

• GH-449:将 yahoo.finance.analystestimate.xml 更新为新的 HTML 结构
• GH-457:更新 yahoo.finance.analystestimate.xml

它们有点重叠，因此您可以同时测试它们(最好检查第一个).

They're bit in overlap, so you may test them both (preferably check the first one).

或者您可以查看我的 yql-tables 的分支(其中包含许多其他修复程序，如好吧)我已经将这个 PR 合并到其中，所以找到更新的 yahoo.finance.analystestimate.xml 在这里，另一个没有合并在另一个之上.

Or you can check my fork of yql-tables (which consist loads of other fixes as well) where I've merged this PR into it, so find updated yahoo.finance.analystestimate.xml in here, the other one doesn't merge on top of the other one.

这篇关于yahoo.finance 相关数据api 的变化(YQL 控制台)吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！