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.

Reply via email to