Good. That eliminates my concern. I hope Julie finds a solution.
On June 17, 2022 11:27:08 PM EDT, David H <hell...@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@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.
