Re: [GNC] GnuCash 5.0 Released

[Murugan Muruganandam]

i just checked the income statement and income statement (multi column) it is 
working as expected. can you check in preference : start date of the accounting 
period



Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of LI 
Daobing 
Sent: Tuesday, March 28, 2023 10:24 PM
To: mjchurc...@aol.com 
Cc: gnucash-devel ; 
gnucash-annou...@lists.gnucash.org ; 
Gnucash Users 
Subject: Re: [GNC] GnuCash 5.0 Released

in the report of "Income Statement (Multicolumn)",

when setting the "Start Date" to "Start of current quarter", the report
will start from "2023-03-01", and it should be "2023-01-01".
similar problem with "Start of previous quarter".

Thanks

On Wed, Mar 29, 2023 at 8:52 AM mjchurchil--- via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
>
>Installed version 5.0 on windows 11 and freebsd 13.1.  Both seem to
> work well for what I do, although didn't try every little detail I use.  Do
> not use quotes any more so can't comment on that.  Thanks everyone for your
> continuing efforts.  Mike
> ___
> 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.
>


--
Best Regards
LI Daobing
___
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] GnuCash 5.0 Released

[Ken Pyzik]

Version 5.0 installed on Windows 11.  No issues -- everything appears to work 
as needed.  I do not use quotes - so cannot comment on that.  I do use reports 
and they seem to be working as needed.  

Thanks! 

-Original Message-
From: gnucash-user  On 
Behalf Of John Ralls
Sent: Sunday, March 26, 2023 2:10 PM
To: gnucash-annou...@lists.gnucash.org
Cc: gnucash-devel ; Gnucash Users 

Subject: [GNC] GnuCash 5.0 Released

The GnuCash development team announces GnuCash 5.0.
 
New Features

A new Stock Transaction Assistant to guide you through entering most 
investment transactions for stocks, bonds, and mutual funds. You can access it 
from Actions>Stock Assistant when the focus tab is the Accounts page or a Stock 
or Fund account register.
A new Investment Lots report showing a graph of capital gains and losses in 
a period by investment lot. Note that if you don't use the View Lots dialog to 
manage capital gains and losses this report won't have anything to show you. 
Use Reports>Assets & Liabilities>Investment Lots to see the report.
The Online Quotes facility has been completely rewritten and the old 
gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced with 
finance-quote-wrapper. The functions performed by those programs may now be 
accomplished by passing commands to gnucash-cli -Q, see gnucash-cli --help for 
specifics. The perl module requirements have changed with the rewrite: The new 
version doesn't need Date::Manip but needs JSON::Parse instead. gnc-fq-update 
has been, er, updated to reflect that.
A new tab on the New/Edit Account dialog called More Properties includes 
entries to set a high and low limit on an account. That's coupled to a new 
column that's available on the Accounts Page, Balance Limit. If you set a high 
or low limit and the account balance falls above or below the respective limit 
an indicator will be shown in the Balance Limit column.
The description field quickfill in the register now displays a drop-down 
list of possible completions instead of just one inline completion.
File import menu items for the MT940, MT942, and DTAUS formats is replaced 
with a single Import from AQBanking that supports importing any file format 
supported by AQBanking, including the frequently requested CAMT. (Note that 
some CAMT profiles are under the XML format.)
The import matcher now permits editing descriptions, notes, and memo fields 
in the matcher window before creating the transactions. Right-click and select 
from the context menu.
The report generated by the Print Invoice button on the Edit Invoice tab 
can now be configured as a book option at the bottom of the Business tab; this 
permits selecting a saved configuration of one of the standard invoice reports. 
Another option enables a delay, during which a dialog box will appear enabling 
the user to select a different report. Note: When saving a configuration make 
sure that the invoice number is not set or you'll get that particular invoice 
instead of the one that you pressed the button for.

Significant Code Changes
Deprecations (will be removed in GnuCash 6.0)

_ (the alias for gettext. Use G_ instead)
gnc:make-account-list-limited-option
gnc:make-account-list-option
gnc:make-account-sel-limited-option
gnc:make-account-sel-option
gnc:make-budget-option
gnc:make-color-option
gnc:make-commodity-option
gnc:make-complex-boolean-option
gnc:make-counter-format-option
gnc:make-counter-option
gnc:make-currency-option
gnc:make-date-format-option
gnc:make-font-option
gnc:make-internal-option
gnc:make-invoice-option
gnc:make-list-option
gnc:make-multichoice-callback-option
gnc:make-multichoice-option
gnc:make-number-plot-size-option
gnc:make-number-range-option
gnc:make-owner-option
gnc:make-pixmap-option
gnc:make-query-option
gnc:make-radiobutton-option
gnc:make-simple-boolean-option
gnc:make-string-option
gnc:make-taxtable-option
gnc:make-text-option
gnc:option-set-default-value
gnc:option-set-value
gnc:option-setter
gnc:option-value
gnc:register-option
The invoice option to gnc:register-report-create-internal

Report and Book Options

This major change will affect everyone who has written custom reports in 
Guile Scheme.
The report and book options code has been completely rewritten in C++ with 
SWIG providing Guile Scheme access for reports. The new design requires 
directly registering options with for example 
gnc-optiondb-register-string-option instead of calling gnc:make-string-option 
to create an option followed by gnc:register-option to insert it in the 
report's options.
Value access is also changed: Instead of retrieving an option and then 
querying or setting its value with gnc:option-value one will query the optiondb 
with gnc-option-value, the arguments to which are the optiondb, the section, 
and the option 

Re: [GNC] GnuCash 5.0 Released

[LI Daobing]

in the report of "Income Statement (Multicolumn)",

when setting the "Start Date" to "Start of current quarter", the report
will start from "2023-03-01", and it should be "2023-01-01".
similar problem with "Start of previous quarter".

Thanks

On Wed, Mar 29, 2023 at 8:52 AM mjchurchil--- via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
>
>Installed version 5.0 on windows 11 and freebsd 13.1.  Both seem to
> work well for what I do, although didn't try every little detail I use.  Do
> not use quotes any more so can't comment on that.  Thanks everyone for your
> continuing efforts.  Mike
> ___
> 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.
>


-- 
Best Regards
LI Daobing
___
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] GnuCash 5.0 Released

[mjchurchil--- via gnucash-user]

 

   Installed version 5.0 on windows 11 and freebsd 13.1.  Both seem to work 
well for what I do, although didn't try every little detail I use.  Do not use 
quotes any more so can't comment on that.  Thanks everyone for your continuing 
efforts.  Mike  
___
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] Problems with Finance::Quote and GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25)

[David G. Pickett via gnucash-user]

Poking aroun more, I see in Edit Security DIA it says "Warning: Finance Quote 
is not installed properly.".

Checking my cron job log, it says:

flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get 
/home/dgp/GnuCash/ubuntu-DGPickett.gnucashF: X11 socket /tmp/.X11-unix/X0 does 
not exist in filesystem, trying to use abstract socket instead.Missing data 
file parameter
gnucash-cli [options] [datafile] - GnuCash, accounting for personal and small 
business finance:
Common Options:  -h [ --help ]          Show this help message  -v [ --version 
]       Show GnuCash version  --debug                Enable debugging mode: 
provide deep detail in the                          logs.                       
  This is equivalent to: --log "=info" --log "qof=info"                         
 --log "gnc=info"  --extra                Enable extra/development/debugging 
features.  --log arg              Log level overrides, of the form              
            "modulename={debug,info,warn,crit,error}"                         
Examples: "--log qof=debug" or "--log                          
gnc.backend.file.sx=info"                         This can be invoked multiple 
times.  --paths                Show paths  --logto arg            File to log 
into; defaults to "/tmp/gnucash.trace";                          can be 
"stderr" or "stdout".
Price Quotes Retrieval Options:  -Q [ --quotes ] arg    Execute price quote 
related commands. The following                          commands are 
supported.                                                    info: Show 
Finance::Quote version and exposed quote                                  
sources.                            get: Fetch current quotes for all foreign   
                               currencies and stocks in the given GnuCash       
                           datafile.                           dump: Fetch 
current quotes for specified currencies                                  or 
stocks from a specified namespace and print                                 the 
results to the console.                                 This must be followed 
with a source and one or                                 more symbols, unless 
the source is "currency"                                  in which case it must 
be followed with two or                                  more symbols, the 
first of which is the                                  currency in which 
exchange rates for the rest                                  will be quoted.    
                       --namespace arg        Regular expression determining 
which namespace                          commodities will be retrieved for when 
using the get                          command  -V [ --verbose ]       When 
using the dump command list all of the parameters                         
Finance::Quote returns for the symbol instead of the                          
ones that Gnucash requires.
Report Generation Options:  -R [ --report ] arg    Execute report related 
commands. The following                          commands are supported.        
                                            list: Lists available reports.      
                     show: Describe the options modified in the named           
                       report. A datafile may be specified to                   
               describe some saved options.                           run: Run 
the named report in the given GnuCash                                 datafile. 
                          --name arg             Name of the report to run      
                     --export-type arg      Specify export type                 
          --output-file arg      Output file for report                         



-Original Message-
From: David G. Pickett 
To: gnucash-user@gnucash.org 
Sent: Tue, Mar 28, 2023 7:23 pm
Subject: Re: [GNC] Problems with Finance::Quote and GnuCash Version: 5.0 Build 
ID: 5.0+(2023-03-25)

I see since it updated to 5.0 the quotes are not coming in from my daily cron 
and the get quotes button is grayed out, so you broke something.  Any concrete 
suggestions on specific actions on how to reactivate this, which was running 
fine in 4.13 ?
___
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] Problems with Finance::Quote and GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25)

[David G. Pickett via gnucash-user]

I see since it updated to 5.0 the quotes are not coming in from my daily cron 
and the get quotes button is grayed out, so you broke something.  Any concrete 
suggestions on specific actions on how to reactivate this, which was running 
fine in 4.13 ?
___
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] Issues Retrieving Quotes with v5.0

[Murugan Muruganandam]

Stock Assistant will be only visible/active when your account type is a stock 
or mutual fund. i was able to enter the transactions

You can access it from Actions>Stock Assistant when the focus tab is the 
Accounts page or a Stock or Fund account register.




Saludos Cordiales


Murugan


From: Fross, Michael 
Sent: Tuesday, March 28, 2023 3:48 PM
To: Murugan Muruganandam 
Cc: Gnucash-User 
Subject: Re: [GNC] Issues Retrieving Quotes with v5.0

Hello Murugan,

I've reinstalled Gnucash 5.  gnucash-cli.exe continues to work.  Actions|Stock 
Assistance is greyed out.  I still can't  update the quote source in the 
security editor (greyed out) and doing an update flashes the shell, but no 
updates are made.

Michael

On Tue, Mar 28, 2023 at 12:39 PM Murugan Muruganandam 
mailto:m.muruganan...@hotmail.com>> wrote:
please discard my query, i did not read the instructions fully, i was able to 
use the same in Stock register.

You can access it from Actions>Stock Assistant when the focus tab is the 
Accounts page or a Stock or Fund account register.




Saludos Cordiales


Murugan


From: gnucash-user 
mailto:hotmail@gnucash.org>>
 on behalf of Murugan Muruganandam 
mailto:m.muruganan...@hotmail.com>>
Sent: Tuesday, March 28, 2023 2:04 PM
To: Fross, Michael mailto:mich...@fross.org>>
Cc: Gnucash-User mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Issues Retrieving Quotes with v5.0

Also can you please check and confirm if you are able to access Stock Assistant 
from Actions menu,  it was appearing greyed out earlier , but after multiple 
install it has disappeared.




Saludos Cordiales


Murugan


From: Fross, Michael mailto:mich...@fross.org>>
Sent: Monday, March 27, 2023 8:08 PM
To: Murugan Muruganandam 
mailto:m.muruganan...@hotmail.com>>
Cc: Gnucash-User mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Issues Retrieving Quotes with v5.0

Hello David - yes the button is enabled.

Thank you Murugan.  It's nice to know it's not just my crazy machine.

Saludos Cordiales!

Michael

On Mon, Mar 27, 2023 at 5:34 PM Murugan Muruganandam 
mailto:m.muruganan...@hotmail.com>>>
 wrote:
hi Michael

i have already logged a bug as i have also the same issue




Saludos Cordiales


Murugan


From: gnucash-user 
mailto:hotmail@gnucash.org>>>
 on behalf of Fross, Michael 
mailto:mich...@fross.org>>>
Sent: Monday, March 27, 2023 5:20 PM
To: Gnucash-User 
mailto:gnucash-user@gnucash.org>>>
Subject: [GNC] Issues Retrieving Quotes with v5.0

Hello everyone,

I'm looking for a few pointers on how to troubleshoot an issue I'm having
with v5 downloading quotes.  I had no issues with v4.13.  When I select
"Tools|Price Database|GetQuotes" a shell opens and closes quickly and
nothing is updated.

I don't seem to have any issues with gnucash-cli.  Here are the results:
---
C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
yahoo_json acn
acn:
 isodate => 2023-03-27
 low => 270.64
type => EQUITY
name => acn (Accenture plc)
  pe => 25.180145
exchange => Sourced from Yahoo Finance (as JSON)
 eps => 10.88
currency => USD
  method => yahoo_json
 success => 1
  volume => 2805531
   close => 272
date => 03/27/2023
  year_range =>242.8 - 345.3
last => 273.96
open => 270.73
   div_yield => 1.5919117
  symbol => acn
high => 274.36
---

Running gnucash with the "--log gnc.scm=debug"  shows the following error:

* 15:11:29 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price
retrieval failed: Failed to parse result returned by Finance::Quote.
Error message:
(1): expected value


To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
itself does not.

I have Finance::Quote: 1.54 installed and it shows this in Help | About

Lastly, if I check the security editor, it seems like every quote provider
is greyed out.  This woudl suggest to me that gnucash doesn't think there
is a valid Finance::Quote configured.

I'd appreciate any pointers on how to dig deeper and determine what broke
for me between 4.13 and 5.0.  Is anyone else having issues?

I'm enjoying v5 quite a bit - congrats on the release.

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 

[GNC] Price retrieval failing

[R. Warriner via gnucash-user]

Since updating to the latest version I have been unable to get prices to 
download. I updated the necessary Perl modules using gnc-fq-update.
In the application it does not report an error. I can see the command line 
window (running the perl scripts) briefly appear in the background, then close. 
The application then returns to the main window with the price window in the 
background. Prices do not update and no error is persistently displayed. If an 
error is shown in the brief command prompt I am unable to catch it in time 
before the window closes.  
If I using the command line, running

"c:\program files (x86)\gnucash\bin\gnucash-cli" --quotes get --namespace=ETF 
Household.gnucash

returns:

.ound Finance::Quote version 1.54
Price retrieval failed: GncQuotes::Fetch called with no commodities.

Everything was working and downloading properly prior to updating to 5.0 and no 
changes were made to commodities. The specified namespace (ETF) uses 
Alphavantage as its quote source, I also receive the same error if I use Yahoo 
as json.

Are there additional configuration changes to be made?

Thanks

Robert


Sent with Proton Mail secure email.

publickey - rmwarriner@protonmail.com - 0x08D61740.asc
Description: application/pgp-keys


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

[GNC] Flatpak Gnucash 5.0 Get Quotes

[Dale Alspach]

The version of Gnucash on my linux mint 21.1 installation was just
upgraded. "Get Quotes" is greyed out in the Price Database tool and
(Accounts) Actions -> Stock Assistant is also.
I know very little about flatpak  so I have no idea as to how to run any of
the command line tools
in /var/lib/flatpak/app/org.gnucash.GnuCash/current/active/files/bin to
test anything.
I think someone else reported this problem but I saw no solution posted.

Dale
___
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] Issues Retrieving Quotes with v5.0

[Fross, Michael]

Hello Murugan,

I've reinstalled Gnucash 5.  gnucash-cli.exe continues to work.
Actions|Stock Assistance is greyed out.  I still can't  update the quote
source in the security editor (greyed out) and doing an update flashes the
shell, but no updates are made.

Michael

On Tue, Mar 28, 2023 at 12:39 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> please discard my query, i did not read the instructions fully, i was able
> to use the same in Stock register.
>
> You can access it from Actions>Stock Assistant when the focus tab is the
> Accounts page or a Stock or Fund account register.
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Murugan Muruganandam <
> m.muruganan...@hotmail.com>
> *Sent:* Tuesday, March 28, 2023 2:04 PM
> *To:* Fross, Michael 
> *Cc:* Gnucash-User 
> *Subject:* Re: [GNC] Issues Retrieving Quotes with v5.0
>
> Also can you please check and confirm if you are able to access Stock
> Assistant from Actions menu,  it was appearing greyed out earlier , but
> after multiple install it has disappeared.
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: Fross, Michael 
> Sent: Monday, March 27, 2023 8:08 PM
> To: Murugan Muruganandam 
> Cc: Gnucash-User 
> Subject: Re: [GNC] Issues Retrieving Quotes with v5.0
>
> Hello David - yes the button is enabled.
>
> Thank you Murugan.  It's nice to know it's not just my crazy machine.
>
> Saludos Cordiales!
>
> Michael
>
> On Mon, Mar 27, 2023 at 5:34 PM Murugan Muruganandam <
> m.muruganan...@hotmail.com> wrote:
> hi Michael
>
> i have already logged a bug as i have also the same issue
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user  hotmail@gnucash.org> on behalf of
> Fross, Michael mailto:mich...@fross.org>>
> Sent: Monday, March 27, 2023 5:20 PM
> To: Gnucash-User mailto:gnucash-user@gnucash.org
> >>
> Subject: [GNC] Issues Retrieving Quotes with v5.0
>
> Hello everyone,
>
> I'm looking for a few pointers on how to troubleshoot an issue I'm having
> with v5 downloading quotes.  I had no issues with v4.13.  When I select
> "Tools|Price Database|GetQuotes" a shell opens and closes quickly and
> nothing is updated.
>
> I don't seem to have any issues with gnucash-cli.  Here are the results:
> ---
> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
> yahoo_json acn
> acn:
>  isodate => 2023-03-27
>  low => 270.64
> type => EQUITY
> name => acn (Accenture plc)
>   pe => 25.180145
> exchange => Sourced from Yahoo Finance (as JSON)
>  eps => 10.88
> currency => USD
>   method => yahoo_json
>  success => 1
>   volume => 2805531
>close => 272
> date => 03/27/2023
>   year_range =>242.8 - 345.3
> last => 273.96
> open => 270.73
>div_yield => 1.5919117
>   symbol => acn
> high => 274.36
> ---
>
> Running gnucash with the "--log gnc.scm=debug"  shows the following error:
>
> * 15:11:29 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price
> retrieval failed: Failed to parse result returned by Finance::Quote.
> Error message:
> (1): expected value
>
>
> To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
> itself does not.
>
> I have Finance::Quote: 1.54 installed and it shows this in Help | About
>
> Lastly, if I check the security editor, it seems like every quote provider
> is greyed out.  This woudl suggest to me that gnucash doesn't think there
> is a valid Finance::Quote configured.
>
> I'd appreciate any pointers on how to dig deeper and determine what broke
> for me between 4.13 and 5.0.  Is anyone else having issues?
>
> I'm enjoying v5 quite a bit - congrats on the release.
>
> 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.
> ___
> 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] Issues Retrieving Quotes with v5.0

[David Reiser via gnucash-user]

Is your iMac an Apple Silicon (M1) machine? It’s possible to get mixed 
architecture perl modules installed. If your gnucash-cli -Q error included 
something like “want x86_64, have amd64”, then you definitely have an 
incompatible version of JSON::Parse. The way around that is to enter (in 
Terminal):

sudo arch -arch x86_64 cpan -f JSON::Parse

After that finishes, since gnucash-cli quits at the first error, you need  to 
run gnucash-cli -Q again — both to ensure that the right architecture 
JSON::Parse got installed, and to check if there are any other perl errors.

If necessary, run the above command repeatedly, substituting any new module 
names from arch-related error messages. When gnucash-cli -Q runs without 
complaint, you should be able to get quotes within gnucash 5.0

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Mar 28, 2023, at 1:27 AM, R Losey  wrote:
> 
> David, thank you.
> 
> I did this on my iMac; it ran a LONG time with LOTS of output, and
> installed the development tools, but finally finished. Even though I'm a
> software engineer, it was kind of scary.
> 
> But the "Get Quotes" is still greyed out, even though I ran the
> gnc-fq-update...
> 
> When I attempt the gnucash-cli command, it fails, stating that
> Finance::Quote is missingcthe JSON::Parse module
> 
> 
> On Mon, Mar 27, 2023 at 3:49 PM David H  wrote:
> 
>> Michael,
>> 
>> Is your "Get Quotes" button in Gnucash also greyed out?  I had to run
>> gnc-fq-update in /Applications/Gnucash.app/Contents/Resources/bin in the
>> terminal on macOS and let it update and then start Gnucash before the
>> button became active. Same in windows 11 pro - open a command prompt as
>> Administrator and use the command perl "C:\Program Files
>> (x86)\gnucash\bin\gnc-fq-update" - you need the double quotes around the
>> path because of the space in the path. After I did this it all seemed ok.
>> 
>> Hope this helps,
>> 
>> Cheers David H.
>> 
>> 
>> 
>> On Tue, 28 Mar 2023 at 06:24, Fross, Michael  wrote:
>> 
>>> Hello everyone,
>>> 
>>> I'm looking for a few pointers on how to troubleshoot an issue I'm having
>>> with v5 downloading quotes.  I had no issues with v4.13.  When I select
>>> "Tools|Price Database|GetQuotes" a shell opens and closes quickly and
>>> nothing is updated.
>>> 
>>> I don't seem to have any issues with gnucash-cli.  Here are the results:
>>> ---
>>> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
>>> yahoo_json acn
>>> acn:
>>> isodate => 2023-03-27
>>> low => 270.64
>>>type => EQUITY
>>>name => acn (Accenture plc)
>>>  pe => 25.180145
>>>exchange => Sourced from Yahoo Finance (as JSON)
>>> eps => 10.88
>>>currency => USD
>>>  method => yahoo_json
>>> success => 1
>>>  volume => 2805531
>>>   close => 272
>>>date => 03/27/2023
>>>  year_range =>242.8 - 345.3
>>>last => 273.96
>>>open => 270.73
>>>   div_yield => 1.5919117
>>>  symbol => acn
>>>high => 274.36
>>> ---
>>> 
>>> Running gnucash with the "--log gnc.scm=debug"  shows the following
>> error:
>>> 
>>> * 15:11:29 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price
>>> retrieval failed: Failed to parse result returned by Finance::Quote.
>>> Error message:
>>> (1): expected value
>>> 
>>> 
>>> To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
>>> itself does not.
>>> 
>>> I have Finance::Quote: 1.54 installed and it shows this in Help | About
>>> 
>>> Lastly, if I check the security editor, it seems like every quote
>> provider
>>> is greyed out.  This woudl suggest to me that gnucash doesn't think there
>>> is a valid Finance::Quote configured.
>>> 
>>> I'd appreciate any pointers on how to dig deeper and determine what broke
>>> for me between 4.13 and 5.0.  Is anyone else having issues?
>>> 
>>> I'm enjoying v5 quite a bit - congrats on the release.
>>> 
>>> 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.
>>> 
>> ___
>> 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.
>> 
> 
> 
> -- 
> _
> 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 

Re: [GNC] Issues Retrieving Quotes with v5.0

[Murugan Muruganandam]

please discard my query, i did not read the instructions fully, i was able to 
use the same in Stock register.

You can access it from Actions>Stock Assistant when the focus tab is the 
Accounts page or a Stock or Fund account register.




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Murugan Muruganandam 
Sent: Tuesday, March 28, 2023 2:04 PM
To: Fross, Michael 
Cc: Gnucash-User 
Subject: Re: [GNC] Issues Retrieving Quotes with v5.0

Also can you please check and confirm if you are able to access Stock Assistant 
from Actions menu,  it was appearing greyed out earlier , but after multiple 
install it has disappeared.




Saludos Cordiales


Murugan


From: Fross, Michael 
Sent: Monday, March 27, 2023 8:08 PM
To: Murugan Muruganandam 
Cc: Gnucash-User 
Subject: Re: [GNC] Issues Retrieving Quotes with v5.0

Hello David - yes the button is enabled.

Thank you Murugan.  It's nice to know it's not just my crazy machine.

Saludos Cordiales!

Michael

On Mon, Mar 27, 2023 at 5:34 PM Murugan Muruganandam 
mailto:m.muruganan...@hotmail.com>> wrote:
hi Michael

i have already logged a bug as i have also the same issue




Saludos Cordiales


Murugan


From: gnucash-user 
mailto:hotmail@gnucash.org>>
 on behalf of Fross, Michael mailto:mich...@fross.org>>
Sent: Monday, March 27, 2023 5:20 PM
To: Gnucash-User mailto:gnucash-user@gnucash.org>>
Subject: [GNC] Issues Retrieving Quotes with v5.0

Hello everyone,

I'm looking for a few pointers on how to troubleshoot an issue I'm having
with v5 downloading quotes.  I had no issues with v4.13.  When I select
"Tools|Price Database|GetQuotes" a shell opens and closes quickly and
nothing is updated.

I don't seem to have any issues with gnucash-cli.  Here are the results:
---
C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
yahoo_json acn
acn:
 isodate => 2023-03-27
 low => 270.64
type => EQUITY
name => acn (Accenture plc)
  pe => 25.180145
exchange => Sourced from Yahoo Finance (as JSON)
 eps => 10.88
currency => USD
  method => yahoo_json
 success => 1
  volume => 2805531
   close => 272
date => 03/27/2023
  year_range =>242.8 - 345.3
last => 273.96
open => 270.73
   div_yield => 1.5919117
  symbol => acn
high => 274.36
---

Running gnucash with the "--log gnc.scm=debug"  shows the following error:

* 15:11:29 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price
retrieval failed: Failed to parse result returned by Finance::Quote.
Error message:
(1): expected value


To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
itself does not.

I have Finance::Quote: 1.54 installed and it shows this in Help | About

Lastly, if I check the security editor, it seems like every quote provider
is greyed out.  This woudl suggest to me that gnucash doesn't think there
is a valid Finance::Quote configured.

I'd appreciate any pointers on how to dig deeper and determine what broke
for me between 4.13 and 5.0.  Is anyone else having issues?

I'm enjoying v5 quite a bit - congrats on the release.

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.
___
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] Issues Retrieving Quotes with v5.0

[Murugan Muruganandam]

Also can you please check and confirm if you are able to access Stock Assistant 
from Actions menu,  it was appearing greyed out earlier , but after multiple 
install it has disappeared.




Saludos Cordiales


Murugan


From: Fross, Michael 
Sent: Monday, March 27, 2023 8:08 PM
To: Murugan Muruganandam 
Cc: Gnucash-User 
Subject: Re: [GNC] Issues Retrieving Quotes with v5.0

Hello David - yes the button is enabled.

Thank you Murugan.  It's nice to know it's not just my crazy machine.

Saludos Cordiales!

Michael

On Mon, Mar 27, 2023 at 5:34 PM Murugan Muruganandam 
mailto:m.muruganan...@hotmail.com>> wrote:
hi Michael

i have already logged a bug as i have also the same issue




Saludos Cordiales


Murugan


From: gnucash-user 
mailto:hotmail@gnucash.org>>
 on behalf of Fross, Michael mailto:mich...@fross.org>>
Sent: Monday, March 27, 2023 5:20 PM
To: Gnucash-User mailto:gnucash-user@gnucash.org>>
Subject: [GNC] Issues Retrieving Quotes with v5.0

Hello everyone,

I'm looking for a few pointers on how to troubleshoot an issue I'm having
with v5 downloading quotes.  I had no issues with v4.13.  When I select
"Tools|Price Database|GetQuotes" a shell opens and closes quickly and
nothing is updated.

I don't seem to have any issues with gnucash-cli.  Here are the results:
---
C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
yahoo_json acn
acn:
 isodate => 2023-03-27
 low => 270.64
type => EQUITY
name => acn (Accenture plc)
  pe => 25.180145
exchange => Sourced from Yahoo Finance (as JSON)
 eps => 10.88
currency => USD
  method => yahoo_json
 success => 1
  volume => 2805531
   close => 272
date => 03/27/2023
  year_range =>242.8 - 345.3
last => 273.96
open => 270.73
   div_yield => 1.5919117
  symbol => acn
high => 274.36
---

Running gnucash with the "--log gnc.scm=debug"  shows the following error:

* 15:11:29 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price
retrieval failed: Failed to parse result returned by Finance::Quote.
Error message:
(1): expected value


To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
itself does not.

I have Finance::Quote: 1.54 installed and it shows this in Help | About

Lastly, if I check the security editor, it seems like every quote provider
is greyed out.  This woudl suggest to me that gnucash doesn't think there
is a valid Finance::Quote configured.

I'd appreciate any pointers on how to dig deeper and determine what broke
for me between 4.13 and 5.0.  Is anyone else having issues?

I'm enjoying v5 quite a bit - congrats on the release.

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.
___
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] Problems with Finance::Quote and GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25)

[david.romano]

Yes Frank, GnuCash is loaded with a current Alphavantage API key.

 

In Edit Security the dropdown list (when clicked) is greyed out

 



 

 

 

-Original Message-
From: Frank H. Ellenberger  
Sent: Tuesday, March 28, 2023 2:26 PM
To: david.rom...@davidjromano.com
Cc: gnucash-user@gnucash.org
Subject: ***SPAM*** Re: [GNC] Problems with Finance::Quote and GnuCash Version: 
5.0 Build ID: 5.0+(2023-03-25)

 

Hi,

 

Am 28.03.23 um 14:11 schrieb   
david.rom...@davidjromano.com:

> Hi Guys,

> 

>   

> 

> I've just installed GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25) on 

> top of Finance::Quote 1.54 and though it seems to be picking up 

> currencies correctly it is failing on equity prices.

> 

>   

> 

>  From the diagnostics it looks as though it's a problem with the quote 

> sources as gnucash-cli -quotes info produces unexpected results and 

> does not include Alphavantage.

 

Did you fill

  
https://code.gnucash.org/docs/C/gnucash-help/set-prefs.html#prefs-quotes-fig

?

 

> Can anyone advise me how I can diagnose this, please

 

Did you read the pages under "See also"?

 

> I migliori saluti,

> 

>   

> 

> Dott. ROMANO Davide,

 

___
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] Problems with Finance::Quote and GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25)

[Frank H. Ellenberger]

Hi,

Am 28.03.23 um 14:11 schrieb david.rom...@davidjromano.com:

Hi Guys,

  


I've just installed GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25) on top
of Finance::Quote 1.54 and though it seems to be picking up currencies
correctly it is failing on equity prices.

  


 From the diagnostics it looks as though it's a problem with the quote
sources as gnucash-cli -quotes info produces unexpected results and does not
include Alphavantage.


Did you fill
https://code.gnucash.org/docs/C/gnucash-help/set-prefs.html#prefs-quotes-fig 
?



Can anyone advise me how I can diagnose this, please


Did you read the pages under "See also"?


I migliori saluti,

  


Dott. ROMANO Davide,


___
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] Best way to import from Interactive Brokers

[Ove Grunnér]

Hello all,

I have just started using "Interactive Brokers" to trade with, and I am
trying to figure out the best way to import transactions to GnuCash,
Buy/Sell Shares and deposits/withdrawals, and also net worth at point in
time to check/compare net worth reported by GnuCash.

I looked at the export options provided by Interactive Brokers and they
have so many different ways to export!

they have "Third-Party Downloads"

   - Quicken Web Connect
   - GainsKeeper
   - TradeLog
   - MS Money

All are OFX format and identical, except Trade Log which is a pipe
separated file (of sorts as they are not completely row and column based)

they also have a number of preconfigured "Default Statements"

   - Activity
   - MTM Summary
   - Realized Summary
   - Commodities Regulatory
   - Trade Confirmation
   - Aggregated Costs and Charges

Most of which is available in CSV format (again sort of)
And you can create custom reports, which I tried but I was not able to
create a report that was formatted as a nice row/column csv file with the
data I needed.

I can import the OFX files into GnuCash, but the problem is that it does
not break out the fee and it does not have any description when buying and
selling shares. The main deal breaker is that it does not separate out the
fees.

I am thinking I may need to work on the trade log and convert that into a
CSV that can be imported into GnuCash.

Is there anyone that is using Interactive Brokers and has a good way of
importing transactions (buy/sell Shares and Cash Deposits Withdrawals)?

Is anyone extracting net worth, e.g. current market value per each
investment?
I use this as a check to compare net worth reported by GnuCash.

Many thanks in advance for any tips or hints.

Ove.
___
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] Problems with Finance::Quote and GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25)

[david.romano]

Hi Guys,

 

I've just installed GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25) on top
of Finance::Quote 1.54 and though it seems to be picking up currencies
correctly it is failing on equity prices.

 

>From the diagnostics it looks as though it's a problem with the quote
sources as gnucash-cli -quotes info produces unexpected results and does not
include Alphavantage.

 



 

Can anyone advise me how I can diagnose this, please

 

I migliori saluti,

 

Dott. ROMANO Davide,

 

IT Mobile & WhatsApp: + 39 32 8675 4983


UK Direct line: +44 (0) 23 9234 1647

UK Mobile: +44 (0) 79 4830 8868


Skype Video Call: David.J.Romano

 

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