Re: [GNC] Online crypto value quote

2022-06-17 Thread 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 res

Re: [GNC] Online crypto value quote

2022-06-16 Thread 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.