其他人
在连接到雅虎财经社区表时遇到问题吗?
YQL 控制台向我提供了连接错误消息。其他人有同样的问题吗
YQL 查询:
select * from yahoo.finance.historicaldata where symbol = "YHOO" and startDate = "2009-09-11" and endDate = "2010-03-10"
ichart链接显示了雅虎警告,该警告已经存在了很长时间。
ichart 链接警告:
Yahoo Will be right back...
Thank you for your patience.
Our engineers are working quickly to resolve the issue.
YQL 控制台输出:
<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
yahoo:count="0" yahoo:created="2017-05-18T01:14:26Z" yahoo:lang="en-US">
<diagnostics>
<url execution-start-time="0" execution-stop-time="1" execution-time="1"><![CDATA[http://www.datatables.org/yahoo/finance/yahoo.finance.historicaldata.xml]]></url>
<publiclyCallable>true</publiclyCallable>
<cache execution-start-time="3" execution-stop-time="3"
execution-time="0" method="GET" type="MEMCACHED"><![CDATA[ada24345cde45cf8aefbdeee1216fea1]]></cache>
<url execution-start-time="4" execution-stop-time="14"
execution-time="10" http-status-code="502" http-status-message="Connection refused"><![CDATA[http://ichart.finance.yahoo.com/table.csv?a=8&b=11&e=10&g=d&c=2009&d=2&f=2010&s=YHOO]]></url>
<query execution-start-time="3" execution-stop-time="15"
execution-time="12" params="{url=[http://ichart.finance.yahoo.com/table.csv?a=8&b=11&e=10&g=d&c=2009&d=2&f=2010&s=YHOO]}"><![CDATA[select * from csv(0,1) where url=@url]]></query>
<cache execution-start-time="15" execution-stop-time="16"
execution-time="1" method="GET" type="MEMCACHED"><![CDATA[50ca55b0c486cc3071c5561ad3a43711]]></cache>
<url execution-start-time="16" execution-stop-time="57"
execution-time="41" http-status-code="502" http-status-message="Connection refused"><![CDATA[http://ichart.finance.yahoo.com/table.csv?a=8&b=11&e=10&g=d&c=2009&d=2&f=2010&s=YHOO]]></url>
<csv>Column mismatch: [<!DOCTYPE_html>] vs font: 300 18px "helvetica neue, helvetica, verdana, tahoma, arial, sans-serif;</csv>
<query execution-start-time="16" execution-stop-time="57"
execution-time="41" params="{columnsNames=[<!DOCTYPE_html>], url=[http://ichart.finance.yahoo.com/table.csv?a=8&b=11&e=10&g=d&c=2009&d=2&f=2010&s=YHOO]}"><![CDATA[select * from csv(2,0) where url=@url and columns=@columnsNames]]></query>
<javascript execution-start-time="2" execution-stop-time="57"
execution-time="55" instructions-used="27497" table-name="yahoo.finance.historicaldata"/>
<user-time>58</user-time>
<service-time>53</service-time>
<build-version>2.0.118</build-version>
</diagnostics>
<results/>
</query>
> 雅虎已正式确认雅虎财经API已在雅虎帮助社区的以下线程中停止使用(请参阅用户名尼克松的帖子(:
https://forums.yahoo.net/t5/Yahoo-Finance-help/Is-Yahoo-Finance-API-broken/m-p/250503#U250503