Re: [GNC] Rounding issues with Stock
Sometimes GnuCash and web sites round my stock shares to 2 places, TD Ameritrade and most do 3 places, for dividend reinvestment or mutual funds, but Schwab now does 4 places, so I have a mix of 3 and 4 places to reconcile to! The durable truth is that they take $x.yz and buy a.bcde or a.bcd shares of stock, based on the current NAV, and round or truncate away the digits to the right. So, the actual price for small amounts may vary a lot from the NAV. I reminds me of my 20% tip rounded up to the next dollar (who wants a tip in coins?) plus a dollar, which is often more than 25% for a cheap breakfast. (On a more expensive meal, where it calculates $19, I tip $20, as using 4 ones seems silly. We started tipping in cash as it makes the servers happier to lie a little bit on their taxes.) Money is real, shares are real, prices are derived and can vary a lot! Amusingly, Morningstar Portfolio's Modify page does not take value, it takes shares and price, so I send it the funny prices GnuCash calculates, and it is happy calculating my gain or loss. I wish they mutual funds would adjust their artificially derived prices to about $10 so a penny buys .001 share, and there is not much variance with rounding or truncation. But they have bigger fish to fry, or no cook in the kitchen (like DIA, SPY etfs). ___ 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] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?
Generally when you type in a password to anything, it is stored in a variable in memory, virtual memory, possibly written to swap space, but those memory and disk spaces are protected and ephemeral, so there is no easy access to them and even then, they are hard to decipher. In theory, one could encrypt it using a one-session generated random password just to make it hard to find in a core dump file or if someone cared to search your swap file pages. Then at write time during that same session, it can be decrypted for use. Many encryption systems actually digest the password into binary keys and discard it. I am no expert, as this is a fast evolving area. Since we all type in passwords all day, there are industry standards one can follow on how to acquire them, store them, use them. GnuCash might also want a password after any period of inactivity, to protect your data from house guests and the like. While PCs tend to promise this, I see them not timing out oh so often. Web sites often do this. On Tuesday, September 10, 2024 at 03:09:24 PM EDT, R Losey wrote: Well, but think about it... after the password is entered, THEN what? The "correct" password would have to be stored somewhere so that GnuCash could verify what is entered is correct, and clearly saving the password in clear text is not secure. Because the software is open source, anyone could read the steps taken to secure the password, and that would be a huge help in breaking the password. On Mon, Sep 9, 2024 at 5:35 PM David G. Pickett via gnucash-user wrote: Nobody suggested putting a password in gnucash, just a pop up dialog to ask the user for it. -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?
Of course you need to select an algorithm in a compatible library, of which there are many. I was just responding to the idea that a unchanging common password would be hard coded is open source, a very odd idea. If you used triple DES, for example, all the open source would show is that you used triple DES and got a password from the console. I have coded things like this, and found several ways to keep the password out of the code, like asking the user for it at the start. GnuCash would hold it for use when it saved, so I suppose you might find it in a crash dump file, if it crashed, and a core dump was generated, and that got shared into an untrusted space, like with a shared folder as current working directory. On Monday, September 9, 2024 at 09:34:38 PM EDT, David Carlson wrote: Not just a pop-up. All the security stuff would have to be added too, and the developers have made it abundantly clear that they do not want to do that when a huge development effort would be required to do it right. From the rest of this thread you can see that no size fits all anyway. They are confident that we users can find a solution outside of their bailiwick. On Mon, Sep 9, 2024 at 5:35 PM David G. Pickett via gnucash-user wrote: Nobody suggested putting a password in gnucash, just a pop up dialog to ask the user for it. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?
Nobody suggested putting a password in gnucash, just a pop up dialog to ask the user for it. ___ 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] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?
True, but aren't security and finances inextricable intertwined these days? You already gzip the data, so it is nicely random going into any encryption! Sadly, I am not seeing a lot of handy tools for this. Windows does have an encrypted file feature, but it assumes you leave the file on the local hard drive. The password on a zip is very weak, I believe. It does save you a lot of password recovery discussions! On Monday, September 9, 2024 at 10:16:30 AM EDT, Derek Atkins wrote: The GnuCash team, historically, have explicitly decided that GnuCash leave encryption and other password protection to external tools and NOT perform it internally. GnuCash is a financial tool, not a security tool. -derek On Mon, September 9, 2024 9:59 am, David G. Pickett via gnucash-user wrote: > The security concerns beg the question, should GnuCash files be password > protected by the app? It'd slow save and open a bit, but then you are > less worried about the files being snooped. > > There are also ways to encrypt local files, and back up the encrypted > files to you network drive. Just make sure you do not lose the password! > ___ > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?
The security concerns beg the question, should GnuCash files be password protected by the app? It'd slow save and open a bit, but then you are less worried about the files being snooped. There are also ways to encrypt local files, and back up the encrypted files to you network drive. Just make sure you do not lose the password! ___ 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] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?
I use the Win 10/11 Google Drive g:\ right now, so continuous backups. But felt more secure when on Linux Ubuntu and had insync backing the gnucash data dir up to my Google Drive, so I had both a local disk copy and a remote copy, and a cron job to sync them up every night. (The tabs did not back up, as that is in a gcm file in some other dir.) The g:\ drive gets funky if the internet is out. You can do this on win10/11 with a local dir and a g:\ google drive dir, if you either write a script to sync them and schedule it, or copy them over manually. Since the data files are new with every save, you have little window of vulnerability. However, you get the same sort of backup with Dropbox, OneDrive, iCloud, etc. but maybe with fewer supported platforms and websites. I seem to have various files flying off in many directions from many apps on many platforms, but I buy 100GB from Google for $1.99/mo. to hold al my pix, docs, music, gnucash, videos. ___ 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] Windows reboots, gnucash restart after auto save
So a rather architectural question, escalating it into a more major change affecting older revisions -- sins of the fathers? :D Transitioning would take some sort of retention of old logic in case a user's books are in the old form. Well, every tool is imperfect, and once an imperfection is created, it can be hard to erase. My take is that it might be good to have a light reference to books in use in the past, but the info like tabs last open should be with the individual set off books, and then auto save would save that. On Wednesday, September 4, 2024 at 04:58:36 PM EDT, David Carlson wrote: If you bothered to investigate what the .gcm file does, if keeps separate records for every different data file that the user has opened since the beginning of time. That is why it is called user data and there is a great deal of discussion on the GnuCash website about why it exists and how to back up and copy the important parts over to a new computer for your favorite operating system when desired. On Wed, Sep 4, 2024 at 3:47 PM David Carlson wrote: You are mixing up several different functions in one message. Not a good way to get cogent comments. As for scheduled transactions, just un-select Edit >> Scheduled Transactions >> Since Last Run >> Run when data file opened, then run it manually by Actions >> Scheduled Transactions >> Since Last Run... whenever you like. On Wed, Sep 4, 2024 at 2:55 PM David G. Pickett wrote: Now that I do not kill nightly to get quotes, I notice that scheduled trans generation does not occur unless you shut down periodically, as that is a startup task. I am having trouble remembering to get quotes most nights, too. "What if the file contains unsaved data?" I was talking about auto save, so what happens to unsaved data with autosave? The shutdown does a save, so there must be some point in the code where the gcm file is saved near the same time. Maybe window/tab closing is mixed in there. Can the gcm data be made part of the main data file? If I was working more than one set of books, I'd expect different tabs on each set of books. On Tuesday, September 3, 2024 at 08:10:28 PM EDT, David Carlson wrote: I wasn't trying to answer your comment about code. Since the developers have not found a way to easily solve either your problem or my related problem, the code must be complex. Thus, we must satisfy ourselves with a work-around that meets our needs. For me, I find a time to close the program after doing a file save when I know there is some display information that I want to save. and I need to refill my coffee cup or whatever. It didn't occur to me to try your suggestion. Would that actually close the data file and re-open it? What if the file contains unsaved data? On Tue, Sep 3, 2024 at 10:59 AM David G. Pickett wrote: My point, in a bit of reverse humor, was that it was a mistake to have 2 kinds of save, in several senses, and my issue is one of them. Surely all the transactions and quotes take much longer to save than my tab list, so I do not see any up side to having two kinds of save -- just more code, less function. On Tuesday, September 3, 2024 at 11:08:42 AM EDT, David Carlson wrote: I don't know about that but it takes a substantial amount of time to wait for GnuCash to (possibly) save the data file, save the .gcm file, shut down and then re-open the data file with all the register windows that were not closed and all the reports that were not closed, vs (possibly) save the data file, save the .gcm file and then refresh the program window. In the bug report the point is made by a developer that the program flow is different when the data is not in an .xml format, but a user doesn't care about that detail. If there was another symbol similar to the asterisk next to the data file name that indicates unsaved file data to indicate unsaved .GCM details, the user would be aware that some display formatting details are not saved. I think that would address your original concern. On Tue, Sep 3, 2024 at 9:22 AM David G. Pickett wrote: How much code is saved by having 2 different definitions of save? On Tuesday, September 3, 2024 at 02:10:45 AM EDT, David Carlson wrote: AFAIK, certain dynamic configuration details such as which account register tabs are open, column widths in those account registers, and settings for reports which are left open are only updated when GnuCash is manually closed. I have proposed a button to manually save these details in Bug 729889. On Mon, Sep 2, 2024 at 8:03 PM David G. Pickett via gnucash-user wrote: Windows 11 seems to reboot itself regularly for some update, when gnucash has been running a while, so it should be auto saved. When I restart gnucash and accept that the lock file was still there, it has the ta
Re: [GNC] Turn off automatically saving changed transaction
I recall a similar conversation about the 'edited transaction', and suggesting that both the original and not confirmed transaction be in the save, but I am not recalling if we got any consensus. These edited transactions are a bit in limbo, so I was surprised that they made it into the save. Certainly any tabs with would be improved with powerful highlighting, but sometimes there is nobody looking to deal with even the best highlighting. An edited transaction might be invalid, incomplete, so I would expect it to be discarded, much as I value every keystroke and click. ___ 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] Windows reboots, gnucash restart after auto save
Now that I do not kill nightly to get quotes, I notice that scheduled trans generation does not occur unless you shut down periodically, as that is a startup task. I am having trouble remembering to get quotes most nights, too. "What if the file contains unsaved data?" I was talking about auto save, so what happens to unsaved data with autosave? The shutdown does a save, so there must be some point in the code where the gcm file is saved near the same time. Maybe window/tab closing is mixed in there. Can the gcm data be made part of the main data file? If I was working more than one set of books, I'd expect different tabs on each set of books. On Tuesday, September 3, 2024 at 08:10:28 PM EDT, David Carlson wrote: I wasn't trying to answer your comment about code. Since the developers have not found a way to easily solve either your problem or my related problem, the code must be complex. Thus, we must satisfy ourselves with a work-around that meets our needs. For me, I find a time to close the program after doing a file save when I know there is some display information that I want to save. and I need to refill my coffee cup or whatever. It didn't occur to me to try your suggestion. Would that actually close the data file and re-open it? What if the file contains unsaved data? On Tue, Sep 3, 2024 at 10:59 AM David G. Pickett wrote: My point, in a bit of reverse humor, was that it was a mistake to have 2 kinds of save, in several senses, and my issue is one of them. Surely all the transactions and quotes take much longer to save than my tab list, so I do not see any up side to having two kinds of save -- just more code, less function. On Tuesday, September 3, 2024 at 11:08:42 AM EDT, David Carlson wrote: I don't know about that but it takes a substantial amount of time to wait for GnuCash to (possibly) save the data file, save the .gcm file, shut down and then re-open the data file with all the register windows that were not closed and all the reports that were not closed, vs (possibly) save the data file, save the .gcm file and then refresh the program window. In the bug report the point is made by a developer that the program flow is different when the data is not in an .xml format, but a user doesn't care about that detail. If there was another symbol similar to the asterisk next to the data file name that indicates unsaved file data to indicate unsaved .GCM details, the user would be aware that some display formatting details are not saved. I think that would address your original concern. On Tue, Sep 3, 2024 at 9:22 AM David G. Pickett wrote: How much code is saved by having 2 different definitions of save? On Tuesday, September 3, 2024 at 02:10:45 AM EDT, David Carlson wrote: AFAIK, certain dynamic configuration details such as which account register tabs are open, column widths in those account registers, and settings for reports which are left open are only updated when GnuCash is manually closed. I have proposed a button to manually save these details in Bug 729889. On Mon, Sep 2, 2024 at 8:03 PM David G. Pickett via gnucash-user wrote: Windows 11 seems to reboot itself regularly for some update, when gnucash has been running a while, so it should be auto saved. When I restart gnucash and accept that the lock file was still there, it has the tabs of a much earlier time. Why does auto save not save the tabs open? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson -- David Carlson -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Windows reboots, gnucash restart after auto save
My gcm file is pretty small, how long can it take to save it? Does it have to mess with the windows, tabs to save? (I didn't know saving was in two places. Funny path, too!) 48976645947672304 8 -rwxrwxrwx 1 dgp dgp 5069 Sep 4 13:55 /mnt/c/Users/david/AppData/Roaming/GnuCash/books/ubuntu-DGPickett.gnucash..gnucash.gcm ___ 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] Windows reboots, gnucash restart after auto save
My point, in a bit of reverse humor, was that it was a mistake to have 2 kinds of save, in several senses, and my issue is one of them. Surely all the transactions and quotes take much longer to save than my tab list, so I do not see any up side to having two kinds of save -- just more code, less function. On Tuesday, September 3, 2024 at 11:08:42 AM EDT, David Carlson wrote: I don't know about that but it takes a substantial amount of time to wait for GnuCash to (possibly) save the data file, save the .gcm file, shut down and then re-open the data file with all the register windows that were not closed and all the reports that were not closed, vs (possibly) save the data file, save the .gcm file and then refresh the program window. In the bug report the point is made by a developer that the program flow is different when the data is not in an .xml format, but a user doesn't care about that detail. If there was another symbol similar to the asterisk next to the data file name that indicates unsaved file data to indicate unsaved .GCM details, the user would be aware that some display formatting details are not saved. I think that would address your original concern. On Tue, Sep 3, 2024 at 9:22 AM David G. Pickett wrote: How much code is saved by having 2 different definitions of save? On Tuesday, September 3, 2024 at 02:10:45 AM EDT, David Carlson wrote: AFAIK, certain dynamic configuration details such as which account register tabs are open, column widths in those account registers, and settings for reports which are left open are only updated when GnuCash is manually closed. I have proposed a button to manually save these details in Bug 729889. On Mon, Sep 2, 2024 at 8:03 PM David G. Pickett via gnucash-user wrote: Windows 11 seems to reboot itself regularly for some update, when gnucash has been running a while, so it should be auto saved. When I restart gnucash and accept that the lock file was still there, it has the tabs of a much earlier time. Why does auto save not save the tabs open? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Windows reboots, gnucash restart after auto save
How much code is saved by having 2 different definitions of save? On Tuesday, September 3, 2024 at 02:10:45 AM EDT, David Carlson wrote: AFAIK, certain dynamic configuration details such as which account register tabs are open, column widths in those account registers, and settings for reports which are left open are only updated when GnuCash is manually closed. I have proposed a button to manually save these details in Bug 729889. On Mon, Sep 2, 2024 at 8:03 PM David G. Pickett via gnucash-user wrote: Windows 11 seems to reboot itself regularly for some update, when gnucash has been running a while, so it should be auto saved. When I restart gnucash and accept that the lock file was still there, it has the tabs of a much earlier time. Why does auto save not save the tabs open? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Windows reboots, gnucash restart after auto save
Windows 11 seems to reboot itself regularly for some update, when gnucash has been running a while, so it should be auto saved. When I restart gnucash and accept that the lock file was still there, it has the tabs of a much earlier time. Why does auto save not save the tabs open? ___ 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] Sales items, Service items, Inventory items
While not intended for inventory, GnuCash tracks securities and foreign(alternative) currency just fine, so you could create a folder in securities for inventory, and create an account to hold inventory like a stock account holds shares of various stocks. Securities also have price history, so every sale will enter a price history, which can get a bit busy. Normally, one wants the price of each item sold to be enforced to the current sale price, although the prices of items bought, and the sale price you set, may vary! It would be an interesting enhancement. ___ 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] Discovered install link for Finance Quotes in Win11 app
So bug report for not handling winDos drive letter? No ideas on how to ensure the current session is gracefully extinguished before trying to get quotes? ___ 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] Discovered install link for Finance Quotes in Win11 app
I suppose there is a command to gracefully kill any running gnucash instance so it does not hit a lock file? Of course, even with auto save, with a kill, you have to clean up the lock file, and the file may lose uncommitted transactions! It'd be nicer for the running instance to run it at an appropriate time. I shut down my instance and gave it a try from a WinDOS command line, but something goes wrong: C:\Program Files (x86)\gnucash\bin>dir "g:\My Drive\LinuxDesktop\GnuCash\ubuntu-DGPickett.gnucash" Volume in drive G is Google Drive Volume Serial Number is 1983-1116 Directory of g:\My Drive\LinuxDesktop\GnuCash 06/19/2024 09:35 PM 3,356,924 ubuntu-DGPickett.gnucash 1 File(s) 3,356,924 bytes 0 Dir(s) 26,673,577,984 bytes free C:\Program Files (x86)\gnucash\bin>.\gnucash-cli.exe --quotes get "g:\My Drive\LinuxDesktop\GnuCash\ubuntu-DGPickett.gnucash"* 15:51:57 ERROR [cleanup_and_exit_with_failure()] Session Error: failed to get_backend using access method "g" C:\Program Files (x86)\gnucash\bin> ___ 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] Discovered install link for Finance Quotes in Win11 app
Only issue now is the price database window hiding itself. Some way to easily schedule price updates would be nice. ___ 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] Discovered install link for Finance Quotes in Win11 app menu, but many questions in install.
Apparently the Price Database window hid itself under, and did not close as I said below. On Sunday, June 16, 2024 at 10:27:04 AM EDT, David G. Pickett wrote: I think I replied yes to these. The install finally said it installed successfully, so I restarted GnuCash, went to Price Database and Get Quotes was available, but when I click it, after a few seconds it disappears and the Price Database window is also gone. It's Sunday, so I cannot tell if it worked, and I have to stop a competing midnight cron update on my Linux that eventually updates the same GnuCash files via Google Drive. On Sunday, June 16, 2024 at 10:06:41 AM EDT, fromvendor wrote: I ran into this also. Additionally there were several prompts that were asked that I just took the suggested value. Finally, I had to run it three times to get it to fully finish the install due to it cancelling from a missing file or folder. -g -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of David G. Pickett via gnucash-user Sent: Sunday, June 16, 2024 8:54 AM To: Gnucash Users Subject: [GNC] Discovered install link for Finance Quotes in Win11 app menu, but many questions in install. I clicked the "Install Online Price Retrieval for GnuCash" in my new Win11 install, but had manually download install Strawberry perl as Norton blocked it. I clicked it again and it went into a long install that now is asking mysterious questions like USE_UNALIGNED or ZSTD. Shouldn't it run more unattended? ___ 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] Discovered install link for Finance Quotes in Win11 app menu, but many questions in install.
I think I replied yes to these. The install finally said it installed successfully, so I restarted GnuCash, went to Price Database and Get Quotes was available, but when I click it, after a few seconds it disappears and the Price Database window is also gone. It's Sunday, so I cannot tell if it worked, and I have to stop a competing midnight cron update on my Linux that eventually updates the same GnuCash files via Google Drive. On Sunday, June 16, 2024 at 10:06:41 AM EDT, fromvendor wrote: I ran into this also. Additionally there were several prompts that were asked that I just took the suggested value. Finally, I had to run it three times to get it to fully finish the install due to it cancelling from a missing file or folder. -g -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of David G. Pickett via gnucash-user Sent: Sunday, June 16, 2024 8:54 AM To: Gnucash Users Subject: [GNC] Discovered install link for Finance Quotes in Win11 app menu, but many questions in install. I clicked the "Install Online Price Retrieval for GnuCash" in my new Win11 install, but had manually download install Strawberry perl as Norton blocked it. I clicked it again and it went into a long install that now is asking mysterious questions like USE_UNALIGNED or ZSTD. Shouldn't it run more unattended? ___ 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.
[GNC] Discovered install link for Finance Quotes in Win11 app menu, but many questions in install.
I clicked the "Install Online Price Retrieval for GnuCash" in my new Win11 install, but had manually download install Strawberry perl as Norton blocked it. I clicked it again and it went into a long install that now is asking mysterious questions like USE_UNALIGNED or ZSTD. Shouldn't it run more unattended? ___ 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] reconcile buttons
Perhaps it was different on Linux. I have not done a lot of GnuCash on Win until lately, and did not expect there were 2 diverse designs. Is the code that diverse between platforms? Maybe we should turn GnuCash into a web server so the client can look the same on every platform? On Saturday, June 15, 2024 at 06:24:17 PM EDT, David Carlson wrote: The Finish button is still in the same place as forever in the Reconcile window in Version: 5.6 Build ID: 5.6+(2024-03-30) on my Windows 10 PC. On Sat, Jun 15, 2024 at 5:00 PM David G. Pickett via gnucash-user wrote: I loaded the latest GnuCash onto my new Win11 PC, and the first reconcile, I accidentally postponed because someone though a new Postpone button should go where Finalize used to be. Thanks! My Flatpak Linux GnuCash version did not do that. I am not sure why I would want to postpone, or what that is, when I could just come back later? It seems like a second cancel button! I asked Google and got: Search Labs | AI Overview In GnuCash, you can postpone the reconciliation of an account by pressing Ctrl+P in the Reconciling Information Window. You might want to postpone reconciliation if you don't have all the information you need yet. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] reconcile buttons
I loaded the latest GnuCash onto my new Win11 PC, and the first reconcile, I accidentally postponed because someone though a new Postpone button should go where Finalize used to be. Thanks! My Flatpak Linux GnuCash version did not do that. I am not sure why I would want to postpone, or what that is, when I could just come back later? It seems like a second cancel button! I asked Google and got: Search Labs | AI Overview In GnuCash, you can postpone the reconciliation of an account by pressing Ctrl+P in the Reconciling Information Window. You might want to postpone reconciliation if you don't have all the information you need yet. ___ 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] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later
For transfers, I put both dates in the description, and start it at the from date for ease of reconciling that account, then move it to the to date for ease in reconciling that account. I have not tried that for checks, but might start them when cleared and then move them to when written. Even ACH often shows up a business day later. So much of the business world still runs like it did on daily tape master file updates, where they fed one or more tapes of input transactions and inquiries into a tape master file update and got one or more output transaction tapes. They could do it in real time on disk. The only downside for instant real time is that a delay with notification allows the account owner a chance at catching fraud. Similarly, some CC make me wait days for a statement, as if printing paper, when they could generate the pdf from their RDBMS for me interactively one second after midnight after the cycle! On Monday, June 3, 2024 at 11:37:12 AM EDT, R Losey wrote: On Sat, Jun 1, 2024 at 3:40 PM David G. Pickett via gnucash-user wrote: I like to record my checks written on the day they were written, not cashed, but am frustrated that then I cannot check when they cleared! Float is nice, especially if you get interest, but not something I bank on! :D Similarly, one bank puts a 3 day hold on transfers, so the money goes out one day and shows up in the other account 3-5 days later! Maybe another field would be nice? I don't want to create a limbo account and two transactions to hold the value when it is floating! I have run into this same thing when transferring funds from one institution to another. I have settled on the practice of using the date when it shows up at the "TO" institution rather than the "FROM" of the previous one; and I usually enter it when the "FROM" initiates the transfer... so there is a future transaction when I enter it to know that it is "in transit" -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Need help with eBay - tagging multiple sales into one payout hitting checking two business days later
I like to record my checks written on the day they were written, not cashed, but am frustrated that then I cannot check when they cleared! Float is nice, especially if you get interest, but not something I bank on! :D Similarly, one bank puts a 3 day hold on transfers, so the money goes out one day and shows up in the other account 3-5 days later! Maybe another field would be nice? I don't want to create a limbo account and two transactions to hold the value when it is floating! ___ 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] Adding ASSETS & LIABILITIES to sub accounts
I was recently feeling a similar vibe as I had income taxes in expenses and refunds in income, but they are really algebraically the same thing of opposite sign until you get into US tax code of itemized deductions making them different. The tax report does somewhat marry them back together. As I am a standard deduction guy for the last few years, I forget the exact place it binds you up, maybe state/city tax refunds and itemization. ___ 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] Adding ASSETS & LIABILITIES to sub accounts
In the realm of enhancement suggestions, if there was a special top level folder of named sets of books, and each named set of books could have its own income, expense, equity, assets, liabilities. Then you could work a hierarchy of books in one gnucash instance. The entries in those books could even be shadowed by being linked into the master folders of income, expense, equity, assets, liabilities (rather like hard links in files -- changing either changes both), with reports knowing they should run in one tree or the other to avoid doubling items. The xml world would record them in the folder of books but the xml to C++ loader would know to also link the transactions to the master set of folders. Reports might even run on the entire folder of books, preceding the report on each set of books with a header in the report. Alternatively, gnucash could have a way to include multiple gnucash instances by reference into a parent instance, with the reporting behaviors described above. When loading the parent instance, the trans in every child would be linked also into the parent income, expense, equity, asset, liability folders. Gnucash in the children would not change, but all the new behaviors are tied to working in a parent folder. It begs the idea of a grandparent folder, i. e., unlimited levels of hierarchy, with a hierarchy of headers and subtotals in reports. And it imposes/suggests the idea that all transactions have to be in 'leaf' books, either a feature or a problem. No idea how these might be kept separate in an RDBMS supported instance, but let's assume a separate schema for each 'leaf' set of books. ___ 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] Easier way to print to PDF
PDF pitfall: some apps print a graphical file, which cannot be searched, and some print text with annotations to set position and font size, name, bold, italic, underlined, which can be searched. You can even find apps to convert the first to the second! My presbytery sends out the first, despite my attempts to educate them. Probably the MS thing! ___ 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] Simultaneous access
Yes, if gnucash was running as a remote service, it might be able to deal with multiple users. Imagine that gnucash becomes a web service and the user interface is a relatively simple web page. Even in this scenario, you would need to avoid processing too much in JavaScript and local files under the web browser, so the remote server has updated data at all times. But already gnucash often leaves a modified transaction not committed to the saved storage, even with auto save. When my cron job kills gnucash to update prices, it sometimes loses such transactions typed but not committed by leaving that line. It might be an improvement to remedy that! If the data is in an RDBMS (not XML read into, and later written from, memory structures) and you allow two or more applications that ignore or miss the lock file, there is still stale data in the memory of each application not yet sent to the RDBMS. I am not sure how closely gnucash keeps the RDBMS in sync with memory. If the data was in memory mapped files, and the files were on a remote server, it is conceivable that multiple apps mapping the same files into their VM could learn to keep out of each other's hair, and could use a mutex in that memory mapped file space. However, I have seen memory mapped remote files not transmit changes to the local RAM until the file is refreshed, say by listing the directory! One solution is to run gnucash under a virtual desktop like VNC and XWindows on Linux. You can connect a window to the virtual desktop from any host, and continue working with the same gnucash session and application on the original server. I used to pick up work at home that was in process at work, or vice versa, but I had a VPN to put me on the work network from home. Security is a concern, but you can run VNC through an SSH tunnel. Some ISPs frown on you running any sort of TCP server. I wonder if anyone has come up with a UDP protocol to hide the presence of a service from the ISP? :D ___ 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] Finance-Quote 1.61 released!
Flatpak? ___ 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] Finance-Quote 1.60 released!
Will there be a flatpak release? No hurry, as yahoo fetching is still off the rails. So many web pages one can scrape the price off of! ___ 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] FYI Web tables, CSV, prices info and inquiry
David T, Nice, but I am told pedagogy suggests even the best explanations are best packaged with examples, like on a nice web page. In fact, the Finance Quote process itself might be divided into three processes: a gnucash call to extract the symbols and sources as a CSV, a web scraper process to convert the input CSV to an output CSV, and a second gnucash call to accept that CSV and update/insert the prices database. It might make testing simpler, too! One wonders what the update versus insert policy is. Buy and sell transactions create price info, often of low precision intraday pricing, as if you are buying a 4 digit precise $98.76 stock for a $1.23 dividend, the apparent price might be $99.19 for 0.0124 shares. If there are multiple entries for a symbol and date, one must win out when I do net worth line graph with table report using price nearest date to report? (Also amazing: that is not the default!) Thanks, David P On Friday, April 12, 2024 at 05:20:25 PM EDT, sunfis...@yahoo.com wrote: Several years back, I sent this in to the list: https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html Pretty sure it still works. David T. On Apr 12, 2024, at 10:02 PM, "David G. Pickett via gnucash-user" wrote: Not all users know that the nice table of your stocks and prices that you see on so many web sites like my morningstar portfolio can be selected and pasted into a spreadsheet like Excel, Google Sheets, or LibreOffice Calc, maybe not perfectly, but so it is easy to turn them into a clean spreadsheet table. My Morningstar did something weird with the first column but it was all there and not too hard to cut and paste or paste-special it into a nice table. Then you have the option of saving it as a CSV file (Comma Separated Value), which loses any funny formatting and hypertext links and is maybe gnucash friendly. It would be a bit of an emergency, and I could do this one stock at a time, but importing this CSV to gnucash prices would be a nice backup. I have not done the research or reading above to know how to import such a table into gnucash prices. Can someone give a simple how-to? Do I need a date column? A column to say it is nav or close? Is there a web page help on this? 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.
[GNC] FYI Web tables, CSV, prices info and inquiry
Not all users know that the nice table of your stocks and prices that you see on so many web sites like my morningstar portfolio can be selected and pasted into a spreadsheet like Excel, Google Sheets, or LibreOffice Calc, maybe not perfectly, but so it is easy to turn them into a clean spreadsheet table. My Morningstar did something weird with the first column but it was all there and not too hard to cut and paste or paste-special it into a nice table. Then you have the option of saving it as a CSV file (Comma Separated Value), which loses any funny formatting and hypertext links and is maybe gnucash friendly. It would be a bit of an emergency, and I could do this one stock at a time, but importing this CSV to gnucash prices would be a nice backup. I have not done the research or reading above to know how to import such a table into gnucash prices. Can someone give a simple how-to? Do I need a date column? A column to say it is nav or close? Is there a web page help on this? ___ 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] Finance::quote YahooJSON
Yes, off the rails again: Found Finance::Quote version 1.59. * 23:45:21 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:VZ - Finance::Quote returned fetch failure.Reason Error retrieving quote for VZ. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=VZ&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized) * 23:45:21 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:WBD - Finance::Quote returned fetch failure.Reason Error retrieving quote for WBD. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=WBD&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized) ___ 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] Finance Quotes Yahoo off the rails again?
That's a lot of crontab weirdness for a cosmetic bug of bad code or bad install, on top of the flatpak weirdness. Maybe either there should be some command line option to direct Finance::Quotes to the right or unusual mechanisms, or Finance::Quotes should just check and move on silently, saving the status for part of a message if all run configurations are discovered not viable at the end? The snap installed apps seem more normal, but then I do not run them from cron or the command line. It'd be nicest if the latest GnuCash updates could be distributed through normal Ubuntu/Linux Software channels. I guess they are not "Long Term Stable"? Life on the bleeding edge! At least once a week, I am running "flatpak update -y", "snap refresh", "Software Updater" (obsolescent but seems to install stuff that "Software" "Updates" tab wants to install with a reboot), and finally "Software" "Updates" tab. The time of the quote fetch might be a busy time, but I want it after I go to bed and before I start clamscan, which is very cpu and file intense. Of course, it has to be after the markets close at 4 Eastern, but the Mutual Fund admins sometimes take a while to post their NAVs. I have to wait a day to get Fidelity captive security quotes from their website for some of my 401Ks. I am not sure my quote updates get the NAV or the last or what, but it is just an approximation for Net Worth reports of unrealized gain. On Friday, April 5, 2024 at 01:09:35 PM EDT, Bruce Schuck wrote: On 4/5/24 8:50 AM, David G. Pickett wrote: > The quotes were fetched despite these usual errors, so it is only a > cosmetic error. > > 2024-04-03 23:45:06 Removed any lck, adding price quotes > > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- > > /home/dgp/GnuCash/ubuntu-DGPickett.gnucash > > F: X11 socket /tmp/.X11-unix/X0 does not exist in filesystem, trying to > > use abstract socket instead. > > > ** (process:102885): WARNING **: 23:45:07.118: Failed to connect to bus: > > Could not connect: Connection refused > > Found Finance::Quote version 1.59. > > This error is from Flatpak. Could be related to this thread: > > https://github.com/flatpak/flatpak/issues/938 > <https://github.com/flatpak/flatpak/issues/938> Possibly. I noticed this in the GnuCash technical reference (https://gnucash.org/docs/v5/C/gnucash-manual.pdf): = On Linux if there is no graphic session that has already started the dbus, running on your computer at the time of the quote request, you must do the entry as follows instead: 0 16 * * 5 env `dbus-launch` sh -c 'trap "kill $DBUS_SESSION_BUS_PID" EXIT; gnucash-cli --quotes get ${HOME}/gnucash-filename > /dev/null 2>&1= For *its and giggles, change the time of your cron job to an hour or so before or after 23:45. Still, I have not been able to duplicate the issue on an Ubuntu 22.04 virtual machine (VirtualBox) and the current stable Flatpak GnuCash 5.6 (Build ID: Flathub 5.6-1). I'm running the update every hour. Bruce S. ___ 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] Finance Quotes Yahoo off the rails again?
The quotes were fetched despite these usual errors, so it is only a cosmetic error. On Thursday, April 4, 2024 at 09:27:11 PM EDT, Bruce Schuck wrote: On 4/4/24 4:02 PM, David G. Pickett wrote: > Ran OK for me last night, 28 seconds, but running too often seems to > create errors: > 2024-04-03 23:45:01 Start GnuCash_price_cron > /home/dgp/GnuCash/ubuntu-DGPickett.gnucash > > 2024-04-03 23:45:01 Killing gnucash hard > 2024-04-03 23:45:06 Removed any lck, adding price quotes > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- > /home/dgp/GnuCash/ubuntu-DGPickett.gnucash > F: X11 socket /tmp/.X11-unix/X0 does not exist in filesystem, trying to > use abstract socket instead. > ** (process:102885): WARNING **: 23:45:07.118: Failed to connect to bus: > Could not connect: Connection refused > Found Finance::Quote version 1.59. This error is from Flatpak. Could be related to this thread: https://github.com/flatpak/flatpak/issues/938 Since GnuCash is running within a Flatpak, I would first address the Flatpak issue. As I suggested in my earlier responses, the problem is likely something else with your configuration. Seeing this Flatpak issue makes that belief stronger. I'm curious if you don't have some sort of tmpwatch process removing /tmp/.X11-unix or files and directories underneath it. I could imagine if it gets removed while the Flatpak is running that strange issues could arise. Bruce S. ___ 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] Finance Quotes Yahoo off the rails again?
Ran OK for me last night, 28 seconds, but running too often seems to create errors: 2024-04-03 23:45:01 Start GnuCash_price_cron /home/dgp/GnuCash/ubuntu-DGPickett.gnucash 2024-04-03 23:45:01 Killing gnucash hard 2024-04-03 23:45:06 Removed any lck, adding price quotesflatpak 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. ** (process:102885): WARNING **: 23:45:07.118: Failed to connect to bus: Could not connect: Connection refusedFound Finance::Quote version 1.59. 2024-04-03 23:45:34 End bash On Thursday, April 4, 2024 at 01:28:20 PM EDT, david amaral wrote: I have been on gnucash for years now and have close to 300 securities that i get updates from yahoo.no problems as to yahoo limits On Thursday, April 4, 2024 at 10:03:26 AM GMT-7, David G. Pickett via gnucash-user wrote: My personal portfolio has 26-28 stocks (I recently closed 2 positions) (Diversity has it's virtues, and while IRSs are free choice, different 401Ks have different restricted choices.) When it is in a mood to block, it seems to block them all, not just the last few. On Wednesday, April 3, 2024 at 10:53:03 PM EDT, Bruce Schuck wrote: Wed Apr 3 13:40:48 EDT 2024 David G. Pickett wrote: > Looks good, (only error because I need to switch DIA back to yahoo) > and slow but much better. A later run under cron got lots of > errors. Do they ration by IP address? If it is by frequency, maybe we > should purposely send requests only every 10 seconds to simulate a > human user? It cannot make it much slower. I've been meaning to ask how many securities are you attempting to get prices for? Early on in this thread I called out the "500" responses. A "500" typically gets returned from a web page if the site has an issue. When Yahoo turned off the previous APIs F::Q was using, the HTTP response was one of the "40?" that would be expected. With no one else reporting the same issue my sense is that your errors are the result of something on your end. I also use YahooJSON, and a cron job fired every weekday at 13:30 Pacific time (16:30 Eastern) updates about 20 securities in less than 15 seconds. My log from today's (04/03/2024) run: = gnc-get-quote.sh start: Wed Apr 3 01:30:01 PM PDT 2024 DATAFILE: /home/bschuck/Documents/bschuck.gnucash BKUPFILE: /home/bschuck/Documents/bschuck.gnucash.20240403133001.gnucash Found Finance::Quote version 1.59. gz_thread_func EOF gnc-get-quote.sh completed: Wed Apr 3 01:30:13 PM PDT 2024 = I would not be surprised if you have a sufficiently large number of securities that Yahoo has mechanisms in place to detect and block/limit further lookups. Bruce S. ___ 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] Finance Quotes Yahoo off the rails again?
My personal portfolio has 26-28 stocks (I recently closed 2 positions) (Diversity has it's virtues, and while IRSs are free choice, different 401Ks have different restricted choices.) When it is in a mood to block, it seems to block them all, not just the last few. On Wednesday, April 3, 2024 at 10:53:03 PM EDT, Bruce Schuck wrote: Wed Apr 3 13:40:48 EDT 2024 David G. Pickett wrote: > Looks good, (only error because I need to switch DIA back to yahoo) > and slow but much better. A later run under cron got lots of > errors. Do they ration by IP address? If it is by frequency, maybe we > should purposely send requests only every 10 seconds to simulate a > human user? It cannot make it much slower. I've been meaning to ask how many securities are you attempting to get prices for? Early on in this thread I called out the "500" responses. A "500" typically gets returned from a web page if the site has an issue. When Yahoo turned off the previous APIs F::Q was using, the HTTP response was one of the "40?" that would be expected. With no one else reporting the same issue my sense is that your errors are the result of something on your end. I also use YahooJSON, and a cron job fired every weekday at 13:30 Pacific time (16:30 Eastern) updates about 20 securities in less than 15 seconds. My log from today's (04/03/2024) run: = gnc-get-quote.sh start: Wed Apr 3 01:30:01 PM PDT 2024 DATAFILE: /home/bschuck/Documents/bschuck.gnucash BKUPFILE: /home/bschuck/Documents/bschuck.gnucash.20240403133001.gnucash Found Finance::Quote version 1.59. gz_thread_func EOF gnc-get-quote.sh completed: Wed Apr 3 01:30:13 PM PDT 2024 = I would not be surprised if you have a sufficiently large number of securities that Yahoo has mechanisms in place to detect and block/limit further lookups. Bruce S. ___ 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] Finance Quotes Yahoo off the rails again?
Looks good, (only error because I need to switch DIA back to yahoo) and slow but much better. A later run under cron got lots of errors. Do they ration by IP address? If it is by frequency, maybe we should purposely send requests only every 10 seconds to simulate a human user? It cannot make it much slower. $ 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. ** (process:56531): WARNING **: 17:13:06.732: Failed to connect to bus: Could not connect: Connection refusedFound Finance::Quote version 1.59.* 18:08:53 ERROR [parse_quotesource_error()] Unrecognized Finance::Quote Error GET https://live.euronext.com/en/search_instruments/DIA failed: 500 Can't connect to live.euronext.com:443 (Temporary failure in name resolution) at /app/lib/perl5/site_perl/5.32.0/Finance/Quote/AEX.pm line 72.Price retrieval failed: Unrecognized Finance::Quote Error: GET https://live.euronext.com/en/search_instruments/DIA failed: 500 Can't connect to live.euronext.com:443 (Temporary failure in name resolution) at /app/lib/perl5/site_perl/5.32.0/Finance/Quote/AEX.pm line 72. real 55m59.087suser 0m0.066ssys 0m0.084s --Found Finance::Quote version 1.59.* 00:41:03 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:CMCSA - Finance::Quote returned fetch failure.Reason Error retrieving quote for CMCSA. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=CMCSA&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 500 (Internal Server Error)* 00:41:03 WARN [GncQuotesImpl::parse_one_quote()] Skipped FUND:WFILX - Finance::Quote returned fetch failure.Reason Error retrieving quote for WFILX. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=WFILX&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 500 (Internal Server Error)* 00:41:03 WARN [GncQuotesImpl::parse_one_quote()] Skipped FUND:FDCAX - Finance::Quote returned fetch failure.Reason Error retrieving quote for FDCAX. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=FDCAX&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 500 (Internal Server Error)* 00:41:03 WARN [GncQuotesImpl::parse_one_quote()] Skipped FUND:RYVLX - Finance::Quote returned fetch failure. . . . . On Tuesday, April 2, 2024 at 01:23:11 PM EDT, john wrote: I pushed a new flatpak to Flathub last night that I hope fixes the JSON-Parse problem. Please give it a try. Regards, John Ralls > On Apr 2, 2024, at 08:54, David G. Pickett via gnucash-user > wrote: > > I tried timing all for a common NYSE stock VZ but they seemed all slow or > failed, so I asked others what worked for them. > > Now I am on a broken flatpak dist of Finance Quote 1.59 (flatpak stuff runs > in an alternate universe, and even though 1.58 had json, 1.59 fails for the > lack of perl json parser), so waiting continues. Yahoo JSON was actually > working pretty well, for most of my securities. > On Tuesday, April 2, 2024 at 09:34:37 AM EDT, Kalpesh Patel > wrote: > > Not sure if anyone answered it or not but really it is a moving target in > terms you have to match up which source provides which quotes. Internet is > always moving and these data sourcer/aggregator always update along with it > as they add/modify/remove what they offer... no one offers entire universe > out there for free although yahoo json has been a good source. > > You can also custom write your own way of pulling them which some of us have > done. If not you can always import prices using csv importation method. Take > a look at https://github.com/ka-patel/dl_quotes which might be a starting > point (fyi: this is not sanctioned by F::Q or GNC; strictly my own personal > project in spare time) > > -Original Message- > From: David G. Pickett > Sent: Thursday, March 28, 2024 10:59 PM > To: Gnucash Users > Subject: Re: [GNC] Finance Quotes Yahoo off the rails again? > > So anyone care to recommend a source setting for quotes that works? > > > ___ > 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:
Re: [GNC] Finance Quotes Yahoo off the rails again?
I tried timing all for a common NYSE stock VZ but they seemed all slow or failed, so I asked others what worked for them. Now I am on a broken flatpak dist of Finance Quote 1.59 (flatpak stuff runs in an alternate universe, and even though 1.58 had json, 1.59 fails for the lack of perl json parser), so waiting continues. Yahoo JSON was actually working pretty well, for most of my securities. On Tuesday, April 2, 2024 at 09:34:37 AM EDT, Kalpesh Patel wrote: Not sure if anyone answered it or not but really it is a moving target in terms you have to match up which source provides which quotes. Internet is always moving and these data sourcer/aggregator always update along with it as they add/modify/remove what they offer... no one offers entire universe out there for free although yahoo json has been a good source. You can also custom write your own way of pulling them which some of us have done. If not you can always import prices using csv importation method. Take a look at https://github.com/ka-patel/dl_quotes which might be a starting point (fyi: this is not sanctioned by F::Q or GNC; strictly my own personal project in spare time) -Original Message- From: David G. Pickett Sent: Thursday, March 28, 2024 10:59 PM To: Gnucash Users Subject: Re: [GNC] Finance Quotes Yahoo off the rails again? So anyone care to recommend a source setting for quotes that works? ___ 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] Linux, Gnucash
Best ask the group! On Monday, April 1, 2024 at 05:06:39 PM EDT, James Baxter wrote: Sir,As I am not complaining or crying. To start with. I am using Linux Mint. I am not get my questions answered. I am looking to get Gnucash working with stock/tickers working. I have my doc, and some where I saved something as "James". So I thing I have two folders working. I can get the stock every Friday or Saturday. But it won't place it in the folders. I have "TSLA" 4 one. It I'd in the stock the way it should be. As I said, there is two folders. Can that be a problem. I have gone over the Gnucash.org. all of the items are in the "O R" all are updated. Not am not up on Linux mint, but learn. I am wondering if you can help. James Baxter kangaro...@yahoo.com I am still getting updated on Gnucash Thanks if you can help Yahoo Mail: Search, Organize, Conquer ___ 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] ANNOUNCE: GnuCash 5.6 Released
Ubuntu Linux 22.04.4 LTS. On Monday, April 1, 2024 at 01:10:17 PM EDT, David G. Pickett wrote: On my batch job it says: Price retrieval failed: Failed to initialize Finance::Quote: missing_modules JSON::Parse On Monday, April 1, 2024 at 01:07:16 PM EDT, David G. Pickett wrote: I eagerly installed it but in the Security editor Edit screen it says Finance Quote is not installed properly, and the Get Quotes of the Price screen is dimmed out. ___ 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] ANNOUNCE: GnuCash 5.6 Released
On my batch job it says: Price retrieval failed: Failed to initialize Finance::Quote: missing_modules JSON::Parse On Monday, April 1, 2024 at 01:07:16 PM EDT, David G. Pickett wrote: I eagerly installed it but in the Security editor Edit screen it says Finance Quote is not installed properly, and the Get Quotes of the Price screen is dimmed out. ___ 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] ANNOUNCE: GnuCash 5.6 Released
I eagerly installed it but in the Security editor Edit screen it says Finance Quote is not installed properly, and the Get Quotes of the Price screen is dimmed out. ___ 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] Finance Quotes Yahoo off the rails again?
Yes, but as I went to flatpak to get a later release, it is discouraging that it fails to get updated for newer releases of Finance Quote and for all I can tell, newer GnuCash. Maybe they update the GnuCash but ignore the Finance Quote update? On Wednesday, March 27, 2024 at 10:57:00 PM EDT, Dale Alspach wrote: I am no expert but I believe that it is not possible to upgrade finance-quote under flatpak. I believe the flatpak versions get their portability from the fact that a great deal is rolled into the package so that it does not need to have compatible dependencies. You might search the list archives. For example see https://lists.gnucash.org/pipermail/gnucash-devel/2022-October/046338.html Dale Dale On Wed, Mar 27, 2024 at 7:31 PM David G. Pickett wrote: Still no advice on how to go to Finance Quote 1.59 under flatpak and Linux? I just checked for flatpak updates, none for GnuCash. It's been out for a while but is still not attached to a new flatpak version. ___ 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] Finance Quotes Yahoo off the rails again?
I am on Ubuntu 22.04.4 LTS, gnucash Version: 5.5 Build ID: Flathub 5.5 Finance::Quote: 1.58, and yahoo json fails every night. I am not thrilled at having to build either piece by hand. It looks like I move prices for EOM by hand from interactive web sites. I have to move 5 prices manually the day after the last trading day for Fidelity's not-publicly-traded funds in a couple 401K's. On Friday, March 29, 2024 at 10:51:00 AM EDT, Fred Tydeman wrote: I am on Fedora Linux, GnuCash 4.14 and yahoo_json works for me (just got the quarter ending pricesfor both stocks and currencies). On Thu, Mar 28, 2024 at 7:59 PM David G. Pickett via gnucash-user wrote: So anyone care to recommend a source setting for quotes that works? ___ 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] Finance Quotes Yahoo off the rails again?
So anyone care to recommend a source setting for quotes that works? ___ 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] Finance Quotes Yahoo off the rails again?
Still no advice on how to go to Finance Quote 1.59 under flatpak and Linux? I just checked for flatpak updates, none for GnuCash. It's been out for a while but is still not attached to a new flatpak version. ___ 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] Finance Quotes Yahoo off the rails again?
URLs are scraped off, so here I am on a plain text email client with more info on the bug. It looks like something on the web does not like some clients: From quote log: * AMEX:DXJ Finance::Quote reported failure with error: Error retrieving quote for DXJ. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 500 (Internal Server Error) Trying with wget: dgp@dgp-p6803w:~ $ wget 'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ&modules=price,summaryDetail,defaultKeyStatistics' | timex wc --2024-03-26 14:18:10-- https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ&modules=price,summaryDetail,defaultKeyStatistics Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)... 69.147.82.60, 69.147.82.61 Connecting to query2.finance.yahoo.com (query2.finance.yahoo.com)|69.147.82.60|:443... connected. HTTP request sent, awaiting response... 429 Too Many Requests 2024-03-26 14:18:25 ERROR 429: Too Many Requests. 0 0 0 real 15.11 user 0.00 sys 0.00 dgp@dgp-p6803w:~ $ wget 'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ&modules=price,summaryDetail,defaultKeyStatistics' | timex wc --2024-03-26 14:19:34-- https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ&modules=price,summaryDetail,defaultKeyStatistics Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)... 69.147.82.60, 69.147.82.61 Connecting to query2.finance.yahoo.com (query2.finance.yahoo.com)|69.147.82.60|:443... connected. HTTP request sent, awaiting response... 429 Too Many Requests 2024-03-26 14:19:50 ERROR 429: Too Many Requests. 0 0 0 real 15.17 user 0.00 sys 0.00 dgp@dgp-p6803w:~ $ With Google Chrome, get: https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ&modules=price,summaryDetail,defaultKeyStatistics {"quoteSummary":{"result":[{"summaryDetail":{"maxAge":1,"priceHint":{"raw":2,"fmt":"2","longFmt":"2"},"previousClose":{"raw":107.84,"fmt":"107.84"},"open":{"raw":108.56,"fmt":"108.56"},"dayLow":{"raw":108.38,"fmt":"108.38"},"dayHigh":{"raw":108.88,"fmt":"108.88"},"regularMarketPreviousClose":{"raw":107.84,"fmt":"107.84"},"regularMarketOpen":{"raw":108.56,"fmt":"108.56"},"regularMarketDayLow":{"raw":108.38,"fmt":"108.38"},"regularMarketDayHigh":{"raw":108.88,"fmt":"108.88"},"dividendRate":{},"dividendYield":{},"exDividendDate":{},"payoutRatio":{},"fiveYearAvgDividendYield":{},"beta":{},"trailingPE":{"raw":12.077986,"fmt":"12.08"},"forwardPE":{},"volume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"regularMarketVolume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"averageVolume":{"raw":1097601,"fmt":"1.1M","longFmt":"1,097,601"},"averageVolume10days":{"raw":120,"fmt":"1.28M","longFmt":"1,277,770"},"averageDailyVolume10Day":{"raw":120,"fmt":"1.28M","longFmt":"1,277,770"},"bid":{"raw":108.82,"fmt":"108.82"},"ask":{"raw":108.83,"fmt":"108.83"},"bidSize":{"raw":1200,"fmt":"1.2k","longFmt":"1,200"},"askSize":{"raw":900,"fmt":"900","longFmt":"900"},"marketCap":{},"yield":{"raw":0.0293,"fmt":"2.93%"},"ytdReturn":{},"totalAssets":{"raw":4416737792,"fmt":"4.42B","longFmt":"4,416,737,792"},"expireDate":{},"strikePrice":{},"openInterest":{},"fiftyTwoWeekLow":{"raw":68.18,"fmt":"68.18"},"fiftyTwoWeekHigh":{"raw":109.28,"fmt":"109.28"},"priceToSalesTrailing12Months":{},"fiftyDayAverage":{"raw":100.636,"fmt":"100.64"},"twoHundredDayAverage":{"raw":90.06975,"fmt":"90.07"},"trailingAnnualDividendRate":{"raw":0.0,"fmt":"0.00"},"trailingAnnualDividendYield":{"raw":0.0,"fmt":"0.00%"},"navPrice":{"raw":107.95631,"fmt":"107.96"},"currency":"USD","fromCurrency":null,"lastMarket":null,"volume24Hr":{},"volumeAllCurrencies":{},"circulatingSupply":{},"algorithm":null,"maxSupply":{},"startDate":{},"tradeable":false},"defaultKeyStatistics":{"maxAge":1,"priceHint":{"raw":2,"fmt":"2","longFmt":"2"},"enterpriseValue":{},"forwardPE":{},"profitMargins":{},"morningStarOverallRating":{},"morningStarRiskRating":{},"category":"Japan Stock","bookValue":{},"priceToBook":{},"annualReportExpenseRatio":{},"ytdReturn":{"raw":0.22916919,"fmt":"22.92%"},"beta3Year":{"raw":0.43,"fmt":"0.43"},"totalAssets":{"raw":4416737792,"fmt":"4.42B","longFmt":"4,416,737,792"},"yield":{"raw":0.0293,"fmt":"2.93%"},"fundFamily":"WisdomTree","fundInceptionDate":{"raw":1150416000,"fmt":"2006-06-16"},"legalType":"Exchange Traded Fund","threeYearAverageReturn":{"raw":0.24652371,"fmt":"24.65%"},"fiveYearAverageReturn":{"raw":0.2016703,"fmt":"20.17%"},"priceToSalesTrailing12Months":{},"lastFiscalYearEnd":{},"nextFiscalYearEnd":{},"mostRecentQuarter":{},"earningsQuarterlyGrowth":{},"revenueQuarterlyGrowth":{},"netIncomeToCommon":{},"trailingEps":{},"forwardEps":{},"pegRatio":{},"lastSplitFactor":null,"lastSplitDate":{},"enterpriseToRevenue":{},"enterpriseToEbitda":{},"52WeekChange":{},"SandP52WeekChange":{},"lastDiv
Re: [GNC] Finance Quotes Yahoo off the rails again?
Here is more info on the problem, as a publicly available Google drive URL to a plain text file: wget.txt | | | | wget.txt | | | On Tuesday, March 26, 2024 at 12:44:02 PM EDT, David G. Pickett wrote: Fred, Sorry, but the mail handler makes trash out of carefully formatted and informative text. I do not know why it hates the noble new line character? I'd send attachments but they probably get removed, but maybe I can send Google Drive URLs to files? On Ubuntu bugs, I can go to the web site and paste in stuff or attach, and then it is fine, but if I send by email, same trashing as here. Hopefully some of the people on the to: and cc: lists get the untrashed original and find it informative. I am just another victim of the unstable world of Finance Quotes and quote sites, hoping it gets improved before Friday. I would be on 1.59 but apparently the wonderful, overworked, volunteer supporters have not updated the flatpak version of GnuCash to include it, which is how I got 1.58! Best, David On Tuesday, March 26, 2024 at 12:33:19 PM EDT, Fred Bone wrote: On 26 March 2024 at 16:23, David G. Pickett said: [lots of stuff, so badly formatted as to be unreadable] PLEASE TRIM QUOTES ___ 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] Finance Quotes Yahoo off the rails again?
Fred, Sorry, but the mail handler makes trash out of carefully formatted and informative text. I do not know why it hates the noble new line character? I'd send attachments but they probably get removed, but maybe I can send Google Drive URLs to files? On Ubuntu bugs, I can go to the web site and paste in stuff or attach, and then it is fine, but if I send by email, same trashing as here. Hopefully some of the people on the to: and cc: lists get the untrashed original and find it informative. I am just another victim of the unstable world of Finance Quotes and quote sites, hoping it gets improved before Friday. I would be on 1.59 but apparently the wonderful, overworked, volunteer supporters have not updated the flatpak version of GnuCash to include it, which is how I got 1.58! Best, David On Tuesday, March 26, 2024 at 12:33:19 PM EDT, Fred Bone wrote: On 26 March 2024 at 16:23, David G. Pickett said: [lots of stuff, so badly formatted as to be unreadable] PLEASE TRIM QUOTES ___ 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] Finance Quotes Yahoo off the rails again?
Last night some symbols did get updated, like it ran a while and then fell of the rails. I am rerunning it now, but it may jump forward a day. It'd be nice if it got fixed before Friday = EOM. Should I change all my stocks to something else? How does one move Finance Quote to 1.59? I think flatpak moved me to 1.58 with the GnuCash update. It does not seem to move up on its own with normal updates. I moved to flatpak GnuCash to get a higher revision than my Ubuntu LTS release provided. I will google around for an answer! Or I can ask Meta AI on WhatsApp! I tried this: dgp@dgp-p6803w:~$ flatpak run --command=sh org.gnucash.GnuCashdgp@dgp-p6803w:~$ sudo gnc-fq-updatesh: sudo: command not founddgp@dgp-p6803w:~$ gnc-fq-update You probably need to be root before running gnc-fq-update. Are you sure, you want to update parts of your Perl library? (y/n) yReading '/home/dgp/.cpan/Metadata' Database was generated on Sat, 01 Mar 2014 17:29:02 GMTFetching with LWP:http://cpan.mirror.vexxhost.com/authors/01mailrc.txt.gzLWP failed with code[500] message[Can't connect to cpan.mirror.vexxhost.com:80 (Name or service not known)] Trying with /usr/bin/wget -O "/home/dgp/.cpan/sources/authors/01mailrc.txt.gz.tmp5"to get http://cpan.mirror.vexxhost.com/authors/01mailrc.txt.gzFailed to resolve 'cpan.mirror.vexxhost.com' (Name or service not known)Failed to connect: General errorFailed to resolve 'cpan.mirror.vexxhost.com' (Name or service not known)Failed to connect: General errorFailed to resolve 'cpan.mirror.vexxhost.com' (Name or service not known)Failed to connect: General errorFailed to resolve 'cpan.mirror.vexxhost.com' (Name or service not known)Failed to connect: General errorFailed to resolve 'cpan.mirror.vexxhost.com' (Name or service not known)Failed to connect: General errorFailed to resolve 'cpan.mirror.vexxhost.com' (Name or service not known)Failed to connect: General error(still flailing, and maybe useless without access to sudo?) I did download Finance-Quote-1.59.tar.gz but how does one get the flatpak version to prefer it over this installed 1.58? dgp@dgp-p6803w:~$ find / -name Quote.pm 2>/dev/null|fgrep /Finance/Quote |fgrep VERSION `cat`/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/lib/perl5/site_perl/5.32.0/Finance/Quote.pm:our $VERSION = '1.58'; # VERSION I suppose I could just install it in the /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/lib/perl5/site_perl/5.32.0/ but that feels very hack. On Tuesday, March 26, 2024 at 12:30:44 AM EDT, David Reiser wrote: I’ve seen that error, but it disappeared on its own in a few minutes. However, I don’t remember if I quit and relaunched Gnucash in between attempts. I do recommend updating F::Q to 1.59. The appearance of the error is rare, not common. -- Dave Reiser dbrei...@icloud.com On Mar 26, 2024, at 00:18, David G. Pickett via gnucash-user wrote: PS: New error tonight: Found Finance::Quote version 1.58.* 23:59:55 ERROR [parse_quotesource_error()] Unrecognized Finance::Quote Error Can't use string ("18.590101") as a HASH ref while "strict refs" in use at /app/lib/perl5/site_perl/5.32.0/Finance/Quote/YahooJSON.pm line 177.Price retrieval failed: Unrecognized Finance::Quote Error: Can't use string ("18.590101") as a HASH ref while "strict refs" in use at /app/lib/perl5/site_perl/5.32.0/Finance/Quote/YahooJSON.pm line 177. 2024-03-26 00:00:01 End bash* 00:07:56 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:CSX - Finance::Quote returned fetch failure.Reason Error retrieving quote for CSX. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=CSX&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 500 (Internal Server Error)* 00:07:56 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:T - Finance::Quote returned fetch failure.Reason Error retrieving quote for T. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=T&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 500 (Internal Server Error)* 00:07:56 WARN [GncQuotesImpl::parse_one_quote()] Skipped FUND:WFILX - Finance::Quote returned fetch failure. On Monday, March 25, 2024 at 03:20:24 AM EDT, Frank H. Ellenberger wrote: Hi David, Am 25.03.24 um 05:13 schrieb David G. Pickett via gnucash-user: Wow, the mail handler seems to hate ascii text! Is it a side effect of html email? I keep forgetting that to run stuff installed by flatpak you need flatpak magic like this: flatpak run --command=gnucash-cli org.gnucash.GnuCash -Q dump xxx yyy may I sug
Re: [GNC] Finance Quotes Yahoo off the rails again?
PS: New error tonight: Found Finance::Quote version 1.58.* 23:59:55 ERROR [parse_quotesource_error()] Unrecognized Finance::Quote Error Can't use string ("18.590101") as a HASH ref while "strict refs" in use at /app/lib/perl5/site_perl/5.32.0/Finance/Quote/YahooJSON.pm line 177.Price retrieval failed: Unrecognized Finance::Quote Error: Can't use string ("18.590101") as a HASH ref while "strict refs" in use at /app/lib/perl5/site_perl/5.32.0/Finance/Quote/YahooJSON.pm line 177. 2024-03-26 00:00:01 End bash* 00:07:56 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:CSX - Finance::Quote returned fetch failure.Reason Error retrieving quote for CSX. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=CSX&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 500 (Internal Server Error)* 00:07:56 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:T - Finance::Quote returned fetch failure.Reason Error retrieving quote for T. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=T&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 500 (Internal Server Error)* 00:07:56 WARN [GncQuotesImpl::parse_one_quote()] Skipped FUND:WFILX - Finance::Quote returned fetch failure. On Monday, March 25, 2024 at 03:20:24 AM EDT, Frank H. Ellenberger wrote: Hi David, Am 25.03.24 um 05:13 schrieb David G. Pickett via gnucash-user: > Wow, the mail handler seems to hate ascii text! Is it a side effect of html >email? > > I keep forgetting that to run stuff installed by flatpak you need flatpak > magic like this: > flatpak run --command=gnucash-cli org.gnucash.GnuCash -Q dump xxx yyy may I suggest, to read https://wiki.gnucash.org/wiki/Flatpak#Tips and https://www.gnucash.org/docs/v5/C/gnucash-manual/fq-command-line.html After flatpak run --command=sh org.gnucash.GnuCash you can enter all flavours of gnucash-cli gnucash-cli --quotes info gnucash-cli --verbose --quotes dump SOURCE SYMBOL HTH Frank > What are the valid source codes? > On Sunday, March 24, 2024 at 07:30:41 PM EDT, David G. Pickett > wrote: > > dgp@dgp-p6803w:~$ find / -name libgnc-report.so* -type f -s >2>/dev/nulldgp@dgp-p6803w:~$ > > On Sunday, March 24, 2024 at 07:26:53 PM EDT, David G. Pickett > wrote: > > How does one run it? > > dgp@dgp-p6803w:~$ gnucash-cli -Q dump Command 'gnucash-cli' not found, but > can be installed with:sudo apt install gnucashdgp@dgp-p6803w:~$ find / -name > gnucash-cli -type f -ls 2>/dev/null 1070407 168 -rwxr-xr-x 2 root > root 170360 Dec 18 13:44 > /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-clidgp@dgp-p6803w:~$ > > /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli > -Q > dump/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli: > error while loading shared libraries: libgnc-report.so: cannot open shared > object file: No such file or directorydgp@dgp-p6803w:~$ > > On Sunday, March 24, 2024 at 08:00:59 AM EDT, Geert Janssens > wrote: > > > gnc-fq-dump's functionality has been replaced with > > > gnucash-cli -Q dump [ ...] > > > Regards, > > > Geert > > > Op zaterdag 23 maart 2024 20:40:43 CET schreef David G. Pickett via > gnucash-user: > >> Version: 5.5Build ID: Flathub 5.5Finance::Quote: 1.58 > >> Ubuntu 22.04.4 LTS (all the latest updates from flatpak, snap, Software > >> Updater, Software). > >> > >> Apparently the Usage is a bit off, or that script is not being distributed > >> by flatpak: $ (cd > >> /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > >> /Program\ Files/gnucash2.2.6/bin ; perl ./gnc-fq-dump; ) Usage: > >> ./gnc-fq-dump [-v] [ ...] > >> > >> $ (cd > >> /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > >> /Program\ Files/gnucash2.2.6/binfor s in bseindia tmx fidelity hufund > >> finanzpartner tsx za six fondsweb iexcloud xetra unionfunds > >> troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref > >> nasdaq romania hu morningstarch bse alphavantage hungary dutch > >> fetch_live_currencies goldmoney treasurydirect twelvedata deka > >> fidelity_direct india ukfunds yahoo_json fundlibrary asegr si
Re: [GNC] Finance Quotes Yahoo off the rails again?
r message:(1): expected valueResult: real 257.01user 1.59sys 0.19 tsx =Finance::Quote reported a failure for symbol vz: Sorry, we couldn't find any results for "vz". Please try again.real 257.21user 1.66sys 0.18 twelvedata =Finance::Quote reported a failure for symbol vz: TwelveData API_KEY not defined. Get an API key at https://twelvedata.comreal 136.80user 1.48sys 0.17 ukfunds =Finance::Quote reported a failure for symbol vz: Error - invalid symbolreal 110.24user 1.48sys 0.18 unionfunds =Finance::Quote reported a failure for symbol vz: No data returnedreal 258.47user 1.64sys 0.19 usa =vz: volume => 14554050 currency => USD net => 0.5000currency_set_by_fq => 1 high => 40.8800 symbol => VZ last => 40.8700 close => 40.3700 open => 40.5300 isodate => 2024-03-25 success => 1 date => 03/25/2024 method => alphavantage low => 40.4800 p_change => 1.2385 real 257.21user 1.71sys 0.16 xetra =Finance::Quote reported a failure for symbol vz: Error retreiving vz: GET failed on https://web.s-investor.de/app/detail.htm?boerse=GER&isin=vz&INST_ID=057: 500 Can't connect to web.s-investor.de:443 (Temporary failure in name resolution) at /app/lib/perl5/site_perl/5.32.0/Finance/Quote/XETRA.pm line 71. real 256.98user 1.56sys 0.22 yahoo_json =vz: close => 40.37 pe => 14.861817 method => yahoo_json name => vz (Verizon Communications Inc.) symbol => vz volume => 14554049 exchange => NYSE type => EQUITY high => 40.88 currency => USD date => 03/25/2024 isodate => 2024-03-25 eps => 2.75 year_range => 30.14 - 43.21 open => 40.53 success => 1 div_yield => 6.527124 low => 40.48 last => 40.87 real 257.23user 1.68sys 0.20 yahooweb =vz: high => 40.88 last => 40.87 method => yahooweb exchange => NYSE - NYSE Delayed Price name => Verizon Communications Inc. date => 03/25/2024 success => 1 isodate => 2024-03-25 symbol => vz volume => 14582800 open => 40.53 currency => USD low => 40.48 real 258.87user 2.44sys 0.21 za =Finance::Quote reported a failure for symbol vz: Search failed: Failed to find vz at /app/lib/perl5/site_perl/5.32.0/Finance/Quote/ZA.pm line 61.real 264.70user 1.81sys 0.16 On Monday, March 25, 2024 at 03:20:24 AM EDT, Frank H. Ellenberger wrote: Hi David, Am 25.03.24 um 05:13 schrieb David G. Pickett via gnucash-user: > Wow, the mail handler seems to hate ascii text! Is it a side effect of html >email? > > I keep forgetting that to run stuff installed by flatpak you need flatpak > magic like this: > flatpak run --command=gnucash-cli org.gnucash.GnuCash -Q dump xxx yyy may I suggest, to read https://wiki.gnucash.org/wiki/Flatpak#Tips and https://www.gnucash.org/docs/v5/C/gnucash-manual/fq-command-line.html After flatpak run --command=sh org.gnucash.GnuCash you can enter all flavours of gnucash-cli gnucash-cli --quotes info gnucash-cli --verbose --quotes dump SOURCE SYMBOL HTH Frank > What are the valid source codes? > On Sunday, March 24, 2024 at 07:30:41 PM EDT, David G. Pickett > wrote: > > dgp@dgp-p6803w:~$ find / -name libgnc-report.so* -type f -s >2>/dev/nulldgp@dgp-p6803w:~$ > > On Sunday, March 24, 2024 at 07:26:53 PM EDT, David G. Pickett > wrote: > > How does one run it? > > dgp@dgp-p6803w:~$ gnucash-cli -Q dump Command 'gnucash-cli' not found, but > can be installed with:sudo apt install gnucashdgp@dgp-p6803w:~$ find / -name > gnucash-cli -type f -ls 2>/dev/null 1070407 168 -rwxr-xr-x 2 root > root 170360 Dec 18 13:44 > /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-clidgp@dgp-p6803w:~$ > > /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli > -Q > dump/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli: > error while loading shared libraries: libgnc-report.so: cannot open shared > object file: No such file or directorydgp@dgp-p6803w:~$ > > On Sunday, March 24, 2024 at 08:00:59 AM EDT, Geert Janssens > wrote: > > > gnc-fq-dump's functionality has been replaced with > > > gnucash-cli -Q dump [ ...] > > > Regards, > > > Geert > > > Op zaterdag 23 maart 2024 20:
Re: [GNC] Finance Quotes Yahoo off the rails again?
flatpak run --command=sh org.gnucash.GnuCash gnucash-cli --quotes info/app/bin/gnucash-cli: /app/bin/gnucash-cli: cannot execute binary file On Monday, March 25, 2024 at 03:20:24 AM EDT, Frank H. Ellenberger wrote: Hi David, Am 25.03.24 um 05:13 schrieb David G. Pickett via gnucash-user: > Wow, the mail handler seems to hate ascii text! Is it a side effect of html >email? > > I keep forgetting that to run stuff installed by flatpak you need flatpak > magic like this: > flatpak run --command=gnucash-cli org.gnucash.GnuCash -Q dump xxx yyy may I suggest, to read https://wiki.gnucash.org/wiki/Flatpak#Tips and https://www.gnucash.org/docs/v5/C/gnucash-manual/fq-command-line.html After flatpak run --command=sh org.gnucash.GnuCash you can enter all flavours of gnucash-cli gnucash-cli --quotes info gnucash-cli --verbose --quotes dump SOURCE SYMBOL HTH Frank > What are the valid source codes? > On Sunday, March 24, 2024 at 07:30:41 PM EDT, David G. Pickett > wrote: > > dgp@dgp-p6803w:~$ find / -name libgnc-report.so* -type f -s >2>/dev/nulldgp@dgp-p6803w:~$ > > On Sunday, March 24, 2024 at 07:26:53 PM EDT, David G. Pickett > wrote: > > How does one run it? > > dgp@dgp-p6803w:~$ gnucash-cli -Q dump Command 'gnucash-cli' not found, but > can be installed with:sudo apt install gnucashdgp@dgp-p6803w:~$ find / -name > gnucash-cli -type f -ls 2>/dev/null 1070407 168 -rwxr-xr-x 2 root > root 170360 Dec 18 13:44 > /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-clidgp@dgp-p6803w:~$ > > /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli > -Q > dump/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli: > error while loading shared libraries: libgnc-report.so: cannot open shared > object file: No such file or directorydgp@dgp-p6803w:~$ > > On Sunday, March 24, 2024 at 08:00:59 AM EDT, Geert Janssens > wrote: > > > gnc-fq-dump's functionality has been replaced with > > > gnucash-cli -Q dump [ ...] > > > Regards, > > > Geert > > > Op zaterdag 23 maart 2024 20:40:43 CET schreef David G. Pickett via > gnucash-user: > >> Version: 5.5Build ID: Flathub 5.5Finance::Quote: 1.58 > >> Ubuntu 22.04.4 LTS (all the latest updates from flatpak, snap, Software > >> Updater, Software). > >> > >> Apparently the Usage is a bit off, or that script is not being distributed > >> by flatpak: $ (cd > >> /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > >> /Program\ Files/gnucash2.2.6/bin ; perl ./gnc-fq-dump; ) Usage: > >> ./gnc-fq-dump [-v] [ ...] > >> > >> $ (cd > >> /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > >> /Program\ Files/gnucash2.2.6/binfor s in bseindia tmx fidelity hufund > >> finanzpartner tsx za six fondsweb iexcloud xetra unionfunds > >> troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref > >> nasdaq romania hu morningstarch bse alphavantage hungary dutch > >> fetch_live_currencies goldmoney treasurydirect twelvedata deka > >> fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet > >> fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp > >> ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual > >> tradeville france bloomberg aufunds australia usa amfiindia hustock > >> morningstaruk tesouro_direto nseindia troweprice fool tradegate europe > >> greece bamoszdo time perl ./gnc-fq-dump $s -v vz echodone)-v not > >> foundFinance::Quote fields Gnucash uses: symbol: -v (deduced) > >> <=== required date: ** missing ** <=== required currency: ** > >> missing ** <=== required last: <=\ > >> nav: <=== one of these price: > >> <=/ timezone: <=== optional ** This > >> stock quote cannot be used by gnucash!! > >> = > >> vz not foundFinance::Quote fields Gnucash uses: symbol: vz (deduced) > >> <=== required date: ** missing ** <=== required currency: > >> ** missing ** <=== required last: <=\ > >> nav:
Re: [GNC] Finance Quotes Yahoo off the rails again?
Wow, the mail handler seems to hate ascii text! Is it a side effect of html email? I keep forgetting that to run stuff installed by flatpak you need flatpak magic like this: flatpak run --command=gnucash-cli org.gnucash.GnuCash -Q dump xxx yyy What are the valid source codes? On Sunday, March 24, 2024 at 07:30:41 PM EDT, David G. Pickett wrote: dgp@dgp-p6803w:~$ find / -name libgnc-report.so* -type f -s 2>/dev/nulldgp@dgp-p6803w:~$ On Sunday, March 24, 2024 at 07:26:53 PM EDT, David G. Pickett wrote: How does one run it? dgp@dgp-p6803w:~$ gnucash-cli -Q dump Command 'gnucash-cli' not found, but can be installed with:sudo apt install gnucashdgp@dgp-p6803w:~$ find / -name gnucash-cli -type f -ls 2>/dev/null 1070407 168 -rwxr-xr-x 2 root root 170360 Dec 18 13:44 /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-clidgp@dgp-p6803w:~$ /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli -Q dump/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli: error while loading shared libraries: libgnc-report.so: cannot open shared object file: No such file or directorydgp@dgp-p6803w:~$ On Sunday, March 24, 2024 at 08:00:59 AM EDT, Geert Janssens wrote: gnc-fq-dump's functionality has been replaced with gnucash-cli -Q dump [ ...] Regards, Geert Op zaterdag 23 maart 2024 20:40:43 CET schreef David G. Pickett via gnucash-user: > Version: 5.5Build ID: Flathub 5.5Finance::Quote: 1.58 > Ubuntu 22.04.4 LTS (all the latest updates from flatpak, snap, Software > Updater, Software). > > Apparently the Usage is a bit off, or that script is not being distributed > by flatpak: $ (cd > /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > /Program\ Files/gnucash2.2.6/bin ; perl ./gnc-fq-dump; ) Usage: > ./gnc-fq-dump [-v] [ ...] > > $ (cd > /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > /Program\ Files/gnucash2.2.6/binfor s in bseindia tmx fidelity hufund > finanzpartner tsx za six fondsweb iexcloud xetra unionfunds > troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref > nasdaq romania hu morningstarch bse alphavantage hungary dutch > fetch_live_currencies goldmoney treasurydirect twelvedata deka > fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet > fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp > ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual > tradeville france bloomberg aufunds australia usa amfiindia hustock > morningstaruk tesouro_direto nseindia troweprice fool tradegate europe > greece bamoszdo time perl ./gnc-fq-dump $s -v vz echodone)-v not > foundFinance::Quote fields Gnucash uses: symbol: -v (deduced) > <=== required date: ** missing ** <=== required currency: ** > missing ** <=== required last: <=\ > nav: <=== one of these price: > <=/ timezone: <=== optional ** This > stock quote cannot be used by gnucash!! > = > vz not foundFinance::Quote fields Gnucash uses: symbol: vz (deduced) > <=== required date: ** missing ** <=== required currency: > ** missing ** <=== required last: <=\ > nav: <=== one of these price: > <=/ timezone: <=== optional ** This > stock quote cannot be used by gnucash!! > > real 0m35.045suser 0m1.709ssys 0m0.135s > ^C > ==without -v, bourso 30s, france 29s, > europe 2:16: (cd > /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > /Program\ Files/gnucash2.2.6/bin; for s in bseindia tmx fidelity hufund > finanzpartner tsx za six fondsweb iexcloud xetra unionfunds > troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref > nasdaq romania hu morningstarch bse alphavantage hungary dutch > fetch_live_currencies goldmoney treasurydirect twelvedata deka > fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet > fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp > ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual > tradeville france bloomberg aufunds australia usa amfiindia hustock > morningstaruk t
Re: [GNC] Finance Quotes Yahoo off the rails again?
dgp@dgp-p6803w:~$ find / -name libgnc-report.so* -type f -s 2>/dev/nulldgp@dgp-p6803w:~$ On Sunday, March 24, 2024 at 07:26:53 PM EDT, David G. Pickett wrote: How does one run it? dgp@dgp-p6803w:~$ gnucash-cli -Q dump Command 'gnucash-cli' not found, but can be installed with:sudo apt install gnucashdgp@dgp-p6803w:~$ find / -name gnucash-cli -type f -ls 2>/dev/null 1070407 168 -rwxr-xr-x 2 root root 170360 Dec 18 13:44 /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-clidgp@dgp-p6803w:~$ /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli -Q dump/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli: error while loading shared libraries: libgnc-report.so: cannot open shared object file: No such file or directorydgp@dgp-p6803w:~$ On Sunday, March 24, 2024 at 08:00:59 AM EDT, Geert Janssens wrote: gnc-fq-dump's functionality has been replaced with gnucash-cli -Q dump [ ...] Regards, Geert Op zaterdag 23 maart 2024 20:40:43 CET schreef David G. Pickett via gnucash-user: > Version: 5.5Build ID: Flathub 5.5Finance::Quote: 1.58 > Ubuntu 22.04.4 LTS (all the latest updates from flatpak, snap, Software > Updater, Software). > > Apparently the Usage is a bit off, or that script is not being distributed > by flatpak: $ (cd > /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > /Program\ Files/gnucash2.2.6/bin ; perl ./gnc-fq-dump; ) Usage: > ./gnc-fq-dump [-v] [ ...] > > $ (cd > /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > /Program\ Files/gnucash2.2.6/binfor s in bseindia tmx fidelity hufund > finanzpartner tsx za six fondsweb iexcloud xetra unionfunds > troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref > nasdaq romania hu morningstarch bse alphavantage hungary dutch > fetch_live_currencies goldmoney treasurydirect twelvedata deka > fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet > fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp > ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual > tradeville france bloomberg aufunds australia usa amfiindia hustock > morningstaruk tesouro_direto nseindia troweprice fool tradegate europe > greece bamoszdo time perl ./gnc-fq-dump $s -v vz echodone)-v not > foundFinance::Quote fields Gnucash uses: symbol: -v (deduced) > <=== required date: ** missing ** <=== required currency: ** > missing ** <=== required last: <=\ > nav: <=== one of these price: > <=/ timezone: <=== optional ** This > stock quote cannot be used by gnucash!! > = > vz not foundFinance::Quote fields Gnucash uses: symbol: vz (deduced) > <=== required date: ** missing ** <=== required currency: > ** missing ** <=== required last: <=\ > nav: <=== one of these price: > <=/ timezone: <=== optional ** This > stock quote cannot be used by gnucash!! > > real 0m35.045suser 0m1.709ssys 0m0.135s > ^C > ==without -v, bourso 30s, france 29s, > europe 2:16: (cd > /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > /Program\ Files/gnucash2.2.6/bin; for s in bseindia tmx fidelity hufund > finanzpartner tsx za six fondsweb iexcloud xetra unionfunds > troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref > nasdaq romania hu morningstarch bse alphavantage hungary dutch > fetch_live_currencies goldmoney treasurydirect twelvedata deka > fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet > fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp > ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual > tradeville france bloomberg aufunds australia usa amfiindia hustock > morningstaruk tesouro_direto nseindia troweprice fool tradegate europe > greece bamosz; do echo $s ; time perl ./gnc-fq-dump $s vz; > echo; done; )bseindia vz not foundFinance::Quote fields Gnucash > uses: symbol: vz (deduced) <=== required date: ** missing > ** <=== required currency: ** missing **
Re: [GNC] Finance Quotes Yahoo off the rails again?
How does one run it? dgp@dgp-p6803w:~$ gnucash-cli -Q dump Command 'gnucash-cli' not found, but can be installed with:sudo apt install gnucashdgp@dgp-p6803w:~$ find / -name gnucash-cli -type f -ls 2>/dev/null 1070407 168 -rwxr-xr-x 2 root root 170360 Dec 18 13:44 /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-clidgp@dgp-p6803w:~$ /var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli -Q dump/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/5b6213dbb6d7a8bbe5dc0ed96590fca4a22cf3a1b9229c2fa0aa65e652bba777/files/bin/gnucash-cli: error while loading shared libraries: libgnc-report.so: cannot open shared object file: No such file or directorydgp@dgp-p6803w:~$ On Sunday, March 24, 2024 at 08:00:59 AM EDT, Geert Janssens wrote: gnc-fq-dump's functionality has been replaced with gnucash-cli -Q dump [ ...] Regards, Geert Op zaterdag 23 maart 2024 20:40:43 CET schreef David G. Pickett via gnucash-user: > Version: 5.5Build ID: Flathub 5.5Finance::Quote: 1.58 > Ubuntu 22.04.4 LTS (all the latest updates from flatpak, snap, Software > Updater, Software). > > Apparently the Usage is a bit off, or that script is not being distributed > by flatpak: $ (cd > /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > /Program\ Files/gnucash2.2.6/bin ; perl ./gnc-fq-dump; ) Usage: > ./gnc-fq-dump [-v] [ ...] > > $ (cd > /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > /Program\ Files/gnucash2.2.6/binfor s in bseindia tmx fidelity hufund > finanzpartner tsx za six fondsweb iexcloud xetra unionfunds > troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref > nasdaq romania hu morningstarch bse alphavantage hungary dutch > fetch_live_currencies goldmoney treasurydirect twelvedata deka > fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet > fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp > ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual > tradeville france bloomberg aufunds australia usa amfiindia hustock > morningstaruk tesouro_direto nseindia troweprice fool tradegate europe > greece bamoszdo time perl ./gnc-fq-dump $s -v vz echodone)-v not > foundFinance::Quote fields Gnucash uses: symbol: -v (deduced) > <=== required date: ** missing ** <=== required currency: ** > missing ** <=== required last: <=\ > nav: <=== one of these price: > <=/ timezone: <=== optional ** This > stock quote cannot be used by gnucash!! > = > vz not foundFinance::Quote fields Gnucash uses: symbol: vz (deduced) > <=== required date: ** missing ** <=== required currency: > ** missing ** <=== required last: <=\ > nav: <=== one of these price: > <=/ timezone: <=== optional ** This > stock quote cannot be used by gnucash!! > > real 0m35.045suser 0m1.709ssys 0m0.135s > ^C > ==without -v, bourso 30s, france 29s, > europe 2:16: (cd > /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F > /Program\ Files/gnucash2.2.6/bin; for s in bseindia tmx fidelity hufund > finanzpartner tsx za six fondsweb iexcloud xetra unionfunds > troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref > nasdaq romania hu morningstarch bse alphavantage hungary dutch > fetch_live_currencies goldmoney treasurydirect twelvedata deka > fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet > fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp > ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual > tradeville france bloomberg aufunds australia usa amfiindia hustock > morningstaruk tesouro_direto nseindia troweprice fool tradegate europe > greece bamosz; do echo $s ; time perl ./gnc-fq-dump $s vz; > echo; done; )bseindia vz not foundFinance::Quote fields Gnucash > uses: symbol: vz (deduced) <=== required date: ** missing > ** <=== required currency: ** missing ** <=== required > last: <=\ nav: <=== > one of these price:
Re: [GNC] Finance Quotes Yahoo off the rails again?
Version: 5.5Build ID: Flathub 5.5Finance::Quote: 1.58 Ubuntu 22.04.4 LTS (all the latest updates from flatpak, snap, Software Updater, Software). Apparently the Usage is a bit off, or that script is not being distributed by flatpak: $ (cd /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F/Program\ Files/gnucash2.2.6/bin ; perl ./gnc-fq-dump; ) Usage: ./gnc-fq-dump [-v] [ ...] $ (cd /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F/Program\ Files/gnucash2.2.6/binfor s in bseindia tmx fidelity hufund finanzpartner tsx za six fondsweb iexcloud xetra unionfunds troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref nasdaq romania hu morningstarch bse alphavantage hungary dutch fetch_live_currencies goldmoney treasurydirect twelvedata deka fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual tradeville france bloomberg aufunds australia usa amfiindia hustock morningstaruk tesouro_direto nseindia troweprice fool tradegate europe greece bamoszdo time perl ./gnc-fq-dump $s -v vz echodone)-v not foundFinance::Quote fields Gnucash uses: symbol: -v (deduced) <=== required date: ** missing ** <=== required currency: ** missing ** <=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by gnucash!! = vz not foundFinance::Quote fields Gnucash uses: symbol: vz (deduced) <=== required date: ** missing ** <=== required currency: ** missing ** <=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by gnucash!! real 0m35.045suser 0m1.709ssys 0m0.135s ^C ==without -v, bourso 30s, france 29s, europe 2:16: (cd /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F/Program\ Files/gnucash2.2.6/bin; for s in bseindia tmx fidelity hufund finanzpartner tsx za six fondsweb iexcloud xetra unionfunds troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref nasdaq romania hu morningstarch bse alphavantage hungary dutch fetch_live_currencies goldmoney treasurydirect twelvedata deka fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual tradeville france bloomberg aufunds australia usa amfiindia hustock morningstaruk tesouro_direto nseindia troweprice fool tradegate europe greece bamosz; do echo $s ; time perl ./gnc-fq-dump $s vz; echo; done; )bseindia vz not foundFinance::Quote fields Gnucash uses: symbol: vz (deduced) <=== required date: ** missing ** <=== required currency: ** missing ** <=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by gnucash!! real 0m23.730suser 0m1.180ssys 0m0.111s tmx Finance::Quote fields Gnucash uses: symbol: vz (deduced) <=== required date: ** missing ** <=== required currency: ** missing ** <=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by gnucash!! real 0m16.354suser 0m1.022ssys 0m0.096s fidelity No results found for stock vz. real 0m22.290suser 0m1.167ssys 0m0.133s hufund Finance::Quote fields Gnucash uses: symbol: vz (deduced) <=== required date: ** missing ** <=== required currency: ** missing ** <=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by gnucash!! real 0m22.200suser 0m0.985ssys 0m0.125s finanzpartner Finance::Quote fields Gnucash uses: symbol: vz (deduced) <=== required date: ** missing ** <=== required currency: ** missing ** <=== required last: <=\ nav: <=== one of these price: <=
[GNC] Finance Quotes Yahho of the rails again?
Verizon, A&T are still traded? Found Finance::Quote version 1.58.* 00:49:23 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:VZ - Finance::Quote returned fetch failure.Reason Error retrieving quote for VZ. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=VZ&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 500 (Internal Server Error)* 00:49:23 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:T - Finance::Quote returned fetch failure. ___ 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 suggestions
I think sort order should be a selection on any table-flavored report. For instance, I prefer the portfolio report to be symbol sorted for ease of comparison with online positions, but it is account sorted. ___ 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] Separating tax years for payments in next year
Subfolders is a good alternative, better for reports over multiple years but more maintenance creating and destroying folders. If GNUCash wanted, they might make a magic subcategory /Prior to qualify the date's year to year - 1, but that seems very tricky to code into every date filter. Automatic subfolder creation (and when empty deletion?) by year as an attribute of the parent folder might work better, and support many such categories. On Saturday, March 9, 2024 at 01:43:41 PM EST, R Losey wrote: I like the idea -- I usually just "remember" that the Jan payment is for the previous year. But if you're going to make sub-accounts under taxes, why not use actual years? Taxes/Federal/2023 and Taxes/Federal/2024. Once a year is done with, you can easily hide the account so that it doesn't show up in your list of accounts. On Fri, Mar 8, 2024 at 3:55 PM David G. Pickett via gnucash-user wrote: I recently created ExpenseAccounts/Taxes/FederalEven and ExpenseAccounts/Taxes/FederalOdd to allow me to get a meaningful report on estimated tax and various tax withholding. The payments in Jan 2024 for 2023 estimated and later for 2-23 tax due do not clutter the reports on 2024 tax year, and the 2022 items do not get into the 2023 report. Is there a better way to deal with this? ___ 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 remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Separating tax years for payments in next year
I recently created ExpenseAccounts/Taxes/FederalEven and ExpenseAccounts/Taxes/FederalOdd to allow me to get a meaningful report on estimated tax and various tax withholding. The payments in Jan 2024 for 2023 estimated and later for 2-23 tax due do not clutter the reports on 2024 tax year, and the 2022 items do not get into the 2023 report. Is there a better way to deal with this? ___ 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] How to get a report in a format which is easy to edit?
You might export as CSV and print it from excel, Google Sheets, libreOffice Sheets or as a spreadsheet into table in a word processing document. ___ 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] Minor silliness bugs
I run the latest gnucash from flatpak on Ubuntu 22.04 LTS Linux. When I launch gnucash from my taskbar of favorites, it sends a notification to my top central bar menu that it is ready, when it is only ready to display a splash, and many additional seconds must elapse before all the XML is loaded into VM structures. Maybe it should not bother, or wait until the app window is actually open (usually asking if I approve my scheduled transaction creation with a list of mostly unchanged folders or subaccounts, also silly, as yes, I approve of it not changing unrelated things). ___ 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] Enhancement: Future sched txn update if updated template.
David, I would be happy with just changed amounts. Phone bills, cable bills, subscriptions all adjust upward in random ways at random times due to the designed in inflation of our economy, plus newly invented or rescinded taxes and fees. Wrong first take -- I cannot imagine being able to predict stock splits! :D The scheduled transaction screen code has the old and new values, so it is in a great position to update the already scheduled transactions. You mean split or 3+way transactions! While mine are generally just simple a-b transactions, there is no reason it could not work for 3 or more way transactions, like if someone is tracking taxes on their cable bill for itemization -- just ask, if yes, find the future txns that match the old template txn, delete each, enter new template txn for same date! While having my future bill and deposit txns in place does send the account listed value up and down a lot, it is nice to see what upcoming expenses I need to keep money in place for, moving excess out and moving savings in as needed. Best, David On Thursday, January 18, 2024 at 04:02:54 AM EST, David H wrote: Ok David so what are you changing on your template that you want to update to your already created txns ? Is it just a changed amount, are you adding further splits, making significant changes ? A bit roundabout but this is how I would handle the situation of a significant change to a template record... 0. Backup your Gnucsh file just in case.1. Forget about your existing template - disable it in fact.2. Search for all created future txns matching the existing template.3. Delete all 11 txns except for the very next occurrence.4. Update the remaining next txn so it reflects what you want to see in your template.5. Right click on the updated txn and select "Schedule" to schedule it and create a new template.6. Update the new template record as necessary.7. Run the "Since last run..." wizard to re-create your next 11 txns.8. Double check the results. Job Done :-) I have a number of scheduled txns that change each year that I've tacked an "Effective 2019/07/01", "Effective 2020/09/17" etc onto the template name. As I create a new one I disable the old one, mind you I only create txns 60 days in advance not 12 months so no biggie for me :-) Or you could do the search for the future txns, export them to a spreadsheet, delete them in Gnucash, update in the spreadsheet and then re-import being careful to ensure you don't end up with duplicate txns because you forgot to delete the txns you exported as I once did. Cheers David H. On Thu, 18 Jan 2024 at 08:56, David G. Pickett wrote: Yes, when editing the template and there are future transactions matching the old template, I want it to ask me if I want to update the pre-scheduled old matching future transactions to match the new template. On Wednesday, January 17, 2024 at 02:07:36 AM EST, David H wrote: I honk he’s talking about having 1 template but the transactions have already been created 12 months in advance. I.e. he wants to update the created tens based on an updated template after the fact. Regards David H. On Wed, 17 Jan 2024 at 10:43 am, Gyle McCollam wrote: Instead of having 11 or 12 sx templates, why not have one that fires monthly? Sent from Samsung Galaxy smartphone. ---- Original message From: "David G. Pickett via gnucash-user" Date: 1/16/24 6:18 PM (GMT-05:00) To: Gnucash Users Subject: [GNC] Enhancement: Future sched txn update if updated template. I schedule my periodic transactions a year in advance, but with constant inflation, often the amount goes up. It'd be nice to have a way to, by interactive option after I update the template, have gnucash update the already generated future transactions to match an updated template transaction, so I do not need to update 11 or 12 more places. ___ 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] Enhancement: Future sched txn update if updated template.
Yes, when editing the template and there are future transactions matching the old template, I want it to ask me if I want to update the pre-scheduled old matching future transactions to match the new template. On Wednesday, January 17, 2024 at 02:07:36 AM EST, David H wrote: I honk he’s talking about having 1 template but the transactions have already been created 12 months in advance. I.e. he wants to update the created tens based on an updated template after the fact. Regards David H. On Wed, 17 Jan 2024 at 10:43 am, Gyle McCollam wrote: Instead of having 11 or 12 sx templates, why not have one that fires monthly? Sent from Samsung Galaxy smartphone. Original message From: "David G. Pickett via gnucash-user" Date: 1/16/24 6:18 PM (GMT-05:00) To: Gnucash Users Subject: [GNC] Enhancement: Future sched txn update if updated template. I schedule my periodic transactions a year in advance, but with constant inflation, often the amount goes up. It'd be nice to have a way to, by interactive option after I update the template, have gnucash update the already generated future transactions to match an updated template transaction, so I do not need to update 11 or 12 more places. ___ 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.
[GNC] Enhancement: Future sched txn update if updated template.
I schedule my periodic transactions a year in advance, but with constant inflation, often the amount goes up. It'd be nice to have a way to, by interactive option after I update the template, have gnucash update the already generated future transactions to match an updated template transaction, so I do not need to update 11 or 12 more places. ___ 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 getting worse?
Being a Linux GNUCash personal finance user, not doing electronic imports of anything but stock prices, I have found it to be relatively stable using the flatpak updates, which are far more current than the apt updates. More aggressive users, and those on other platforms, may have more problems. Code changes are fraught with peril, as there are an infinite number of ways that code can malfunction, and very few ways it can function perfectly. It reminds me of integral calculus that way :D! Does the GNUCash team use a TDD (Test Driven Development) methodology, where each bug first generates new tests to detect the bug, and then code to fix the test defect? I like to say, "TDD means never having to twice say you are sorry." Ever expanding test suites help reduce the possibility of introducing defects as the product matures. ___ 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] Finance::Quote upgrade
I run Ubuntu 22.04 and used flatpack to install: Version: 5.4Build ID: Flathub 5.4.1Finance::Quote: 1.58 $ flatpak --helpUsage: flatpak [OPTION…] COMMAND Builtin Commands: Manage installed applications and runtimes install Install an application or runtime update Update an installed application or runtime uninstall Uninstall an installed application or runtime mask Mask out updates and automatic installation pin Pin a runtime to prevent automatic removal list List installed apps and/or runtimes info Show info for installed app or runtime history Show history config Configure flatpak repair Repair flatpak installation create-usb Put applications or runtimes onto removable media Find applications and runtimes search Search for remote apps/runtimes Manage running applications run Run an application override Override permissions for an application make-current Specify default version to run enter Enter the namespace of a running application ps Enumerate running applications kill Stop a running application Manage file access documents List exported files document-export Grant an application access to a specific file document-unexport Revoke access to a specific file document-info Show information about a specific file Manage dynamic permissions permissions List permissions permission-remove Remove item from permission store permission-set Set permissions permission-show Show app permissions permission-reset Reset app permissions Manage remote repositories remotes List all configured remotes remote-add Add a new remote repository (by URL) remote-modify Modify properties of a configured remote remote-delete Delete a configured remote remote-ls List contents of a configured remote remote-info Show information about a remote app or runtime Build applications build-init Initialize a directory for building build Run a build command inside the build dir build-finish Finish a build dir for export build-export Export a build dir to a repository build-bundle Create a bundle file from a ref in a local repository build-import-bundle Import a bundle file build-sign Sign an application or runtime build-update-repo Update the summary file in a repository build-commit-from Create new commit based on existing ref repo Show information about a repo Help Options: -h, --help Show help options Application Options: --version Print version information and exit --default-arch Print default arch and exit --supported-arches Print supported arches and exit --gl-drivers Print active gl drivers and exit --installations Print paths for system installations and exit --print-updated-env Print the updated environment needed to run flatpaks --print-system-only Only include the system installation with --print-updated-env -v, --verbose Show debug information, -vv for more detail --ostree-verbose Show OSTree debug information ___ 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] Enhancement suggestion
I had sql once but you moved me to xml. Is there an easy way to go back to SQL? sql saves uncommitted transactions? It seems simple enough to have attributes in XML to hold the uncommitted information beside the original information, so you can always save the entire state of the application. But even without that, having a strong indication on the tab that has pending changes would be much more ergonomic and prevent data loss. On Thursday, November 30, 2023 at 04:49:00 PM EST, Glenn Fowler wrote: I'm assuming you are using XML. In that case the "Save" button does appear from being greyed out and you are indicated on close. Of course this is global and not individual indications that you would like. The SQL database will save as you go. I'm in the other camp where I *don't* want to auto-save. This has saved me numerous times where I make a big mistake and it's a simple close without saving and reopening which is a littler easier and quicker than opening a previous backup and renaming files. On Thu, Nov 30, 2023 at 2:51 PM David Carlson wrote: Have you looked at https://bugs.gnucash.org/show_bug.cgi?id=686051, which was reported 13 years ago? On Thu, Nov 30, 2023 at 12:27 PM Glenn Fowler wrote: Hi that is expected behavior with xml, have you tried the database format? On Thu, Nov 30, 2023, 1:05 PM David G. Pickett via gnucash-user < gnucash-user@gnucash.org> wrote: > One problem with gnucash is inadvertently uncommitted modified > transactions. It's be nice if the tab lit up if that account included > such, so I can commit it before wandering off. If the system is rebooted > or gnucash is killed for batch stock price updates, these modifications are > lost, even with timed save configured. > > Alternately, find a way to save the modified transaction so when you > reopen gnucash, you can approve it. > ___ > 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. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement suggestion
I guess it never got implemented as a blinking tab or such. On Thursday, November 30, 2023 at 02:52:08 PM EST, David Carlson wrote: Have you looked at https://bugs.gnucash.org/show_bug.cgi?id=686051, which was reported 13 years ago? On Thu, Nov 30, 2023 at 12:27 PM Glenn Fowler wrote: Hi that is expected behavior with xml, have you tried the database format? On Thu, Nov 30, 2023, 1:05 PM David G. Pickett via gnucash-user < gnucash-user@gnucash.org> wrote: > One problem with gnucash is inadvertently uncommitted modified > transactions. It's be nice if the tab lit up if that account included > such, so I can commit it before wandering off. If the system is rebooted > or gnucash is killed for batch stock price updates, these modifications are > lost, even with timed save configured. > > Alternately, find a way to save the modified transaction so when you > reopen gnucash, you can approve it. > ___ > 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. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Enhancement suggestion
One problem with gnucash is inadvertently uncommitted modified transactions. It's be nice if the tab lit up if that account included such, so I can commit it before wandering off. If the system is rebooted or gnucash is killed for batch stock price updates, these modifications are lost, even with timed save configured. Alternately, find a way to save the modified transaction so when you reopen gnucash, you can approve it. ___ 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] Bad date not caught
String to date parsers provide a way to tell if the entire string was not digested, see 'man strptime' that says it returns a pointer to where it stopped, should be at the end of the string. ___ 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] Inventory
Does GNUCash do inventory at least on a small scale? It seems like a security or stock, you could define a price for sales or a recent/current cost for supplies, and when you sell or order it might be like a stock sale or order. ___ 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] GnuCash autofill headaches
Maybe, suggestion, move the leading matches to the top of the list and the others below, maybe even sorted by match start column, and then by value. Thus it works like as old if you type enough leading and hit tab or click on it. ___ 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] Stuck on old quotes version
What do I need to do to rise above 1.5301 ? I may have some residue of old app deb install as well as flatpak to get later versions of gnucash. dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes infoFound Finance::Quote version 1.5301.Finance::Quote sources:aex alphavantage amfiindia asegr asx aufunds australia bamosz bet bloomberg bourso bse bseindia canada canadamutual comdirect cse deka dutch dwsfunds europe fetch_live_currencies fidelity fidelity_direct finanzpartner fondsweb fool france ftfunds fundata fundlibrary goldmoney greece hu hufund hungary hustock iexcloud india indiamutual known_currencies morningstarau morningstarch morningstarjp mstaruk nasdaq nseindia nyse nzx onvista oslobors romania seb_funds six tesouro_direto tiaacref tmx tradeville treasurydirect troweprice troweprice_direct tsp ukfunds unionfunds usa yahoo_json za dgp@dgp-p6803w:~$ flatpak update -yLooking for updates…Nothing to do.dgp@dgp-p6803w:~$ perl /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc/310GB/media/0A32075E32074E5F/Program\ Files/gnucash2.2.6/bin/gnc-fq-check("1.56" "fondsweb" "tesouro_direto" "mstaruk" "canadamutual" "oslobors" "hu" "unionfunds" "nzx" "troweprice_direct" "hustock" "sinvestor" "alphavantage" "fool" "bseindia" "fidelity_direct" "cse" "seb_funds" "yahoo_json" "canada" "iexcloud" "nasdaq" "onvista" "known_currencies" "fidelity" "morningstarau" "morningstarjp" "deka" "tsp" "hungary" "indiamutual" "za" "troweprice" "hufund" "ftfunds" "aex" "tradeville" "six" "morningstaruk" "aufunds" "bvb" "tmx" "finanzpartner" "dwsfunds" "greece" "india" "bet" "nseindia" "morningstarch" "asegr" "bloomberg" "fundata" "tsx" "bse" "comdirect" "tiaacref" "goldmoney" "twelvedata" "europe" "romania" "bamosz" "usa" "fundlibrary" "asx" "ukfunds" "treasurydirect" "amfiindia" "tradegate" "france" "nyse" "australia" "dutch" "xetra" "fetch_live_currencies" "bourso")dgp@dgp-p6803w:~$ ___ 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] gunzip test.gnucash fails
Now if only the digest email back was a readable as and, unmodified from, the email out? -Original Message- From: David G. Pickett To: gnucash-user@gnucash.org Sent: Wed, May 31, 2023 3:00 pm Subject: Re: [GNC] gunzip test.gnucash fails Quick tutorial on OS file name extensions (suffixes) and file type: While '.gz' tells your OS it needs to go to gunzip to be uncompressed into a file without the '.gz', gunzip does not care about the name. To bypass the OS extension association, you can force the input and output file names using command line I/O redirection: gunzip < input_file > output_file. Since gunzip reads from standard input file descriptor 0 by default, and write to standard output file descriptor 1 by default, it will gladly uncompress your gnucash data into an editable xml text file. Of course, it has to like the taste of the file it reads! :D You can even name the output_file as some_base_name.txt so you text editor will gladly open and write it. As to editing XML, as long as you only modify the strings inside ... , and not any punctuation, like the fragment below where it says 'alphavantage' you could change 'alphavantage' to another source, if you know the *exact* string for that source. Change one the slow way to see what the magic word is! The second example is a description IRC where you can change 'IRC' to whatever pleases you, but try not to stick anything funny or huge in there! AMEX DIA DIA 1000 alphavantage user_symbol DIA . . . 20d545fb18b34e7ca920c11335705ac4 CURRENCY USD 2023-05-22 10:59:00 + 2023-05-26 14:36:25 + IRC ___ 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] gunzip test.gnucash fails
Quick tutorial on OS file name extensions (suffixes) and file type: While '.gz' tells your OS it needs to go to gunzip to be uncompressed into a file without the '.gz', gunzip does not care about the name. To bypass the OS extension association, you can force the input and output file names using command line I/O redirection: gunzip < input_file > output_file. Since gunzip reads from standard input file descriptor 0 by default, and write to standard output file descriptor 1 by default, it will gladly uncompress your gnucash data into an editable xml text file. Of course, it has to like the taste of the file it reads! :D You can even name the output_file as some_base_name.txt so you text editor will gladly open and write it. As to editing XML, as long as you only modify the strings inside ... , and not any punctuation, like the fragment below where it says 'alphavantage' you could change 'alphavantage' to another source, if you know the *exact* string for that source. Change one the slow way to see what the magic word is! The second example is a description IRC where you can change 'IRC' to whatever pleases you, but try not to stick anything funny or huge in there! AMEX DIA DIA 1000 alphavantage user_symbol DIA . . . 20d545fb18b34e7ca920c11335705ac4 CURRENCY USD 2023-05-22 10:59:00 + 2023-05-26 14:36:25 + IRC ___ 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] experience using Alpha Vantage
One theory I have that seems good is that they delay Fund pricing, perhaps because each fund firm publishes their NAVs at different times after the trading day, so the do not collect them or make them visible until much later. I finally got my Friday fund prices today, which is not a trading day because of the holiday, but to a simple computer schedule might seem a trading day, as it is Monday. -Original Message- From: David G. Pickett To: john.lay...@laymanandlayman.com ; gnucash-user@gnucash.org Sent: Sat, May 27, 2023 5:14 pm Subject: Re: [GNC] experience using Alpha Vantage It is frustrating that you can find dozens of free sites for human viewing with up to date quotes, especially for funds that change once after each trading day close (I guess if they have interest bearing securities they could fluctuate all the time as rates fluctuate, but not that I ever heard of). If we learn to mine these pages, the quote fetch overhead on the providers goes way up from them creating junk we throw away, e.g.: https://finance.yahoo.com/quote/SPY/ -Original Message- From: John Layman To: 'David G. Pickett' ; gnucash-user@gnucash.org Sent: Sat, May 27, 2023 8:09 am Subject: RE: [GNC] experience using Alpha Vantage Mostly, no. I'm getting few mutual fund returns. But misses are only sporadically logged. That makes me wonder if stale quotes are being delivered. But it also makes me wonder if I've been tuned out and am unaware that a secret handshake is now needed. I don't fetch prices automatically, but typically download around 6 AM. I also run an Excel spreadsheet that fetches quotes from Refinitiv using the Stocks data type. That has its own issues as some newer mutual fund tickers aren't recognized. -Original Message- From: gnucash-user On Behalf Of David G. Pickett via gnucash-user Sent: Friday, May 26, 2023 4:42 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] experience using Alpha Vantage I have seen it fumble, too, not sure if it is FQ or AA. Funds do their nav some time after 4 eastern, so I do my quotes on cron at midnight. This also means the 6 minute run time is not a problem. But silently lost quotes seems like a bad behavior. Does the code log when the price fetch fails a AA? It certainly did with Yahoo! ___ 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] experience using Alpha Vantage
It is frustrating that you can find dozens of free sites for human viewing with up to date quotes, especially for funds that change once after each trading day close (I guess if they have interest bearing securities they could fluctuate all the time as rates fluctuate, but not that I ever heard of). If we learn to mine these pages, the quote fetch overhead on the providers goes way up from them creating junk we throw away, e.g.: https://finance.yahoo.com/quote/SPY/ -Original Message- From: John Layman To: 'David G. Pickett' ; gnucash-user@gnucash.org Sent: Sat, May 27, 2023 8:09 am Subject: RE: [GNC] experience using Alpha Vantage Mostly, no. I'm getting few mutual fund returns. But misses are only sporadically logged. That makes me wonder if stale quotes are being delivered. But it also makes me wonder if I've been tuned out and am unaware that a secret handshake is now needed. I don't fetch prices automatically, but typically download around 6 AM. I also run an Excel spreadsheet that fetches quotes from Refinitiv using the Stocks data type. That has its own issues as some newer mutual fund tickers aren't recognized. -Original Message- From: gnucash-user On Behalf Of David G. Pickett via gnucash-user Sent: Friday, May 26, 2023 4:42 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] experience using Alpha Vantage I have seen it fumble, too, not sure if it is FQ or AA. Funds do their nav some time after 4 eastern, so I do my quotes on cron at midnight. This also means the 6 minute run time is not a problem. But silently lost quotes seems like a bad behavior. Does the code log when the price fetch fails a AA? It certainly did with Yahoo! ___ 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] experience using Alpha Vantage
I see last night it missed all my funds, so I am running it again. That worked! Maybe I will add another run to make sure! 9:15? -Original Message- From: David G. Pickett To: gnucash-user@gnucash.org Sent: Fri, May 26, 2023 4:42 pm Subject: Re: [GNC] experience using Alpha Vantage I have seen it fumble, too, not sure if it is FQ or AA. Funds do their nav some time after 4 eastern, so I do my quotes on cron at midnight. This also means the 6 minute run time is not a problem. But silently lost quotes seems like a bad behavior. Does the code log when the price fetch fails a AA? It certainly did with Yahoo! ___ 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] experience using Alpha Vantage
I have seen it fumble, too, not sure if it is FQ or AA. Funds do their nav some time after 4 eastern, so I do my quotes on cron at midnight. This also means the 6 minute run time is not a problem. But silently lost quotes seems like a bad behavior. Does the code log when the price fetch fails a AA? It certainly did with Yahoo! ___ 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] Finance:Quote again [sorry]
You seem to get to choose either Alphadvantage, which turns slow after a few stocks, or Yahoo v6, where we wonder how long before Yahoo discovers the v6 URL bypasses their v7 authentication and they stop servicing it. ___ 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] Auto commit with auto save?
An alternative proposal is to create data elements to allow auto-saving of both the modified and unmodified transaction of uncommitted changes, so if the file is reloaded, the uncommitted state is restored as it was at the time of the save. Then auto save would ensure these uncommitted transactions are saved as uncommitted, for future discovery after a file load on a *manual* save or graceful interactive exit with save warnings. ___ 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] Auto commit with auto save?
I use auto save, and if the app is running, the cron kills it and removes the lock before running the quote fetch. One can imagine the app having a listening socket to let you ask it to get quotes from a cron script. Or having it maintain a schedule where it gets all quotes, like an internal crontab. -Original Message- From: David T. To: David G. Pickett Cc: David G. Pickett via gnucash-user Sent: Sun, May 7, 2023 11:34 pm Subject: Re: [GNC] Auto commit with auto save? Nope and nope. Sorry. It seems to me that leaving GnuCash open and running a con job against the open app is a recipe for troubles just like the ones you have encountered. You could tell the script to abort if it found the lock file, but that would require you to close the app every night, which you're not doing now. David T. On May 7, 2023, at 9:25 PM, "David G. Pickett" wrote: Any suggestions on a) how a shell script tells that the auto save is incomplete, b) even if it knew, what it could do about it? -Original Message- From: David T. To: David G. Pickett Cc: gnucash-user@gnucash.org Sent: Sun, May 7, 2023 1:28 am Subject: Re: [GNC] Auto commit with auto save? I agree that it would be nice to have some visual cue that a transaction has been edited but not saved; that would be useful. I'm honestly not sure why that hasn't been implemented. The app does throw a dialog onscreen when a user tries to save with an open transaction. Unfortunately, the message is generic, and a user is forced to look through the open tabs and try to figure out which register holds this transaction. Others have commented on this in the past. If I recall correctly, you were having trouble because you have a cron job set up to retrieve quotes at a specified time each day, and this job causes the file to close dirty if there is an open transaction. The problem in this case, is that this cron job doesn't have necessary fault testing and tolerance. I'd suggest working on ensuring that this cron job was properly set up to handle your specific situation. David T. On May 6, 2023, at 9:02 PM, "David G. Pickett via gnucash-user" < gnucash-user@gnucash.org> wrote: "Don't do that!" does not prevent data loss from human error, which for this app behavior is too easy to create and not realize. If the commit was automatic every time you modified a transaction when the new state was valid, then I would not leave the tab in an uncommitted state, but that is not how it was devised. I leave because it looks fine. There is no indication of an uncommitted transaction I can see. In terms of human factors, one might go to another tab for information to complete a transaction, so we do not want to prevent the user leaving a tab with an uncommitted, possibly invalid transaction. Maybe we should color the tab red while in this state? Or pop up a dialog if it persists a bit too long, or if auto save fires on its timer? But the user may have left, trusting in auto save, so I suggest an auto commit if valid on auto save. 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] Yahoo JSON - throwing unauthorized error
I have previously posted my mystery regarding why I am stuck 1.5301 even after downloading and installing later versions! I went to flatpak to get later releases than the Ubuntu base. I guess I can start doing uninstall hacks using synaptics! If it is not broke -Original Message- From: Bruce Schuck To: gnucash-user@gnucash.org Cc: dgpick...@aol.com Sent: Sat, May 6, 2023 9:16 pm Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error > Switching all my securities to Alphadvantage was tiresome, as the > gui was no responsive to the keyboard, but I found the source could be found > using page up. Some display at the security editor main screen or > somewhere would help to see which is running quotes where, how many > currently owned. I have many stocks not currently owned, and so they > should not be quoted. I got more info out of an strace. Having the > security editor sort each list might be much nicer, too. Ditto for the > portfolio report. Most reports in this world sort left to right, for > some silly reason. This has been a problem with AlphaVantage since they started throttling responses for those using the free API key. > Now it is so slow, and while some work, it locks up on some security. > Maybe it needs a timeout error? I resolves the host name over and over. > Eventually only perl is running, and then nothing. It takes a long > time just to get to "Found Finance::Quote version 1.5301." Hmm... how did 1.5301 get into a flatpak? The official F::Q releases are 1.xx with only 2 digits following the major release number. Crap... looks like my screw-up. I uploaded 1.5301 instead of 1.53_01, which was a pre-release of 1.54. I did the same for 1.5402 today and it's currently being deleted. Juggling too many tasks at once. Sorry all. As stated in another thread pertaining to this issue, find the proper YahooJSON.pm file and edit it changing my $YIND_URL_HEAD = 'https://query1.finance.yahoo.com/v7/finance/quote?symbols='; to my $YIND_URL_HEAD = 'https://query1.finance.yahoo.com/v6/finance/quote?symbols='; Quick fix seems to work. New file with the quick fix uploaded to CPAN - https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.54_03.tar.gz. It can be installed in cpan as BPSCHUCK/Finance-Quote-1.54_03.tar.gz. - Bruce S. ___ 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] Auto commit with auto save?
Any suggestions on a) how a shell script tells that the auto save is incomplete, b) even if it knew, what it could do about it? -Original Message- From: David T. To: David G. Pickett Cc: gnucash-user@gnucash.org Sent: Sun, May 7, 2023 1:28 am Subject: Re: [GNC] Auto commit with auto save? I agree that it would be nice to have some visual cue that a transaction has been edited but not saved; that would be useful. I'm honestly not sure why that hasn't been implemented. The app does throw a dialog onscreen when a user tries to save with an open transaction. Unfortunately, the message is generic, and a user is forced to look through the open tabs and try to figure out which register holds this transaction. Others have commented on this in the past. If I recall correctly, you were having trouble because you have a cron job set up to retrieve quotes at a specified time each day, and this job causes the file to close dirty if there is an open transaction. The problem in this case, is that this cron job doesn't have necessary fault testing and tolerance. I'd suggest working on ensuring that this cron job was properly set up to handle your specific situation. David T. On May 6, 2023, at 9:02 PM, "David G. Pickett via gnucash-user" wrote: "Don't do that!" does not prevent data loss from human error, which for this app behavior is too easy to create and not realize. If the commit was automatic every time you modified a transaction when the new state was valid, then I would not leave the tab in an uncommitted state, but that is not how it was devised. I leave because it looks fine. There is no indication of an uncommitted transaction I can see. In terms of human factors, one might go to another tab for information to complete a transaction, so we do not want to prevent the user leaving a tab with an uncommitted, possibly invalid transaction. Maybe we should color the tab red while in this state? Or pop up a dialog if it persists a bit too long, or if auto save fires on its timer? But the user may have left, trusting in auto save, so I suggest an auto commit if valid on auto save. 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] Yahoo JSON - throwing unauthorized error
PS: I give up on Yahoo! Switching all my securities to Alphadvantage was tiresome, as the gui was no responsive to the keyboard, but I found the source could be found using page up. Some display at the security editor main screen or somewhere would help to see which is running quotes where, how many currently owned. I have many stocks not currently owned, and so they should not be quoted. I got more info out of an strace. Having the security editor sort each list might be much nicer, too. Ditto for the portfolio report. Most reports in this world sort left to right, for some silly reason. Now it is so slow, and while some work, it locks up on some security. Maybe it needs a timeout error? I resolves the host name over and over. Eventually only perl is running, and then nothing. It takes a long time just to get to "Found Finance::Quote version 1.5301." I ran an strace on the batch quotes, found a few stocks still on Yahoo by accident (but yahoo was at least not hanging), reran, still running, showing occasional activity, but really slow, so slow I was sure it was dead, but no! I can send the strace if it would help! The yahoo when working ran all my stocks in a few seconds. OK for midnight crontab but for the get quotes button is too slow. dgp@dgp-p6803w:~$ time trussx flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash 2>tmp/quote.trFound Finance::Quote version 1.5301. real 6m3.619suser 0m5.033ssys 0m12.509sdgp@dgp-p6803w:~$ time flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucashFound Finance::Quote version 1.5301. real 5m15.338suser 0m0.056ssys 0m0.025sdgp@dgp-p6803w:~$ I can send the strace, or make an strace, optionally with usec time stamps, if desired. POGSX did not have a 5/5 quote, only 5/4 for some reason! -Original Message- From: David G. Pickett To: gnucash-user@gnucash.org Sent: Sat, May 6, 2023 1:51 pm Subject: Re: [GNC] Yahoo JSON - throwing unauthorized error Yeah, it's back. - Is Yahoo aware of their server rejects? - Is there some magic cookie or such we need to be authorized? Many previous fixes proposed, which did not seem to prevent its return! ___ 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] Auto commit with auto save?
"Don't do that!" does not prevent data loss from human error, which for this app behavior is too easy to create and not realize. If the commit was automatic every time you modified a transaction when the new state was valid, then I would not leave the tab in an uncommitted state, but that is not how it was devised. I leave because it looks fine. There is no indication of an uncommitted transaction I can see. In terms of human factors, one might go to another tab for information to complete a transaction, so we do not want to prevent the user leaving a tab with an uncommitted, possibly invalid transaction. Maybe we should color the tab red while in this state? Or pop up a dialog if it persists a bit too long, or if auto save fires on its timer? But the user may have left, trusting in auto save, so I suggest an auto commit if valid on auto save. ___ 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] Yahoo JSON - throwing unauthorized error
Yeah, it's back. - Is Yahoo aware of their server rejects? - Is there some magic cookie or such we need to be authorized? Many previous fixes proposed, which did not seem to prevent its return! ___ 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] Auto commit with auto save?
I often accidentally leave a transaction complete but with the cursor of that sheet still on the same line, so despite an aggressive auto save setting, such a transaction is not committed to the saved image. Of course, if it is not in valid form, it cannot be committed! But if the host goes down or gnucash terminates for any reason not a stable interactive exit, despite the auto save, the entire transaction or any change is lost. I would like an option to auto-commit such transactions, if valid, before the timed auto save. For me, this creates loss of input when I run my nightly cron job for quotes, where I kill any running gnucash and remove any lock to allow the quote additions. (A side thought would to have the quote fetch built into the interactive gnucash such that it has a way to get quotes without being killed. Maybe a gnucash service daemon that could negotiate the updates with any running interactive gnucash or do the updates if no interactive gnucash is running? That in turn suggests a gnucash with a service and multiple interactive sessions so changes in any interactive session could be notified to other interactive sessions, supporting both quotes from a crontab scheduled service internal or external, and multiple interactive users to support larger enterprises.) ___ 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] Changes to transaction entry, and quirks
I miss the old entry of transaction account, as it had fewer keystrokes/clicks to get the average desired entry. I have it set to the leaf value mode, which itself is a mixed deal since sometimes I am not sure what the full path is, but it fits better (takes less column width). ___ 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] Command line quotes still not fixed
Stopped working again just that quick: 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. ** (process:164114): WARNING **: 00:01:07.654: Failed to connect to bus: Could not connect: Connection refused* 00:01:07 ERROR [cleanup_and_exit_with_failure()] File is locked, won't open. Is there some new lock besides the .LCK file ? -Original Message- From: Bruce Schuck To: David G. Pickett ; gnucash-user@gnucash.org Cc: rlo...@gmail.com ; geert.gnuc...@kobaltwit.be ; m.muruganan...@hotmail.com ; hell...@gmail.com Sent: Tue, Apr 11, 2023 10:21 pm Subject: Re: [GNC] Command line quotes still not fixed On 4/11/23 6:51 PM, David G. Pickett wrote: > Maybe patch the code to load a junk string in there > "Enter_your_key_here" and suppress the warning? I have been thinking about that. I haven't tested if bogus API keys are subject to the same limitations as the free keys, but I think it would lead to other issues when it works for some people earlier in the day, but after the 500 per day limit is reached then getting quotes or exchange rates fail. And that would be for other people, or those who it worked for earlier in the day. On top of that, we humans can be quite lazy. If someone notices their AlphaVantage stock quotes or exchange rates work, they may not bother with getting their own real free API key. Still, setting the dummy key if none is supplied may make it into F::Q v1.55 (may be pushed to CPAN next month). - Bruce S. ___ 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] Command line quotes still not fixed
Maybe patch the code to load a junk string in there "Enter_your_key_here" and suppress the warning? -Original Message- From: Bruce Schuck To: gnucash-user@gnucash.org Cc: rlo...@gmail.com; geert.gnuc...@kobaltwit.be; m.muruganan...@hotmail.com; hell...@gmail.com; dgpick...@aol.com Sent: Mon, Apr 10, 2023 12:01 pm Subject: Re: [GNC] Command line quotes still not fixed On 10 Apr 2023 09:22:04 -0500R Losey wrote: > You could always get a key (they are free) and have it set. Sh, don't tell anyone but I stumbled on a bug with the authentication of the AlphaVantage API Key. Make one up! Using "NOTAREALAPIKEY" as the key, I found that lookups work. I hit on this when testing updates to the AlphaVantage.pm module to see what is returned for invalid as well as blank/unset key. curl 'https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=NXPI&interval=5min&apikey=NOTAREALAPIKEY' I sent AlphaVantage an email about this last year and never got a response, nor did the issue get fixed. In related news, I am just about finished testing a new currency module for Finance::Quote that gets the data from Yahoo. No API key needed. Along with this I am thinking about using an environment variable (FQ_CURRENCY) to allow users to choose their preferred currency exchange API. If not set a default will be used, currently AlphaVantage, but that may change to YahooJSON so users will not have to worry about setting both it and an AV API key. Feel free to discuss this at https://github.com/finance-quote/finance-quote/discussions/239. - Bruce S. ___ 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] Command line quotes still not fixed
As it should never have occurred, and should not be a warning, it is a (low priority) bug report, not an enhancement. Assume everything is good but validate inputs before using, leads to simpler, cleaner code. The code should complain about the key when it has occasion to use it, not as a warning, but as an error. If it has occasion to use it 30 times, 30 errors until the user configures it correctly. -Original Message- From: Geert Janssens To: m.muruganan...@hotmail.com ; hell...@gmail.com ; gnucash-user@gnucash.org Cc: David G. Pickett Sent: Sun, Apr 9, 2023 5:31 am Subject: Re: [GNC] Command line quotes still not fixed What you get is not an error but a warning. In your case it's superfluous because as you say you don't have currency rate quotes. So it adds some noise for you but should otherwise work (barring the other bugs we're fixing in the online quote retrieval area). However for users that would have currency quotes but omitted to set an AlphaVantage key, not getting the warning would leave them puzzled. I agree it's currently a bit of an all-or-nothing approach but that can be refined eventually. A good improvement would be to check whether currency quotes are requested and only then emit a warning for a missing AlphaVantage API key. That would be an enhancement request for you to file though. Regards, Geert Op zondag 9 april 2023 01:50:55 CEST schreef David G. Pickett via gnucash-user:> I have no currency rate quotes, just US stocks in US dollars.> > > -Original Message-> From: Murugan Muruganandam > To: hell...@gmail.com ; David G. Pickett> Cc: gnucash-user@gnucash.org > Sent: Thu, Apr 6, 2023 5:08 pm> Subject: Re: [GNC] Command line quotes still not fixed> > #yiv0949692185 P {margin-top:0;margin-bottom:0;}Alphavantage is required for> currency rates> > > Saludos Cordiales> Murugan> From: gnucash-user> on behalf of> David G. Pickett via gnucash-user Sent:> Thursday, April 6, 2023 4:41 PM> To: hell...@gmail.com > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Command line quotes still not fixed As I do not use> Alphavantage, just 'Yahoo as json', why is it looking for an api key?> > > -Original Message-> From: David H > To: David G. Pickett > Cc: geert.gnuc...@kobaltwit.be ;> gnucash-user@gnucash.org ; jra...@ceridwen.us> Sent: Thu, Apr 6, 2023 4:21 pm> Subject: Re: [GNC] Command line quotes still not fixed> > I don't think the version difference is a mystery - remember that Flatpak is> a sandbox so presumably brings along whatever perl version it was> built/packaged with. If you set your Alphavantage api key in the Gnucash> application itself you'll probably also also get rid of the other error> message. The following is all I get displayed using Geert's command format:> flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get --> '/home/h/Documents/GnuCash/Data Files/h.gnucash' Found Finance::Quote> version 1.5301.> > Cheers David H.> > On Fri, 7 Apr 2023 at 05:08, David G. Pickett wrote:> > I don't understand why, but "--" does also work, like "--namespace='.*'".> > I still get a lot of errors that do not affect my quote fetch.> It finds 1.5301 even though I installed 1.5401, a different mystery!> > dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash> --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:17 WARN> [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage> API key set, currency quotes and other AlphaVantage based quotes won't> work.Found Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ flatpak run> --command=gnucash-cli org.gnucash.GnuCash --quotes get --namespace='.*'> /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:57 WARN> [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage> API key set, currency quotes and other AlphaVantage based quotes won't> work.Found Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ -Original> Message-> From: Geert Janssens > To: David H ; gnucash-user@gnucash.org> Cc: David G. Pickett ; john> Sent: Thu, Apr 6, 2023 3:47 am> Subject: Re: [GNC] Command line quotes still not fixed> > Actually instead of adding a --namespace parameter, you can just use '--' to> separate the named parameters from the positional parameters like> so:flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get --> /home/dgp/GnuCash/ubuntu-DGPickett.gnucash That's a common unix way to> solve such ambiquities.> Regards,> Geert> Op donderdag 6 april 2023 05:04:02 CEST schreef john:> The namespace> parameter is a regular expression, so .* will get the
Re: [GNC] Command line quotes still not fixed
I have no currency rate quotes, just US stocks in US dollars. -Original Message- From: Murugan Muruganandam To: hell...@gmail.com ; David G. Pickett Cc: gnucash-user@gnucash.org Sent: Thu, Apr 6, 2023 5:08 pm Subject: Re: [GNC] Command line quotes still not fixed #yiv0949692185 P {margin-top:0;margin-bottom:0;}Alphavantage is required for currency rates Saludos Cordiales Murugan From: gnucash-user on behalf of David G. Pickett via gnucash-user Sent: Thursday, April 6, 2023 4:41 PM To: hell...@gmail.com Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Command line quotes still not fixed As I do not use Alphavantage, just 'Yahoo as json', why is it looking for an api key? -Original Message- From: David H To: David G. Pickett Cc: geert.gnuc...@kobaltwit.be ; gnucash-user@gnucash.org ; jra...@ceridwen.us Sent: Thu, Apr 6, 2023 4:21 pm Subject: Re: [GNC] Command line quotes still not fixed I don't think the version difference is a mystery - remember that Flatpak is a sandbox so presumably brings along whatever perl version it was built/packaged with. If you set your Alphavantage api key in the Gnucash application itself you'll probably also also get rid of the other error message. The following is all I get displayed using Geert's command format: flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- '/home/h/Documents/GnuCash/Data Files/h.gnucash' Found Finance::Quote version 1.5301. Cheers David H. On Fri, 7 Apr 2023 at 05:08, David G. Pickett wrote: I don't understand why, but "--" does also work, like "--namespace='.*'". I still get a lot of errors that do not affect my quote fetch. It finds 1.5301 even though I installed 1.5401, a different mystery! dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:17 WARN [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, currency quotes and other AlphaVantage based quotes won't work.Found Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get --namespace='.*' /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:57 WARN [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, currency quotes and other AlphaVantage based quotes won't work.Found Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ -Original Message- From: Geert Janssens To: David H ; gnucash-user@gnucash.org Cc: David G. Pickett ; john Sent: Thu, Apr 6, 2023 3:47 am Subject: Re: [GNC] Command line quotes still not fixed Actually instead of adding a --namespace parameter, you can just use '--' to separate the named parameters from the positional parameters like so:flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash That's a common unix way to solve such ambiquities. Regards, Geert Op donderdag 6 april 2023 05:04:02 CEST schreef john:> The namespace parameter is a regular expression, so .* will get the quotes> from all of your namespaces.> > Regards,> John Ralls> > > On Apr 5, 2023, at 3:46 PM, David H wrote:> > > > What default namespace, look in YOUR security editor - as far as> > I know it's whatever you set up. I have a vague recollection that it> > doesn't really care and will be happy with just a single character> > i.e. --namespace=x> > but don't quote me on that.> > > > By the way your original email could do with some halfway decent> > formatting> > - see what the mailing list received at> >https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106230.html> > you> > might like to tweak that to make it readable in future.> > > > Cheers David H.> > > > On Thu, 6 Apr 2023 at 07:46, David G. Pickett wrote:> >> I saw that later. What's the default namespace?> >> > >> > >> -Original Message-> >> From: David H > >> To: David G. Pickett > >> Cc: gnucash-user@gnucash.org > >> Sent: Wed, Apr 5, 2023 3:45 pm> >> Subject: Re: [GNC] Command line quotes still not fixed> >> > >> And you'll see there's a whole other thread on this -> >>https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html.> >> Bug report athttps://bugs.gnucash.org/show_bug.cgi?id=798815> >> > >> If you include a namespace parameter for now it will work.> >> > >> Cheers David H.> >> > >> On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user <> >> gnucash-user@gnucash.org> wrote:> >> > >> I can still
Re: [GNC] Command line quotes still not fixed
As I do not use Alphavantage, just 'Yahoo as json', why is it looking for an api key? -Original Message- From: David H To: David G. Pickett Cc: geert.gnuc...@kobaltwit.be ; gnucash-user@gnucash.org ; jra...@ceridwen.us Sent: Thu, Apr 6, 2023 4:21 pm Subject: Re: [GNC] Command line quotes still not fixed I don't think the version difference is a mystery - remember that Flatpak is a sandbox so presumably brings along whatever perl version it was built/packaged with. If you set your Alphavantage api key in the Gnucash application itself you'll probably also also get rid of the other error message. The following is all I get displayed using Geert's command format: flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- '/home/h/Documents/GnuCash/Data Files/h.gnucash' Found Finance::Quote version 1.5301. Cheers David H. On Fri, 7 Apr 2023 at 05:08, David G. Pickett wrote: I don't understand why, but "--" does also work, like "--namespace='.*'". I still get a lot of errors that do not affect my quote fetch. It finds 1.5301 even though I installed 1.5401, a different mystery! dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:17 WARN [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, currency quotes and other AlphaVantage based quotes won't work.Found Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get --namespace='.*' /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:57 WARN [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, currency quotes and other AlphaVantage based quotes won't work.Found Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ -Original Message- From: Geert Janssens To: David H ; gnucash-user@gnucash.org Cc: David G. Pickett ; john Sent: Thu, Apr 6, 2023 3:47 am Subject: Re: [GNC] Command line quotes still not fixed Actually instead of adding a --namespace parameter, you can just use '--' to separate the named parameters from the positional parameters like so:flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash That's a common unix way to solve such ambiquities. Regards, Geert Op donderdag 6 april 2023 05:04:02 CEST schreef john:> The namespace parameter is a regular expression, so .* will get the quotes> from all of your namespaces.> > Regards,> John Ralls> > > On Apr 5, 2023, at 3:46 PM, David H wrote:> > > > What default namespace, look in YOUR security editor - as far as> > I know it's whatever you set up. I have a vague recollection that it> > doesn't really care and will be happy with just a single character> > i.e. --namespace=x> > but don't quote me on that.> > > > By the way your original email could do with some halfway decent> > formatting> > - see what the mailing list received at> > https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106230.html> > you> > might like to tweak that to make it readable in future.> > > > Cheers David H.> > > > On Thu, 6 Apr 2023 at 07:46, David G. Pickett wrote:> >> I saw that later. What's the default namespace?> >> > >> > >> -Original Message-> >> From: David H > >> To: David G. Pickett > >> Cc: gnucash-user@gnucash.org > >> Sent: Wed, Apr 5, 2023 3:45 pm> >> Subject: Re: [GNC] Command line quotes still not fixed> >> > >> And you'll see there's a whole other thread on this -> >> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html.> >> Bug report at https://bugs.gnucash.org/show_bug.cgi?id=798815> >> > >> If you include a namespace parameter for now it will work.> >> > >> Cheers David H.> >> > >> On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user <> >> gnucash-user@gnucash.org> wrote:> >> > >> I can still only update quotes with the interactive button, the flatpak> >> run gnucash command that ran in 4.* is still broken:> >> dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash> >> --quotes get /home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing 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>
Re: [GNC] Command line quotes still not fixed
I don't understand why, but "--" does also work, like "--namespace='.*'". I still get a lot of errors that do not affect my quote fetch. It finds 1.5301 even though I installed 1.5401, a different mystery! dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:17 WARN [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, currency quotes and other AlphaVantage based quotes won't work.Found Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get --namespace='.*' /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:57 WARN [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage API key set, currency quotes and other AlphaVantage based quotes won't work.Found Finance::Quote version 1.5301.dgp@dgp-p6803w:~$ -Original Message- From: Geert Janssens To: David H ; gnucash-user@gnucash.org Cc: David G. Pickett ; john Sent: Thu, Apr 6, 2023 3:47 am Subject: Re: [GNC] Command line quotes still not fixed Actually instead of adding a --namespace parameter, you can just use '--' to separate the named parameters from the positional parameters like so:flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash That's a common unix way to solve such ambiquities. Regards, Geert Op donderdag 6 april 2023 05:04:02 CEST schreef john:> The namespace parameter is a regular expression, so .* will get the quotes> from all of your namespaces.> > Regards,> John Ralls> > > On Apr 5, 2023, at 3:46 PM, David H wrote:> > > > What default namespace, look in YOUR security editor - as far as> > I know it's whatever you set up. I have a vague recollection that it> > doesn't really care and will be happy with just a single character> > i.e. --namespace=x> > but don't quote me on that.> > > > By the way your original email could do with some halfway decent> > formatting> > - see what the mailing list received at> > https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106230.html> > you> > might like to tweak that to make it readable in future.> > > > Cheers David H.> > > > On Thu, 6 Apr 2023 at 07:46, David G. Pickett wrote:> >> I saw that later. What's the default namespace?> >> > >> > >> -Original Message-> >> From: David H > >> To: David G. Pickett > >> Cc: gnucash-user@gnucash.org > >> Sent: Wed, Apr 5, 2023 3:45 pm> >> Subject: Re: [GNC] Command line quotes still not fixed> >> > >> And you'll see there's a whole other thread on this -> >> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html.> >> Bug report at https://bugs.gnucash.org/show_bug.cgi?id=798815> >> > >> If you include a namespace parameter for now it will work.> >> > >> Cheers David H.> >> > >> On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user <> >> gnucash-user@gnucash.org> wrote:> >> > >> I can still only update quotes with the interactive button, the flatpak> >> run gnucash command that ran in 4.* is still broken:> >> dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash> >> --quotes get /home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing 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 ]
Re: [GNC] Command line quotes still not fixed
Thanks! So someone erased a ' = ".*" ' from a char * / std::string variable definition, so sad! I am sure the bug fix will be out soon if not already. Does GnuCash have a test suite to verify it still works in prior behaviors? Do bug repairs update the test suite to detect the bug before they fix it? There's a term for that, code to test or something such! Another email chain on grep is full of bugs introduced into various implementations of regex and grep, so they might not have learned/adopted that paradigm. I supposed it was invented by Hippocrates: "First, do no harm!"? :D -Original Message- From: john To: David H Cc: David G. Pickett ; gnucash-user@gnucash.org Sent: Wed, Apr 5, 2023 11:04 pm Subject: Re: [GNC] Command line quotes still not fixed The namespace parameter is a regular expression, so .* will get the quotes from all of your namespaces. Regards, John Ralls > On Apr 5, 2023, at 3:46 PM, David H wrote: > > What default namespace, look in YOUR security editor - as far as > I know it's whatever you set up. I have a vague recollection that it > doesn't really care and will be happy with just a single character > i.e. --namespace=x > but don't quote me on that. > > By the way your original email could do with some halfway decent formatting > - see what the mailing list received at > https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106230.html you > might like to tweak that to make it readable in future. > > Cheers David H. > > On Thu, 6 Apr 2023 at 07:46, David G. Pickett wrote: > >> I saw that later. What's the default namespace? >> >> >> -Original Message- >> From: David H >> To: David G. Pickett >> Cc: gnucash-user@gnucash.org >> Sent: Wed, Apr 5, 2023 3:45 pm >> Subject: Re: [GNC] Command line quotes still not fixed >> >> And you'll see there's a whole other thread on this - >> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html. >> Bug report at https://bugs.gnucash.org/show_bug.cgi?id=798815 >> >> If you include a namespace parameter for now it will work. >> >> Cheers David H. >> >> On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user < >> gnucash-user@gnucash.org> wrote: >> >> I can still only update quotes with the interactive button, the flatpak >> run gnucash command that ran in 4.* is still broken: >> dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash >> --quotes get /home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing 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 n