[GNC] Online crypto value quote
David T.
sunfish62 at yahoo.com
Fri Jun 17 22:54:41 EDT 2022
I'll note that Julie's first attachment stated that quotes were not returned for certain entries. Finance::Quote is returning that error, so it is installed.
I see in Julie's attachment that her bitcoin entry is assigned to "Digital Cash". The screen shot for the Yahoo! suggests that their site categorizes bitcoin in CCC. I know in the past that F::Q would fail to retrieve quotes unless I matched this exactly. You might try changing "Digital Cash" to "CCC" and see what happens.
On June 16, 2022 10:52:16 PM EDT, Geoff <cleanoutmyshed at gmail.com> wrote:
>Hi David
>
>Yes, Bitcoin certainly is quoted on Yahoo:
>
>https://finance.yahoo.com/quote/BTC-USD/
>
>Julia's problem is with Finance::Quote itself, not Bitcoin, as she can't get quotes for IBM.
>
>Regards
>
>Geoff
>=====
>
>
>
>On 17/06/2022 12:42 pm, David Carlson wrote:
>> I don't trade bitcoin so I don't know for sure, but for a long time bitcoin was not an officially recognized currency and GnuCash was not able to track it unless the user jumped through some tricky hoops. I don't know if that has changed yet. Is it quoted on Yahoo?
>>
>> On Thu, Jun 16, 2022, 8:22 PM Geoff <cleanoutmyshed at gmail.com <mailto: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 <mailto: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 <mailto:gnucash-user at gnucash.org>
>> >>> To update your subscription preferences or to unsubscribe:
>> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> >>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists
>> <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 at gnucash.org <mailto:gnucash-user at gnucash.org>
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists
>> <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.
>>
More information about the gnucash-user
mailing list