使用YQL获取金融期权数据 [英] Get Financial Option Data with YQL
问题描述
我正在使用YQL检索金融期权数据.像这样:
I am using YQL to retrieve Financial Option data. Something like:
select * from yahoo.finance.options where symbol="AAPL" and expiration="2011-07"
但是,上述查询返回数据的optionsChain
.
However, the above query returns an optionsChain
of data.
有没有一种方法可以只检索特定选项符号的记录,例如symbol=AAPL110716C00155000
?
Is there a way to retrieve just the record for a specific option symbol, e.g. symbol=AAPL110716C00155000
?
感谢您的时间.
推荐答案
除了远程过滤器"之外,您还可以对从yahoo.finance.options
返回的结果集应用所需符号的本地过滤器"( symbol
和expiration
).
You can apply a "local filter", for your desired symbol, on the result set brought back from yahoo.finance.options
in addition to the "remote filters" (symbol
and expiration
).
select option
from yahoo.finance.options
where symbol = "AAPL"
and expiration = "2011-07"
and option.symbol = "AAPL110716C00155000"
有关过滤查询结果的更多信息,请参见 过滤查询结果(WHERE) "页面.
For more info on filtering query results see the Filtering Query Results (WHERE) page in the YQL documentation.
这篇关于使用YQL获取金融期权数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!