> On Mar 7, 2021, at 11:39 AM, John Ralls <jra...@ceridwen.us> wrote: > > > >> On Mar 7, 2021, at 11:31 AM, Rainer Dorsch <m...@bokomoko.de> wrote: >> >> Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls: >>>> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch <m...@bokomoko.de> wrote: >>>> >>>> [ move this thread from gnucash-devel to gnucash-user, the original >>>> gnucash- devel thread is here >>>> https://lists.gnucash.org/pipermail/gnucash-devel/2021-March/045777.html >>>> ]> >>>> Am Sonntag, 7. März 2021, 17:51:19 CET schrieb John Ralls: >>>>> You're on the wrong list, please use gnucash-user for this sort of >>>>> question. >>>>> >>>>> GnuCash can't use the quotes because Fondsweb.pm doesn't make a field >>>>> "symbol" in its return array. You should raise an issue at >>>>> https://github.com/financequote/financequote. >>>> >>>> If I understand you right, the field "symbol" is that same symbol which >>>> gnucash supplied. I added this locally here. >>>> >>>> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ gnc-fq-dump >>>> fondsweb >>>> LU0119891520 LU2027374805 >>>> >>>> Finance::Quote fields Gnucash uses: >>>> symbol: LU0119891520 <=== required >>>> >>>> date: 03/05/2021 <=== recommended >>>> >>>> currency: EUR <=== required >>>> >>>> last: 708.99 <=\ >>>> >>>> nav: 708.99 <=== one of these >>>> >>>> price: <=/ >>>> >>>> timezone: <=== optional >>>> >>>> ===== >>>> >>>> Finance::Quote fields Gnucash uses: >>>> symbol: LU2027374805 <=== required >>>> >>>> date: 03/05/2021 <=== recommended >>>> >>>> currency: USD <=== required >>>> >>>> last: 68.39 <=\ >>>> >>>> nav: 68.39 <=== one of these >>>> >>>> price: <=/ >>>> >>>> timezone: <=== optional >>>> >>>> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ >>>> >>>> I also opened a bug report and cross-referenced it: >>>> >>>> https://github.com/finance-quote/finance-quote/issues/179 >>>> >>>>> As for your complaint about duplicate prices, your pasted-in results >>>>> don't >>>>> show that. >>>> >>>> Many thanks for your quick reply, John. I move the discusion to >>>> gnucash-user. >>>> >>>> There are two things which I think are strange from the gnucash side: >>>> >>>> 1. gnc-fq-dump reports that stock quote cannot be used, but gnucash uses >>>> it >>>> 2. duplicate prices: I do not see them with gnc-fq-dump but gnucash shows >>>> them >>>> >>>> Ist gnucash using gnc-fq-dump in the same way I did? >>> >>> No. gnc-fq-dump is a user-convenience tool. GnuCash uses gnc-fq-helper, >>> which formats its results so that they can be fed directly to Scheme. >>> Instructions for using it by hand are in its POD. >>> >>> apparently there are others that don't pass a "symbol" element so if it >>> doesn't find the "symbol" entry in the F::Q results hash it uses the >>> user-supplied symbol instead. There's probably something about the >>> Fondweb.pm results hash that messes up retrieving the right entry. >>> >>> You can use .cpan/build/Finance-Quote-1.49-0/Examples/stockdump.pl (.cpan is >>> probably in your $HOME) to see exactly what F::Q is sending. >> >> I run stockdump.pl, but did not see anything wrong or unexpected in there: >> >> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ ./stockdump.pl >> Fondsweb >> LU2027374805 >> $VAR1 = { >> 'LU2027374805success' => 1, >> 'LU2027374805name' => 'Morgan Stanley INVF Global Endurance Fund >> (USD) Z', >> 'LU2027374805isin' => 'LU2027374805', >> 'LU2027374805isodate' => '2021-03-05', >> 'LU2027374805method' => 'fondsweb', >> 'LU2027374805nav' => '68.39', >> 'LU2027374805date' => '03/05/2021', >> 'LU2027374805type' => 'fund', >> 'LU2027374805currency' => 'USD', >> 'LU2027374805last' => '68.39', >> 'LU2027374805year_range' => '81.19 - 16.47', >> 'LU2027374805symbol' => 'LU2027374805' >> }; >> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ ./stockdump.pl >> Fondsweb >> LU0119891520 >> $VAR1 = { >> 'LU0119891520name' => 'MEDICAL BioHealth EUR', >> 'LU0119891520method' => 'fondsweb', >> 'LU0119891520isodate' => '2021-03-05', >> 'LU0119891520isin' => 'LU0119891520941135', >> 'LU0119891520success' => 1, >> 'LU0119891520year_range' => '807.77 - 414.77', >> 'LU0119891520currency' => 'EUR', >> 'LU0119891520last' => '708.99', >> 'LU0119891520type' => 'fund', >> 'LU0119891520nav' => '708.99', >> 'LU0119891520date' => '03/05/2021', >> 'LU0119891520symbol' => 'LU0119891520' >> }; >> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ >> >> The symbol part I added in Fondsweb.pm (see also >> >> https://github.com/finance-quote/finance-quote/issues/179 >> >> ) >> >> Do you see something unexpected or suspicious in there which can cause the >> mess up? >> > > Not offhand, but it's quite possible that adding symbol fixes the problem. > Did you try gnc-fq-helper, and if so what was its output? >
Another thought, though: You passed just one symbol at a time to stock dumper.pl. When I pass both, I get ~/.cpan/build/finance-quote/Examples/stockdump.pl fondsweb LU0119891520 LU2027374805 $VAR1 = { 'LU0119891520last' => '708.99', 'LU2027374805date' => '03/05/2021', 'LU0119891520isin' => 'LU0119891520941135', 'LU0119891520method' => 'fondsweb', 'LU0119891520success' => 1, 'LU2027374805nav' => '708.99', 'LU0119891520type' => 'fund', 'LU2027374805name' => 'MEDICAL BioHealth EURMorgan Stanley INVF Global Endurance Fund (USD) Z', 'LU2027374805isodate' => '2021-03-05', 'LU2027374805currency' => 'EUR', 'LU0119891520year_range' => '807.77 - 414.77', 'LU0119891520nav' => '708.99', 'LU2027374805success' => 1, 'LU2027374805last' => '708.99', 'LU0119891520date' => '03/05/2021', 'LU2027374805method' => 'fondsweb', 'LU2027374805isin' => 'LU0119891520941135', 'LU2027374805year_range' => '807.77 - 414.77', 'LU0119891520currency' => 'EUR', 'LU0119891520isodate' => '2021-03-05', 'LU0119891520name' => 'MEDICAL BioHealth EUR', 'LU2027374805type' => 'fund' }; While if I do ~/.cpan/build/finance-quote/Examples/stockdump.pl yahoo_json CSCO AAPL I get $VAR1 = { 'CSCOlast' => '46.25', 'AAPLvolume' => 153766501, 'AAPLhigh' => '121.935', 'CSCOpe' => '19.351463', 'AAPLname' => 'AAPL (Apple Inc.)', 'AAPLopen' => '120.98', 'AAPLcurrency' => 'USD', 'CSCOisodate' => '2021-03-05', 'CSCOdate' => '03/05/2021', 'CSCOeps' => '2.39', 'CSCOtype' => 'EQUITY', 'CSCOexchange' => 'Sourced from Yahoo Finance (as JSON)', 'CSCOmethod' => 'yahoo_json', 'CSCOlow' => '45.27', 'AAPLsymbol' => 'AAPL', 'CSCOclose' => '44.56', 'AAPLdiv_yield' => '0.67177224', 'CSCOyear_range' => ' 32.4 - 49.34', 'CSCOsuccess' => 1, 'CSCOcurrency' => 'USD', 'CSCOhigh' => '46.74', 'CSCOopen' => '45.4455', 'AAPLpe' => '32.931923', 'CSCOname' => 'CSCO (Cisco Systems, Inc.)', 'CSCOvolume' => 33197580, 'AAPLlast' => '121.42', 'AAPLtype' => 'EQUITY', 'AAPLisodate' => '2021-03-05', 'AAPLeps' => '3.687', 'AAPLdate' => '03/05/2021', 'AAPLlow' => '117.57', 'AAPLexchange' => 'Sourced from Yahoo Finance (as JSON)', 'AAPLmethod' => 'yahoo_json', 'AAPLsuccess' => 1, 'AAPLyear_range' => ' 53.1525 - 145.09', 'AAPLclose' => '120.13', 'CSCOdiv_yield' => '3.2315977', 'CSCOsymbol' => 'CSCO' }; So ISTM the problem is that Fondsweb.pm isn't able to handle batched requests. Regards, John Ralls _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.