Yahoo! Query Language

Back to YQL Forum

problem with weekly options in YQL (yahoo.finance.options)

In the YQL console I'm typing this:

SELECT * FROM yahoo.finance.options WHERE symbol='IBM' AND expiration='2011-10-07'

but it does not return this week's options - it seems to be stuck on the monthly options.

here is a snippet from the reply below - does anyone know the trick to making it return weekly options?

TODDL

  <results>    <optionsChain symbol="IBM">      <option symbol="IBM111022C00085000" type="C">        <strikePrice>85</strikePrice>        <lastPrice>83.75</lastPrice>        <change>0</change>        <changeDir/>        <bid>88.25</bid>        <ask>90.8</ask>        <vol>1</vol>        <openInt>1</openInt>      </option>

Todd L
Oct 3, 2011

4 Replies

- Vinit
- Oct 3, 2011
Expiration format doesn't matches with the table example query. It should be something like SELECT * FROM yahoo.finance.options WHERE symbol='IBM' AND expiration='2011-10' <div class="quote"><div class="quotetop">QUOTE<cite>(Todd L @ 3 Oct 2011 1:11 PM)</cite></div><blockquote class="quotemain">In the YQL console I'm typing this: SELECT * FROM yahoo.finance.options WHERE symbol='IBM' AND expiration='2011-10-07' but it does not return this week's options - it seems to be stuck on the monthly options. here is a snippet from the reply below - does anyone know the trick to making it return weekly options? TODDL <pre id="mypre" class="pre"><pre class="xml" id="prexml"><pre class="xml" id="prexml"> > symbol="IBM"> symbol="IBM111022C00085000" type="C"> > 85> > 83.75> > 0> /> > 88.25> > 90.8> > 1> > 1> ></pre></pre></pre></blockquote></div>

Report Abuse

0
- Todd L
- Oct 3, 2011
Thank you Vinit - that is correct - however, there are about 30-40 stocks that have weekly expirations - does that mean that this YQL does not work with weeklies? TODDL <div class="quote"><div class="quotetop">QUOTE<cite>(Vinit @ 3 Oct 2011 1:48 PM)</cite></div><blockquote class="quotemain">Expiration format doesn't matches with the table example query. It should be something like SELECT * FROM yahoo.finance.options WHERE symbol='IBM' AND expiration='2011-10' <div class="quote"><div class="quotetop">QUOTE<cite>(Todd L @ 3 Oct 2011 1:11 PM)</cite></div><blockquote class="quotemain">In the YQL console I'm typing this: SELECT * FROM yahoo.finance.options WHERE symbol='IBM' AND expiration='2011-10-07' but it does not return this week's options - it seems to be stuck on the monthly options. here is a snippet from the reply below - does anyone know the trick to making it return weekly options? TODDL <pre id="mypre" class="pre"><pre class="xml" id="prexml"><pre class="xml" id="prexml"> > symbol="IBM"> symbol="IBM111022C00085000" type="C"> > 85> > 83.75> > 0> /> > 88.25> > 90.8> > 1> > 1> ></pre></pre></pre></blockquote></div></blockquote></div>

Report Abuse

0
- Vinit
- Oct 6, 2011
Hi Todd, Table "finance.options" is a community table and not directly managed by Yahoo!. Here is the author's description, if you want to contact him for upgrade. https://github.com/thomasdfowler Thanks Vinit <div class="quote"><div class="quotetop">QUOTE<cite>(Todd L @ 3 Oct 2011 3:12 PM)</cite></div><blockquote class="quotemain">Thank you Vinit - that is correct - however, there are about 30-40 stocks that have weekly expirations - does that mean that this YQL does not work with weeklies? TODDL <div class="quote"><div class="quotetop">QUOTE<cite>(Vinit @ 3 Oct 2011 1:48 PM)</cite></div><blockquote class="quotemain">Expiration format doesn't matches with the table example query. It should be something like SELECT * FROM yahoo.finance.options WHERE symbol='IBM' AND expiration='2011-10' <div class="quote"><div class="quotetop">QUOTE<cite>(Todd L @ 3 Oct 2011 1:11 PM)</cite></div><blockquote class="quotemain">In the YQL console I'm typing this: SELECT * FROM yahoo.finance.options WHERE symbol='IBM' AND expiration='2011-10-07' but it does not return this week's options - it seems to be stuck on the monthly options. here is a snippet from the reply below - does anyone know the trick to making it return weekly options? TODDL <pre id="mypre" class="pre"><pre class="xml" id="prexml"><pre class="xml" id="prexml"> > symbol="IBM"> symbol="IBM111022C00085000" type="C"> > 85> > 83.75> > 0> /> > 88.25> > 90.8> > 1> > 1> ></pre></pre></pre></blockquote></div></blockquote></div></blockquote></div>

Report Abuse

0
- Avi
- Oct 13, 2011
Todd, The weekly options are selected with the same query among the monthly options. For example SELECT * FROM yahoo.finance.options WHERE symbol='YHOO' will return an optionChain of 48 options which is the complete list like here <a href="http://finance.yahoo.com/q/op?s=YHOO+Options">http://finance.yahoo.com/q/op?s=YHOO+Options</a> including the weekly. <div class="quote "><div class="quotetop ">QUOTE<cite>(Todd L @ 3 Oct 2011 3:12 PM)</cite><blockquote class="quotemain">Thank you Vinit - that is correct - however, there are about 30-40 stocks that have weekly expirations - does that mean that this YQL does not work with weeklies? TODDL <div class="quote "><div class="quotetop ">QUOTE<cite>(Vinit @ 3 Oct 2011 1:48 PM)</cite><blockquote class="quotemain">Expiration format doesn't matches with the table example query. It should be something like SELECT * FROM yahoo.finance.options WHERE symbol='IBM' AND expiration='2011-10' <div class="quote "><div class="quotetop ">QUOTE<cite>(Todd L @ 3 Oct 2011 1:11 PM)</cite><blockquote class="quotemain">In the YQL console I'm typing this: SELECT * FROM yahoo.finance.options WHERE symbol='IBM' AND expiration='2011-10-07' but it does not return this week's options - it seems to be stuck on the monthly options. here is a snippet from the reply below - does anyone know the trick to making it return weekly options? TODDL <pre id="mypre" class="pre"><pre class="xml" id="prexml"><pre class="xml" id="prexml"> > symbol="IBM"> symbol="IBM111022C00085000" type="C"> > 85> > 83.75> > 0> /> > 88.25> > 90.8> > 1> > 1> ></pre></pre></pre></blockquote></div></div></blockquote></div></div></blockquote></div></div>

Report Abuse

0

Ask a Question

Yahoo! Developer Network

Yahoo! Query Language

problem with weekly options in YQL (yahoo.finance.options)

Recent Posts