[GNC] Online crypto value quote

[Trang Julie]

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 <cleanoutmyshed at gmail.com> wrote:


> Hi Julie
>
> [Etiquette - always include the gnucash-user at 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 cleanoutmyshed at 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 cleanoutmyshed at 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 at 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2022-06-17 at 10.02.27.png
Type: image/png
Size: 58251 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220617/79f2f384/attachment-0001.png>