[GNC] Online crypto value quote

[Geoff]

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.