[GNC] Finance-Quote 1.53 released!

[Bruce Schuck]

New version 1.52 of Finance-Quote is available with the following changes:

* dist.ini - changed bugtracker.web to
  https://github.com/finance-quote/finance-quote/issues
* DWS.pm - Set $info{$symbol, 'symbol'} to $symbol.
* Union.pm - #231 - reworked for a different CSV file.
* CurrencyRates/AlphaVantage.pm - API CURRENCY_EXCHANGE_RATE
  no longer accepts free API keys. Changed to use FX_DAILY API.
  Issue #229 PR #230
* Set minimum version for LWP::UserAgent in dist.ini to
  honor redirects.
* CurrencyRates/AlphaVantage.pm - Added logic to account
  for empty JSON returned from currency exchange fetch.
* Bourso.pm - Added Europe and France back as failover
  methods. These were removed some time ago in commit e26484b.
* Tradeville.pm - Changed hostname in URL to tradeville.ro.
  Added logic to better account for the symbol not being
  found.
* YahooJSON.pm - #202 - Account for symbols with '&'.
* Minor change to isoTime function in Quote.pm.
* Updated TSP.pm - PR #227 - update URL and handling of dates.

Authors:

  - alex314159 
  - AndreJ 
  - Ben Hemming 
  - Bradley Dean 
  - Brent Neal 
  - Bruce Schuck 
  - Caleb Begly 
  - CleanShed <72849657+cleans...@users.noreply.github.com>
  - David Hampton 
  - Diego Marcolungo 
  - e-dorigatti 
  - Eelco Dolstra 
  - Emmanuel Di Pretoro 
  - Erik Colson 
  - Florian Schlichting 
  - goodvibes2 
  - gregor herrmann 
  - Gustavo R. Montesino 
  - Henrik Ahlgren 
  - Hiranya Samarasekera 
  - Jacinta Richardson 
  - Jalon Avens 
  - Jean-Marie Pacquet 
  - John Haiducek 
  - jvolkening 
  - Lance Wicks 
  - Linas Vepstas 
  - Liviu Tinta 
  - Manuel Friedli 
  - Martin Kompf 
  - Mike Alexander 
  - Paul Fenwick 
  - Paul Howarth 
  - Pawel Konieczny 
  - Pete Ratzlaff 
  - Ross Peachey 
  - Sam Morris 
  - Sigve Indregard 
  - Stephan Ebelt 
  - thinus 
  - Vinay Shastry 
  - Vincent Lucarelli 
  - x42x64 
___
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] Help

[Carl S.]

OpenPGP_0x19B6B68457884FFB.asc
Description: OpenPGP public key


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

Re: [GNC] Mac Installation 4.12 issue

[David T. via gnucash-user]

Hylton,

The main GnuCash page includes a link for installation, and on that 
installation page, the section for macos states: "Once you have downloaded the 
disk image, double click to open it, and then drag the app icon into your 
Applications folder (or anywhere else on your system that you choose)."

Sorry that this wasn't clear to you. 

⁣David T. ​

On Oct 8, 2022, 7:42 PM, at 7:42 PM, "Hylton Conacher (ZR1HPC)" 
 wrote:
>Hi,
>
>I recently downloaded the .dmg file for my OS.
>
>I read the README and several other of the texts and not seeing any 
>reference installation on a Mac I double clicked on the GnuCash icon.
>
>This verified the package and opened it where I was able to create a
>new 
>set of accounts.
>I was puzzled as I had not seen anything about dragging and dropping
>the 
>executable into the Applications folder.
>
>I carried on and made the Mac remember the icon in the task bar.
>
>Each time I execute the app it verifies the package, asks me if I am 
>sure I want to open it as it was downloaded from a website. I confirm 
>and the accounts I created and saved are opened, thank goodness.
>
>I did some Google work and found the GnuCash app does not open a window
>
>showing a Mac user to drag the app into the Applications folder.
>
>I ran the .dmg again and dragged the GnuCash icon to a Finder window 
>open on Applications.
>
>My problem was solved.
>
>Please add something into the README contents about installing on a
>Mac.
>
>Thanks and good gnucashing
>
>Hylton
>___
>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] Reconciling subaccounts

[R Losey]

Well said!

I actually have both kinds of parent accounts, as you described.

On Sat, Oct 8, 2022 at 7:39 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> John,
>
> I don't know about "typically." There are any of a number of ways that
> someone might use placeholder accounts. In my own books, I have placeholder
> accounts for brokerage holdings, where the placeholder represents an
> institution's account and the leaf accounts represent individual
> securities. I also have placeholder accounts that represent a class of
> account types-- for example, a placeholder for savings accounts at
> different institutions.
>
> The OP appears to be using the structure to implement an envelope
> allocation system, in which case the subaccounts are virtual. They want
> both the real and the virtual accounts to show that reconciliation. GnuCash
> doesn't currently do that.
>
> Whether that's a bug or a feature (and whether a sensible implementation
> can be devised to address it) is perhaps a different matter.
>
> ⁣David T.
>
> On Oct 8, 2022, 9:17 AM, at 9:17 AM, John Layman <
> john.lay...@laymanandlayman.com> wrote:
> >Typically, the place holder account represents an institution, not an
> >account.  I have never seen a bank statement that presents rolled up
> >account totals at the institution level.  Each checking account,
> >savings account, money market account, CD holdings, installment loan
> >accounts, etc. are presented separately (even if within the same
> >document) with beginning and ending balances shown separately for each
> >such account.  Balancing could be an absolute nightmare if you had to
> >track down a discrepancy in conglomerated the numbers.
>
-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Ubuntu: Documentation not working

[R Losey]

Thank you. Do you know where the other docs get installed? Perhaps I could
link /usr/share/help to the proper location for the time being.


On Sat, Oct 8, 2022 at 3:41 AM Geert Janssens 
wrote:

> Op zaterdag 8 oktober 2022 09:33:05 CEST schreef R Losey:
>
> > When I installed GnuCash in Ubuntu, it seemed to install everything --
> the
>
> > price quote program as well as the documentation... however, when I run
>
> > GnuCash, it won't find the documentation and speculates that it is not
>
> > installed (but it is). I can take my browser to
>
> > /usr/share/docs/gnucash-docs/gnucash-guide-en/index.html, and everything
>
> > looks fine.
>
> >
>
> > Is there some environment variable I need to set? It would be nice to
> have
>
> > the "Help" buttons actually work.
>
> Ubuntu ships our documentation in the wrong format and in the wrong
> location.
>
> GnuCash expects to find the documentation in docbook format and located in
>
> /usr/share/help.
>
> What you have found in /usr/share/docs is the html formatted version of
> our documentation. That's only meant for general consumption via a browser,
> not via gnucash (on linux). It was never even intended to be distributed
> via linux distributions, though distributions are free to do so. It's just
> not the format gnucash itself expects to present to you.
>
> This is a bug that was already in the upstream Debian distribution.
>
> Meanwhile is has been fixed there. I'm not sure what's needed to get the
> fix in Ubuntu. Probably a bug report in the Ubuntu bug tracker ?
>
>
> Regards,
>
> Geert
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Mac Installation 4.12 issue

[Hylton Conacher (ZR1HPC)]

Hi,

I recently downloaded the .dmg file for my OS.

I read the README and several other of the texts and not seeing any 
reference installation on a Mac I double clicked on the GnuCash icon.


This verified the package and opened it where I was able to create a new 
set of accounts.
I was puzzled as I had not seen anything about dragging and dropping the 
executable into the Applications folder.


I carried on and made the Mac remember the icon in the task bar.

Each time I execute the app it verifies the package, asks me if I am 
sure I want to open it as it was downloaded from a website. I confirm 
and the accounts I created and saved are opened, thank goodness.


I did some Google work and found the GnuCash app does not open a window 
showing a Mac user to drag the app into the Applications folder.


I ran the .dmg again and dragged the GnuCash icon to a Finder window 
open on Applications.


My problem was solved.

Please add something into the README contents about installing on a Mac.

Thanks and good gnucashing

Hylton
___
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] Problem with missing balance in a parent account

[David T. via gnucash-user]

That account register doesn't have any transactions in it, so it won't have any 
value either. Is it possible that in the past, you used a report to see the 
parent account balances, or even the Chart of Accounts? 

And if the account in the screen shot is a placeholder account, then you a) 
wouldn't be able to open the account by double clicking, b) be told on 
selecting Open that it was read only, and c) once opened, the entire register 
would be greyed out. The screen shot seems to show a normal account. It also 
shows a similarly-named tab next to the active tab.

⁣David T. ​

On Oct 8, 2022, 1:51 PM, at 1:51 PM, Jay Ridgley  
wrote:
>On 10/7/22 16:38, john wrote:
>> 
>> 
>>> On Oct 7, 2022, at 12:43 PM, Jay Ridgley 
>wrote:
>>>
>>> Good Morning,
>>>
>>> BRAND NEW to the list, have been using GnuCash on my Ubuntu system
>for over 20 years, this is the first problem I have encountered that I
>have not been able to resolve.
>>>
>>> I discovered that the balance amount that should appear in a the
>parent account for my bank is missing. Therefore I am unable to do this
>month's reconcile.
>>>
>>> The account was proper last month, and I was able to balance my
>checkbook successfully. In the meantime I upgraded to Ubuntu 22.04 LTS
>from 20.04 LTS every thing seems to running properly, otherwise,
>including GnuCash.
>>>
>>> Today when I tried to reconcile my bank account I discovered the
>amount of the balance is missing and the reconcile button is grayed
>out(naturally since nothing shows).
>>>
>>> All the sub accounts point to the parent account and when I list my
>accounts the balance appears there and is correct.
>>>
>>> What happened and how can I get it back?
>> 
>> 
>> Can you attach (don't inline!) a screenshot of the problem? It's not
>clear from your description what balance is missing and what button is
>disabled.
>> 
>> Regards,
>> John Ralls
>> 
>John,
>
>  Sorry it took so long...
>The account shown is the parent and the Balance should NOT be blank,
>but 
>the sum of 4  account balances.
>
>Thanks,
>Jay
>-- 
>Jay Ridgley
>jridgley2 at austin.rr.com
>Registered Linux User ID - 9115
>https://linuxcounter.net/cert/9115.png
>Registered Ubuntu User ID - 23320
>
>
>
>
>___
>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] Reconciling subaccounts

[David T. via gnucash-user]

John, 

I don't know about "typically." There are any of a number of ways that someone 
might use placeholder accounts. In my own books, I have placeholder accounts 
for brokerage holdings, where the placeholder represents an institution's 
account and the leaf accounts represent individual securities. I also have 
placeholder accounts that represent a class of account types-- for example, a 
placeholder for savings accounts at different institutions. 

The OP appears to be using the structure to implement an envelope allocation 
system, in which case the subaccounts are virtual. They want both the real and 
the virtual accounts to show that reconciliation. GnuCash doesn't currently do 
that. 

Whether that's a bug or a feature (and whether a sensible implementation can be 
devised to address it) is perhaps a different matter. 

⁣David T. ​

On Oct 8, 2022, 9:17 AM, at 9:17 AM, John Layman 
 wrote:
>Typically, the place holder account represents an institution, not an
>account.  I have never seen a bank statement that presents rolled up
>account totals at the institution level.  Each checking account,
>savings account, money market account, CD holdings, installment loan
>accounts, etc. are presented separately (even if within the same
>document) with beginning and ending balances shown separately for each
>such account.  Balancing could be an absolute nightmare if you had to
>track down a discrepancy in conglomerated the numbers.
>
>-Original Message-
>From: gnucash-user
> On Behalf Of
>Stephen M. Butler
>Sent: Friday, October 7, 2022 2:09 PM
>To: gnucash-user@gnucash.org
>Subject: Re: [GNC] Reconciling subaccounts
>
>For  me the parent placeholder account in GnC is the bank account that
>is being reconciled.  The sub-accounts in GnC are just my way of
>delegating the funds within that account for certain  purposes.
>
>I'm not sure about the use case of using the placeholder as a grand
>total for all accounts held at the bank and then reconciling all of
>them in one step (checking, saving, CD, money market).  I suppose if
>they were all reported on a single statement
>
>
>On 10/7/22 10:41, R Losey wrote:
>> I kind of like it the way it is currently, for what it's worth.
>>
>> On Thu, Oct 6, 2022 at 1:20 PM Adrien Monteleone < 
>> adrien.montele...@lusfiber.net> wrote:
>>
>>> Thanks for the details.
>>>
>>> I'd say this is a bug, as the expected result would be to have the 
>>> reconcile status of sub-accounts updated.
>>>
>>> You should file that on bugs.gnucash.org
>>>
>>> It *might* be designed that way however. I could be wrong, but I 
>>> think the idea for this feature is to be used for 'virtual' 
>>> sub-accounts that are used for segregating funds in your own books, 
>>> but not actual multiple real-world accounts with an institution.
>>>
>>> The parent is the real account in such a case, so that might be why 
>>> it is the only one marked reconciled with a date. (it is the only
>one 
>>> with a statement to reconcile against)
>>>
>>> In your case, you seem to be trying to reconcile multiple real 
>>> accounts through a placeholder parent. But GnuCash doesn't know
>that. 
>>> (or 'reconciling' non-institution accounts, such as Expenses.)
>>>
>>> Until it is 'fixed' or changed, I guess your option is to continue
>to 
>>> reconcile-finish the sub-accounts to update them, or else just 
>>> reconcile them all individually rather than together as
>sub-accounts.
>>>
>>> Regards,
>>> Adrien
>>>
>>> On 10/3/22 4:56 PM, Uttam Chakravorty wrote:
 My apologies Adrien, I will be more specific.  Line 2 - >Sales -> 
 A/c No
>>> 01: all the subsequent lines starting '01-' are the subaccounts.
>>> Reconciling 01 with subaccounts ticked will reconcile all of them, 
>>> but only update 01's date field.  I then step through the
>subaccounts 
>>> and as they are all already reconciled I just press 'Finish' to
>update their date.

 Line 11 is a single entry with no subaccounts.


 Line 12 is similar to Line 2, a Placeholder with three subaccounts.


 I have tried to indicate the above in Column E, however I have made
>
 a
>>> mistake with Lines 64, 71 and 77.  They have no subaccounts, I 
>>> annotated them in error as all the top level accounts are
>reconciled.  
>>> In terms of consistency I failed to annotate Lines 12, 17 and 59.  
>>> Looking back this is a scrappy piece of work put together in haste. 
>
>>> I hope you will be able to extract something useful, or I will
>happily do it again.  Please advise.


 Line 18 (A/c code 5 (should be 05)) is particularly interesting.  
 This
>>> has subaccounts and they have Placeholders which have subaccounts
>i.e.
>>> three levels deep.  Reconciling the top level reconciles all the 
>>> other levels, however once more it only updates the date at the top
>level.

 I do not find it too onerous to live with this little extra
>keyboard
>>> activity.  I just wondered if I was doing something wrong 

Re: [GNC] Price update not working

[David T. via gnucash-user]

While it's always best to try to use the latest versions, Richard's error 
message doesn't sound like one that has to do with currency rate retrieval 
(which I believe is the major bug that F::Q1.53 is meant to fix). 

I would personally check to see what quote sources are selected for each 
security. One can quickly see the quote source for securities in the security 
list by adding that column to the view. 

Over the years, there's been quite a bit of turmoil in the price retrieval 
realm-- first, there was the discontinuation of prices by Yahoo!, which had 
everyone scramble to AlphaVantage; then there was the retrieval throttle that 
AlphaVantage imposed, causing people to change to Yahoo.json. Those seem like 
more likely points to examine before updating F::Q. 

⁣David T. ​

On Oct 8, 2022, 9:05 AM, at 9:05 AM, Geoff  wrote:
>Hi Richard
>
>If you have configured your GnuCash securities to retrieve their prices
>
>using AlphaVantage then you need to make sure that you have entered
>your 
>API Key in GnuCash preferences.
>
>Also, depending on the problem, it may help if you upgrade to a later 
>version of of Finance Quote:-
>
>https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2
>https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz
>
>Hope this helps.
>
>Regards
>
>Geoff
>=
>
>
>On 8/10/2022 4:58 pm, R Losey wrote:
>> I just installed GnuCash on Ubuntu 22.04LTS (it is version 4.8 from
>the
>> Ubuntu Software area).
>> 
>> On a different Ubuntu, I had an older version running, and back then,
>price
>> updates were working. I managed to mess up that gnucash Linux
>install, so I
>> haven't been updating quotes - I've been using GnuCash on other
>operating
>> systems, and since it is a pain to get the quotes working on them, I
>> haven't bothered.
>> 
>> But now that I have a nice shiny Ubuntu, I have installed gnucash and
>> thought I'd attempt to update prices. I merely get :
>> 
>> "ERROR  There was an unknown error while retrieving the
>price
>>> quotes."
>> 
>> 
>> I have Finance::Quote version 1.51 - it was installed along with
>GnuCash 4.8
>> 
>> Notes:
>> - The reason I mentioned running updates some time ago (pre version
>4.0, I
>> think) is that perhaps I need to do something in the securities
>editor? I
>> think that I no longer own some of securities tagged to get updates,
>but I
>> wouldn't think that would be a problem...
>> 
>> - I remember reading something about ALPHAVANTAGE_API_KEY - the debug
>text
>> prints it as empty (for what that's worth)
>> 
>___
>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] Move transactions from one account to another

[David T. via gnucash-user]

Or simply delete account A, and you'll be asked the same question. 

⁣David T. ​

On Oct 8, 2022, 4:02 AM, at 4:02 AM, "Carl S."  wrote:
>
>
>*From:* David Carlson [mailto:david.carlson@gmail.com]
>*Subject:* [GNC] Move transactions from one account to another
>*
>*
>Perfect!  Thanks!
>
>Carl
>*
>*
>*
>*
>*
>*
>*
>*
>*Date:* Friday, October 7, 2022 at 8:01 PM
>*To:* Carl S.
>*Cc:* Gnucash Users
>
>> Yes.  Edit Account A to make it a sub-Account of Account B.  Then 
>> delete A.  You will be asked if you want Account A's transactions 
>> moved to B!!
>>
>> On Fri, Oct 7, 2022 at 6:46 PM Carl S.  wrote:
>>
>> I want to move all of Account A's transactions into Account B. 
>Then
>> delete Account B.
>>
>> Is there an easy way to do it?
>>
>> Thanks,
>>
>> Carl Smith
>>
>> ___
>> 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.
>>
>>
>>
>> -- 
>> David Carlson
>
>
>
>
>
>
>___
>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] Problem with missing balance in a parent account

[Jay Ridgley]

On 10/7/22 15:11, David Carlson wrote:

What version of GnuCash do you have now and is it the same as before?

The installed version is 1.4.8-1build2 the binary for gnucash has a date 
stamp of Feb 9, 2022. That is well before the upgrade.


BTW What which is the preferred method of posting top or bottom?
Regards,
Jay



On Fri, Oct 7, 2022, 11:44 AM Jay Ridgley > wrote:


Good Morning,

BRAND NEW to the list, have been using GnuCash on my Ubuntu system for
over 20 years, this is the first problem I have encountered that I have
not been able to resolve.

I discovered that the balance amount that should appear in a the parent
account for my bank is missing. Therefore I am unable to do this
month's
reconcile.

The account was proper last month, and I was able to balance my
checkbook successfully. In the meantime I upgraded to Ubuntu 22.04 LTS
from 20.04 LTS every thing seems to running properly, otherwise,
including GnuCash.

Today when I tried to reconcile my bank account I discovered the amount
of the balance is missing and the reconcile button is grayed
out(naturally since nothing shows).

All the sub accounts point to the parent account and when I list my
accounts the balance appears there and is correct.

What happened and how can I get it back?

GREAT PACKAGE!

Help please, thank You
Jay
-- 
Jay Ridgley

jridgley2 at austin.rr.com 
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png

Registered Ubuntu User ID - 23320
___
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.



--
Jay Ridgley
jridgley2 at austin.rr.com
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png
Registered Ubuntu User ID - 23320

___
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] Problem with missing balance in a parent account

[Jay Ridgley]

On 10/7/22 16:38, john wrote:




On Oct 7, 2022, at 12:43 PM, Jay Ridgley  wrote:

Good Morning,

BRAND NEW to the list, have been using GnuCash on my Ubuntu system for over 20 
years, this is the first problem I have encountered that I have not been able 
to resolve.

I discovered that the balance amount that should appear in a the parent account 
for my bank is missing. Therefore I am unable to do this month's reconcile.

The account was proper last month, and I was able to balance my checkbook 
successfully. In the meantime I upgraded to Ubuntu 22.04 LTS from 20.04 LTS 
every thing seems to running properly, otherwise, including GnuCash.

Today when I tried to reconcile my bank account I discovered the amount of the 
balance is missing and the reconcile button is grayed out(naturally since 
nothing shows).

All the sub accounts point to the parent account and when I list my accounts 
the balance appears there and is correct.

What happened and how can I get it back?



Can you attach (don't inline!) a screenshot of the problem? It's not clear from 
your description what balance is missing and what button is disabled.

Regards,
John Ralls


John,

 Sorry it took so long...
The account shown is the parent and the Balance should NOT be blank, but 
the sum of 4  account balances.


Thanks,
Jay
--
Jay Ridgley
jridgley2 at austin.rr.com
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png
Registered Ubuntu User ID - 23320
___
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] Price update not working

[Geoff]

Hi Richard

Glad to hear you can now fetch prices.

> It is supposed to take so long? There is a long (7 minute) delay before
> the update finishes... I've been using the gnucash-cli command line.

That does seem a long time, but how long is a piece of string? (as my 
father used to say ;--)


How many prices are you fetching?
How busy are Alpha Vantage's servers?
Are Alpha Vantage throttling you?
Is your ISP throttling you?
How fast, and how busy, is your machine?
How long does it take to fetch a single price manually from the command 
line?

How long does it take to open and save your GnuCash data file?
Have you tried using the GnuCash GUI instead of the gnucash-cli command 
line?



As a benchmark, my 13 year old Windows 10 desktop consistently retrieves 
prices for 30 odd securities in about 3 seconds using the GnuCash GUI, 
but in my case Finance Quote pulls them directly from the local stock 
exchange and doesn't use Alpha Vantage.


I did a few command line tests for a single security using Alpha Vantage 
and it averages around 2.2 seconds from the other side of the world - 
see attached screenshot.
[Technically it is slightly quicker than this which includes invoking 
the Python interpreter to measure the elapsed time.]


Perhaps others on this list who do use Alpha Vantage can relate their 
own experiences?


Finally, if you do know your way around Linux, Wire Shark is your go to 
friend for network troubleshooting:

https://www.wireshark.org/


Good luck!

Regards

Geoff
=


On 8/10/2022 6:29 pm, R Losey wrote:
Hi... yes, I did not have al ALPHAVANTAGE_API_KEY and that was the 
issue. Things now seem to be updating properly.


It is supposed to take so long? There is a long (7 minute) delay before 
the update finishes... I've been using the gnucash-cli command line.


On Sat, Oct 8, 2022 at 1:03 AM Geoff > wrote:


Hi Richard

If you have configured your GnuCash securities to retrieve their prices
using AlphaVantage then you need to make sure that you have entered
your
API Key in GnuCash preferences.

Also, depending on the problem, it may help if you upgrade to a later
version of of Finance Quote:-

https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2 


https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz 


Hope this helps.

Regards

Geoff
=


On 8/10/2022 4:58 pm, R Losey wrote:
 > I just installed GnuCash on Ubuntu 22.04LTS (it is version 4.8
from the
 > Ubuntu Software area).
 >
 > On a different Ubuntu, I had an older version running, and back
then, price
 > updates were working. I managed to mess up that gnucash Linux
install, so I
 > haven't been updating quotes - I've been using GnuCash on other
operating
 > systems, and since it is a pain to get the quotes working on them, I
 > haven't bothered.
 >
 > But now that I have a nice shiny Ubuntu, I have installed gnucash and
 > thought I'd attempt to update prices. I merely get :
 >
 > "ERROR  There was an unknown error while retrieving the
price
 >> quotes."
 >
 >
 > I have Finance::Quote version 1.51 - it was installed along with
GnuCash 4.8
 >
 > Notes:
 > - The reason I mentioned running updates some time ago (pre
version 4.0, I
 > think) is that perhaps I need to do something in the securities
editor? I
 > think that I no longer own some of securities tagged to get
updates, but I
 > wouldn't think that would be a problem...
 >
 > - I remember reading something about ALPHAVANTAGE_API_KEY - the
debug text
 > prints it as empty (for what that's worth)
 >



--
_
Richard Losey
rlo...@gmail.com 
Micah 6:8___
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] Ubuntu: Documentation not working

[Geert Janssens]

Op zaterdag 8 oktober 2022 09:33:05 CEST schreef R Losey:
> When I installed GnuCash in Ubuntu, it seemed to install everything -- the
> price quote program as well as the documentation... however, when I run
> GnuCash, it won't find the documentation and speculates that it is not
> installed (but it is). I can take my browser to
> /usr/share/docs/gnucash-docs/gnucash-guide-en/index.html, and everything
> looks fine.
> 
> Is there some environment variable I need to set? It would be nice to have
> the "Help" buttons actually work.

Ubuntu ships our documentation in the wrong format and in the wrong location.

GnuCash expects to find the documentation in docbook format and located in
/usr/share/help.

What you have found in /usr/share/docs is the html formatted version of our 
documentation. That's only meant for general consumption via a browser, not via 
gnucash 
(on linux). It was never even intended to be distributed via linux 
distributions, though 
distributions are free to do so. It's just not the format gnucash itself 
expects to present to 
you.

This is a bug that was already in the upstream Debian distribution.

Meanwhile is has been fixed there. I'm not sure what's needed to get the fix in 
Ubuntu. 
Probably a bug report in the Ubuntu bug tracker ?


Regards,

Geert
___
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] Ubuntu: Documentation not working

[R Losey]

When I installed GnuCash in Ubuntu, it seemed to install everything -- the
price quote program as well as the documentation... however, when I run
GnuCash, it won't find the documentation and speculates that it is not
installed (but it is). I can take my browser to
/usr/share/docs/gnucash-docs/gnucash-guide-en/index.html, and everything
looks fine.

Is there some environment variable I need to set? It would be nice to have
the "Help" buttons actually work.

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Price update not working

[R Losey]

Hi... yes, I did not have al ALPHAVANTAGE_API_KEY and that was the issue.
Things now seem to be updating properly.

It is supposed to take so long? There is a long (7 minute) delay before the
update finishes... I've been using the gnucash-cli command line.

On Sat, Oct 8, 2022 at 1:03 AM Geoff  wrote:

> Hi Richard
>
> If you have configured your GnuCash securities to retrieve their prices
> using AlphaVantage then you need to make sure that you have entered your
> API Key in GnuCash preferences.
>
> Also, depending on the problem, it may help if you upgrade to a later
> version of of Finance Quote:-
>
> https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2
>
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz
>
> Hope this helps.
>
> Regards
>
> Geoff
> =
>
>
> On 8/10/2022 4:58 pm, R Losey wrote:
> > I just installed GnuCash on Ubuntu 22.04LTS (it is version 4.8 from the
> > Ubuntu Software area).
> >
> > On a different Ubuntu, I had an older version running, and back then,
> price
> > updates were working. I managed to mess up that gnucash Linux install,
> so I
> > haven't been updating quotes - I've been using GnuCash on other operating
> > systems, and since it is a pain to get the quotes working on them, I
> > haven't bothered.
> >
> > But now that I have a nice shiny Ubuntu, I have installed gnucash and
> > thought I'd attempt to update prices. I merely get :
> >
> > "ERROR  There was an unknown error while retrieving the price
> >> quotes."
> >
> >
> > I have Finance::Quote version 1.51 - it was installed along with GnuCash
> 4.8
> >
> > Notes:
> > - The reason I mentioned running updates some time ago (pre version 4.0,
> I
> > think) is that perhaps I need to do something in the securities editor? I
> > think that I no longer own some of securities tagged to get updates, but
> I
> > wouldn't think that would be a problem...
> >
> > - I remember reading something about ALPHAVANTAGE_API_KEY - the debug
> text
> > prints it as empty (for what that's worth)
> >
>


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] Reconciling subaccounts

[John Layman]

Typically, the place holder account represents an institution, not an account.  
I have never seen a bank statement that presents rolled up account totals at 
the institution level.  Each checking account, savings account, money market 
account, CD holdings, installment loan accounts, etc. are presented separately 
(even if within the same document) with beginning and ending balances shown 
separately for each such account.  Balancing could be an absolute nightmare if 
you had to track down a discrepancy in conglomerated the numbers.

-Original Message-
From: gnucash-user  On 
Behalf Of Stephen M. Butler
Sent: Friday, October 7, 2022 2:09 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Reconciling subaccounts

For  me the parent placeholder account in GnC is the bank account that is being 
reconciled.  The sub-accounts in GnC are just my way of delegating the funds 
within that account for certain  purposes.

I'm not sure about the use case of using the placeholder as a grand total for 
all accounts held at the bank and then reconciling all of them in one step 
(checking, saving, CD, money market).  I suppose if they were all reported on a 
single statement


On 10/7/22 10:41, R Losey wrote:
> I kind of like it the way it is currently, for what it's worth.
>
> On Thu, Oct 6, 2022 at 1:20 PM Adrien Monteleone < 
> adrien.montele...@lusfiber.net> wrote:
>
>> Thanks for the details.
>>
>> I'd say this is a bug, as the expected result would be to have the 
>> reconcile status of sub-accounts updated.
>>
>> You should file that on bugs.gnucash.org
>>
>> It *might* be designed that way however. I could be wrong, but I 
>> think the idea for this feature is to be used for 'virtual' 
>> sub-accounts that are used for segregating funds in your own books, 
>> but not actual multiple real-world accounts with an institution.
>>
>> The parent is the real account in such a case, so that might be why 
>> it is the only one marked reconciled with a date. (it is the only one 
>> with a statement to reconcile against)
>>
>> In your case, you seem to be trying to reconcile multiple real 
>> accounts through a placeholder parent. But GnuCash doesn't know that. 
>> (or 'reconciling' non-institution accounts, such as Expenses.)
>>
>> Until it is 'fixed' or changed, I guess your option is to continue to 
>> reconcile-finish the sub-accounts to update them, or else just 
>> reconcile them all individually rather than together as sub-accounts.
>>
>> Regards,
>> Adrien
>>
>> On 10/3/22 4:56 PM, Uttam Chakravorty wrote:
>>> My apologies Adrien, I will be more specific.  Line 2 - >Sales -> 
>>> A/c No
>> 01: all the subsequent lines starting '01-' are the subaccounts.
>> Reconciling 01 with subaccounts ticked will reconcile all of them, 
>> but only update 01's date field.  I then step through the subaccounts 
>> and as they are all already reconciled I just press 'Finish' to update their 
>> date.
>>>
>>> Line 11 is a single entry with no subaccounts.
>>>
>>>
>>> Line 12 is similar to Line 2, a Placeholder with three subaccounts.
>>>
>>>
>>> I have tried to indicate the above in Column E, however I have made 
>>> a
>> mistake with Lines 64, 71 and 77.  They have no subaccounts, I 
>> annotated them in error as all the top level accounts are reconciled.  
>> In terms of consistency I failed to annotate Lines 12, 17 and 59.  
>> Looking back this is a scrappy piece of work put together in haste.  
>> I hope you will be able to extract something useful, or I will happily do it 
>> again.  Please advise.
>>>
>>>
>>> Line 18 (A/c code 5 (should be 05)) is particularly interesting.  
>>> This
>> has subaccounts and they have Placeholders which have subaccounts i.e.
>> three levels deep.  Reconciling the top level reconciles all the 
>> other levels, however once more it only updates the date at the top level.
>>>
>>> I do not find it too onerous to live with this little extra keyboard
>> activity.  I just wondered if I was doing something wrong again.
>>
>>
>> ___
>> 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.
>>
>


--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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

Re: [GNC] Price update not working

[Geoff]

Hi Richard

If you have configured your GnuCash securities to retrieve their prices 
using AlphaVantage then you need to make sure that you have entered your 
API Key in GnuCash preferences.


Also, depending on the problem, it may help if you upgrade to a later 
version of of Finance Quote:-


https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2
https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz

Hope this helps.

Regards

Geoff
=


On 8/10/2022 4:58 pm, R Losey wrote:

I just installed GnuCash on Ubuntu 22.04LTS (it is version 4.8 from the
Ubuntu Software area).

On a different Ubuntu, I had an older version running, and back then, price
updates were working. I managed to mess up that gnucash Linux install, so I
haven't been updating quotes - I've been using GnuCash on other operating
systems, and since it is a pain to get the quotes working on them, I
haven't bothered.

But now that I have a nice shiny Ubuntu, I have installed gnucash and
thought I'd attempt to update prices. I merely get :

"ERROR  There was an unknown error while retrieving the price

quotes."



I have Finance::Quote version 1.51 - it was installed along with GnuCash 4.8

Notes:
- The reason I mentioned running updates some time ago (pre version 4.0, I
think) is that perhaps I need to do something in the securities editor? I
think that I no longer own some of securities tagged to get updates, but I
wouldn't think that would be a problem...

- I remember reading something about ALPHAVANTAGE_API_KEY - the debug text
prints it as empty (for what that's worth)


___
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] Price update not working

[R Losey]

I just installed GnuCash on Ubuntu 22.04LTS (it is version 4.8 from the
Ubuntu Software area).

On a different Ubuntu, I had an older version running, and back then, price
updates were working. I managed to mess up that gnucash Linux install, so I
haven't been updating quotes - I've been using GnuCash on other operating
systems, and since it is a pain to get the quotes working on them, I
haven't bothered.

But now that I have a nice shiny Ubuntu, I have installed gnucash and
thought I'd attempt to update prices. I merely get :

"ERROR  There was an unknown error while retrieving the price
> quotes."


I have Finance::Quote version 1.51 - it was installed along with GnuCash 4.8

Notes:
- The reason I mentioned running updates some time ago (pre version 4.0, I
think) is that perhaps I need to do something in the securities editor? I
think that I no longer own some of securities tagged to get updates, but I
wouldn't think that would be a problem...

- I remember reading something about ALPHAVANTAGE_API_KEY - the debug text
prints it as empty (for what that's worth)

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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.