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