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@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 <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. >
_______________________________________________ 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.