Re: [GNC] Is anyone else getting these malicious e-mails?

2024-04-14 Thread Liz
On Sun, 14 Apr 2024 22:57:24 -0400 Michael DeBusk wrote: > I've gotten two or three obviously-malicious e-mails pretending to be > from this mailing list. The From: line lists the sender as "Gnucash > User" but the address is not this one. I fear a spammer (or worse) has > subscribed and is harve

Re: [GNC] Is anyone else getting these malicious e-mails?

2024-04-14 Thread Geoff
Unsurprising, but no, or at least, not yet. They don't need to subscribe, it's all publicly available information: https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111555.html Lax IT security by various of my service providers has exposed my email address and many more personal deta

Re: [GNC] Recording a "price margin code change"

2024-04-14 Thread Geoff
Well if that is the case I think you should just mirror those transactions in GnuCash. "Sell" all the old units at that valuation and "buy" the new units back for the same consideration. No capital gains will be booked. Your cost basis *per share* has changed, but not your overall cost. [I

[GNC] Is anyone else getting these malicious e-mails?

2024-04-14 Thread Michael DeBusk
I've gotten two or three obviously-malicious e-mails pretending to be from this mailing list. The From: line lists the sender as "Gnucash User" but the address is not this one. I fear a spammer (or worse) has subscribed and is harvesting addresses. Is anyone else seeing this? -- () ascii ribbon

[GNC] Compiled release 5.6 - finance-quote not working

2024-04-14 Thread osbert
I have compiled the latest stable release 5.6 on Linux Mint. After installation, I am able to run the program, but the application fails at the finance-quotequery. I get the error "https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=AAPL&modules=price,summaryDetail,defaultKeyStatis

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread Fross, Michael via gnucash-user
Thanks all. Yes, I just assumed the module name was the same. I’ll check when I’m back at my computer, but I’m sure it wo4ks. Much appreciated. Michael On Sun, Apr 14, 2024 at 5:02 PM David Reiser wrote: > yahoo_json not YahooJSON > > > -- > Dave Reiser > dbrei...@icloud.com > > > > > > On Apr

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread Kalpesh Patel
I have always wondered why two are not in sync... -Original Message- From: Bruce Schuck Sent: Sunday, April 14, 2024 6:14 PM To: David Reiser ; Fross, Michael Cc: david amaral ; gnucash-user@gnucash.org Subject: Re: [GNC] Finance Quotes Yahoo off the rails again? On 4/14/24 3:02 PM, Da

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread Kalpesh Patel
Verbose; not terse ... 😊 gnucash-cli.exe --verbose -Q dump yahoo_json aapl -Original Message- From: David Reiser Sent: Sunday, April 14, 2024 6:02 PM To: Fross, Michael Cc: david amaral ; gnucash-user@gnucash.org; Bruce Schuck Subject: Re: [GNC] Finance Quotes Yahoo off the rails ag

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread Bruce Schuck
On 4/14/24 3:02 PM, David Reiser wrote: yahoo_json not YahooJSON Yeah... I've made that mistake myself many times. The original author of the YahooJSON module chose to name the method (aka subroutine with the name used in the Security Editor and on the command line) "yahoo_json". Most other

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread David Reiser via gnucash-user
yahoo_json not YahooJSON -- Dave Reiser dbrei...@icloud.com > On Apr 14, 2024, at 17:03, Fross, Michael via gnucash-user > wrote: > > Thanks Bruce for the update. I've installed it but must be doing something > wrong. > > Syntax seems to work fine for YahooWeb, but I received an error if

Re: [GNC] Recording a "price margin code change"

2024-04-14 Thread Steven N. Severinghaus
As far as I can tell, there were no associated capital gains or losses, fees, or distributions. Frustratingly, the website lists the transactions differently from what shows up in the downloadable CSV or OFX files, though they at least seem to add up. And since the brokerage moved to this new b

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread Fross, Michael via gnucash-user
Thanks Bruce for the update. I've installed it but must be doing something wrong. Syntax seems to work fine for YahooWeb, but I received an error if I do the same command with YahooJSON. HTTP::CookieJar::LWP is installed and up to date. I'm not sure how to troubleshoot this effectively. Any poi

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread david amaral via gnucash-user
Thank you.Installed on windows 11 Gnucash 5.6 flawlesly in an admin comand window issued the command and all went without any errors. On Sunday, April 14, 2024 at 08:45:09 AM GMT-7, Bruce Schuck wrote: On 4/13/24 20:08:20 -0700, Bruce S wrote: > There is some miscellaneous housekeepi

Re: [GNC] Use same transfer column info for identical description

2024-04-14 Thread Jim DeLaHunt
Hello, Adrien, and welcome to MusicBrainz! On 2024-04-14 13:03, Adrien Laveau wrote: Hello community, I uploaded 5 years worth of bank account transaction to gnu-cash. I would like the apply the same transfer information to all the transactions having the same description and keep applying it

[GNC] Use same transfer column info for identical description

2024-04-14 Thread Adrien Laveau
Hello community, I uploaded 5 years worth of bank account transaction to gnu-cash. I would like the apply the same transfer information to all the transactions having the same description and keep applying it automatically to all future transaction. I found old topics about that saying it had to

Re: [GNC] Location of savd reports

2024-04-14 Thread john
> On Apr 14, 2024, at 12:45, Lester Bennett wrote: > > I've upgraded from Gnucash 4.8 to 5.6 on Ubuntu and now don't have my saved > reports. > There is a /.local/share/gnucash/saved-reports-2.8 file with my original > saved reports but they are not displayed under Saved Reports. > The origi

[GNC] Location of savd reports

2024-04-14 Thread Lester Bennett
I've upgraded from Gnucash 4.8 to 5.6 on Ubuntu and now don't have my saved reports. There is a /.local/share/gnucash/saved-reports-2.8 file with my original saved reports but they are not displayed under Saved Reports. The original installation was via the Ubuntu App store but it is still at 4.

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread Bruce Schuck
On 4/13/24 20:08:20 -0700, Bruce S wrote: There is some miscellaneous housekeeping and cleanup that needs to be done before pushing a final release to CPAN. Plus I had some other changes that I was planning for v1.60 but haven't done yet. Instead of v1.60, I may upload v1.59_01 tomorrow so peopl

Re: [GNC] how to find open invoices

2024-04-14 Thread Adrien Monteleone
Business > Customer > Find Invoice Set criteria to: Is Posted?, unchecked You can of course add other criteria to refine the search. Regards, Adrien On 4/13/24 10:07 PM, tburmas wrote:     I often have invoices that are open (in progress) that are not ready to post.  Is there a way to see a

Re: [GNC] FYI Web tables, CSV, prices info and inquiry

2024-04-14 Thread Ken Farley
I found this information extremely enlightening. I didn't know that there was a capability to use Google's capabilities to make a spreadsheet and automatically include pricing data. It's as if Libre Office Calc or Excel had an inbuilt function to retrieve pricing info. Very useful information.

Re: [GNC] importing or pasting reports into spreadsheets

2024-04-14 Thread Chris Skudder
I do this using the "Export" choice in GnuCash, saving the report as an html file on the desktop, then right-click + open with LibreOffice Calc. In addition to what Hop said below about ticking the box for:     "Detect special numbers (such as dates)" in the import ... I also need to do this st

Re: [GNC] importing or pasting reports into spreadsheets

2024-04-14 Thread Maria Inmaculada de la Torre
Hello David, I do the same for my reports but paste it into Excel and whenever I had that issue I either use powerquery for the clean up or more quick and dirty approach of using functions to extract the correct figures, some MID/RIGHT function, within the CLEAN one wrapping the result and if you

Re: [GNC] Recording a "price margin code change"

2024-04-14 Thread Geoff
Hi Steven Yes, this type of event is not unheard of. You need to find out more information before deciding how to treat it in GnuCash. In particular, did this trigger a capital gain/loss event, or does your existing cost basis carry forward. Also was there an associated cash payout or divi

[GNC] Recording a "price margin code change"

2024-04-14 Thread Steven N. Severinghaus
Hi, all. I had an odd transaction labeled as a "price margin code change" show up on a brokerage account recently. It appears to represent having "sold" all of my shares at one price, then "buying" them back at a slightly different price, with the difference made up in having somewhat more or f