Looking at the JSON, I see this being returned, so indeed there is an issue with the service response not being parsed well: "div_yield":-nan
On Sat, Sep 21, 2024 at 3:17 PM <[email protected]> wrote: > Send gnucash-user mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > > > Today's Topics: > > 1. Re: Australian Mutual Funds (John Ralls) > 2. Re: Australian Mutual Funds (John Ralls) > 3. Re: Multiple accounts (John Ralls) > 4. Inactive/Hidden accounts (Chris Miller) > 5. Re: Multiple accounts (Stan Brown (using GC 4.14)) > 6. Re: Monthly Reports (Phyllis Bruce) > 7. Re: Inactive/Hidden accounts (Stan Brown (using GC 4.14)) > 8. Re: Monthly Reports (Phyllis Bruce) > 9. Re: Monthly Reports (David Carlson) > 10. Finance::Quote expected digits after - (Scott Steimle) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 21 Sep 2024 09:22:54 -0700 > From: John Ralls <[email protected]> > To: flywire <[email protected]> > Cc: Gnucash Users <[email protected]> > Subject: Re: [GNC] Australian Mutual Funds > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8 > > > > > On Sep 20, 2024, at 22:27, flywire <[email protected]> wrote: > > > > > https://lists.gnucash.org/pipermail/gnucash-user/2024-September/113205.html > > John > > Ralls wrote: > > > >> ... > > > > > > Posts with links can be opened directly if there is clear space around > the > > link. Would commodity Wheat be Type Stock? > > > > While this is raised in the context of Managed Funds > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/invest_concepts1.html#invest_types2 > > defines > > Stocks and Mutual Funds: > > > >> ...A mutual fund is a group investment mechanism in which you can buy > into > >> many stocks simultaneously. For example, a ?S&P 500 index fund? is a > fund > >> which purchases all 500 stocks listed in the Standard and Poor?s index. > >> When you buy a share of this fund, you are really buying a small amount > of > >> each of the 500 stocks contained within the fund. Mutual funds are > treated > >> exactly like e a single stock, both for tax purposes and in accounting. > > > > > > Firstly, the definition applies equally to Exchange Traded Funds and > > unlisted Managed Funds. Seems painful splitting the same stock exchange > > (workspace) into two types. Why differentiate between Account Type Stock > > and Mutual Fund? > > > > Secondly, assuming there is good reason to split from Stock, why not use > a > > more generic term "Fund" for Account Type instead of "Mutual Fund?? > > Those choices were made early in GnuCash?s development by people who > stopped contributing long ago. I don?t know why they made the choices they > did; as you say, there?s no accounting difference between mutual funds and > stocks, and there are lots of commodity types that don?t fit into either > category. Unfortunately they made other design choices that deeply embed > that choice into GnuCash?s data so changing it would be a lot of work and > would require a data migration. It doesn?t seem to me to be worth the > effort. > > Regards, > John Ralls > > > > > > ------------------------------ > > Message: 2 > Date: Sat, 21 Sep 2024 09:32:22 -0700 > From: John Ralls <[email protected]> > To: Megan Tilley <[email protected]> > Cc: [email protected] > Subject: Re: [GNC] Australian Mutual Funds > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8 > > Megan, > > Perhaps it isn?t obvious that after selecting the account type you need to > click the Select button in the Security/Currency row to get the Select > security dialog box. One can?t have an account without an associated > commodity. It would be a better UI design to disable the OK button when > that field is empty, but the current code doesn?t do that. > > Regards, > John Ralls > > > On Sep 21, 2024, at 02:53, Megan Tilley <[email protected]> wrote: > > > > Thanks John - I have moved a step forward, I think: > > > > > > Open Tools>Security Editor ===> First thing is -- I thought you could > only select the suggest fund (which showed as Stocks to me), not create > another in the Namespace - I created Mutual, so that worked! > > > > New Account information ===> Created the Name, inserted the Code, > selected the Brokerage Account Mutual Fund as the Parent (So that is > different to your 2nd screenshot), Account Type set to Mutual Fund. Clicked > OK - message popped up saying select the commodity. Screenshot attached. I > closed the message, moved to select the account name, clicked OK, same > message popped up. > > > > > > I hope you can see my confusion! LOL! > > > > I have read both Chapter 9 and Chapter 11, but thanks for the reminder. > My issue has always been translating financial terms into the terms I have > learned here in Australia (eg 401k --- superannuation fund, etc.) > > > > Thanks, John, eager to learn more! > > > > > > -- > > Regards, > > > > > > Megan Tilley > > [email protected] <mailto:[email protected]> > > 0409 949 717 > > > > ------- > > "He who laughs last probably made a backup." > > ------- > > > > > > > > On Sat, 21 Sept 2024 at 12:39, John Ralls <[email protected] <mailto: > [email protected]>> wrote: > >> That?s not correct. You can create a commodity for anything you like, > and BTW you can create any number of namespaces to categorize your > commodities. > >> > >> Yes, ?commodity? is an overloaded word in English. To market traders it > means futures in some physical product: Sow bellies, wheat, steel. In > GnuCash it means anything that you might account for that isn?t an official > (meaning recognized by the ISO 4217 committee). > >> > >> So, you want a namespace ?Mutual Fund?? No problem. Open Tools>Security > Editor. Click the Add button. Fill out the dialog box as shown in the first > screenshot and click OK. On the Accounts tab click the New button and fill > out the new account information, selecting either Stock or Mutual Fund for > the Account Type, then click Select. If the new commodity is the only one > you?ve got then that will be in the selection dialog as shown in the second > screenshot. > >> > >> This is all explained much more thoroughly in Chapter 9 of the Tutorial > and Concepts Guide: > https://www.gnucash.org/docs/v5/C/gnucash-guide/chapter_invest.html. See > Chapter 11 for a thorough discussion of Capital Gains. > >> > >> Regards, > >> John Ralls > >> > >>> On Sep 20, 2024, at 18:52, Megan Tilley <[email protected] > <mailto:[email protected]>> wrote: > >>> > >>> I have done so (created the commodity in Tools>Security Editor) > however, that process only allows "Stocks" and not a Fund... so - confusion > on my part. > >>> > >>> I have obviously done the creation incorrectly as the 'new' list still > does not show the additions - snip of Security list and also Account list. > >>> > >>> As I indicated - I believe that they should be Mutual Funds... > >>> > >>> Commodity in Australia is a classification - a Stock fits in a > Commodity market place - Manufacturing, Property, etc.. So I think I need > to add "Property" somewhere. > >> > >> <Screenshot 2024-09-20 at 19.28.54.png><Screenshot 2024-09-20 at > 19.30.27.png> > > <Select Commodity3.PNG><Create account fundname4.PNG> > > > > ------------------------------ > > Message: 3 > Date: Sat, 21 Sep 2024 09:40:36 -0700 > From: John Ralls <[email protected]> > To: Robert Heller <[email protected]> > Cc: Chris Miller <[email protected]>, gnucash-user > <[email protected]> > Subject: Re: [GNC] Multiple accounts > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8 > > There?s a preference for that on the Register defaults page: Register > opens in a new window. The default is off. There?s a similar one for > reports on the Reports page. > > You can also move any tab to a new window with Windows>New Window with > Page. > > Regards, > John Ralls > > > > On Sep 21, 2024, at 07:34, Robert Heller <[email protected]> wrote: > > > > The accounts should be as tabs. It is possible to open a new accounts > window > > (Windows menu). Older versions of GnuCash would open a new window when > you > > opened an account, but with the whole "tabs are better than window > managers" > > craze, accounts are opened as tabs. At least that is how things work on > my > > Linux machine. > > > > At Sat, 21 Sep 2024 06:08:06 -0700 (PDT) Chris Miller <[email protected]> > wrote: > > > >> > >> Hi Folks, > >> > >> It looks like I can only see one account at a time. I can't find a way > to open several for cross-reference and comparison. Am I missing something? > >> > >> Thanks for the help, > > > > -- > > Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 > > Deepwoods Software -- Custom Software Services > > http://www.deepsoft.com/ -- Linux Administration Services > > [email protected] -- Webhosting Services > > > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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. > > > > ------------------------------ > > Message: 4 > Date: Sat, 21 Sep 2024 11:22:48 -0700 (PDT) > From: Chris Miller <[email protected]> > To: gnucash-user <[email protected]> > Subject: [GNC] Inactive/Hidden accounts > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > Hi Folks, > Can I set an account inactive or hidden? As I flee QuickBooks I have a > number of accounts that I no longer use and have hidden but I dare not > delete them because it will require an adjusting entry somewhere to > preserve "assets + liability + equity = zero" > Thanks for the help, > Chris. > Laboriously sent to you from my ... do you really care? > > > ------------------------------ > > Message: 5 > Date: Sat, 21 Sep 2024 11:32:14 -0700 > From: "Stan Brown (using GC 4.14)" <[email protected]> > To: [email protected] > Subject: Re: [GNC] Multiple accounts > Message-ID: <[email protected]> > Content-Type: text/plain; charset=UTF-8 > > On 2024-09-21 09:40, John Ralls wrote: > > There?s a preference for that on the Register defaults page: Register > opens in a new window. The default is off. There?s a similar one for > reports on the Reports page. > > > > You can also move any tab to a new window with Windows>New Window with > Page. > > Before I saw your note, I was about to post about Window?? New Window > with Page, but first I tried it while in the Accounts tab. Then I > couldn't find a way to get it back into the original GC window. I tried > View?? New Accounts Page, but that opened in default layout, so I lost > all my subaccount expansions and geometry of columns. > > I recovered by closing GC and copying a recent backup of my .gcm file > over the new one in %APPDATA%\GnuCash\books. But to echo Chris, did _I_ > miss some way I could have just put my detached Accounts tab back into > the original GC window? > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com/ > > > ------------------------------ > > Message: 6 > Date: Sat, 21 Sep 2024 13:42:08 -0500 > From: Phyllis Bruce <[email protected]> > To: [email protected] > Subject: Re: [GNC] Monthly Reports > Message-ID: > < > caf7y9z_ux2ejpwponco-bl03fyxojyg4a711ok-moe_wrvw...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Yes My end of month report is for reconciled payments. > > On Sat, Sep 21, 2024 at 4:13?AM Fred Bone <[email protected]> > wrote: > > > On 18 September 2024 at 10:19, Phyllis Bruce said: > > > > > These are the options I chose. Still no report. > > > > > > [image: image.png] > > > [image: image.png] > > > > I see you are restricting the report to Reconciled transactions. Is that > > what you want? > > > > > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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. > > > > > ------------------------------ > > Message: 7 > Date: Sat, 21 Sep 2024 11:43:29 -0700 > From: "Stan Brown (using GC 4.14)" <[email protected]> > To: [email protected] > Subject: Re: [GNC] Inactive/Hidden accounts > Message-ID: <[email protected]> > Content-Type: text/plain; charset=UTF-8 > > > On 2024-09-21 11:22, Chris Miller via gnucash-user wrote: > > Can I set an account inactive or hidden? As I flee QuickBooks > > I have a number of accounts that I no longer use and have > > hidden but I dare not delete them because it will require an > > adjusting entry somewhere to preserve "assets + liability + > > equity = zero" > > Yes, you can mark an account as hidden. You can also separately mark an > account as Placeholder, which prevents you from entering a new > transaction against that account. I do this with obsolete accounts, like > the mortgage on my previous house. Most reports give you a choice in > Options?? Accounts whether to include hidden accounts. > > If you have only one or two of these, it's probably simplest to select > each one in the Accounts tab and then click Edit. > > If you have more than one or two, I recommend adding the Hidden and > Placeholder columns to the Accounts tab; then you can just tick the > boxes without getting into the Edit dialog. (Also, you'll know at a > glance whether a given account is hidden or placeholder, with no need to > open the Edit dialog.) To add columns to Accounts, click the down arrow > at the extreme right of the column headings. > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com > > > > ------------------------------ > > Message: 8 > Date: Sat, 21 Sep 2024 14:00:48 -0500 > From: Phyllis Bruce <[email protected]> > To: [email protected] > Subject: Re: [GNC] Monthly Reports > Message-ID: > < > caf7y9z-4xgoxcc2yaa2fuhci77gtvc8mpnrrpny2q5wknr4...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Thanks for looking at it. I'm still unable to get an actual report. > > On Sat, Sep 21, 2024 at 1:42?PM Phyllis Bruce <[email protected]> wrote: > > > Yes My end of month report is for reconciled payments. > > > > On Sat, Sep 21, 2024 at 4:13?AM Fred Bone < > [email protected]> > > wrote: > > > >> On 18 September 2024 at 10:19, Phyllis Bruce said: > >> > >> > These are the options I chose. Still no report. > >> > > >> > [image: image.png] > >> > [image: image.png] > >> > >> I see you are restricting the report to Reconciled transactions. Is that > >> what you want? > >> > >> > >> _______________________________________________ > >> gnucash-user mailing list > >> [email protected] > >> 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. > >> > > > > > ------------------------------ > > Message: 9 > Date: Sat, 21 Sep 2024 15:12:01 -0500 > From: David Carlson <[email protected]> > To: Phyllis Bruce <[email protected]> > Cc: [email protected] > Subject: Re: [GNC] Monthly Reports > Message-ID: > <CADYgSb= > [email protected]> > Content-Type: text/plain; charset="UTF-8" > > If you can describe more details we can try to help. I know, for example, > that sometimes it is difficult to get exactly what you want. for reasons > that do not seem to make sense at first. > > On Sat, Sep 21, 2024 at 2:01?PM Phyllis Bruce <[email protected]> wrote: > > > Thanks for looking at it. I'm still unable to get an actual report. > > > > On Sat, Sep 21, 2024 at 1:42?PM Phyllis Bruce <[email protected]> > wrote: > > > > > Yes My end of month report is for reconciled payments. > > > > > > On Sat, Sep 21, 2024 at 4:13?AM Fred Bone < > > [email protected]> > > > wrote: > > > > > >> On 18 September 2024 at 10:19, Phyllis Bruce said: > > >> > > >> > These are the options I chose. Still no report. > > >> > > > >> > [image: image.png] > > >> > [image: image.png] > > >> > > >> I see you are restricting the report to Reconciled transactions. Is > that > > >> what you want? > > >> > > >> > > >> _______________________________________________ > > >> gnucash-user mailing list > > >> [email protected] > > >> 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 > > [email protected] > > 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 > > > ------------------------------ > > Message: 10 > Date: Sat, 21 Sep 2024 15:14:46 -0500 > From: Scott Steimle <[email protected]> > To: [email protected] > Subject: [GNC] Finance::Quote expected digits after - > Message-ID: > < > cabbontgkp7bqo9fzfgnlgxe1xgxoez1u5nrfytasdstkrry...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > I am using GnuCash Version: 5.5, Build ID: 5.5+(2023-12-16) on Xubuntu > 24.04.1. This is a recent OS upgrade however quotes worked last weekend. > Now when getting quotes either in the application through the Price > Database or via command line with "gnucash-cli --quotes get > /path/to/file.gnucash", I receive the following output (followed by a large > JSON document for all tickers): > > * 14:18:25 WARN <gnc.price-quotes> [GncFQQuoteSource::GncFQQuoteSource()] > No Alpha Vantage API key set, currency quotes and other AlphaVantage based > quotes won't work. > Found Finance::Quote version 1.62. > Price retrieval failed: Failed to parse result returned by Finance::Quote. > Error message: > <unspecified file>(1): expected digits after - > Result: > {...} > > I ran "sudo gnc-fq-update" and there were updates (Test2) but it did not > resolve the issue. Current module versions: > > Test2 is up to date (1.302204). > Finance::Quote is up to date (1.62). > JSON::Parse is up to date (0.62). > > Retrieving a single ticker quote from the command line such as "gnucash-cli > -V --quotes dump yahoo_json IBM" does work, however. > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > > gnucash-user mailing list > [email protected] > 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. > > > ------------------------------ > > End of gnucash-user Digest, Vol 258, Issue 59 > ********************************************* > _______________________________________________ gnucash-user mailing list [email protected] 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.
