Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
Hi John,
it seems currency retrieval does not work with finance-quote 1.50rc1 in
gnucash. currency-lookup.pl works though. I understand it is using
alphavantage.
Can you have a quick look at https://github.com/finance-quote/finance-quote/
issues/173 ?
Is that because of lack of support for the alphavantage key? For stocks this
seem to work though
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ echo '(alphavantage
"MSFT")' | gnc-fq-helper
(("MSFT" (symbol . "MSFT") (gnc:time-no-zone . "2021-03-08 12:00:00") (last .
#e227.3900) (currency . "USD")))
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ gnc-fq-dump alphavantage
MSFT
Finance::Quote fields Gnucash uses:
symbol: MSFT <=== required
date: 03/08/2021 <=== recommended
currency: USD <=== required
last: 227.3900 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$
Thanks
Rainer
--
Rainer Dorsch
http://bokomoko.de/
___
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.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
Am Mittwoch, 10. März 2021, 05:04:34 CET schrieb John Ralls:
> > On Mar 9, 2021, at 1:08 PM, Rainer Dorsch wrote:
> >
> > Hi John,
> >
> > it seems currency retrieval does not work with finance-quote 1.50rc1 in
> > gnucash. currency-lookup.pl works though. I understand it is using
> > alphavantage.
> >
> > Can you have a quick look at
> > https://github.com/finance-quote/finance-quote/ issues/173 ?
> >
> > Is that because of lack of support for the alphavantage key? For stocks
> > this seem to work though
> >
> > rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ echo
> > '(alphavantage
> > "MSFT")' | gnc-fq-helper
> > (("MSFT" (symbol . "MSFT") (gnc:time-no-zone . "2021-03-08 12:00:00")
> > (last . #e227.3900) (currency . "USD")))
> > rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ gnc-fq-dump
> > alphavantage MSFT
> >
> > Finance::Quote fields Gnucash uses:
> >symbol: MSFT <=== required
> >
> > date: 03/08/2021 <=== recommended
> >
> > currency: USD <=== required
> >
> > last: 227.3900 <=\
> >
> > nav: <=== one of these
> >
> > price: <=/
> >
> > timezone: <=== optional
> >
> > rd@h370:/usr/share/doc/libfinance-quote-perl/examples$
>
> Ranier,
>
> You need to set ALPHAVANTAGE_API_KEY in the shell in order to use
> gnc-fq-dump or gnc-fq-helper. To use it in GnuCash you set it in
> Preferences>Online Quotes.
Thanks for your quick response. I understood that I have to set
ALPHAVANTAGE_API_KEY as an evironment variable on the command line. For some
reason the command line works with stocks but not with currencies:
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ export
ALPHAVANTAGE_API_KEY=
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ echo '(alphavantage
"MSFT")' | gnc-fq-helper
(("MSFT" (symbol . "MSFT") (gnc:time-no-zone . "2021-03-09 12:00:00") (last .
#e233.7800) (currency . "USD")))
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ echo '(currency "USD"
"EUR")' | gnc-fq-helper
(#f)
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$
even though
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ ~/tmp.nobackup/currency-
lookup.pl USD EUR
USD->EUR = 0.8384
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$
works (with the patch setting ALPHAVANTAGE_API_KEY in currency-lookup.pl, as
shown here https://github.com/finance-quote/finance-quote/issues/
173#issuecomment-793126311 ). This indicates that the information is correctly
retrieved from Alphavantage, but the communication between finance-quote and
gnc-fq-helper does not work properly.
Thanks
Rainer
--
Rainer Dorsch
http://bokomoko.de/
___
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.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 9, 2021, at 1:08 PM, Rainer Dorsch wrote:
>
> Hi John,
>
> it seems currency retrieval does not work with finance-quote 1.50rc1 in
> gnucash. currency-lookup.pl works though. I understand it is using
> alphavantage.
>
> Can you have a quick look at https://github.com/finance-quote/finance-quote/
> issues/173 ?
>
> Is that because of lack of support for the alphavantage key? For stocks this
> seem to work though
>
> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ echo '(alphavantage
> "MSFT")' | gnc-fq-helper
> (("MSFT" (symbol . "MSFT") (gnc:time-no-zone . "2021-03-08 12:00:00") (last .
> #e227.3900) (currency . "USD")))
> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ gnc-fq-dump
> alphavantage
> MSFT
> Finance::Quote fields Gnucash uses:
>symbol: MSFT <=== required
> date: 03/08/2021 <=== recommended
> currency: USD <=== required
> last: 227.3900 <=\
> nav: <=== one of these
> price: <=/
> timezone: <=== optional
> rd@h370:/usr/share/doc/libfinance-quote-perl/examples$
Ranier,
You need to set ALPHAVANTAGE_API_KEY in the shell in order to use gnc-fq-dump
or gnc-fq-helper. To use it in GnuCash you set it in Preferences>Online Quotes.
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.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
Am Montag, 8. März 2021, 02:03:29 CET schrieb John Ralls:
> fondsweb in lowercase (I haven't applied your patches):
>
> echo '(fondsweb "LU2027374805" "LU0119891520")' |
> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
> (("LU2027374805" (symbol . "LU2027374805") (gnc:time-no-zone . "2021-03-05
> 12:00:00") (last . #e68.39) (currency . "USD")) ("LU0119891520" (symbol .
> "LU0119891520") (gnc:time-no-zone . "2021-03-05 12:00:00") (last . #e68.39)
> (currency . "USD")))
works very well:
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$ echo '(fondsweb
"LU2027374805" "LU0119891520")' | gnc-fq-helper
(("LU2027374805" (symbol . "LU2027374805") (gnc:time-no-zone . "2021-03-05
12:00:00") (last . #e68.39) (currency . "USD"))
("LU0119891520" (symbol . "LU0119891520") (gnc:time-no-zone . "2021-03-08
12:00:00") (last . #e727.23) (currency . "EUR")))
rd@h370:/usr/share/doc/libfinance-quote-perl/examples$
Many thanks for your excellent help.
Rainer :-)
--
Rainer Dorsch
http://bokomoko.de/
___
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.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 8, 2021, at 2:37 AM, Geert Janssens wrote: > > Hmm, my mail client insists on munging part of my original message on re- > sending, so here's a manually edited one with my full comment... > > Op zondag 7 maart 2021 20:39:00 CET schreef John Ralls: >> 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? >> > On a tangent, why does gnucash require a symbol key ? The full hash keys also > have the symbol name, albeit in a weird format that can be converted into a > proper two-dimensional hash without too much trouble. I'm doing that in my > work in progress branch: > https://github.com/gjanssens/gnucash/blob/ > c847fa3aa4a5f90fa4dbf93673d3668e9ddc9e22/libgnucash/quotes/finance-quote- > wrapper.in#L107 > > What would be the potential issues if we decided to make the symbol key > optional, assuming we also fix the code to use the symbol part of the hash > keys of course ? gnc-fq-helper already does do that, see https://github.com/Gnucash/gnucash/blob/maint/libgnucash/quotes/gnc-fq-helper.in#L241. I guess we should remove the warning from gnc-fq-dump, it seems to be misleading. 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.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
Hmm, my mail client insists on munging part of my original message on re- sending, so here's a manually edited one with my full comment... Op zondag 7 maart 2021 20:39:00 CET schreef John Ralls: > 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? > On a tangent, why does gnucash require a symbol key ? The full hash keys also have the symbol name, albeit in a weird format that can be converted into a proper two-dimensional hash without too much trouble. I'm doing that in my work in progress branch: https://github.com/gjanssens/gnucash/blob/ c847fa3aa4a5f90fa4dbf93673d3668e9ddc9e22/libgnucash/quotes/finance-quote- wrapper.in#L107 What would be the potential issues if we decided to make the symbol key optional, assuming we also fix the code to use the symbol part of the hash keys of course ? Regards, Geert ___ 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.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
Op zondag 7 maart 2021 20:39:00 CET schreef John Ralls:
> > On Mar 7, 2021, at 11:31 AM, Rainer Dorsch wrote:
> >
> > Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls:
> >>> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch 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'
> >
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 7, 2021, at 2:25 PM, Rainer Dorsch wrote:
>
> Am Sonntag, 7. März 2021, 22:00:04 CET schrieb John Ralls:
>>> On Mar 7, 2021, at 11:39 AM, John Ralls wrote:
On Mar 7, 2021, at 11:31 AM, Rainer Dorsch wrote:
Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls:
>> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch 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.htm
>> l
>> ]>
>>
>> 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',
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
Am Sonntag, 7. März 2021, 22:00:04 CET schrieb John Ralls:
> > On Mar 7, 2021, at 11:39 AM, John Ralls wrote:
> >> On Mar 7, 2021, at 11:31 AM, Rainer Dorsch wrote:
> >>
> >> Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls:
> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch 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.htm
> l
> ]>
>
> 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' =>
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 7, 2021, at 11:39 AM, John Ralls wrote:
>
>
>
>> On Mar 7, 2021, at 11:31 AM, Rainer Dorsch wrote:
>>
>> Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls:
On Mar 7, 2021, at 9:15 AM, Rainer Dorsch 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
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 7, 2021, at 11:31 AM, Rainer Dorsch wrote:
>
> Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls:
>>> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch 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
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
Am Sonntag, 7. März 2021, 19:12:35 CET schrieb John Ralls:
> > On Mar 7, 2021, at 9:15 AM, Rainer Dorsch 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?
Thanks
Rainer
--
Rainer Dorsch
http://bokomoko.de/
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
> On Mar 7, 2021, at 9:15 AM, Rainer Dorsch 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. 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.
Re: [GNC] [GNC-dev] Finance Quote 1.50 release candidate 1 is available
[ 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? Thanks Rainer -- Rainer Dorsch http://bokomoko.de/ ___ 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.
