[GNC] Online crypto value quote

David H hellvee at gmail.com
Fri Jun 17 23:27:08 EDT 2022


I've set up BTC and ETH as Digital cash as per Julie's screenshots (I
think) and it seems to retrieve the quotes ok, see below...

Cheers David H

[image: image.png]

On Sat, 18 Jun 2022 at 12:54, David T. via gnucash-user <
gnucash-user at gnucash.org> wrote:

> 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.
> >>
> _______________________________________________
> 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: image.png
Type: image/png
Size: 84511 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220618/b19ccab9/attachment-0001.png>


More information about the gnucash-user mailing list