[GNC-dev] [GNC] error message with finance::quote gnc-path-check + problems with retrieving quotes for 2 symbols.

[John Ralls]

Please remember to copy the list on all replies.

The security you had trouble with is QCSCRX. I get:
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v yahoo_json QCSCRX
Finance::Quote fields Gnucash uses:
    symbol: QCSCRX               <=== required
      date: 06/23/2020           <=== recommended
  currency: USD                  <=== required
      last: 267.395              <=\
       nav:                      <=== one of these
     price:                      <=/
  timezone:                      <=== optional

All fields returned by Finance::Quote for stock QCSCRX

stock           field  value
-----           -----  -----
QCSCRX       currency: USD
QCSCRX           date: 06/23/2020
QCSCRX       exchange: Sourced from Yahoo Finance (as JSON)
QCSCRX        isodate: 2020-06-23
QCSCRX           last: 267.395
QCSCRX         method: yahoo_json
QCSCRX           name: QCSCRX (CREF Social Choice Account - R1)
QCSCRX        success: 1
QCSCRX         symbol: QCSCRX
QCSCRX           type: MUTUALFUND
Use of uninitialized value in printf at /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump line 138.
QCSCRX         volume:

It seems unlikely that it would be anything other than a temporary issue at Yahoo!.

Regards,
John Ralls

> On Jun 23, 2020, at 4:21 PM, uhopfer at gmail <uhopfer at gmail.com> wrote:
> 
> John,
> 
> thanks for getting back. I must have gotten gnc-path-check with an earlier version of gnucash. The file (attached) is dated 7/29/2017. I updated gnucash a few times over the years. This time I went from version 3.3 to stable 3.10 from this Spring.
> 
> The 3 TIAA-CREF symbols are QCGLRX, QCSCIX, QCSCRX. TIAA-CREF does not return any quote for these.
> 
> I have attached 3 files with the Stdout and Stderr for yahoo direct queries and for gnc-fq-dump queries, one when successful, one when gnc-fq-dump fails.
> 
> In both gnc-fq-dump cases, I get error messages indicating that the yahoo_json perl module has problems interpreting the yahoo output. I do not know whether they are meaningful or significant. Whether the gnc-fq-dump query fails or succeeds appears somewhat random, now that I tried more often with queries.
> 
> Let me know what you think that I can do.
> 
> Ulrich
> 
> 
> 
> On 6/22/2020 10:54 PM, John Ralls wrote:
>> 
>>> On Jun 22, 2020, at 6:08 PM, uhopfer at gmail <uhopfer at gmail.com> wrote:
>>> 
>>> I had to reinstall strawberry perl and finance::quote (1.49) and now can download again all my quotes except for 2 symbols using alpha vantage, vanguard, or yahoo_json.
>>> 
>>> I discovered that gnc-path-check comes back  with a programming error message (below):
>>> 
>>> perl gnc-path-check -v 2>temp.txt
>>> 
>>> Can't use global $_ in "my" at gnc-path-check line 60, near "my $_ "
>>> Execution of gnc-path-check aborted due to compilation errors.
>>> 
>>> That error needs  to be fixed, but I do not know any perl.
>>> 
>>> I wondered whether the error could be related to my  new problem of retrieving 2 of 3 TIAA-CREF symbols with yahoo_json that I used to be able to retrieve automatically, but now can only retrieve manually. In other words, yahoo still has information on the symbols, but f::q does not retrieve it. The automatic retrieval works for 1, but not the other 2 sumbols. gnc-fq-dump gives the same anwer.
>>> 
>> Dunno where you got gnc-path-check, but it wasn't from us. We have a gnc-fq-check, gnc-fq-dump, gnc-fq-helper, and gnc-fq-update. No gnc-path-check.
>> 
>> What same answer does gnc-fq-dump give, that the symbol isn't found? What are the two symbols? Have you tried price source tiaacref?
>> 
>> Regards,
>> John Ralls
>> 
> -- 
> Ulrich Hopfer
> 2915 Coleridge Rd.
> Cleveland Heights, OH 44118
> 216-932-2437
> uhopfer at gmail.com
> 
> <gnc-path-check.txt><gnc-fq-dump failure..txt><gnc-fq-dump success.txt><yahoo direct query.txt>