[GNC] Online crypto value quote
David T.
sunfish62 at yahoo.com
Sat Jun 18 08:31:57 EDT 2022
Good. That eliminates my concern. I hope Julie finds a solution.
On June 17, 2022 11:27:08 PM EDT, David H <hellvee at gmail.com> wrote:
>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.
>>
More information about the gnucash-user
mailing list