[GNC] Online crypto value quote
Geoff
cleanoutmyshed at gmail.com
Thu Jun 16 22:52:16 EDT 2022
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.
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: yahoo_btc-usd.jpg
Type: image/jpeg
Size: 99952 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220617/eb0ddeda/attachment-0001.jpg>
More information about the gnucash-user
mailing list