[GNC] quotes for stock options

Ralph suselist at cableone.net
Tue Dec 15 18:03:11 EST 2020


Hello!

I use json/yahoo also and it works fine for me.  If there is no trading
in a certain option for the day a quote is requested then it will
return nothing (usually) OR the quote from the last day the option
traded (rarely).  

Your option looks to be low volume.  According to yahoo web
(https://in.finance.yahoo.com/quote/SPY211217C00325000) it last traded
on the 11th, volume of 8, and nothing since.  If that last-trade-date
is correct then the quote you see in gnc would be correct. 

Ralph


On Tue, 15 Dec 2020 16:20:27 -0600 (CST)
mike823 <fkjasdhf878 at mailinator.com> wrote:

> I am wondering what people are using for downloading quotes for US
> stock options. I am currently using yahoo_json, which works fine for
> stocks but it is not reliable for stock options.
> 
> D:\>perl "D:\tools\gnucash\bin\gnc-fq-dump" -v yahoo_json
> SPY211217C00325000 Finance::Quote fields Gnucash uses:
>     symbol: SPY211217C00325000   <=== required
>       date: 12/11/2020           <=== recommended
>   currency: USD                  <=== required
>       last: 56.6                 <=\
>        nav:                      <=== one of these
>      price:                      <=/
>   timezone:                      <=== optional
> 
> All fields returned by Finance::Quote for stock SPY211217C00325000
> 
> stock           field  value
> -----           -----  -----
> SPY211217C00325000      close: 56.84
> SPY211217C00325000   currency: USD
> SPY211217C00325000       date: 12/11/2020
> SPY211217C00325000  div_yield: 0
> Use of uninitialized value in printf at
> D:\tools\gnucash\bin\gnc-fq-dump line 138.
> SPY211217C00325000        eps:
> SPY211217C00325000   exchange: Sourced from Yahoo Finance (as JSON)
> SPY211217C00325000       high: 56.6
> SPY211217C00325000    isodate: 2020-12-11
> SPY211217C00325000       last: 56.6
> SPY211217C00325000        low: 56.19
> SPY211217C00325000     method: yahoo_json
> SPY211217C00325000       name: SPY211217C00325000 (SPY Dec 2021
> 325.000 call)
> SPY211217C00325000       open: 56.19
> Use of uninitialized value in printf at
> D:\tools\gnucash\bin\gnc-fq-dump line 138.
> SPY211217C00325000         pe:
> SPY211217C00325000    success: 1
> SPY211217C00325000     symbol: SPY211217C00325000
> SPY211217C00325000       type: OPTION
> SPY211217C00325000     volume: 8
> SPY211217C00325000 year_range:        56.19 - 56.6
> 
> The update on Dec 15 comes back with Dec 11 data.
> 
> TIA
 


More information about the gnucash-user mailing list