[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