Re: [GNC] Bitcoin Lightning payments

[HSC]

Unfortunately, the idea of pretending that 1$ = 1BTC doesn't work exactly as it 
should, because the Spend/Receive fields don't accept entries smaller than 
0.01, even if smallest fraction for account is set to 1e-8.
Neither does setting the decimal places to 8 in Preferences > Numbers > Decimal 
places affect Spend/Receive fields. Even setting to 3 doesn't increase them 
beyond 2 decimal places.
GNC just blanks and ignores a number less than 0.01

That's tolerable, if we pretend that 1$ = 1 sat instead of 1 BTC, and round the 
the milisats of fees to nearest 10, as if they are US cents.
That should be close enough for the foreseeable.

HSC

--- Original Message ---
On Saturday, June 18th, 2022 at 04:05, HSC  wrote:


> 

> 

> 

> Thank you, Michael D Novack!
> That's a great solution until GNC development catches up to the crypto world: 
> we will keep separate GNC file for each cryptoasset.
> 

> The remaining problem is that Bitcoin Lightning goes to 11 decimal places, 
> and Ethereum I think goes to 16.
> Will round up to 1 sat for now, since it's still of insignificant value, but 
> eventually that will also need some improvement.
> 

> Another thing is that moving from onchain Bitcoin to its Lightning layer 
> channels and back is a Bitcoin transaction in itself, which involves an 
> onchain fee to open the channel. (Subsequent instant txs in the LN channels 
> are at most a few sats for substantial BTC amount, and small payments txs 
> often cost less than 1 sat - a fraction of a US cent in value - as I 
> mentioned.)
> So, I guess Lightning layer bitcoins will have to be represented by some 
> other fiat of the obscure ones that start with L perhaps.
> 

> The other issue is exchanging BTC for USD stablecoins, such as USDC. Then 
> would have to represent that USD with some other dollar, such as the CAD 
> maybe?
> 

> Might get error-prone. Since even Bitcoin is over a decade old now, seems 
> that it would be useful for GNC to allow "user-defined non-ISO" currencies, 
> such as "XBT" used for Bitcoin on some exchanges.
> Seems unlikely that central banks will ever allow such currencies to become 
> ISO.
> 

> 

> HSC
> 

> 

> --- Original Message ---
> On Saturday, June 18th, 2022 at 02:56, gnucash-user-requ...@gnucash.org wrote:
> 

> 

> 

> > Today's Topics:
> > 

> > 1. Re: Bitcoin Lightning payments (Michael or Penny Novack)
> > 2. Re: Online crypto value quote (David T.)
> > 3. Re: Online crypto value quote (Geoff)
> > 

> > --
> > 

> > Message: 1
> > Date: Fri, 17 Jun 2022 22:45:25 -0400
> > From: Michael or Penny Novack stepbystepf...@comcast.net
> > 

> > To: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Bitcoin Lightning payments
> > Message-ID: 967b4023-8d76-dc43-9fbe-f00854c99...@comcast.net
> > 

> > Content-Type: text/plain; charset=UTF-8; format=flowed
> > 

> > On 6/17/2022 9:21 PM, HSC wrote:
> > 

> > > Hello Everyone,
> > > 

> > > Haven?t used GC a couple years, and trying to recollect how it all works.
> > > 

> > > Current challenge is starting to work with payments and expenses that are 
> > > exclusively in Bitcoin.
> > 

> > > Has anyone experience with some commercial accounting software that 
> > > handles Bitcoin in an easier way as a currency that it is?
> > 

> > IF what you mean by "exclusively in bitcoin" is accounting JUST in
> > bitcoin, you would not have to treat it as stock/commodity evaluated in
> > some other currency. You could keep a set of books denominated in
> > bitcoin. The lack of a currency symbol is an illusion, as they are just
> > conventional symbols. Understand? In YOUR books "$" doesn't have to
> > stand for dollars, it could stand for "bitcoin".
> > 

> > Michael D Novack

signature.asc
Description: OpenPGP digital signature
___
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.

Re: [GNC] Bitcoin Lightning payments

[HSC]

Thank you, Michael D Novack!
That's a great solution until GNC development catches up to the crypto world: 
we will keep separate GNC file for each cryptoasset.

The remaining problem is that Bitcoin Lightning goes to 11 decimal places, and 
Ethereum I think goes to 16.
Will round up to 1 sat for now, since it's still of insignificant value, but 
eventually that will also need some improvement.

Another thing is that moving from onchain Bitcoin to its Lightning layer 
channels and back is a Bitcoin transaction in itself, which involves an onchain 
fee to open the channel. (Subsequent instant txs in the LN channels are at most 
a few sats for substantial BTC amount, and small payments txs  often cost less 
than 1 sat - a fraction of a US cent in value - as I mentioned.)
So, I guess Lightning layer bitcoins will have to be represented by some other 
fiat of the obscure ones that start with L perhaps.

The other issue is exchanging BTC for USD stablecoins, such as USDC. Then would 
have to represent that USD with some other dollar, such as the CAD maybe?

Might get error-prone. Since even Bitcoin is over a decade old now, seems that 
it would be useful for GNC to allow "user-defined non-ISO" currencies, such as 
"XBT" used for Bitcoin on some exchanges.
Seems unlikely that central banks will ever allow such currencies to become ISO.


HSC


--- Original Message ---
On Saturday, June 18th, 2022 at 02:56,  wrote:


> 

> 

> 

> Today's Topics:
> 

> 1. Re: Bitcoin Lightning payments (Michael or Penny Novack)
> 2. Re: Online crypto value quote (David T.)
> 3. Re: Online crypto value quote (Geoff)
> 

> 

> --
> 

> Message: 1
> Date: Fri, 17 Jun 2022 22:45:25 -0400
> From: Michael or Penny Novack stepbystepf...@comcast.net
> 

> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Bitcoin Lightning payments
> Message-ID: 967b4023-8d76-dc43-9fbe-f00854c99...@comcast.net
> 

> Content-Type: text/plain; charset=UTF-8; format=flowed
> 

> On 6/17/2022 9:21 PM, HSC wrote:
> 

> > Hello Everyone,
> > 

> > Haven?t used GC a couple years, and trying to recollect how it all works.
> > 

> > Current challenge is starting to work with payments and expenses that are 
> > exclusively in Bitcoin.
> 

> > Has anyone experience with some commercial accounting software that handles 
> > Bitcoin in an easier way as a currency that it is?
> 

> 

> IF what you mean by "exclusively in bitcoin" is accounting JUST in
> bitcoin, you would not have to treat it as stock/commodity evaluated in
> some other currency. You could keep a set of books denominated in
> bitcoin. The lack of a currency symbol is an illusion, as they are just
> conventional symbols. Understand? In YOUR books "$" doesn't have to
> stand for dollars, it could stand for "bitcoin".
> 

> Michael D Novack
> 

> 

> 

> 

>

signature.asc
Description: OpenPGP digital signature
___
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.

Re: [GNC] Online crypto value quote

[David H]

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  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>> 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
> >> 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

Re: [GNC] Online crypto value quote

[David T. via gnucash-user]

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  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 > > 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
>> 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 crypt

Re: [GNC] Bitcoin Lightning payments

[Michael or Penny Novack]

On 6/17/2022 9:21 PM, HSC wrote:

Hello Everyone,

Haven’t used GC a couple years, and trying to recollect how it all works.

Current challenge is starting to work with payments and expenses that are 
exclusively in Bitcoin.




Has anyone experience with some commercial accounting software that handles 
Bitcoin in an easier way as a currency that it is?


IF what you mean by "exclusively in bitcoin" is accounting JUST in 
bitcoin, you would not have to treat it as stock/commodity evaluated in 
some other currency. You could keep a set of books denominated in 
bitcoin. The lack of a currency symbol is an illusion, as they are just 
conventional symbols. Understand? In YOUR books "$" doesn't have to 
stand for dollars, it could stand for "bitcoin".


Michael D Novack


___
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.

[GNC] Bitcoin Lightning payments

[HSC]

Hello Everyone,

Haven’t used GC a couple years, and trying to recollect how it all works.

Current challenge is starting to work with payments and expenses that are 
exclusively in Bitcoin.
Can’t find the Bitcoin stock vs currency discussion in the archive. Sorry if I 
overlooked it, but I read the workaround here:
https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_manual.html
https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_trading_accts.html.

Seems awkward to treat it as a stock, and not sure that way is even precise, 
because Bitcoin tx fee is in BTC.
Also, the tx fees is just being transferred to the miners; it’s not being sold 
for fiat by the payer.

Main challenge at the moment though is Bitcoin Lightning Network payments. In 
attached example, the payment is sent to a payment processor via LN, converted 
to THB and sent to the vendor.

If Bitcoin is treated as a stock with USD account unit, then GC first converts 
it into USD. Then have to account for BTC tx fee by rounding. 


On LN in particular, the fees are in milisats. (1-e11 BTC) In the example, it 
would be about 50 milisats = 5.0-e10 BTC.
I could calculate what fraction of US cent that would be, but in the long-term 
would add a lot of accounting time for very small txs. Rounding will compound 
the errors.

Is there a way to automate this calculation?

Is my example even the best way to do that?

Has anyone experience with some commercial accounting software that handles 
Bitcoin in an easier way as a currency that it is?

Thank you for your attention.

signature.asc
Description: OpenPGP digital signature
___
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.

Re: [GNC] Online crypto value quote

[Adrien Monteleone]

That's the thing with server errors. Sometimes they are quite transient. 
I've done a simple reload of a page, or re-run a command and received 
expected results right after a 500-class error.


Regards,
Adrien

On 6/17/22 11:31 AM, Richard Ullger via gnucash-user wrote:
That's strange, I don't have any issues getting crypto quotes using 
yahoo json as the source.


___
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.

Re: [GNC] Online crypto value quote

[Richard Ullger via gnucash-user]

That's strange, I don't have any issues getting crypto quotes using 
yahoo json as the source.


Regards,

Richard


On 17/06/2022 16:17, Adrien Monteleone wrote:

The error message reports "500" as the status code. That's an Internal
Server Error, so it isn't you. Unfortunately, "500" is a generic
catch-all for server errors, so there isn't any further information as
to what type of error. There's nothing you can do but wait. (at least
for Yahoo)

Try getting individual quotes in the Terminal using AlphaVantage.

Regards,
Adrien

On 6/17/22 2:34 AM, Trang Julie via gnucash-user wrote:

Thank you, Geoff,

I tried and it says as in attached screenshot.



___
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.




OpenPGP_0x10E7349A8F376444.asc
Description: OpenPGP public key


OpenPGP_signature
Description: OpenPGP digital signature


signature.asc
Description: OpenPGP digital signature
___
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.

Re: [GNC] Online crypto value quote

[Adrien Monteleone]

The error message reports "500" as the status code. That's an Internal 
Server Error, so it isn't you. Unfortunately, "500" is a generic 
catch-all for server errors, so there isn't any further information as 
to what type of error. There's nothing you can do but wait. (at least 
for Yahoo)


Try getting individual quotes in the Terminal using AlphaVantage.

Regards,
Adrien

On 6/17/22 2:34 AM, Trang Julie via gnucash-user wrote:

Thank you, Geoff,

I tried and it says as in attached screenshot.



___
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.

Re: [GNC] Online crypto value quote

[Liz Dodd]

On Fri, 17 Jun 2022 12:51:25 +1000
Geoff  wrote:

> [Etiquette - always include the  list in
> all your emails.]

The OP is not subscribed to the list, and so has to wait for me to
approve the postings.

Liz
___
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.

Re: [GNC] Online crypto value quote

[Trang Julie via gnucash-user]

Thank you, Geoff,

I tried and it says as in attached screenshot.

Sent with Proton Mail secure email.
--- Original Message ---
On Friday, June 17th, 2022 at 9:51 AM, Geoff  wrote:


> Hi Julie
>
> [Etiquette - always include the gnucash-user@gnucash.org list in all
>
> your emails.]
>
> OK, we need to try and find out why Finance::Quote itself is not working.
>
> Please try this command (all one line):
>
> perl -MFinance::Quote -e 'my $q = Finance::Quote->new(); print
>
> $q->fetch(q/yahoo_json/,q/IBM/);'
>
>
>
> Regards
>
> Geoff
> =
>
> On 17/06/2022 12:05 pm, Trang Julie wrote:
>
> > Thank you for your respond, Geoff!
> >
> > You're right when you suggested verifying if it's working properly.
> > I see the details such as date, currency, etc are missing. Attached is the 
> > screenshot.
> > Could you let me know what I should do?
> >
> > Thank you
> > Julie
> >
> >
> > Sent with Proton Mail secure email.
> > --- Original Message ---
> > On Friday, June 17th, 2022 at 8:21 AM, Geoff 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 
> > > > 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.
> > >