[GNC] Finance::Quote expected digits after -

Scott Steimle scoaste at gmail.com
Sun Sep 22 16:27:08 EDT 2024


Since the single quote retrieval works, I am guessing this is more of a
parsing issue than a problem with Finance::Quote?

On Sat, Sep 21, 2024 at 3:17 PM <gnucash-user-request at gnucash.org> wrote:

> Send gnucash-user mailing list submissions to
>         gnucash-user at gnucash.org
>
> 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
>         gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
>         gnucash-user-owner at gnucash.org
>
> 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 <jralls at ceridwen.us>
> To: flywire <flywire0 at gmail.com>
> Cc: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Australian Mutual Funds
> Message-ID: <FD2A28BD-8BD6-44A2-B142-B47254E35EB8 at ceridwen.us>
> Content-Type: text/plain;       charset=utf-8
>
>
>
> > On Sep 20, 2024, at 22:27, flywire <flywire0 at gmail.com> 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 <jralls at ceridwen.us>
> To: Megan Tilley <megan.tilley at gmail.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] Australian Mutual Funds
> Message-ID: <7845A433-A45F-4BD8-BB7C-1C3A81A2E363 at ceridwen.us>
> 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 <megan.tilley at gmail.com> 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
> > megan.tilley at gmail.com <mailto:megan.tilley at gmail.com>
> > 0409 949 717
> >
> > -------
> > "He who laughs last probably made a backup."
> > -------
> >
> >
> >
> > On Sat, 21 Sept 2024 at 12:39, John Ralls <jralls at ceridwen.us <mailto:
> jralls at ceridwen.us>> 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 <megan.tilley at gmail.com
> <mailto:megan.tilley at gmail.com>> 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 <jralls at ceridwen.us>
> To: Robert Heller <heller at deepsoft.com>
> Cc: Chris Miller <cjm at tryx.org>, gnucash-user
>         <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Multiple accounts
> Message-ID: <C794779D-564A-4495-A693-F5687B5AF4D1 at ceridwen.us>
> 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 <heller at deepsoft.com> 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 <cjm at tryx.org>
> 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
> > heller at deepsoft.com       -- Webhosting Services
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at 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.
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 21 Sep 2024 11:22:48 -0700 (PDT)
> From: Chris Miller <cjm at tryx.org>
> To: gnucash-user <gnucash-user at gnucash.org>
> Subject: [GNC] Inactive/Hidden accounts
> Message-ID: <6e7e91af-6a2a-475c-98ab-aace116c8bf0 at email.android.com>
> 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)" <stan+gc at fastmail.fm>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Multiple accounts
> Message-ID: <a651c7c0-a71b-4f2e-a0c6-db33a955e52c at fastmail.fm>
> 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 <pobruce46 at gmail.com>
> To: gnucash-user at lists.gnucash.org
> Subject: Re: [GNC] Monthly Reports
> Message-ID:
>         <
> CAF7y9z_uX2EJPwpONco-BL03fyxOjyg4A711OK-Moe_wRvWMTQ at 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 <gnucash-user at lists.gnucash.org>
> 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
> > gnucash-user at 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.
> >
>
>
> ------------------------------
>
> Message: 7
> Date: Sat, 21 Sep 2024 11:43:29 -0700
> From: "Stan Brown (using GC 4.14)" <stan+gc at fastmail.fm>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Inactive/Hidden accounts
> Message-ID: <a756906b-db8e-409e-82ee-65fbc25e7f6a at fastmail.fm>
> 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 <pobruce46 at gmail.com>
> To: gnucash-user at lists.gnucash.org
> Subject: Re: [GNC] Monthly Reports
> Message-ID:
>         <
> CAF7y9z-4xGOxCC2yaA2FUhCi77GTvc8mpNRrPNy2Q5wknr4NtA at 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 <pobruce46 at gmail.com> wrote:
>
> > Yes  My end of month report is for reconciled payments.
> >
> > On Sat, Sep 21, 2024 at 4:13?AM Fred Bone <
> gnucash-user at lists.gnucash.org>
> > 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
> >> gnucash-user at 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.
> >>
> >
>
>
> ------------------------------
>
> Message: 9
> Date: Sat, 21 Sep 2024 15:12:01 -0500
> From: David Carlson <david.carlson.417 at gmail.com>
> To: Phyllis Bruce <pobruce46 at gmail.com>
> Cc: gnucash-user at lists.gnucash.org
> Subject: Re: [GNC] Monthly Reports
> Message-ID:
>         <CADYgSb=
> iKpr3M0zW1Hi6EfRaxFx1zVSH8hQkDOpRhPJBWKJRrw at mail.gmail.com>
> 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 <pobruce46 at gmail.com> 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 <pobruce46 at gmail.com>
> wrote:
> >
> > > Yes  My end of month report is for reconciled payments.
> > >
> > > On Sat, Sep 21, 2024 at 4:13?AM Fred Bone <
> > gnucash-user at lists.gnucash.org>
> > > 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
> > >> gnucash-user at 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 at 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
>
>
> ------------------------------
>
> Message: 10
> Date: Sat, 21 Sep 2024 15:14:46 -0500
> From: Scott Steimle <scoaste at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: [GNC] Finance::Quote expected digits after -
> Message-ID:
>         <
> CABBoNTGkP7BqO9fzfGNLgXE1XgXoEZ1u5nRfYtaSDstKRrYX6g at 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
> gnucash-user at 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.
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 258, Issue 59
> *********************************************
>


More information about the gnucash-user mailing list