Re: [GNC] Finance-Quote 1.62 released!
On Thu May 16 22:22:53 EDT 2024, Adrien Monteleone wrote: Coding can be fun in many cases, but you seem to find solace in the mindbogglingly headache-inducing game of whack-a-mole, to everyone else's benefit! heh-heh. Sometimes it does seem like playing whack-a-mole. Thank you for the insane amount of effort you put forth on this project. Thanks, but most of the time I'm just a traffic cop / gatekeeper of the work done by others. This release for example, Kalpesh Patel worked on the fixes for YahooJSON, and created the new currency rate module CurrencyFreaks. Paolo Maero wrote the new BorsaItaliana module. I have yet to use (or profit) from all of it, but even in my limited exposure, I know that if I ran into a snag, many folks would be there to guide me along, and not just 'because', but because *you* make the effort to keep F::Q humming along. Without this project, many folks would be in quite the 'inedible' pickle. I've really only been involved in F::Q for about 4 years. Started out giving Erik C a hand, and sort of inherited it when he stepped away for personal reasons. There have been times I wish he would come back, but emails such as yours' are appreciated. 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-Quote 1.62 released!
Bruce, et al, Coding can be fun in many cases, but you seem to find solace in the mindbogglingly headache-inducing game of whack-a-mole, to everyone else's benefit! Thank you for the insane amount of effort you put forth on this project. I have yet to use (or profit) from all of it, but even in my limited exposure, I know that if I ran into a snag, many folks would be there to guide me along, and not just 'because', but because *you* make the effort to keep F::Q humming along. Without this project, many folks would be in quite the 'inedible' pickle. Cheers, Adrien On 5/16/24 8:19 PM, Bruce Schuck wrote: New version 1.62 of Finance-Quote is available with the following changes: * Fixed AEX.pm * Removed throttling from AlphaVantage.pm - Issue #363 * Added CurrencyFreaks.pm - new currency module * YahooJSON.pm - added more error handling - Issue #390 * Fixed MarketWatch.pm module - Issue #389 * Fool.pm - Rewrote Fool.pm and added back to F::Q. Issue #379. * New Module! StockData.pm. Methods stockdata, nyse, nasdaq. * Modified yahooJSON.pm module in order handle EU consent redirects better. * TwelveData.pm - Added "last" to data being returned * BorsaItaliana.pm - New module for Borsa Italiana, Italian traded bonds using ISIN * YahooWeb.pm - Issue #377. Modified YahooWeb to account for changes from Yahoo. Authors: - Erik Colson - Paul Fenwick - Bruce Schuck - Vincent Lucarelli - David Hampton - jvolkening - Pawel Konieczny - Mike Alexander - AndreJ - Vinay S Shastry - Bradley Dean - Brent Neal - Jacinta Richardson - e-dorigatti - goodvibes2 - Paul Howarth - Sam Morris - Linas Vepstas - Hiranya Samarasekera - Manuel Friedli - Achim Winkler - Diego Marcolungo - John Haiducek - Rajan Vaswani <111571283+bgr22...@users.noreply.github.com> - alex314159 - gregor herrmann - Jalon Avens - Sigve Indregard - bgr22112 <111571283+bgr22...@users.noreply.github.com> - goodvibes2 - Ben Hemming - Caleb Begly - CleanShed <72849657+cleans...@users.noreply.github.com> - Eelco Dolstra - Emmanuel Di Pretoro - Florian Schlichting - Gabor Szabo - GitGord <46006740+gitg...@users.noreply.github.com> - Gustavo R. Montesino - Henrik Ahlgren - Jean-Marie Pacquet - Joseph Heron - Lance Wicks - Liviu Tinta - Martin Kompf - Pete Ratzlaff - Ross Peachey - Stephan Ebelt - Stephan Gambke - linas - thinus - x42x64 ___ 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] Finance-Quote 1.62 released!
New version 1.62 of Finance-Quote is available with the following changes: * Fixed AEX.pm * Removed throttling from AlphaVantage.pm - Issue #363 * Added CurrencyFreaks.pm - new currency module * YahooJSON.pm - added more error handling - Issue #390 * Fixed MarketWatch.pm module - Issue #389 * Fool.pm - Rewrote Fool.pm and added back to F::Q. Issue #379. * New Module! StockData.pm. Methods stockdata, nyse, nasdaq. * Modified yahooJSON.pm module in order handle EU consent redirects better. * TwelveData.pm - Added "last" to data being returned * BorsaItaliana.pm - New module for Borsa Italiana, Italian traded bonds using ISIN * YahooWeb.pm - Issue #377. Modified YahooWeb to account for changes from Yahoo. Authors: - Erik Colson - Paul Fenwick - Bruce Schuck - Vincent Lucarelli - David Hampton - jvolkening - Pawel Konieczny - Mike Alexander - AndreJ - Vinay S Shastry - Bradley Dean - Brent Neal - Jacinta Richardson - e-dorigatti - goodvibes2 - Paul Howarth - Sam Morris - Linas Vepstas - Hiranya Samarasekera - Manuel Friedli - Achim Winkler - Diego Marcolungo - John Haiducek - Rajan Vaswani <111571283+bgr22...@users.noreply.github.com> - alex314159 - gregor herrmann - Jalon Avens - Sigve Indregard - bgr22112 <111571283+bgr22...@users.noreply.github.com> - goodvibes2 - Ben Hemming - Caleb Begly - CleanShed <72849657+cleans...@users.noreply.github.com> - Eelco Dolstra - Emmanuel Di Pretoro - Florian Schlichting - Gabor Szabo - GitGord <46006740+gitg...@users.noreply.github.com> - Gustavo R. Montesino - Henrik Ahlgren - Jean-Marie Pacquet - Joseph Heron - Lance Wicks - Liviu Tinta - Martin Kompf - Pete Ratzlaff - Ross Peachey - Stephan Ebelt - Stephan Gambke - linas - thinus - x42x64 ___ 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
On 5/16/2024 2:17 PM, David G. Pickett via gnucash-user wrote: 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! Gnucash can work with multiple SEQUENTIAL users (one at a time) Gnucash cannot work with multiple CONCURRENT users (more than one at a time). That requires running under the control of a DBM. This issue is really beyond almost all end users. The issues involved with concurrent processing, and the various solutions that can be employed, would usually be learned at the upper levels of Computer Science program. Look for a course with a name like "concurrent processing". Michael D Novack ___ 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] Use of cash discounts in business account tree
I am no accountant, but that doesn't sound quite correct. If you put the Cash Discounts account under Expenses, then that would be a contra-account as it reduces the price of your expenses you pay the wholesaler. So that credit is correct, but I don't see that there should be a debit to your checking account. It isn't like you received funds in return, you just paid less out. So that might look like: Dr. Expenses:something 100 Cr. Expenses:Cash Discounts Received10 Cr. Assets:Checking 90 On the other side, when you are the seller and offer a cash discount, that too could be an expense (but this time not contra-balanced) however, it might be best *not* to use the same account as above due to the potential need to track the discounts you offer being muddled with the discounts you receive. As well, there shouldn't be an equal debit to Checking here, but rather less money received like so: Dr. Assets:Checking 90 Dr. Expenses:Cash Discounts Offered 10 Cr. Income:Sales 100 Some texts and accountants might counsel that this Cash Discount account should instead be a sub contra-account of Income:Sales as it is really a reduction of Sales, rather than an expense, but that would depend on your needs, situation, and legal requirements. *notice - none of the above is specific to GnuCash, thus, this is an 'accounting question', not 'how do I do this in GnuCash' question. We're happy to offer *ideas* here on such questions, but *NONE* of those ideas are *advice*. Regards, Adrien On 5/15/24 5:25 PM, nisp1953 wrote: WHen I get a discount from a wholesaler, then there is a credit to Cash discounts, which is an expense. There is also a corresponding debit to my checking account. When I issue a site wide discount there is a debit to the cash discount but a credit to the checking account. Am I doing that correctly? ___ 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.