Re: [GNC] Online crypto value quote

[David T. via gnucash-user]

Good. That eliminates my concern. I hope Julie finds a solution. 

On June 17, 2022 11:27:08 PM EDT, David H  wrote:
>I've set up BTC and ETH as Digital cash as per Julie's screenshots (I
>think) and it seems to retrieve the quotes ok, see below...
>
>Cheers David H
>
>[image: image.png]
>
>On Sat, 18 Jun 2022 at 12:54, David T. via gnucash-user <
>gnucash-user@gnucash.org> wrote:
>
>> I'll note that Julie's first attachment stated that quotes were not
>> returned for certain entries. Finance::Quote is returning that error, so it
>> is installed.
>>
>> I see in Julie's attachment that her bitcoin entry is assigned to "Digital
>> Cash". The screen shot for the Yahoo! suggests that their site categorizes
>> bitcoin in CCC. I know in the past that F::Q would fail to retrieve quotes
>> unless I matched this exactly. You might try changing "Digital Cash" to
>> "CCC" and see what happens.
>>
>>
>> On June 16, 2022 10:52:16 PM EDT, Geoff  wrote:
>> >Hi David
>> >
>> >Yes, Bitcoin certainly is quoted on Yahoo:
>> >
>> >https://finance.yahoo.com/quote/BTC-USD/
>> >
>> >Julia's problem is with Finance::Quote itself, not Bitcoin, as she can't
>> get quotes for IBM.
>> >
>> >Regards
>> >
>> >Geoff
>> >=
>> >
>> >
>> >
>> >On 17/06/2022 12:42 pm, David Carlson wrote:
>> >> I don't trade bitcoin so I don't know for sure, but for a long time
>> bitcoin was not an officially recognized currency and GnuCash was not able
>> to track it unless the user jumped through some tricky hoops.  I  don't
>> know if that has changed yet. Is it quoted on Yahoo?
>> >>
>> >> On Thu, Jun 16, 2022, 8:22 PM Geoff > cleanoutmys...@gmail.com>> wrote:
>> >>
>> >> Hi Julie
>> >>
>> >> You say that you have "successfully installed" Finance::Quote.  We
>> need
>> >> to verify that is is actually working, independently of GnuCash.
>> The
>> >> easiest way to do this is to use the gnc-fq-dump utility as I
>> explained
>> >> in my email yesterday.
>> >>
>> >> You need to:
>> >> (A) Locate the folder containing the gnc-fq-dump utility
>> >> (B) Open a Terminal session and navigate to this folder
>> >> (C) Run these two commands:
>> >> perl gnc-fq-dump yahoo_json IBM
>> >> perl gnc-fq-dump yahoo_json BTC-USD
>> >>
>> >> If Finance:Quote is working correctly, you should see something like
>> >> this:
>> >>
>> >> gnc-fq-dump yahoo_json IBM
>> >> Finance::Quote fields Gnucash uses:
>> >>   symbol: IBM  <=== required
>> >> date: 06/17/2022   <=== recommended
>> >> currency: USD  <=== required
>> >> last: 135.67   <=\
>> >>  nav:  <=== one of these
>> >>price:  <=/
>> >> timezone:  <=== optional
>> >>
>> >>
>> >> gnc-fq-dump yahoo_json BTC-USD
>> >> Finance::Quote fields Gnucash uses:
>> >>   symbol: BTC-USD  <=== required
>> >> date: 06/17/2022   <=== recommended
>> >> currency: USD  <=== required
>> >> last: 20453.908<=\
>> >>  nav:  <=== one of these
>> >>price:  <=/
>> >> timezone:  <=== optional
>> >>
>> >>
>> >> Let us know the results.
>> >>
>> >> Regards
>> >>
>> >> Geoff
>> >> =
>> >>
>> >> On 16/06/2022 11:08 pm, Trang Julie wrote:
>> >>  > Thank you very much for your quick response, Geoff.
>> >>  >
>> >>  > Good news is I successfully installed the Finance::Quote version
>> >> 1.51 but still can't get online quotes.
>> >>  > I tried both Yahoo as JSON source and Alpha Vantage, and got API
>> >> key, but the notification still says the same "Unable to retrieve
>> >> quotes", as the screenshot in attached.
>> >>  >
>> >>  > I'm not sure if it's just something with the connection or data
>> >> source or I need to do something else from my end.
>> >>  >
>> >>  >
>> >>  > Sent with Proton Mail secure email.
>> >>  > --- Original Message ---
>> >>  > On Thursday, June 16th, 2022 at 7:47 PM, Geoff
>> >> mailto:cleanoutmys...@gmail.com>> wrote:
>> >>  >
>> >>  >
>> >>  >> Hi Julie
>> >>  >>
>> >>  >>> Does it mean something went wrong with Finance Quote module
>> >> install,
>> >>  >>
>> >>  >> since it doesn't show its version?
>> >>  >>
>> >>  >> Possibly. You can use the GnuCash gnc-fq-dump utility (it is a
>> Perl
>> >>  >> script) to try and narrow down the problem. You didn't mention
>> your
>> >>  >> operating system, but your screenshot looks like MacOS? Anyway,
>> on
>> >>  >> Windows you will typically find this utility in the "C:\Program
>> >> Files
>> >>  >> (x86)\gnucash\bin" directory, and you can run it from a command
>> >> prompt.
>> >>  >> See 

Re: [GNC] Online crypto value quote

[David H]

I've set up BTC and ETH as Digital cash as per Julie's screenshots (I
think) and it seems to retrieve the quotes ok, see below...

Cheers David H

[image: image.png]

On Sat, 18 Jun 2022 at 12:54, David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I'll note that Julie's first attachment stated that quotes were not
> returned for certain entries. Finance::Quote is returning that error, so it
> is installed.
>
> I see in Julie's attachment that her bitcoin entry is assigned to "Digital
> Cash". The screen shot for the Yahoo! suggests that their site categorizes
> bitcoin in CCC. I know in the past that F::Q would fail to retrieve quotes
> unless I matched this exactly. You might try changing "Digital Cash" to
> "CCC" and see what happens.
>
>
> On June 16, 2022 10:52:16 PM EDT, Geoff  wrote:
> >Hi David
> >
> >Yes, Bitcoin certainly is quoted on Yahoo:
> >
> >https://finance.yahoo.com/quote/BTC-USD/
> >
> >Julia's problem is with Finance::Quote itself, not Bitcoin, as she can't
> get quotes for IBM.
> >
> >Regards
> >
> >Geoff
> >=
> >
> >
> >
> >On 17/06/2022 12:42 pm, David Carlson wrote:
> >> I don't trade bitcoin so I don't know for sure, but for a long time
> bitcoin was not an officially recognized currency and GnuCash was not able
> to track it unless the user jumped through some tricky hoops.  I  don't
> know if that has changed yet. Is it quoted on Yahoo?
> >>
> >> On Thu, Jun 16, 2022, 8:22 PM Geoff  cleanoutmys...@gmail.com>> wrote:
> >>
> >> Hi Julie
> >>
> >> You say that you have "successfully installed" Finance::Quote.  We
> need
> >> to verify that is is actually working, independently of GnuCash.
> The
> >> easiest way to do this is to use the gnc-fq-dump utility as I
> explained
> >> in my email yesterday.
> >>
> >> You need to:
> >> (A) Locate the folder containing the gnc-fq-dump utility
> >> (B) Open a Terminal session and navigate to this folder
> >> (C) Run these two commands:
> >> perl gnc-fq-dump yahoo_json IBM
> >> perl gnc-fq-dump yahoo_json BTC-USD
> >>
> >> If Finance:Quote is working correctly, you should see something like
> >> this:
> >>
> >> gnc-fq-dump yahoo_json IBM
> >> Finance::Quote fields Gnucash uses:
> >>   symbol: IBM  <=== required
> >> date: 06/17/2022   <=== recommended
> >> currency: USD  <=== required
> >> last: 135.67   <=\
> >>  nav:  <=== one of these
> >>price:  <=/
> >> timezone:  <=== optional
> >>
> >>
> >> gnc-fq-dump yahoo_json BTC-USD
> >> Finance::Quote fields Gnucash uses:
> >>   symbol: BTC-USD  <=== required
> >> date: 06/17/2022   <=== recommended
> >> currency: USD  <=== required
> >> last: 20453.908<=\
> >>  nav:  <=== one of these
> >>price:  <=/
> >> timezone:  <=== optional
> >>
> >>
> >> Let us know the results.
> >>
> >> Regards
> >>
> >> Geoff
> >> =
> >>
> >> On 16/06/2022 11:08 pm, Trang Julie wrote:
> >>  > Thank you very much for your quick response, Geoff.
> >>  >
> >>  > Good news is I successfully installed the Finance::Quote version
> >> 1.51 but still can't get online quotes.
> >>  > I tried both Yahoo as JSON source and Alpha Vantage, and got API
> >> key, but the notification still says the same "Unable to retrieve
> >> quotes", as the screenshot in attached.
> >>  >
> >>  > I'm not sure if it's just something with the connection or data
> >> source or I need to do something else from my end.
> >>  >
> >>  >
> >>  > Sent with Proton Mail secure email.
> >>  > --- Original Message ---
> >>  > On Thursday, June 16th, 2022 at 7:47 PM, Geoff
> >> mailto:cleanoutmys...@gmail.com>> wrote:
> >>  >
> >>  >
> >>  >> Hi Julie
> >>  >>
> >>  >>> Does it mean something went wrong with Finance Quote module
> >> install,
> >>  >>
> >>  >> since it doesn't show its version?
> >>  >>
> >>  >> Possibly. You can use the GnuCash gnc-fq-dump utility (it is a
> Perl
> >>  >> script) to try and narrow down the problem. You didn't mention
> your
> >>  >> operating system, but your screenshot looks like MacOS? Anyway,
> on
> >>  >> Windows you will typically find this utility in the "C:\Program
> >> Files
> >>  >> (x86)\gnucash\bin" directory, and you can run it from a command
> >> prompt.
> >>  >> See attached screenshot for an example of successfully fetching
> >> prices
> >>  >> for IBM and Bitcoin using Yahoo.
> >>  >>
> >>  >> See if you can try this and let us know the results.
> >>  >>
> >>  >> Someone more familiar 

Re: [GNC] Online crypto value quote

[David T. via gnucash-user]

I'll note that Julie's first attachment stated that quotes were not returned 
for certain entries. Finance::Quote is returning that error, so it is 
installed. 

I see in Julie's attachment that her bitcoin entry is assigned to "Digital 
Cash". The screen shot for the Yahoo! suggests that their site categorizes 
bitcoin in CCC. I know in the past that F::Q would fail to retrieve quotes 
unless I matched this exactly. You might try changing "Digital Cash" to "CCC" 
and see what happens. 


On June 16, 2022 10:52:16 PM EDT, Geoff  wrote:
>Hi David
>
>Yes, Bitcoin certainly is quoted on Yahoo:
>
>https://finance.yahoo.com/quote/BTC-USD/
>
>Julia's problem is with Finance::Quote itself, not Bitcoin, as she can't get 
>quotes for IBM.
>
>Regards
>
>Geoff
>=
>
>
>
>On 17/06/2022 12:42 pm, David Carlson wrote:
>> I don't trade bitcoin so I don't know for sure, but for a long time bitcoin 
>> was not an officially recognized currency and GnuCash was not able to track 
>> it unless the user jumped through some tricky hoops.  I  don't know if that 
>> has changed yet. Is it quoted on Yahoo?
>> 
>> On Thu, Jun 16, 2022, 8:22 PM Geoff > > wrote:
>> 
>> Hi Julie
>> 
>> You say that you have "successfully installed" Finance::Quote.  We need
>> to verify that is is actually working, independently of GnuCash.  The
>> easiest way to do this is to use the gnc-fq-dump utility as I explained
>> in my email yesterday.
>> 
>> You need to:
>> (A) Locate the folder containing the gnc-fq-dump utility
>> (B) Open a Terminal session and navigate to this folder
>> (C) Run these two commands:
>> perl gnc-fq-dump yahoo_json IBM
>> perl gnc-fq-dump yahoo_json BTC-USD
>> 
>> If Finance:Quote is working correctly, you should see something like
>> this:
>> 
>> gnc-fq-dump yahoo_json IBM
>> Finance::Quote fields Gnucash uses:
>>       symbol: IBM                  <=== required
>>         date: 06/17/2022           <=== recommended
>>     currency: USD                  <=== required
>>         last: 135.67               <=\
>>          nav:                      <=== one of these
>>        price:                      <=/
>>     timezone:                      <=== optional
>> 
>> 
>> gnc-fq-dump yahoo_json BTC-USD
>> Finance::Quote fields Gnucash uses:
>>       symbol: BTC-USD              <=== required
>>         date: 06/17/2022           <=== recommended
>>     currency: USD                  <=== required
>>         last: 20453.908            <=\
>>          nav:                      <=== one of these
>>        price:                      <=/
>>     timezone:                      <=== optional
>> 
>> 
>> Let us know the results.
>> 
>> Regards
>> 
>> Geoff
>> =
>> 
>> On 16/06/2022 11:08 pm, Trang Julie wrote:
>>  > Thank you very much for your quick response, Geoff.
>>  >
>>  > Good news is I successfully installed the Finance::Quote version
>> 1.51 but still can't get online quotes.
>>  > I tried both Yahoo as JSON source and Alpha Vantage, and got API
>> key, but the notification still says the same "Unable to retrieve
>> quotes", as the screenshot in attached.
>>  >
>>  > I'm not sure if it's just something with the connection or data
>> source or I need to do something else from my end.
>>  >
>>  >
>>  > Sent with Proton Mail secure email.
>>  > --- Original Message ---
>>  > On Thursday, June 16th, 2022 at 7:47 PM, Geoff
>> mailto:cleanoutmys...@gmail.com>> wrote:
>>  >
>>  >
>>  >> Hi Julie
>>  >>
>>  >>> Does it mean something went wrong with Finance Quote module
>> install,
>>  >>
>>  >> since it doesn't show its version?
>>  >>
>>  >> Possibly. You can use the GnuCash gnc-fq-dump utility (it is a Perl
>>  >> script) to try and narrow down the problem. You didn't mention your
>>  >> operating system, but your screenshot looks like MacOS? Anyway, on
>>  >> Windows you will typically find this utility in the "C:\Program
>> Files
>>  >> (x86)\gnucash\bin" directory, and you can run it from a command
>> prompt.
>>  >> See attached screenshot for an example of successfully fetching
>> prices
>>  >> for IBM and Bitcoin using Yahoo.
>>  >>
>>  >> See if you can try this and let us know the results.
>>  >>
>>  >> Someone more familiar with MacOS than me may be able to help you
>> further.
>>  >>
>>  >> Regards
>>  >>
>>  >> Geoff
>>  >> =
>>  >> P.S. Accountants (I am not one) may have opinions on the merits of
>>  >> treating Bitcoin as a Security vs a Currency.
>>  >>
>>  >>
>>  >> On 16/06/2022 1:06 pm, Trang Julie via gnucash-user wrote:
>>  >>
>>  >>> Hi team.
>>  >>>
>>  >>> I'm Julie, I need your help on how to get online 

Re: [GNC] Online crypto value quote

[Adrien Monteleone]

That's the thing with server errors. Sometimes they are quite transient. 
I've done a simple reload of a page, or re-run a command and received 
expected results right after a 500-class error.


Regards,
Adrien

On 6/17/22 11:31 AM, Richard Ullger via gnucash-user wrote:
That's strange, I don't have any issues getting crypto quotes using 
yahoo json as the source.


___
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] Online crypto value quote

[Richard Ullger via gnucash-user]

That's strange, I don't have any issues getting crypto quotes using 
yahoo json as the source.


Regards,

Richard


On 17/06/2022 16:17, Adrien Monteleone wrote:

The error message reports "500" as the status code. That's an Internal
Server Error, so it isn't you. Unfortunately, "500" is a generic
catch-all for server errors, so there isn't any further information as
to what type of error. There's nothing you can do but wait. (at least
for Yahoo)

Try getting individual quotes in the Terminal using AlphaVantage.

Regards,
Adrien

On 6/17/22 2:34 AM, Trang Julie via gnucash-user wrote:

Thank you, Geoff,

I tried and it says as in attached screenshot.



___
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.




OpenPGP_0x10E7349A8F376444.asc
Description: OpenPGP public key


OpenPGP_signature
Description: OpenPGP digital signature


signature.asc
Description: OpenPGP digital signature
___
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] Online crypto value quote

[Adrien Monteleone]

The error message reports "500" as the status code. That's an Internal 
Server Error, so it isn't you. Unfortunately, "500" is a generic 
catch-all for server errors, so there isn't any further information as 
to what type of error. There's nothing you can do but wait. (at least 
for Yahoo)


Try getting individual quotes in the Terminal using AlphaVantage.

Regards,
Adrien

On 6/17/22 2:34 AM, Trang Julie via gnucash-user wrote:

Thank you, Geoff,

I tried and it says as in attached screenshot.



___
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] Online crypto value quote

[Liz Dodd]

On Fri, 17 Jun 2022 12:51:25 +1000
Geoff  wrote:

> [Etiquette - always include the  list in
> all your emails.]

The OP is not subscribed to the list, and so has to wait for me to
approve the postings.

Liz
___
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] Online crypto value quote

[Trang Julie via gnucash-user]

Thank you, Geoff,

I tried and it says as in attached screenshot.

Sent with Proton Mail secure email.
--- Original Message ---
On Friday, June 17th, 2022 at 9:51 AM, Geoff  wrote:


> Hi Julie
>
> [Etiquette - always include the gnucash-user@gnucash.org list in all
>
> your emails.]
>
> OK, we need to try and find out why Finance::Quote itself is not working.
>
> Please try this command (all one line):
>
> perl -MFinance::Quote -e 'my $q = Finance::Quote->new(); print
>
> $q->fetch(q/yahoo_json/,q/IBM/);'
>
>
>
> Regards
>
> Geoff
> =
>
> On 17/06/2022 12:05 pm, Trang Julie wrote:
>
> > Thank you for your respond, Geoff!
> >
> > You're right when you suggested verifying if it's working properly.
> > I see the details such as date, currency, etc are missing. Attached is the 
> > screenshot.
> > Could you let me know what I should do?
> >
> > Thank you
> > Julie
> >
> >
> > Sent with Proton Mail secure email.
> > --- Original Message ---
> > On Friday, June 17th, 2022 at 8:21 AM, Geoff cleanoutmys...@gmail.com wrote:
> >
> > > Hi Julie
> > >
> > > You say that you have "successfully installed" Finance::Quote. We need
> > > to verify that is is actually working, independently of GnuCash. The
> > > easiest way to do this is to use the gnc-fq-dump utility as I explained
> > > in my email yesterday.
> > >
> > > You need to:
> > > (A) Locate the folder containing the gnc-fq-dump utility
> > > (B) Open a Terminal session and navigate to this folder
> > > (C) Run these two commands:
> > > perl gnc-fq-dump yahoo_json IBM
> > > perl gnc-fq-dump yahoo_json BTC-USD
> > >
> > > If Finance:Quote is working correctly, you should see something like this:
> > >
> > > gnc-fq-dump yahoo_json IBM
> > > Finance::Quote fields Gnucash uses:
> > > symbol: IBM <=== required
> > > date: 06/17/2022 <=== recommended
> > > currency: USD <=== required
> > > last: 135.67 <=\
> > > nav: <=== one of these
> > > price: <=/
> > > timezone: <=== optional
> > >
> > > gnc-fq-dump yahoo_json BTC-USD
> > > Finance::Quote fields Gnucash uses:
> > > symbol: BTC-USD <=== required
> > > date: 06/17/2022 <=== recommended
> > > currency: USD <=== required
> > > last: 20453.908 <=\
> > > nav: <=== one of these
> > > price: <=/
> > > timezone: <=== optional
> > >
> > > Let us know the results.
> > >
> > > Regards
> > >
> > > Geoff
> > > =
> > >
> > > On 16/06/2022 11:08 pm, Trang Julie wrote:
> > >
> > > > Thank you very much for your quick response, Geoff.
> > > >
> > > > Good news is I successfully installed the Finance::Quote version 1.51 
> > > > but still can't get online quotes.
> > > > I tried both Yahoo as JSON source and Alpha Vantage, and got API key, 
> > > > but the notification still says the same "Unable to retrieve quotes", 
> > > > as the screenshot in attached.
> > > >
> > > > I'm not sure if it's just something with the connection or data source 
> > > > or I need to do something else from my end.
> > > >
> > > > Sent with Proton Mail secure email.
> > > > --- Original Message ---
> > > > On Thursday, June 16th, 2022 at 7:47 PM, Geoff cleanoutmys...@gmail.com 
> > > > wrote:
> > > >
> > > > > Hi Julie
> > > > >
> > > > > > Does it mean something went wrong with Finance Quote module install,
> > > > >
> > > > > since it doesn't show its version?
> > > > >
> > > > > Possibly. You can use the GnuCash gnc-fq-dump utility (it is a Perl
> > > > > script) to try and narrow down the problem. You didn't mention your
> > > > > operating system, but your screenshot looks like MacOS? Anyway, on
> > > > > Windows you will typically find this utility in the "C:\Program Files
> > > > > (x86)\gnucash\bin" directory, and you can run it from a command 
> > > > > prompt.
> > > > > See attached screenshot for an example of successfully fetching prices
> > > > > for IBM and Bitcoin using Yahoo.
> > > > >
> > > > > See if you can try this and let us know the results.
> > > > >
> > > > > Someone more familiar with MacOS than me may be able to help you 
> > > > > further.
> > > > >
> > > > > Regards
> > > > >
> > > > > Geoff
> > > > > =
> > > > > P.S. Accountants (I am not one) may have opinions on the merits of
> > > > > treating Bitcoin as a Security vs a Currency.
> > > > >
> > > > > On 16/06/2022 1:06 pm, Trang Julie via gnucash-user wrote:
> > > > >
> > > > > > Hi team.
> > > > > >
> > > > > > I'm Julie, I need your help on how to get online crypto value 
> > > > > > quotes.
> > > > > >
> > > > > > I tried the Tools > Security Editor and also Price Database but it 
> > > > > > didn't work. Screenshot attached.
> > > > > >
> > > > > > In the About, it says:
> > > > > > "Version: 4.10
> > > > > > Build ID: 4.10+(2022-03-26)Finance::Quote: -"
> > > > > >
> > > > > > Does it mean something went wrong with Finance Quote module 
> > > > > > install, since it doesn't show its version?
> > > > > >
> > > > > > Thank you very much for your work.
> > > > > > Julie
> > > > > >
> > > > > > Sent with Proton Mail secure email.
> > > 

Re: [GNC] Online crypto value quote

[Geoff]

Hi David

Yes, Bitcoin certainly is quoted on Yahoo:

https://finance.yahoo.com/quote/BTC-USD/

Julia's problem is with Finance::Quote itself, not Bitcoin, as she can't 
get quotes for IBM.


Regards

Geoff
=



On 17/06/2022 12:42 pm, David Carlson wrote:
I don't trade bitcoin so I don't know for sure, but for a long time 
bitcoin was not an officially recognized currency and GnuCash was not 
able to track it unless the user jumped through some tricky hoops.  I  
don't know if that has changed yet. Is it quoted on Yahoo?


On Thu, Jun 16, 2022, 8:22 PM Geoff > wrote:


Hi Julie

You say that you have "successfully installed" Finance::Quote.  We need
to verify that is is actually working, independently of GnuCash.  The
easiest way to do this is to use the gnc-fq-dump utility as I explained
in my email yesterday.

You need to:
(A) Locate the folder containing the gnc-fq-dump utility
(B) Open a Terminal session and navigate to this folder
(C) Run these two commands:
perl gnc-fq-dump yahoo_json IBM
perl gnc-fq-dump yahoo_json BTC-USD

If Finance:Quote is working correctly, you should see something like
this:

gnc-fq-dump yahoo_json IBM
Finance::Quote fields Gnucash uses:
      symbol: IBM                  <=== required
        date: 06/17/2022           <=== recommended
    currency: USD                  <=== required
        last: 135.67               <=\
         nav:                      <=== one of these
       price:                      <=/
    timezone:                      <=== optional


gnc-fq-dump yahoo_json BTC-USD
Finance::Quote fields Gnucash uses:
      symbol: BTC-USD              <=== required
        date: 06/17/2022           <=== recommended
    currency: USD                  <=== required
        last: 20453.908            <=\
         nav:                      <=== one of these
       price:                      <=/
    timezone:                      <=== optional


Let us know the results.

Regards

Geoff
=

On 16/06/2022 11:08 pm, Trang Julie wrote:
 > Thank you very much for your quick response, Geoff.
 >
 > Good news is I successfully installed the Finance::Quote version
1.51 but still can't get online quotes.
 > I tried both Yahoo as JSON source and Alpha Vantage, and got API
key, but the notification still says the same "Unable to retrieve
quotes", as the screenshot in attached.
 >
 > I'm not sure if it's just something with the connection or data
source or I need to do something else from my end.
 >
 >
 > Sent with Proton Mail secure email.
 > --- Original Message ---
 > On Thursday, June 16th, 2022 at 7:47 PM, Geoff
mailto:cleanoutmys...@gmail.com>> wrote:
 >
 >
 >> Hi Julie
 >>
 >>> Does it mean something went wrong with Finance Quote module
install,
 >>
 >> since it doesn't show its version?
 >>
 >> Possibly. You can use the GnuCash gnc-fq-dump utility (it is a Perl
 >> script) to try and narrow down the problem. You didn't mention your
 >> operating system, but your screenshot looks like MacOS? Anyway, on
 >> Windows you will typically find this utility in the "C:\Program
Files
 >> (x86)\gnucash\bin" directory, and you can run it from a command
prompt.
 >> See attached screenshot for an example of successfully fetching
prices
 >> for IBM and Bitcoin using Yahoo.
 >>
 >> See if you can try this and let us know the results.
 >>
 >> Someone more familiar with MacOS than me may be able to help you
further.
 >>
 >> Regards
 >>
 >> Geoff
 >> =
 >> P.S. Accountants (I am not one) may have opinions on the merits of
 >> treating Bitcoin as a Security vs a Currency.
 >>
 >>
 >> On 16/06/2022 1:06 pm, Trang Julie via gnucash-user wrote:
 >>
 >>> Hi team.
 >>>
 >>> I'm Julie, I need your help on how to get online crypto value
quotes.
 >>>
 >>> I tried the Tools > Security Editor and also Price Database but
it didn't work. Screenshot attached.
 >>>
 >>> In the About, it says:
 >>> "Version: 4.10
 >>> Build ID: 4.10+(2022-03-26)Finance::Quote: -"
 >>>
 >>> Does it mean something went wrong with Finance Quote module
install, since it doesn't show its version?
 >>>
 >>> Thank you very much for your work.
 >>> Julie
 >>>
 >>> Sent with Proton Mail secure email.
 >>>
 >>> ___
 >>> gnucash-user mailing list
 >>> gnucash-user@gnucash.org 
 >>> To update your subscription preferences or to unsubscribe:
 >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user

 

Re: [GNC] Online crypto value quote

[Geoff]

Hi Julie

[Etiquette - always include the  list in all 
your emails.]


OK, we need to try and find out why Finance::Quote itself is not working.

Please try this command (all one line):

perl -MFinance::Quote -e 'my $q = Finance::Quote->new(); print 
$q->fetch(q/yahoo_json/,q/IBM/);'



Regards

Geoff
=

On 17/06/2022 12:05 pm, Trang Julie wrote:

Thank you for your respond, Geoff!

You're right when you suggested verifying if it's working properly.
I see the details such as date, currency, etc are missing. Attached is the 
screenshot.
Could you let me know what I should do?

Thank you
Julie

Sent with Proton Mail secure email.
--- Original Message ---
On Friday, June 17th, 2022 at 8:21 AM, Geoff  wrote:



Hi Julie

You say that you have "successfully installed" Finance::Quote. We need
to verify that is is actually working, independently of GnuCash. The
easiest way to do this is to use the gnc-fq-dump utility as I explained
in my email yesterday.

You need to:
(A) Locate the folder containing the gnc-fq-dump utility
(B) Open a Terminal session and navigate to this folder
(C) Run these two commands:
perl gnc-fq-dump yahoo_json IBM
perl gnc-fq-dump yahoo_json BTC-USD

If Finance:Quote is working correctly, you should see something like this:

gnc-fq-dump yahoo_json IBM
Finance::Quote fields Gnucash uses:
symbol: IBM <=== required
date: 06/17/2022 <=== recommended
currency: USD <=== required
last: 135.67 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional


gnc-fq-dump yahoo_json BTC-USD
Finance::Quote fields Gnucash uses:
symbol: BTC-USD <=== required
date: 06/17/2022 <=== recommended
currency: USD <=== required
last: 20453.908 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional


Let us know the results.

Regards

Geoff
=

On 16/06/2022 11:08 pm, Trang Julie wrote:


Thank you very much for your quick response, Geoff.

Good news is I successfully installed the Finance::Quote version 1.51 but still 
can't get online quotes.
I tried both Yahoo as JSON source and Alpha Vantage, and got API key, but the 
notification still says the same "Unable to retrieve quotes", as the screenshot 
in attached.

I'm not sure if it's just something with the connection or data source or I 
need to do something else from my end.


Sent with Proton Mail secure email.
--- Original Message ---
On Thursday, June 16th, 2022 at 7:47 PM, Geoff cleanoutmys...@gmail.com wrote:


Hi Julie


Does it mean something went wrong with Finance Quote module install,


since it doesn't show its version?

Possibly. You can use the GnuCash gnc-fq-dump utility (it is a Perl
script) to try and narrow down the problem. You didn't mention your
operating system, but your screenshot looks like MacOS? Anyway, on
Windows you will typically find this utility in the "C:\Program Files
(x86)\gnucash\bin" directory, and you can run it from a command prompt.
See attached screenshot for an example of successfully fetching prices
for IBM and Bitcoin using Yahoo.

See if you can try this and let us know the results.

Someone more familiar with MacOS than me may be able to help you further.

Regards

Geoff
=
P.S. Accountants (I am not one) may have opinions on the merits of
treating Bitcoin as a Security vs a Currency.

On 16/06/2022 1:06 pm, Trang Julie via gnucash-user wrote:


Hi team.

I'm Julie, I need your help on how to get online crypto value quotes.

I tried the Tools > Security Editor and also Price Database but it didn't work. 
Screenshot attached.

In the About, it says:
"Version: 4.10
Build ID: 4.10+(2022-03-26)Finance::Quote: -"

Does it mean something went wrong with Finance Quote module install, since it 
doesn't show its version?

Thank you very much for your work.
Julie

Sent with Proton Mail secure email.

___
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.

___
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] Online crypto value quote

[David Carlson]

I don't trade bitcoin so I don't know for sure, but for a long time bitcoin
was not an officially recognized currency and GnuCash was not able to track
it unless the user jumped through some tricky hoops.  I  don't know if that
has changed yet. Is it quoted on Yahoo?

On Thu, Jun 16, 2022, 8:22 PM Geoff  wrote:

> Hi Julie
>
> You say that you have "successfully installed" Finance::Quote.  We need
> to verify that is is actually working, independently of GnuCash.  The
> easiest way to do this is to use the gnc-fq-dump utility as I explained
> in my email yesterday.
>
> You need to:
> (A) Locate the folder containing the gnc-fq-dump utility
> (B) Open a Terminal session and navigate to this folder
> (C) Run these two commands:
> perl gnc-fq-dump yahoo_json IBM
> perl gnc-fq-dump yahoo_json BTC-USD
>
> If Finance:Quote is working correctly, you should see something like this:
>
> gnc-fq-dump yahoo_json IBM
> Finance::Quote fields Gnucash uses:
>  symbol: IBM  <=== required
>date: 06/17/2022   <=== recommended
>currency: USD  <=== required
>last: 135.67   <=\
> nav:  <=== one of these
>   price:  <=/
>timezone:  <=== optional
>
>
> gnc-fq-dump yahoo_json BTC-USD
> Finance::Quote fields Gnucash uses:
>  symbol: BTC-USD  <=== required
>date: 06/17/2022   <=== recommended
>currency: USD  <=== required
>last: 20453.908<=\
> nav:  <=== one of these
>   price:  <=/
>timezone:  <=== optional
>
>
> Let us know the results.
>
> Regards
>
> Geoff
> =
>
> On 16/06/2022 11:08 pm, Trang Julie wrote:
> > Thank you very much for your quick response, Geoff.
> >
> > Good news is I successfully installed the Finance::Quote version 1.51
> but still can't get online quotes.
> > I tried both Yahoo as JSON source and Alpha Vantage, and got API key,
> but the notification still says the same "Unable to retrieve quotes", as
> the screenshot in attached.
> >
> > I'm not sure if it's just something with the connection or data source
> or I need to do something else from my end.
> >
> >
> > Sent with Proton Mail secure email.
> > --- Original Message ---
> > On Thursday, June 16th, 2022 at 7:47 PM, Geoff 
> wrote:
> >
> >
> >> Hi Julie
> >>
> >>> Does it mean something went wrong with Finance Quote module install,
> >>
> >> since it doesn't show its version?
> >>
> >> Possibly. You can use the GnuCash gnc-fq-dump utility (it is a Perl
> >> script) to try and narrow down the problem. You didn't mention your
> >> operating system, but your screenshot looks like MacOS? Anyway, on
> >> Windows you will typically find this utility in the "C:\Program Files
> >> (x86)\gnucash\bin" directory, and you can run it from a command prompt.
> >> See attached screenshot for an example of successfully fetching prices
> >> for IBM and Bitcoin using Yahoo.
> >>
> >> See if you can try this and let us know the results.
> >>
> >> Someone more familiar with MacOS than me may be able to help you
> further.
> >>
> >> Regards
> >>
> >> Geoff
> >> =
> >> P.S. Accountants (I am not one) may have opinions on the merits of
> >> treating Bitcoin as a Security vs a Currency.
> >>
> >>
> >> On 16/06/2022 1:06 pm, Trang Julie via gnucash-user wrote:
> >>
> >>> Hi team.
> >>>
> >>> I'm Julie, I need your help on how to get online crypto value quotes.
> >>>
> >>> I tried the Tools > Security Editor and also Price Database but it
> didn't work. Screenshot attached.
> >>>
> >>> In the About, it says:
> >>> "Version: 4.10
> >>> Build ID: 4.10+(2022-03-26)Finance::Quote: -"
> >>>
> >>> Does it mean something went wrong with Finance Quote module install,
> since it doesn't show its version?
> >>>
> >>> Thank you very much for your work.
> >>> Julie
> >>>
> >>> Sent with Proton Mail secure email.
> >>>
> >>> ___
> >>> 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.
> ___
> 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] Online crypto value quote

[Trang Julie via gnucash-user]

Thank you very much for your quick response, Geoff.

Good news is I successfully installed the Finance::Quote version 1.51 but still 
can't get online quotes.
I tried both Yahoo as JSON source and Alpha Vantage, and got API key, but the 
notification still says the same "Unable to retrieve quotes", as the screenshot 
in attached.

I'm not sure if it's just something with the connection or data source or I 
need to do something else from my end.


Sent with Proton Mail secure email.
--- Original Message ---
On Thursday, June 16th, 2022 at 7:47 PM, Geoff  wrote:


> Hi Julie
>
> > Does it mean something went wrong with Finance Quote module install,
>
> since it doesn't show its version?
>
> Possibly. You can use the GnuCash gnc-fq-dump utility (it is a Perl
> script) to try and narrow down the problem. You didn't mention your
> operating system, but your screenshot looks like MacOS? Anyway, on
> Windows you will typically find this utility in the "C:\Program Files
> (x86)\gnucash\bin" directory, and you can run it from a command prompt.
> See attached screenshot for an example of successfully fetching prices
> for IBM and Bitcoin using Yahoo.
>
> See if you can try this and let us know the results.
>
> Someone more familiar with MacOS than me may be able to help you further.
>
> Regards
>
> Geoff
> =
> P.S. Accountants (I am not one) may have opinions on the merits of
> treating Bitcoin as a Security vs a Currency.
>
>
> On 16/06/2022 1:06 pm, Trang Julie via gnucash-user wrote:
>
> > Hi team.
> >
> > I'm Julie, I need your help on how to get online crypto value quotes.
> >
> > I tried the Tools > Security Editor and also Price Database but it didn't 
> > work. Screenshot attached.
> >
> > In the About, it says:
> > "Version: 4.10
> > Build ID: 4.10+(2022-03-26)Finance::Quote: -"
> >
> > Does it mean something went wrong with Finance Quote module install, since 
> > it doesn't show its version?
> >
> > Thank you very much for your work.
> > Julie
> >
> > Sent with Proton Mail secure email.
> >
> > ___
> > 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.___
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] Online crypto value quote

[Geoff]

Hi Julie

You say that you have "successfully installed" Finance::Quote.  We need 
to verify that is is actually working, independently of GnuCash.  The 
easiest way to do this is to use the gnc-fq-dump utility as I explained 
in my email yesterday.


You need to:
(A) Locate the folder containing the gnc-fq-dump utility
(B) Open a Terminal session and navigate to this folder
(C) Run these two commands:
perl gnc-fq-dump yahoo_json IBM
perl gnc-fq-dump yahoo_json BTC-USD

If Finance:Quote is working correctly, you should see something like this:

gnc-fq-dump yahoo_json IBM
Finance::Quote fields Gnucash uses:
symbol: IBM  <=== required
  date: 06/17/2022   <=== recommended
  currency: USD  <=== required
  last: 135.67   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional


gnc-fq-dump yahoo_json BTC-USD
Finance::Quote fields Gnucash uses:
symbol: BTC-USD  <=== required
  date: 06/17/2022   <=== recommended
  currency: USD  <=== required
  last: 20453.908<=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional


Let us know the results.

Regards

Geoff
=

On 16/06/2022 11:08 pm, Trang Julie wrote:

Thank you very much for your quick response, Geoff.

Good news is I successfully installed the Finance::Quote version 1.51 but still 
can't get online quotes.
I tried both Yahoo as JSON source and Alpha Vantage, and got API key, but the 
notification still says the same "Unable to retrieve quotes", as the screenshot 
in attached.

I'm not sure if it's just something with the connection or data source or I 
need to do something else from my end.


Sent with Proton Mail secure email.
--- Original Message ---
On Thursday, June 16th, 2022 at 7:47 PM, Geoff  wrote:



Hi Julie


Does it mean something went wrong with Finance Quote module install,


since it doesn't show its version?

Possibly. You can use the GnuCash gnc-fq-dump utility (it is a Perl
script) to try and narrow down the problem. You didn't mention your
operating system, but your screenshot looks like MacOS? Anyway, on
Windows you will typically find this utility in the "C:\Program Files
(x86)\gnucash\bin" directory, and you can run it from a command prompt.
See attached screenshot for an example of successfully fetching prices
for IBM and Bitcoin using Yahoo.

See if you can try this and let us know the results.

Someone more familiar with MacOS than me may be able to help you further.

Regards

Geoff
=
P.S. Accountants (I am not one) may have opinions on the merits of
treating Bitcoin as a Security vs a Currency.


On 16/06/2022 1:06 pm, Trang Julie via gnucash-user wrote:


Hi team.

I'm Julie, I need your help on how to get online crypto value quotes.

I tried the Tools > Security Editor and also Price Database but it didn't work. 
Screenshot attached.

In the About, it says:
"Version: 4.10
Build ID: 4.10+(2022-03-26)Finance::Quote: -"

Does it mean something went wrong with Finance Quote module install, since it 
doesn't show its version?

Thank you very much for your work.
Julie

Sent with Proton Mail secure email.

___
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.

___
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] Online crypto value quote

[Geoff]

Hi Julie

>Does it mean something went wrong with Finance Quote module install, 
since it doesn't show its version?


Possibly.  You can use the GnuCash gnc-fq-dump utility (it is a Perl 
script) to try and narrow down the problem.  You didn't mention your 
operating system, but your screenshot looks like MacOS?  Anyway, on 
Windows you will typically find this utility in the "C:\Program Files 
(x86)\gnucash\bin" directory, and you can run it from a command prompt. 
 See attached screenshot for an example of successfully fetching prices 
for IBM and Bitcoin using Yahoo.


See if you can try this and let us know the results.

Someone more familiar with MacOS than me may be able to help you further.

Regards

Geoff
=
P.S. Accountants (I am not one) may have opinions on the merits of 
treating Bitcoin as a Security vs a Currency.



On 16/06/2022 1:06 pm, Trang Julie via gnucash-user wrote:

Hi team.

I'm Julie, I need your help on how to get online crypto value quotes.

I tried the Tools > Security Editor and also Price Database but it didn't work. 
Screenshot attached.

In the About, it says:
"Version: 4.10
Build ID: 4.10+(2022-03-26)Finance::Quote: -"

Does it mean something went wrong with Finance Quote module install, since it 
doesn't show its version?

Thank you very much for your work.
Julie

Sent with [Proton Mail](https://proton.me/) secure email.


___
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.___
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.