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 <cleanoutmys...@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 <cleanoutmys...@gmail.com >> <mailto:cleanoutmys...@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 >> <cleanoutmys...@gmail.com <mailto:cleanoutmys...@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@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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@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.
