[GNC] Online crypto value quote

[Geoff]

Hi Julie

That error message (response code 500) was returned from Yahoo. 
Finance::Quote itself does appear to be working.  Here are two more 
things for you to try:

(1) Repeat that command at different times of the day and night - it may 
be an intermittent problem with Yahoo.

(2) Try accessing the Yahoo URL with a web browser:
https://query1.finance.yahoo.com/v7/finance/quote?symbols=IBM
https://query1.finance.yahoo.com/v7/finance/quote?symbols=BTC-USD
I have attached screenshots showing the expected results.  If not 
successful, repeat at different times of the day and night.

Further questions:
(a) Have you been able to get any other quotes for any other securities?
(b) Are you running a firewall on your computer?
(c) How are you connected to the internet?
(d) Can you try a different connection, for example hot spot from your 
phone or use a connection at a friend's house?
(e) Does your internet service provider block certain web sites or 
otherwise interfere with traffic?
(f) Are you behind a corporate or government firewall or proxy server 
that may interfere with traffic?

Regards

Geoff
=====

On 17/06/2022 5:34 pm, Trang Julie wrote:
> 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: https_jahoo_json.jpg
Type: image/jpeg
Size: 152368 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220618/4029eb1d/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: firefox_jahoo_json.jpg
Type: image/jpeg
Size: 134015 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220618/4029eb1d/attachment-0003.jpg>