Re: [GNC] strange lack of exchange rates in a new currency cash account

[Scott Ellsworth]

Hi John,

Every transaction is big enough to equal more than one cent. And the dong cash 
register starts with an ATM withdrawal of 2 million dong. 

In the Price Database, which I was not familiar with before, I see three 
entries, two of which are at zero value. The Account Summary now shows 
"₫540,780.00 $0.00" but the transactions do usually have dollar equivalent 
values: When I look at my Food account I see that the most recent transactions 
were worth $1.18, $0.25, and $38.53. But I notice one transaction from the 
19th, a split transaction where the Food component came out to zero and the 
number fields are simply blank on that line, not with zeroes shown. The other 
parts of the transaction were $6.19 spent from Assets:Cash:vn dong balanced 
against $3.18 spent on Expenses:Health, so the transaction obviously does not 
balance. When I go to the blank line for Expenses:Food and click on Jump, 
nothing happens. But when I go to the Cash:vn dong account and find that 
transaction, I see an amount for the food component, 549,000 dong, which was 
missing in the Food account.

This is confusing. I hope my file is not corrupted, since my financial data is 
important to me. And it's strange that even after I created a second dong cash 
account to test, the new account had the same exact problems.

Be Well,
 
Scott
 Scott Ellsworth || +1 (775) 386-2519 

- Original message -
From: john 
To: Scott Ellsworth 
Cc: GnuCash user forum 
Subject: Re: [GNC] strange lack of exchange rates in a new currency cash account
Date: Friday, July 21, 2023 23:24

Scott,

Did you perhaps get the balance to  2M VND in small increments so that the USD 
value of every transaction rounded to $0.00? That would have prevented the 
price from being recorded, resulting in the symptoms you describe. If you've 
been trying to use VND for several days you can look at the price database 
entries to see if any of the earlier transactions recorded prices.

Regards,
John Ralls

> On Jul 21, 2023, at 01:14, Scott Ellsworth  wrote:
> 
> Another strange thing: It might be starting to work normally now: I just 
> entered a couple of transactions and accidentally entered the exchange rate 
> as 23,600 instead of 1/23,6000. Now it's starting to show the dollar 
> equivalent on the Account Summary, even after I went back and corrected the 
> exchange rate on those two transactions. I'm not sure if it's fixed, but at 
> least for right now it appears to be working normally again.
> 
> Be Well,
> 
> Scott
>  Scott Ellsworth || +1 (775) 386-2519 
> 
> - Original message -
> From: Scott Ellsworth 
> To: gnucash-user@gnucash.org
> Subject: strange lack of exchange rates in a new currency cash account
> Date: Friday, July 21, 2023 15:06
> 
> Dear fellow Gnucash users,
> 
> I have a strange problem with a new currency account that I just added the 
> other day: I created a cash account for Vietnamese dong (VND), and somehow 
> it's not working with exchange rates. The two strange things I'm noticing are:
> 1. Every time I create a new transaction in this account, I have to type in 
> an exchange rate manually. (With other cash accounts (other than USD, my 
> default currency) an exchange rate always is remembered from earlier 
> transactions.)
> 2. On my Account Summary report, I see the new account, which I've named "vn 
> dong" and placed under Assets > Cash, and the number of dong that I have in 
> cash, but the US dollar equivalent always shows up as zero. (I use "Cash" as 
> a placeholder account, under which I have all my cash currencies including US 
> dollars, euros, Japanese yen, etc.) Right now, for example, it shows 
> "₫2,080,870.00   $0.00" but in dollars that should be about $88.
> 
> I thought maybe the new account was somehow corrupted, so I tried creating a 
> new one from scratch, but the same problem occurred again.
> 
> The one thing that is different about this currency compared to all others 
> for which I have cash accounts is that it's very tiny: It's about 23,600 dong 
> per US dollar. Is Gnucash not able to handle such extreme exchange rates?
> 
> Be Well,
> 
> Scott
>  Scott Ellsworth || +1 (775) 386-2519 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record payments for several items paid with a single transaction?

[Chris Green]

On Fri, Jul 21, 2023 at 10:17:12AM +0100, Michael Hendry wrote:
> Hello again Chris.
> 
Hi! :-)

> Comments inserted below:
> 
> On 21 Jul 2023, at 09:09, Chris Green  wrote:
> 
> > 
> > I quite often seem to have cases where several 'items' (see below for
> > the type of thing I mean) are paid for with a single payment to/from a
> > bank account.  What is a good way to record this sort of thing?
> 
> I use separate accounts for recording cash and cheques received 
> (Assets:Current 
> Assets:Cash and Assets:Current Assets:Cheques). This allows for several 
> different items to be recorded in the appropriate income accounts - with 
> splits if (e.g.) a cheque is received for more than one income account. 
> 
But what if one has cash from two collections to go to the same account. 
I.e.  a collection on 22nd July and a collection on 29th July both
paid in at the same time?

-- 
Chris Green
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record payments for several items paid with a single transaction?

[cl]

On Fri, Jul 21, 2023 at 10:17:12AM +0100, Michael Hendry wrote:
> Hello again Chris.
>
Hi! :-)

> >
> > I quite often seem to have cases where several 'items' (see below for
> > the type of thing I mean) are paid for with a single payment to/from a
> > bank account.  What is a good way to record this sort of thing?
>
> I use separate accounts for recording cash and cheques received 
> (Assets:Current
> Assets:Cash and Assets:Current Assets:Cheques). This allows for several
> different items to be recorded in the appropriate income accounts - with
> splits if (e.g.) a cheque is received for more than one income account.
>
But what if one has cash from two collections to go to the same account.
I.e.  a collection on 22nd July and a collection on 29th July both
paid in at the same time?

-- 
Chris Green
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote - AlphaVantage Trade

[Bruce Schuck]

On 07/21/2023 at 18:34 EDT Kaligula wrote:

In general the suffix idea looks like a nice workaround – but I'd 
like to throw in my two cents.


So maybe a general solution in case of AV module pricing errors – a 
".???" suffix (to any ticker, not only LSE ones) where the "???" is 
the currency that the security is traded in? (Or even better with a 
":???" suffix, to avoid confusion with stock exchange suffixes). This

would allow the user to inform the AV module about changes in
default currency – e.g. "GBP.L:GPX" or "MVOL.L:USD".

Kaligula,

Please don't disturb the horse. It's well beyond deceased and we're not 
trying to make glue. At least I am not. I've made my decision on how 
it's going to be handled. I'm not going to waste any more time beyond 
writing this email on this issue.


My original question in this thread was asking how many of the users (at 
least GnuCash users on the email list) used AlphaVantage for non-US 
traded securities. *No one* responded answering that question, but John 
and I had a decent little discussion of the matter.


For a real solution, I would urge anybody using AlphaVantage for quote 
data to contact AV's support and request that the trade currency be 
added to the JSON returned from the GLOBAL_QUOTE API.


As always, F::Q is community supported software. So anyone is welcome to 
submit a pull request.


Bruce S

P.S. Likely any further responses with suggestions or ideas related to 
this issue will be ignored. Please let the Equus ferus caballus rest in 
peace.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] strange lack of exchange rates in a new currency cash account

[john]

Scott,

The simple solution is to fix that split and remove or fix the 0 price entries 
in the pricedb. You should check your other VND transactions to make sure that 
there aren't any other 0-price splits. There's only one set of prices for any 
particular commodity pair so you'd have to make a new book to see different 
price behavior.

The more complicated problem is how did that 0-price split get created and why 
did that become the price for the day instead of one of the others. Would you 
be willing to post a transaction report of the VND account with Display 
optiions set to show date, date entered, accounts, shares, and prices  with one 
line per split? Leave off description, memo, and account to keep confidential 
what you spent the money on, that's irrelevant here.

Regards,
John Ralls



> On Jul 22, 2023, at 01:34, Scott Ellsworth  wrote:
> 
> Hi John,
> 
> Every transaction is big enough to equal more than one cent. And the dong 
> cash register starts with an ATM withdrawal of 2 million dong. 
> 
> In the Price Database, which I was not familiar with before, I see three 
> entries, two of which are at zero value. The Account Summary now shows 
> "₫540,780.00 $0.00" but the transactions do usually have dollar equivalent 
> values: When I look at my Food account I see that the most recent 
> transactions were worth $1.18, $0.25, and $38.53. But I notice one 
> transaction from the 19th, a split transaction where the Food component came 
> out to zero and the number fields are simply blank on that line, not with 
> zeroes shown. The other parts of the transaction were $6.19 spent from 
> Assets:Cash:vn dong balanced against $3.18 spent on Expenses:Health, so the 
> transaction obviously does not balance. When I go to the blank line for 
> Expenses:Food and click on Jump, nothing happens. But when I go to the 
> Cash:vn dong account and find that transaction, I see an amount for the food 
> component, 549,000 dong, which was missing in the Food account.
> 
> This is confusing. I hope my file is not corrupted, since my financial data 
> is important to me. And it's strange that even after I created a second dong 
> cash account to test, the new account had the same exact problems.
> 
> Be Well,
>  
> Scott
>  Scott Ellsworth || +1 (775) 386-2519 
> 
> - Original message -
> From: john mailto:jra...@ceridwen.us>>
> To: Scott Ellsworth mailto:sc...@fastmail.us>>
> Cc: GnuCash user forum  >
> Subject: Re: [GNC] strange lack of exchange rates in a new currency cash 
> account
> Date: Friday, July 21, 2023 23:24
> 
> Scott,
> 
> Did you perhaps get the balance to  2M VND in small increments so that the 
> USD value of every transaction rounded to $0.00? That would have prevented 
> the price from being recorded, resulting in the symptoms you describe. If 
> you've been trying to use VND for several days you can look at the price 
> database entries to see if any of the earlier transactions recorded prices.
> 
> Regards,
> John Ralls
> 
> > On Jul 21, 2023, at 01:14, Scott Ellsworth  > > wrote:
> > 
> > Another strange thing: It might be starting to work normally now: I just 
> > entered a couple of transactions and accidentally entered the exchange rate 
> > as 23,600 instead of 1/23,6000. Now it's starting to show the dollar 
> > equivalent on the Account Summary, even after I went back and corrected the 
> > exchange rate on those two transactions. I'm not sure if it's fixed, but at 
> > least for right now it appears to be working normally again.
> > 
> > Be Well,
> > 
> > Scott
> >  Scott Ellsworth || +1 (775) 386-2519 
> > 
> > - Original message -
> > From: Scott Ellsworth mailto:sc...@fastmail.us>>
> > To: gnucash-user@gnucash.org 
> > Subject: strange lack of exchange rates in a new currency cash account
> > Date: Friday, July 21, 2023 15:06
> > 
> > Dear fellow Gnucash users,
> > 
> > I have a strange problem with a new currency account that I just added the 
> > other day: I created a cash account for Vietnamese dong (VND), and somehow 
> > it's not working with exchange rates. The two strange things I'm noticing 
> > are:
> > 1. Every time I create a new transaction in this account, I have to type in 
> > an exchange rate manually. (With other cash accounts (other than USD, my 
> > default currency) an exchange rate always is remembered from earlier 
> > transactions.)
> > 2. On my Account Summary report, I see the new account, which I've named 
> > "vn dong" and placed under Assets > Cash, and the number of dong that I 
> > have in cash, but the US dollar equivalent always shows up as zero. (I use 
> > "Cash" as a placeholder account, under which I have all my cash currencies 
> > including US dollars, euros, Japanese yen, etc.) Right now, for example, it 
> > shows "₫2,080,870.00   $0.00" but in dollars that should be about $88.
> > 
> > I thought maybe the new accoun

Re: [GNC] How to record payments for several items paid with a single transaction?

[Michael Hendry]

On 22 Jul 2023, at 17:58, c...@isbd.net wrote:

>> 
> But what if one has cash from two collections to go to the same account.
> I.e.  a collection on 22nd July and a collection on 29th July both
> paid in at the same time?
> 

Record the collections individually as Assets:Current Assets:Cash received from 
the appropriate Income: account, one on the 22nd July, the second on the 29th.

When you come to deposit the cash in the current account the cash moves from 
Assets:Current:Cash to Assets:Current:Bank - the original sources of the cash 
aren’t relevant at this point.

The same applies to Cheques Received - the reason the cheque was received is 
recorded as it is received, and a bunch of cheques can be paid into the current 
account without having to specify what the cheques are for.

Regards,

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Trouble building 5.3

[Simon Roberts]

Hi all, I'm looking to build GNC 5.3 on my Ubuntu 20.04 box. I did this as
a trial run on a laptop with Ubuntu 22.04, where it went flawlessly. But,
on this 20.04 "production" machine, the same process is failing. I don't
want to upgrade this at this time if I can help it--it would disturb too
many other things that are working smoothly.

I did this:

$ sudo apt-get build-dep gnucash
Reading package lists... Done
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 191 not upgraded.

(I'm not sure why it installed nothing, I don't think I built GNC on this
before)
But then when I run the cmake process with:

$ cmake -DCMAKE_INSTALL_PREFIX=${HOME}/gnucash5.3 gnucash-5.3/

It progresses a while before reporting:

-- Checking for module 'gwenhywfar>=5.6.0'
--   Requested 'gwenhywfar >= 5.6.0' but version of gwenhywfar is 5.1.3
CMake Error at /usr/share/cmake-3.16/Modules/FindPkgConfig.cmake:463
(message):
  A required package was not found

At the risk of stating the obvious, it seems I have the older version:

$ sudo apt list libgwenhywfar\*
Listing... Done
libgwenhywfar-core-dev/focal,now 5.1.3-1build1 amd64 [installed,automatic]
libgwenhywfar-data/focal,focal,now 5.1.3-1build1 all [installed,automatic]
libgwenhywfar-doc/focal,focal 5.1.3-1build1 all
libgwenhywfar79-dev/focal 5.1.3-1build1 amd64
libgwenhywfar79/focal,now 5.1.3-1build1 amd64 [installed]

And it doesn't seem that 20.04 is willing to upgrade this.

Am I toast? Do I have to have Ubuntu 22.04 if I am to build this
successfully? Or can anyone offer a workaround (e.g. is it perhaps
practical to build the newer version of this library by hand?)

Thanks for any ideas!
Cheers,
Simon

-- 
Simon Roberts
(303) 249 3613
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trouble building 5.3

[Steve Butler]

First I would upgrade those 191 packages.

sudo apt update
sudo apt upgrade

Make sure everything upgradable was upgraded.

Check that you have build-essentials.

On Sat, Jul 22, 2023, 14:15 Simon Roberts 
wrote:

> Hi all, I'm looking to build GNC 5.3 on my Ubuntu 20.04 box. I did this as
> a trial run on a laptop with Ubuntu 22.04, where it went flawlessly. But,
> on this 20.04 "production" machine, the same process is failing. I don't
> want to upgrade this at this time if I can help it--it would disturb too
> many other things that are working smoothly.
>
> I did this:
>
> $ sudo apt-get build-dep gnucash
> Reading package lists... Done
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> 0 upgraded, 0 newly installed, 0 to remove and 191 not upgraded.
>
> (I'm not sure why it installed nothing, I don't think I built GNC on this
> before)
> But then when I run the cmake process with:
>
> $ cmake -DCMAKE_INSTALL_PREFIX=${HOME}/gnucash5.3 gnucash-5.3/
>
> It progresses a while before reporting:
>
> -- Checking for module 'gwenhywfar>=5.6.0'
> --   Requested 'gwenhywfar >= 5.6.0' but version of gwenhywfar is 5.1.3
> CMake Error at /usr/share/cmake-3.16/Modules/FindPkgConfig.cmake:463
> (message):
>   A required package was not found
>
> At the risk of stating the obvious, it seems I have the older version:
>
> $ sudo apt list libgwenhywfar\*
> Listing... Done
> libgwenhywfar-core-dev/focal,now 5.1.3-1build1 amd64 [installed,automatic]
> libgwenhywfar-data/focal,focal,now 5.1.3-1build1 all [installed,automatic]
> libgwenhywfar-doc/focal,focal 5.1.3-1build1 all
> libgwenhywfar79-dev/focal 5.1.3-1build1 amd64
> libgwenhywfar79/focal,now 5.1.3-1build1 amd64 [installed]
>
> And it doesn't seem that 20.04 is willing to upgrade this.
>
> Am I toast? Do I have to have Ubuntu 22.04 if I am to build this
> successfully? Or can anyone offer a workaround (e.g. is it perhaps
> practical to build the newer version of this library by hand?)
>
> Thanks for any ideas!
> Cheers,
> Simon
>
> --
> Simon Roberts
> (303) 249 3613
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record payments for several items paid with a single transaction?

[Michael or Penny Novack]

But what if one has cash from two collections to go to the same account.
I.e.  a collection on 22nd July and a collection on 29th July both
paid in at the same time?

First of all, you are perhaps confusing when money/cash/check received 
with when deposited.


Let's say the following events:

a) 7/14   check $100 for building fund

b) 7/15   check $50   general donation

c) 7/16   collection plate$47.45

d) 7/17   deposited these checks and cash to the bank account

The ley thing to keep in mind is that the bank deposit date has nothing 
to do with when "cash" was received. There are FOUR separate events 
here, three receipts of cash (if normally no "cash box" might call tat 
account "undepositied funds") and each of these credited to the 
appropriate income account and then a fourth transaction transferring 
the undeposaited funds to the bank account.


Is the source of confusion that you are e=required to list each check 
separately on the deposit ticket? THAT has nothing to do with your books 
(nor is it reflected in your bank statement. Think of that as just 
rechecking your sums.


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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record payments for several items paid with a single transaction?

[Liz]

On Sat, 22 Jul 2023 17:56:09 +0100
Chris Green  wrote:

> But what if one has cash from two collections to go to the same
> account. I.e.  a collection on 22nd July and a collection on 29th
> July both paid in at the same time?

One way of doing this is with an intermediate account. You take the
cash from 22nd July and put it in the intermediate account, which could
be called "undeposited funds" or "cash on hand". You do the
same with the cash from 29th July. On banking day you put the cash from
the cash tin in the bank, and move it in your books from the
intermediate account to the bank account.

Summary
Physical movement of funds

collection > count done > cash tin 
2nd collection > count done > cash tin > count done again

cash tin > bank (and another count)

Recorded movement of funds
collection > cash on hand 
2nd collection > cash on hand
cash on hand > bank

I'm sure you will sort this out shortly.

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trouble building 5.3

[Liz]

On Sat, 22 Jul 2023 14:25:38 -0700
Steve Butler  wrote:

> First I would upgrade those 191 packages.
> 
> sudo apt update
> sudo apt upgrade
> 
> Make sure everything upgradable was upgraded.
> 
> Check that you have build-essentials.

May I suggest checking what would happen if you did upgrade first?
sudo apt update
sudo apt -s upgrade


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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to record payments for several items paid with a single transaction?

[Stan Brown]

On 2023-07-22 13:45, Michael Hendry wrote:
> Record the collections individually as Assets:Current Assets:Cash received 
> from the appropriate Income: account, one on the 22nd July, the second on the 
> 29th.

With this I think we all agree. I do, certainly.

> When you come to deposit the cash in the current account the cash> moves from 
> Assets:Current:Cash to Assets:Current:Bank - the original
> sources of the cash aren’t relevant at this point.
> The same applies to Cheques Received - the reason the cheque was
received is recorded as it is received, and a bunch of cheques can be
paid into the current account without having to specify what the cheques
are for.

Or perhaps both cash and checks could go into a single account,
Assets:Deposits Pending. That would perhaps save confusion with a
different Cash account, Petty Cash (American name for cash on hand
intended for making small purchases).

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

[Kaligula]

Please, calm down, Bruce :) That was just an idea.

If I knew Perl as much as I know JavaScript I'd submit a PR yesterday. 
(I know, I made a few modules for private use, they're on my GitHub – 
but it involved much much much more learning than actual writing, and it 
was long ago).


Nevermind. Have a nice day :)

Best regards,
Kaligula

W dniu 22.07.2023 o 19:53, Bruce Schuck pisze:

On 07/21/2023 at 18:34 EDT Kaligula wrote:

In general the suffix idea looks like a nice workaround – but I'd 
like to throw in my two cents.


So maybe a general solution in case of AV module pricing errors – a 
".???" suffix (to any ticker, not only LSE ones) where the "???" is 
the currency that the security is traded in? (Or even better with a 
":???" suffix, to avoid confusion with stock exchange suffixes). This

would allow the user to inform the AV module about changes in
default currency – e.g. "GBP.L:GPX" or "MVOL.L:USD".

Kaligula,

Please don't disturb the horse. It's well beyond deceased and we're 
not trying to make glue. At least I am not. I've made my decision on 
how it's going to be handled. I'm not going to waste any more time 
beyond writing this email on this issue.


My original question in this thread was asking how many of the users 
(at least GnuCash users on the email list) used AlphaVantage for 
non-US traded securities. *No one* responded answering that question, 
but John and I had a decent little discussion of the matter.


For a real solution, I would urge anybody using AlphaVantage for quote 
data to contact AV's support and request that the trade currency be 
added to the JSON returned from the GLOBAL_QUOTE API.


As always, F::Q is community supported software. So anyone is welcome 
to submit a pull request.


Bruce S

P.S. Likely any further responses with suggestions or ideas related to 
this issue will be ignored. Please let the Equus ferus caballus rest 
in peace.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trouble building 5.3

[John Ralls]

> On Jul 22, 2023, at 5:15 PM, Liz  wrote:
> 
> On Sat, 22 Jul 2023 14:25:38 -0700
> Steve Butler  wrote:
> 
>> First I would upgrade those 191 packages.
>> 
>> sudo apt update
>> sudo apt upgrade
>> 
>> Make sure everything upgradable was upgraded.
>> 
>> Check that you have build-essentials.
> 
> May I suggest checking what would happen if you did upgrade first?
> sudo apt update
> sudo apt -s upgrade


It won't help. Ubuntu doesn't update Gwenhywfar and AQBanking post-release, and 
they're not in focal-backports. Gwen 5.6.0 and AQBanking 6.2.10 are in Debian's 
buster-backports (https://backports.debian.org/Instructions/) so you could see 
if you can install them from there.

If that fails they're both pretty easy to build from source. Download from 
https://www.aquamaniac.com.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trouble building 5.3

[Liz]

On Sat, 22 Jul 2023 18:27:52 -0700
John Ralls  wrote:

> > On Jul 22, 2023, at 5:15 PM, Liz  wrote:
> > 
> > On Sat, 22 Jul 2023 14:25:38 -0700
> > Steve Butler  wrote:
> >   
> >> First I would upgrade those 191 packages.
> >> 
> >> sudo apt update
> >> sudo apt upgrade
> >> 
> >> Make sure everything upgradable was upgraded.
> >> 
> >> Check that you have build-essentials.  
> > 
> > May I suggest checking what would happen if you did upgrade first?
> > sudo apt update
> > sudo apt -s upgrade  
> 
> 
> It won't help. Ubuntu doesn't update Gwenhywfar and AQBanking
> post-release, and they're not in focal-backports. Gwen 5.6.0 and
> AQBanking 6.2.10 are in Debian's buster-backports
> (https://backports.debian.org/Instructions/) so you could see if you
> can install them from there.
> 
> If that fails they're both pretty easy to build from source. Download
> from https://www.aquamaniac.com.
> 
> Regards,
> John Ralls
> 

I was thinking that the user would check the output, and see if
gwenhywfar or aqbanking were in the list to be upgraded before
upgrading any packages.
As you note, they wouldn't be, and then the next option is to build the
required packages as well as Gnucash.

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Wells Fargo OFX

[Chris Miller]

   Hi Folks,
   I bank with Wells Fargo and have done so for 30 years. I've used
   QuickBooks and Quicken for most of that time and they have worked out
   well. Regardless, I am not a fan of Intuit.
   I'm investigating GnuCash, and the thing I find most important is being
   able to synchronize my accounts with Wells Fargo. However I'm not
   finding much advice on how to set up OFX.
   Does anybody have experience with this? Does anybody have advice for me
   on how to do it, or if I should do it.
   Thanks for the help,
   Chris.
   Laboriously sent to you from my ... do you really care?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Wells Fargo OFX

[Brad Morrison]

Hi Chris/all,

Did you already review the information & links from my last email 
responding to your OFX/online banking issues?


https://lists.gnucash.org/pipermail/gnucash-user/2023-July/107875.html

If so, did you have more specific questions?

Thanks,

Brad


On 7/22/23 19:13, Chris Miller wrote:

Hi Folks,
I bank with Wells Fargo and have done so for 30 years. I've used
QuickBooks and Quicken for most of that time and they have worked out
well. Regardless, I am not a fan of Intuit.
I'm investigating GnuCash, and the thing I find most important is being
able to synchronize my accounts with Wells Fargo. However I'm not
finding much advice on how to set up OFX.
Does anybody have experience with this? Does anybody have advice for me
on how to do it, or if I should do it.
Thanks for the help,
Chris.
Laboriously sent to you from my ... do you really care?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Wells Fargo OFX

[David T. via gnucash-user]

I'll take the contrarian position and note that there are more ways to 
synchronize your account with the bank's. Some argue that using the bank to 
keep your books up to date leaves you dependent entirely on the bank for 
accuracy. I enter the transactions for my family's activities manually, and 
while it gets tedious at times, it does give me a chance to review the 
transactions and have a check on what we are spending money on. And generally, 
it goes pretty quickly anyway. 

⁣David T. ​

On Jul 23, 2023, 6:12 AM, at 6:12 AM, Brad Morrison  
wrote:
>Hi Chris/all,
>
>Did you already review the information & links from my last email 
>responding to your OFX/online banking issues?
>
>https://lists.gnucash.org/pipermail/gnucash-user/2023-July/107875.html
>
>If so, did you have more specific questions?
>
>Thanks,
>
>Brad
>
>
>On 7/22/23 19:13, Chris Miller wrote:
>> Hi Folks,
>> I bank with Wells Fargo and have done so for 30 years. I've used
>> QuickBooks and Quicken for most of that time and they have worked
>out
>> well. Regardless, I am not a fan of Intuit.
>> I'm investigating GnuCash, and the thing I find most important is
>being
>> able to synchronize my accounts with Wells Fargo. However I'm not
>> finding much advice on how to set up OFX.
>> Does anybody have experience with this? Does anybody have advice
>for me
>> on how to do it, or if I should do it.
>> Thanks for the help,
>> Chris.
>> Laboriously sent to you from my ... do you really care?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
>-
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.