Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11
FWIW - Revo Uninstaller has worked well for me. nvsoar On 09/12/22 13:20, David Carlson wrote: Also, in your thread started last May you mentioned an adventure with release 4.0 and 4.10, after which you may not have had a clean uninstall. Have you tried using either the Windows uninstaller or a third party uninstaller? I wish I could remember the name of the third party uninstaller that used to work very well, at least several years ago. On Mon, Sep 12, 2022 at 3:03 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Richard (Clarkson), You mentioned in the other thread that you also tried from PowerShell. Is there no output there when it fails to completely open? Have you tried to view the Windows Logs to see if any warnings or errors were reported about the time you tried to start GnuCash? Of course, if you can get a Trace File (see the wiki) and/or stack trace that might help too. And to confirm - you downloaded GnuCash *from* the links on gnucash.org, and not somewhere else? (which take you to the GnuCash SourceForge project page) Regards, Adrien On 9/10/22 6:03 PM, Richard Clarkson via gnucash-user wrote: Yes I use the windows installer and I have tried letting the installer delete the previous version and have also tried deleting the previous version myself. From: David Carlson Sent: 10 September 2022 17:33 To: Gyle McCollam Cc: Richard Clarkson ; Gnucash Users < gnucash-user@gnucash.org> Subject: Re: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11 Are you using the windows installer as downloaded from the Gnucash.org website for each gnucash version? Do you let the installer delete the existing version or do you use another method? ___ 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] Stock Split - am I doing this right?
On 07/30/22 16:10, replicon wrote: I'm trying to capture the AMZN stock split that took place a while back. I was surprised by the UI, since instead of "enter split ratio" or something like that, it wants me to manually calculate additional stock. Is the correct way to do it: - Multiply stock holdings by 19, and add that as additional stock (since it's 20-to-1) - Set the "new price" to the value it had when the split occurred My concern is, since stock purchases we track in GNUCash include the basis, doesn't the stock split tool cause it to lose track of cost basis? I imagine the correct way to track things like capital gains is that any transaction where stock was received at a certain price should be supplanted with a new transaction for 20x that much stock, at 1/20 of the value at time of receipt. Is that not correct? Or is that actually happening under the hood without my noticing? Thanks! FWIW - costbasis.com has assisted me in getting numerous stock transaction calculations correctly. No charge, donations accepted. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Clearing due invoice reminder
On 10/19/21 14:07, Rich Shepard wrote: On Tue, 19 Oct 2021, Geert Janssens wrote: The way to fix it is described here: https://wiki.gnucash.org/wiki/ Business_Features_Issues#Unposting_and_reposting_a_paid_invoice_loses_its_payment Geert, That URL displayed an empty page. The suggestion on it to search for the topic on another page also returned an empty page. Ah, well. Thanks, Rich __ FWIW - use the entire link https://wiki.gnucash.org/wiki/Business_Features_Issues#Unposting_and_reposting_a_paid_invoice_loses_its_payment regards,, nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
On 06/03/21 11:14, Michael or Penny Novack wrote: The only problem I have is that it is far too easy (IMO, IME!) to accidentally create or use Orphan-* and Imbalance-* accounts just by hitting the tab key one time too many. I'd prefer to be able to set an option to disable that and to force me to balance the transaction before leaving it. You mean by (on the fly) creating an account with a name like "Imbalance" (or "Not-yet-assigned") to serve as a placeholder for when you don't know where it should go? That anything in there means an issue yet to be addressed? Gee, gnucash comes with that built in. I know if the ONLY books you are keeping under gnucash are informal personal books, you might think it easy to just "create an account" on the fly. But some of us are keeping more formal books and might need to consult with somebody before making that decision. Sometimes it was as simple as getting an answer to "what was that item?" in a packet of receipts submitted for reimbursements. Maybe need to get the accountant involved, maybe the board of directors, or the owner(s) of a business. Note that "Imbalance"isn't the only sort of special account used to hold amounts until resolved. Many. if not most businesses have a "Suspense" account used when a payment comes in without necessary information to determine "what for". Then somebody's job to resolve everything in suspense. Businesses that do not ordinarily handle cash (and so not making daily bank deposits) might have an "undeposited cash" account to deal with rare cash situations. Michael D Novack Roger that. I use a 'Pending Exchange' account when I haven't yet figured out the situation at hand. Many thanks and blessings to all who contribute to the health of GnuCash. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] entry point error after recent automatic windows 10 update
On 02/28/21 09:23, John Ralls wrote: On Feb 25, 2021, at 2:46 PM, pholck wrote: DIrectly following latest automatic update of Windows 10, I have the exact same error pop up (I am using gnucash 4.4). Fortunately in my case, after I click "OK" to the "Entry Point Not Found" error, and then reclick about 10 times, GnuCash starts up for me (apparently despite the missing libgncmod-app-utils.dll). I have not give a full test that it is running properly, but so far no issues. If anyone has any fixes for this issue (as I am concerned that at some point multiple clicking of the OK button will cease to work for me) do let me know! At any rate, given Laurel's issues, I think it's pretty certain this error is a result of something updating Windows 10 causes... libgncmod-app-utils.dll was renamed to libgnc-app-utils.dll in GnuCash 4.x so if something is trying to link it it's a leftover from GnuCash 3.x or earlier. It seems unlikely that Windows updates would have anything to do with it. As Geert mentioned back in November, the uninstaller doesn't always get everything. That may be because its manifest is incomplete or because the file in question is left over from a previous installation whose uninstaller has been removed. I just checked the registry and user directory on my Windows VM for mentions of libgnc-app-utils or libgncmod-app-utils and found nothing, so I think that both you and Ms. Hargis must have artifacts from previous installations on your system. Please try the following: Uninstall GnuCash using Apps and Features (right-click on the start icon, it's the first item in the menu). Open Windows File Explorer and navigate to Local Disk (C:) > Program Files (x86). Delete the gnucash directory if there is one. If you have ever installed GnuCash to some other location check that as well and make sure that the gnucash directory is deleted. If you're not sure about that use Windows File Explorers search to search all disks for libgnc*.dll. Delete any that you find. Empty the trash. Install GnuCash 4.4. Regards, John Ralls FWIW - I have found that the free version of Revo Uninstaller does a good job of removing a windows program. In addition, take a look at CCleaner as well for further clean up. My experience with these free versions has been trouble free. That said, there can be no guarantees when things get all twisted up. A choice for finding files on Windows is a free program called Everything. I have no connection to any of these programs. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multi-split multi-currency Transaction Import from CSV
On 11/27/20 07:50, Anton via gnucash-user wrote: Dear community, Is the multi-split multi-currency transactino import from CSV still known to be making errors and thus dangerous to use / not stable yet? Or is it safe to use with the latest GNU version? I found a few threads discussing this issue of the importer, and not sure what the current state is. Please advise. Many thanks, Anton snip - FWIW - Seems to me that two books may be called for given the arbitrary currency transactions. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] entry point error after recent automatic windows 10 update
On 11/26/20 13:57, laurel hargis wrote: Nvsoar: I am using revo. Do I only uninstall the c program x86 exe files? It shows me an entire tree with accounts, invoices , lLots of files snip Provided I have a pair of complete backups stored remotely; particularly of the data; my procedure is to delete everything that the revo uninstaller finds using the 'medium' or 'maximum' procedure. _nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] entry point error after recent automatic windows 10 update
On 11/25/20 19:19, David Cousens wrote: Laurel, Uninstalling and reinstalling the Windows 10 system should be a last resort. *Before you do that, at least make a copy of all the data files in your user directory either on a USB stick or a copy to another computer*. *Don't let a technician reinstall it without doing this first*. Your user files will be stored in C:/Users// where you will need to substitute your actual user name on the computer for the placeholder in the above path. Copy all files in that location onto a USB stick or other medium before attempting a reinstall of Windows. You will then be able to restore your user data files from the USB stick if you do have to do a Windows reinstall and reinstall all programs. That should prevent any loss of data stored in the GNuCash files. GnuCash 4.2 should not be looking for that file in that location which may suggest that the initial install of GC 4.2 has perhaps not completely removed all files from a previous version (which it should do during the install procedure) and that an outdated dll file is being accessed and in turn is looking for a routine in a dll which no longer exists. AFAIK there have been some rewrites of the GnuCash library files recently which could lead to this. You could also try making sure any subsequent Windows updates are installed and that Windows 10 itself is fully up to date. Try manually removing GnuCash using the Control Panel programs tab before reinstalling GnuCash from a fresh download of 4.2. If old files have not been removed properly this may unload them. If that doesn't work I would then try reinstalling the version you had previously and see if it works Doing a manual uninstall of the previous version from the control panel after a reinstall of the old version should then get rid of any previous program files which may have been left in place. Then follow that by reinstalling GC 4.2. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html snip - I support the above approach suggested by David Cousens. FWIW - I use the Revo Uninstaller because I found that the Windows uninstaller still leaves stuff hanging around. As for file finding I use an application called Everything that indexes all windows files - much faster than Windows search. (Links are https://www.revouninstaller.com/ and https://www.voidtools.com/) _nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Make PDF from reports
On 10/20/20 09:02, Adrien Monteleone wrote: If I recall correctly, there is are PDF issues on Windows and Mac. You should be able to Export the report as HTML, open with a modern browser and print to paper or PDF from there. You'll need a PDF virtual printer however. Win10 includes one built-in and you might be able to install it separately on Win7, but if not, look into Bullzip. It is free for personal use. Regards, Adrien On 10/19/20 7:05 PM, Derek Zehr wrote: Hello, I just created my first-ever report in GnuCash, to report some finances with a forum I'm involved with. This is the window I get when I hit Make PDF, and specify a valid file name in my documents folder. GnuCash Version: 4.1 Build ID: 4.1+(2020-07-25) on Windows 7. Derek Zehr Another choice for a pdf printer is foxit reader version 9.7 https://www.filepuma.com/download/foxit_reader_9.7.1.29511-24443/ nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Installing on Windows 10 (with Defender)
On 08/03/20 08:06, GTI .H wrote: Em seg., 3 de ago. de 2020 às 00:41, Peter West escreveu: My brother-in-law in the US (I’m in Oz) tried on my recommendation to install Gnucash 4.1 from the gnucash.org <http://gnucash.org/> site. The install was initially blocked by Defender, but he managed to overcome that. When he tried to run the program, the complaint was about missing .dll files in C:\Program files (x86)\gnucash\bin\ As I don’t know about Windows 10, can someone please tell me the way to perform the install correctly in this case? Thanks. For many years I installed GnuCahs on Windows 10 with defender enabled using the .exe installation file. I've never had any problems. I'm currently running v4.1 well, and it was the first master update that I haven't noticed any problems with so far. *Congratulations DEVs!* -- Regards ___ Sounds to me that there is a fault in the downloaded install file. I suggest re-downloading the .exe file; checkg the hash code for accuracy of the downloaded file; and then installing the new download file. Do not believe the Defender is problem. Windows will ask if you really want to install the GnuCash install file. All the best, nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 also opens Interest Payment box?
FWIW - For me the pop ups are confusing. I delete and hope it works out. A million thanks for a great application. All the best from the Carson Valley, nvsoar On 07/12/20 15:15, jean laroche wrote: The thing is, there's a good chance we won't know if somebody uses the feature and happens to not be on this forum, which is very likely. So out of caution, I would err on the side of keeping it. The code bloat isn't enormous. In my PR I removed a bit of it, and simplified things a bit. I know that as a user, I really dislike when features disappear... (if I happen to use them). I think the onus is on us to justify why it's really bad to keep the feature. Jean P.S. Nobody's suggesting to remove reconciling! I think it was a misunderstanding from the start! On 7/12/2020 3:02 PM, John Ralls wrote: Larry, Thanks for the offer, but I wouldn't want to turn our users into more product for survey monkey. Besides, I'm not looking for votes, I'm looking for reasons why removing the dialogs might be a bad thing. A single person with a persuasive reason would outweigh all of the "don't cares". To your points: A Scheduled Transaction is an even better reminder and quick fill (aka autocomplete) in the register will fill in the last payment account too. What quickfill won't do is pre-populate the credit field with the reconciled balance. Regards, John Ralls On Jul 12, 2020, at 2:11 PM, Larry Long wrote: John, I almost always pay off entire credit card balances, so I rarely ever use the "interest charge" pop-up.However, I do use the "interest earned" pop-up associated with bank accounts. I find it a convenient reminder for me to enter that figure before I begin checking-off transactions in the reconcile window.Similarly, I use (and appreciate) the "payment transaction" pop-up window associated with credit card accounts. The fact that it remembers and prepopulates my usual source account for the payment is also a handy convenience for me. Could I do without these two features? Certainly. Do I find them helpful and time-saving for me? Yes.Compelling reasons? While I find them helpful, I can't say that I have any. If you want a survey of your users, I don't believe that this list is the best method. I would suggest that you set up a free account on Survey Monkey, create your questions there and post a link on this list. It will accumulate the results for you and is much less effort than trying to track responses here. I'd be happy to create one for you based on what you asked below. However, if you wanted to write your own questions, it might be better for you to do it. Meanwhile, a huge "Thank You" to you and the entire team for all the effort that you folks put into the software--and in answering questions on this list! Regards,Larry Long On Sunday, July 12, 2020, John Ralls wrote: > > Frank and I have both opined on https://bugs.gnucash.org/show_bug.cgi?id=797854 that the whole interest payment as part of reconciling is stupid. I want to add to that opinion that so is the payment transfer that optionally pops up when one finishes reconciling a credit card account. It's a lot of program complexity that relieves the user of very little work indeed: Those interest and payment transactions can just as easily--maybe more easily--be created in the register before and after reconciling, and in the case of interest they're an obvious candidate for a scheduled transaction. But that's a UI change and UI changes tend to generate heated disagreement. I want to get that out of the way up front: Who here objects to removing the interest and payment transfer automatic popups and the interest payment button on the reconcile info dialog, and what compelling reason do you have for objecting? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane,
Re: [GNC] Potential regression: PDFs generated using "Make PDF" have a superfluous blank page
On 06/29/20 03:31, Yves-Eric Martin wrote: Hi all, (Full bug report below) I am having a PDF issue trying to upgrade from 3.7 to 4.0, but traced the problem back to 3.8. The invoice PDFs generated using "Make PDF" have a superfluous blank page. I first thought the problem may be with my heavily customized CSS, but I was able to reproduce the issue with the vanilla invoices (Easy / Printable / Fancy). Any idea what introduced this change? Is a fix needed? And short of manually editing the PDFs, is there a workaround to remove that extra blank page on the GnuCash side, maybe editing some SCM files? Thank you. Full bug report: GnuCash versions: tested all stable from 3.5 to 4.0 OS: MacOS Catalina (10.15.5) Problem: Invoice PDFs generated using "Make PDF" have a superfluous blank page. Versions not affected: 3.5, 3.6, 3.7 Versions affected: 3.8, 3.9, 3.10, 3.11, 4.0 Steps to reproduce: 1) Create a dummy invoice with a single line 2) Create an Easy Invoice: Reports > Business > Easy Invoice 3) Select the dummy invoice: Edit > Report Options > General > Invoice Number > Select the dummy invoice 4) Make Pdf Expected behavior: The generated PDF has only 1 page. Current behavior (since 3.8): The generated PDF has a superfluous blank page. Comparison of various invoice PDFs, generated with 3.7 and 3.8: https://www.dropbox.com/sh/h8hwhy43uiz9c8m/AADslcR3uJtfXy5Q7GTn6FqVa?dl=0 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. If having the blank page really bothers you take a look at PDFTK (pdf tool kit) - does a good job manipulating pages of pdf documents. All the best - nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Changing account tree on large database
On 04/26/19 16:18, Tommy Trussell wrote: On Fri, Apr 26, 2019 at 4:53 PM David Carlson wrote: Strongly consider only moving one or two years data to GnuCash. I agree. I found that I could import a lot more, but I found I was going crazy trying to make everything look right, which ultimately seemed pointless for things like long-ago closed bank accounts etc. Since I had been using Quicken since the 1990s I had a number of "historical" transactions I MIGHT conceivably want to look up, so I exported those and kept the (enormous) QIF files. Any time I want to find a transaction I can just do a few searches through the QIF file and find the transaction date and the amount. If I really really want to, I COULD create a "historical" GnuCash book with the imported data and just ignore the odd balances etc. (I'm looking through my data and found that I kept a complete QIF I exported in 2000, and then another one I exported in 2007. I believe 2007 is when I gave up on Quicken for good, so my original GnuCash-only data was based upon 2006 and 2007 transactions only.) snip FWIW - if Quicken will export to a .csv file then I think I would download the entire Quicken file, and then import to GnuCash only those files that I need to refer to, and leave the rest as an archive in the .csv file. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Error While Saving in GnuCash 3.5 on Win7-64
On 04/05/19 13:14, Chris Graves wrote: As a test on Windows 10, I made the following directory hierarchy, tried saving and got the same error. C:\Users\chris\Documents\My Docs\Thorough C & D\GnuCash Files After I renamed "Thorough C & D" to "Thorough C and D", the save worked just fine. On Thu, Apr 4, 2019 at 4:03 PM Greg Feneis wrote: snip For info - See https://docs.microsoft.com/en-us/windows/desktop/fileio/naming-a-file for acceptable characters in Win 10 file names - '&' is a reserved character. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] The Meaning of Split (previously Example of multi-split feature of CSV importer?)
snip FWIW - this old owl looks at every GnuCash transaction as having one source and one or more sinks; and doesn't give a hoot about splits, simple transactions, compound transactions inter alia. Have enjoyed the back and forth. Many thanks to the GnuCash developers, contributors and the members of the list. All the best from the Carson Valley, nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Stock Quotes
On 01/02/19 08:51, Dave Cooper via gnucash-user wrote: Hi gnucash I have returned to gnu-cash having not used it for several years so please bear with me. I have reloaded the system and set it up to get some UK stock prices (LSE) using Alphavantage Unfortunately I get poor results - only 25% - 50% prices are returned - I assume this is caused by time outs As a temporary fix I now use yahoo - json which gets results every time so far, but I have to manually adjust these prices because the return is in pence not pounds Is there a parameter or easy way to fix this? I note that yahoo are having problems due to their historical data for UK is in pounds - not that I am going there. Cheers Dave A solution to AlphaVantage limits is in Ameet Sengar's message; available here. https://lists.gnucash.org/pipermail/gnucash-user/2018-September/079698.html It has been my experience that the AlphaVantage.pm file is read only. Change file properties to read write to modify; then back to read only. (Notepad++ worked well for me on a Win10 system.) nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] *.deb package for GnuCash 3.4 Released
On 01/03/19 00:09, Colin Law wrote: On Wed, 2 Jan 2019 at 23:12, nvsoar wrote: ... Do you think that 'sudo apt -f install' would work to get the libboost packages? No, as Liz said that would only help if the deb said that it needs those packages, in which case dpkg would have complained that they were not installed. They probably cannot be included as "depends" as the deb is aimed principally at 18.04 and the packages may have different names there. Colin Thank you both, nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] *.deb package for GnuCash 3.4 Released
On 01/02/19 13:44, Colin Law wrote: I have installed 3.4 onto another Ubuntu 18.10 and can confirm Tim Kallmer's findings as to the additional packages that need to be installed. I have noticed one other slight complication, that Ubuntu seems to think that the version from the deb (3.4-0-1) is earlier than the version from the repo (1:3.3-2), possibly due to the 1: on the front. The result is that updating the system wants to update gnucash back to 3.3. The solution to that is to mark it as held so that it won't be upgraded. So to install on Ubuntu 18.10 from the deb first download it from Stephen's Drive https://drive.google.com/open?id=172BMIvLgD7twcGEWkR5GcddoZ_A4QWfY to, for example Downloads, then run sudo apt remove gnucash sudo apt autoremove sudo dpkg -i Downloads/gnucash_3.4-0-1_amd64.deb sudo apt install libboost-filesystem1.65.1 libboost-date-time1.65.1 libboost-locale1.65.1 libboost-regex1.65.1 sudo apt-mark hold gnucash and you should be good to go. Thanks again to Stephen Butler for providing this. Colin Do you think that 'sudo apt -f install' would work to get the libboost packages? nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Location of GnuCash data files
FWIW - for Windows systems there is light weight, free, fast file and folder locator called 'Everything'; available at void tools.com. (Quite impressive with respect to windows search.) nvsoar On 12/31/18 13:26, Adrien Monteleone wrote: That’s an easy go-to method for nearly any application. I teach it to my family regularly. It is very useful when they aren’t paying attention to where they just saved something moments ago as most apps default to a standard preference location (like Downloads or Documents) or the last-used location. Regards, Adrien On Dec 31, 2018, at 2:20 PM, David Carlson wrote: The thread GNCupdating advice seems to have answers that could apply to this thread. Adding to both: In the release 2.6.xx family, a simple method to find the last used data file is to start the File > Save as process and see where GnuCash wants to put the new file. Then cancel before actually saving. David C On Mon, Dec 31, 2018 at 1:42 PM Adrien Monteleone wrote: It should probably be filed in Bugzilla, but I think it might already be there. I seem to recall asking this question myself some months ago after a thread about user confusion over these files. I unfortunately can’t find the thread and don’t remember the exact final point, but I do remember one of the devs stated a good reason for why the present situation is what it is, darned if I can remember it though. Maybe one of them will chime in. Regards, Adrien On Dec 31, 2018, at 12:09 PM, David T. via gnucash-user wrote: Been done. https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1470507-configuration-option-for-backup-location On Mon, Dec 31, 2018 at 23:18, Stephen M. Butler wrote: On 12/31/18 9:29 AM, Stan Brown wrote: Under "Uddating advice", I believe Finbar Mahon wrote: On reading it I see that what is missing is how to find where the gnucash file is saved. The problem is that where it is was specified by yourself when you first saved your accounts file. Just as it is if you save a word processor document for example, so the wiki assumes you remember where that is. True enough, and a couple of people have suggested how to find a file. But word processors typically DON'T put dozens of log files in the same directory or folder as the actual document. Because Gnucash does, when someone naively saves a Gnucash data file to her desktop, it's almost immediately cluttered with log files. The same was true when I naively saved my first GnuCash file to the same folder as my financial spreadsheets -- relatively quickly they were buried under a blizzard of log files. (Granted, I'm exaggerating a bit, for effect.) I understand the usefulness of the log files, but why aren't they written to the temp folder? Or better yet, why aren't they written to a user-specified location, with the temp folder as default? This sounds like an idea that needs to be filed as an enhancement request. I'd suggest an alternative might be to create two sub-folders in the folder where the data file is stored: 1. ./GnuCash-Backups 2. ./GnuCash-Logs That would keep them from cluttering up the main folder but be readily at hand and easily identifiable. Of course, I've used *Nix style paths but the idea should port to Windows (I don't know Mac). --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 t
Re: [GNC] When will there be a new Finance::Quote version on CPAN?
On 12/01/18 10:47, Eric Coates wrote:
Hi
I am about to expose my ignorance - sensitive people should look away
now!
I have found the file referred to (I think); on my Ubuntu system I
found it at
~/.cpan/build/Finance-Quote-1.47-JrEF3h/lib/Finance/quote
The last few lines of the file are:
# divide USD quotes by 100 if suffix is '.IL'
if ( ($suffix eq '.IL') && ($info{$stock,'currency'}
eq 'USD') ) {
foreach my $field (
$quoter->default_currency_fields ) {
next unless ( $info{ $stock, $field } );
$info{ $stock, $field } =
$quoter->scale_field( $info{ $stock,
$field },
0.01 );
}
}
}
}
else {
$info{ $stock, 'currency' } = 'USD';
}
$info{ $stock, "currency_set_by_fq" } = 1;
$quantity--;
select(undef, undef, undef, .7) if ($quantity); sleep(15);
}
return wantarray() ? %info : \%info;
}
Unfortunately I am completely ignorant of Perl (I guess that's what it
is). Could you please indicate exactly where the 'sleep 15' should be
entered. And, if it's to be indented, is the indentation done with
spaces or tabs and is the number of spaces/tabs critical.
Many thanks
Eric
And, because I enjoy coincidences, , best wishes from the Soar Valley
- the Soar being our local river
snip
Eric,
See the mod I made in your message above at the "select(undef, undef,
undef, .7) if ($quantity); line".
Attached to this message are: a modified version of AlphaVantage.pm ( a
text file) for my Win10 system; and an image of Ameet Sengar's message
of last Sept. Check and set the properties of AlphaVantage.pm to read
only if you choose to replace that file as a unit.
Have no idea why Sengar's message wasn't included in the 29Nov note.
Please be aware that while I have an Ubuntu system, I have had no
experience with Gnucash on that system.
All the best, nvsoar
#!/usr/bin/perl -w
#This module is based on the Finance::Quote::yahooJSON module
#
#This program is free software; you can redistribute it and/or modify
#it under the terms of the GNU General Public License as published by
#the Free Software Foundation; either version 2 of the License, or
#(at your option) any later version.
#
#This program is distributed in the hope that it will be useful,
#but WITHOUT ANY WARRANTY; without even the implied warranty of
#MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
#GNU General Public License for more details.
#
#You should have received a copy of the GNU General Public License
#along with this program; if not, write to the Free Software
#Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA
#02111-1307, USA
package Finance::Quote::AlphaVantage;
require 5.005;
our $VERSION = '1.47'; # VERSION
use strict;
use JSON qw( decode_json );
use HTTP::Request::Common;
my $ALPHAVANTAGE_URL =
'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY=compact=json';
my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
my %currencies_by_suffix = (
# Country City/Exchange Name
'.US' => "USD",# USA AMEX, Nasdaq, NYSE
'.A' => "USD",# USA American Stock Exchange (ASE)
'.B' => "USD",# USA Boston Stock Exchange (BOS)
'.N' => "USD",# USA Nasdaq Stock Exchange (NAS)
'.O' => "USD",# USA NYSE Stock Exchange (NYS)
'.OB' => "USD",# USA OTC Bulletin Board
'.PK' => "USD",# USA Pink Sheets
'.X' => "USD",# USA US Options
'.BA' => "ARS",# Argentina Buenos Aires
'.VI' => "EUR",# Austria Vienna
'.AX' => "AUD",# Australia
'.SA' => "BRL",# BrazilSao Paolo
'.BR' => "EUR",# Belgium Brussels
'.TO' => "CAD",# CanadaToronto
'.V' => "CAD",# Toronto Venture
'.SN' => "CLP",# Chile Santiago
'.SS' => "CNY",# China Shanghai
'.SZ' => "CNY",# Shenzhen
'.CO' => "DKK",# Denmark Copenhagen
'.PA' => "EUR",# FranceParis
'.BE' => "EUR",# Germany Berlin
'.BM' => "EUR",# Bremen
'.D' => "EUR",# Dusseldorf
'.F' => "EUR",# Fran
Re: [GNC] When will there be a new Finance::Quote version on CPAN?
On 11/29/18 19:36, Mike Alexander wrote: On Nov 27, 2018, at 6:26 PM, John Ralls wrote: Not here. It’s up to Erik Colson. Who has been asking for help on the finance-quote list. If you have Perl experience and want to volunteer, that would be helpful. Mike FWIW - I made a similar query last October. Two suggestions were offered; use YahooJson as a quote source; or modify AlphaVantage.pm in the FinanceQuote folder; (for Windows - in C:\strawberry\perl\site\lib\Finance\Quote\) Ameet Sengar's modification suggestion is to add 'sleep(15)' as the last line of the 'foreach' loop. The text of his message is below. If I remember correctly, the AlphaVantage.pm file is read only; change that attribute before attempting to modify. Restore the read only attribute after modification. All the best from the Carson Valley, nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] PriceQuotes and AlphaVantage assistance request
On 10/05/18 10:20, Frank H. Ellenberger wrote: Hi Megagrumpy, Am 05.10.18 um 08:46 schrieb Megagrumpy: I do not know how to link to a previous message go to https://lists.gnucash.org/pipermail/gnucash-user/ and select the month i.e. by thread it should look similar to your inbox. Finally here is the link: https://lists.gnucash.org/pipermail/gnucash-user/2018-September/079698.html but the workaround posted on Sep 08 by Ameet Sengar, where he provides instructions to delay the requests to Alphavantage, works very well and I am now consistently getting 100% of my 50 plus quotes. Hopefully this link works - HTH Frank Many thanks to those who responded. Yahoo Json worked very well on GnuCash v3.3; resulted in 'program not responding' on v2.6.21. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] PriceQuotes and AlphaVantage assistance request
Win 10, Strawberry 5.28, Cpan 1.47; GnuCash 3.3 and 2.6.21 on separate machines. Please advise what needs to be accomplished so that AlphaVantage can return more that 4 out of the 20 quotes requested. Thank your for your assistance, nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Online Price Retrieval Fails
On 09/06/18 07:12, John Ralls wrote: On Sep 5, 2018, at 8:49 PM, nvsoar <mailto:nvs...@charter.net>> wrote: On 09/05/18 17:27, John Ralls wrote: On Sep 5, 2018, at 12:26 PM, nvsoar <mailto:nvs...@charter.net>> wrote: Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) reports DateManip could not be found; reports the following at the end. * Run gnc-fq-helper Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/strawberry/perl/site/lib C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at gnc-fq-helper line 29. BEGIN failed--compilation aborted at gnc-fq-helper line 29. An error occurred, see above. Press any key to continue . . . Have know idea for the meaning of @INC, or where to put the Date::Manip module. Same fault for GnuCash version 2.6.17 Run the Online Price Retrieval Setup program. Date::Manip is a required perl module. Regards, John Ralls That's what did not work. Downloaded v2.6.21; went GnuCash menu and selected "Install Online Price Retrieval for GnuCash." This action resulted in the message above at the end of the process. Observing the process running on the terminal showed a message similar to "could not find DateManip" part way through. I apologize for not being clear in the initial report. Hmm. Date::Manip is in the CPAN repository, https://cpan.metacpan.org/authors/id/S/SB/SBECK/Date-Manip-6.73.tar.gz. The URL has changed, though, from cpan.org <http://cpan.org> to metacpan.org <http://metacpan.org>. That’s just the last couple of months, I think. Try opening a Strawberry Perl window from the Start menu and run the command cpan -i Date::Manip There are likely multiple error messages and having the output in a window that doesn’t disappear at the end will help you see them all. Regards, John Ralls For info - Here are the results from the above suggestion - - C:\>cd strawberry C:\strawberry> cpan -i Date::Manip CPAN: CPAN::SQLite loaded ok (v0.203) CPAN: LWP::UserAgent loaded ok (v6.05) CPAN: Time::HiRes loaded ok (v1.9726) Fetching with LWP: http://cpan.strawberryperl.com/authors/01mailrc.txt.gz CPAN: YAML::XS loaded ok (v0.41) Fetching with LWP: http://cpan.strawberryperl.com/modules/02packages.details.txt.gz Fetching with LWP: http://cpan.strawberryperl.com/modules/03modlist.data.gz Database was generated on Wed, 05 Sep 2018 03:53:51 GMT Updating database file ... Done! Warning: Cannot install Date::Manip, don't know what it is. Try the command i /Date::Manip/ to find objects with matching identifiers. C:\strawberry> i /Date::Manip/ 'i' is not recognized as an internal or external command, operable program or batch file. C:\strawberry>cpan i /Date::Manip/ CPAN: CPAN::SQLite loaded ok (v0.203) Database was generated on Sat, 15 Sep 2018 22:32:21 GMT Warning: Cannot install i, don't know what it is. Try the command i /i/ to find objects with matching identifiers. CPAN: Time::HiRes loaded ok (v1.9726) Sorry, install with a regular expression is only supported when unambiguous. Rejecting argument '/Date::Manip/' C:\strawberry> __ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Online Price Retrieval Fails
On 09/05/18 17:27, John Ralls wrote: On Sep 5, 2018, at 12:26 PM, nvsoar wrote: Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) reports DateManip could not be found; reports the following at the end. * Run gnc-fq-helper Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/strawberry/perl/site/lib C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at gnc-fq-helper line 29. BEGIN failed--compilation aborted at gnc-fq-helper line 29. An error occurred, see above. Press any key to continue . . . Have know idea for the meaning of @INC, or where to put the Date::Manip module. Same fault for GnuCash version 2.6.17 Run the Online Price Retrieval Setup program. Date::Manip is a required perl module. Regards, John Ralls That's what did not work. Downloaded v2.6.21; went GnuCash menu and selected "Install Online Price Retrieval for GnuCash." This action resulted in the message above at the end of the process. Observing the process running on the terminal showed a message similar to "could not find DateManip" part way through. I apologize for not being clear in the initial report. All the best, nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Online Price Retrieval Fails
Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) reports DateManip could not be found; reports the following at the end. * Run gnc-fq-helper Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/strawberry/perl/site/lib C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .) at gnc-fq-helper line 29. BEGIN failed--compilation aborted at gnc-fq-helper line 29. An error occurred, see above. Press any key to continue . . . Have know idea for the meaning of @INC, or where to put the Date::Manip module. Same fault for GnuCash version 2.6.17 Please advise. Thank you for your assistance. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: The two modules
Seems to me that I read recently that gwenhywfar is an AQ Banking package. On the same google page is an entry that it can be downloaded from Source Forge. nvsoar On 06/20/18 13:17, Stephen M. Butler wrote: Then I ran into this problem. Researching. I don't see 'gwenhywfar' listed on the installation page. Attempting to install says package not found. $ cmake -D CMAKE_INStALL_PREFIX=/usr/local ../gnucash-3.1 -- The C compiler identification is GNU 7.3.0 -- The CXX compiler identification is GNU 7.3.0 -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Detecting C compile features -- Detecting C compile features - done -- Check for working CXX compiler: /usr/bin/c++ -- Check for working CXX compiler: /usr/bin/c++ -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Detecting CXX compile features -- Detecting CXX compile features - done -- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1") -- Checking for module 'glib-2.0>=2.40' -- Found glib-2.0, version 2.56.1 -- Checking for module 'gio-2.0' -- Found gio-2.0, version 2.56.1 -- Checking for module 'gobject-2.0>=2.20'$ cmake -D CMAKE_INStALL_PREFIX=/usr/local ../gnucash-3.1 -- The C compiler identification is GNU 7.3.0 -- The CXX compiler identification is GNU 7.3.0 -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Detecting C compile features -- Detecting C compile features - done -- Check for working CXX compiler: /usr/bin/c++ -- Check for working CXX compiler: /usr/bin/c++ -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Detecting CXX compile features -- Detecting CXX compile features - done -- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1") -- Checking for module 'glib-2.0>=2.40' -- Found glib-2.0, version 2.56.1 -- Checking for module 'gio-2.0' -- Found gio-2.0, version 2.56.1 -- Checking for module 'gobject-2.0>=2.20' -- Found gobject-2.0, version 2.56.1 -- Checking for module 'gmodule-2.0>=2.20' -- Found gmodule-2.0, version 2.56.1 -- Checking for module 'gthread-2.0>=2.20' -- Found gthread-2.0, version 2.56.1 -- Checking for module 'libxml-2.0>=2.7.0' -- Found libxml-2.0, version 2.9.4 -- Checking for module 'libxslt' -- Found libxslt, version 1.1.29 -- Checking for module 'webkit2gtk-4.0' -- Found webkit2gtk-4.0, version 2.20.3 -- Checking for module 'gtk+-3.0>=3.10.0' -- Found gtk+-3.0, version 3.22.30 -- Checking for module 'zlib' -- Found zlib, version 1.2.11 -- Found Gettext: /usr/bin/msgmerge (found suitable version "0.19.8.1", minimum required is "0.19.6") -- Using guile-2.0.x -- Using guile SRFI-64 -- Checking for module 'gwenhywfar' -- No package 'gwenhywfar' found CMake Error at /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:415 (message): A required package was not found Call Stack (most recent call first): /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:593 (_pkg_check_modules_internal) common/cmake_modules/GncFindPkgConfig.cmake:253 (PKG_CHECK_MODULES) CMakeLists.txt:347 (GNC_PKG_CHECK_MODULES) -- Configuring incomplete, errors occurred! See also "/home/steve/Projects/GnuCash/mybuild/CMakeFiles/CMakeOutput.log". -- Found gobject-2.0, version 2.56.1 -- Checking for module 'gmodule-2.0>=2.20' -- Found gmodule-2.0, version 2.56.1 -- Checking for module 'gthread-2.0>=2.20' -- Found gthread-2.0, version 2.56.1 -- Checking for module 'libxml-2.0>=2.7.0' -- Found libxml-2.0, version 2.9.4 -- Checking for module 'libxslt' -- Found libxslt, version 1.1.29 -- Checking for module 'webkit2gtk-4.0' -- Found webkit2gtk-4.0, version 2.20.3 -- Checking for module 'gtk+-3.0>=3.10.0' -- Found gtk+-3.0, version 3.22.30 -- Checking for module 'zlib' -- Found zlib, version 1.2.11 -- Found Gettext: /usr/bin/msgmerge (found suitable version "0.19.8.1", minimum required is "0.19.6") -- Using guile-2.0.x -- Using guile SRFI-64 -- Checking for module 'gwenhywfar' -- No package 'gwenhywfar' found CMake Error at /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:415 (message): A required package was not found Call Stack (most recent call first): /usr/share/cmake-3.10/Modules/FindPkgConfig.cmake:593 (_pkg_check_modules_internal) common/cmake_modules/GncFindPkgConfig.cmake:253 (PKG_CHECK_MODULES) CMakeLists.txt:347 (GNC_PKG_CHECK_MODULES) -- Configuring incomplete, errors occurred! See also "/home/steve/Projects/GnuCash/mybuild/CMakeFiles/CMakeOutput.log". Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758
Re: [GNC] Help - GnuCash will not open, crashes
On 04/24/18 13:26, Mike Johnson wrote: Good day. I have been running GnuCash for 3 ½ years successfully. Great application! I upgraded to a new PC, saved the entire gnucash library, and copied to the new PC after installing GnuCash fresh, on Windows 10. The first time I started GnuCash (and every time since), I get "GnuCash could not obtain the lock for file: (gives the name of my accounting file)" It gives me the options: Open Read-Only Create New File Open Anyway Quit I don't want to create a new file, and I want to continue editing the file! So I use Open Anyway. The application either then hangs, or receives a Windows Microsoft Visual C++ Runtime error. "The application has requested the Runtime to terminate it in an unusual way". I am unable to continue using the app until this is resolved. Help! Mike There have been some issues with the deployment of GnuCash, particularly with Win10. The advice from many on this condition is to revert to at least version 2.6.21, and try the version 3 series again with the release of version 3.1. Another choice is to download the latest maintenance version of v3 and see if that works for you. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Unrealized loss
Hm. Seems to me that a price is added to the system any time a stock is purchased or sold, or when a dividend is reinvested. nvsoar On 04/04/18 09:32, Adrien Monteleone wrote: The value will usually change based on that setting. Sometimes ‘latest’ and ’nearest in time’ will be the same, but that depends on running the report ON an actual day (not FOR an actual day) that is on or after a price update and before the next price update. First, you say you deleted all rates updated automatically by GC without you noticing. (does not happen, you have to open the price editor and tell it to ‘get quotes’) This leaves the presumption that there are other prices in the db that you either entered manually or intentionally updated with the ‘get quotes’ button. Then you say there are NO rates in the system. Which is it? If you open the Price Database is there anything at all listed in the window? (this includes a Currencies tree) Do you have ANY transactions where you purchased or entered an opening balance for a commodity or any currency other than the default book currency? (EUR) If you go to File > Properties, is ‘Use Trading Accounts’ checked? Regards, Adrien On Apr 4, 2018, at 11:10 AM, cag...@free.fr wrote: I suspect there is a bug that should be reported: As I do NOT manage currencies other than EUR and no traders accounts taking into account share values, I have deleted all exchanges rates that had been updated automatically by GC without my noticing. BUT my Unrealized loss on a given day varies according to my setting the calculation mode to "average" or "nearest in time" for instance. It doesn's seem to make sense since there are NO exchange rates in my system. Ideas? TIA Alain De: "sunfish62" <sunfis...@yahoo.com> À: cag...@free.fr, "John Ralls" <jra...@ceridwen.us> Cc: "gnucash-user" <gnucash-user@gnucash.org> Envoyé: Lundi 2 Avril 2018 14:52:46 Objet: Re: Unrealized loss Alain, Your new transaction is balanced, and won't affect the imbalance in another transaction. I personally find the unrealized gains issue to be exceedingly difficult to understand. Since you say you don't care about this, just ignore it. David T On Mon, Apr 2, 2018 at 17:02, cag...@free.fr <cag...@free.fr> wrote: De: [ mailto:cag...@free.fr | cag...@free.fr ] À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | gnucash-user@gnucash.org ] > Envoyé: Lundi 2 Avril 2018 13:51:03 Objet: Re: Unrealized loss De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > À: [ mailto:cag...@free.fr | cag...@free.fr ] Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | gnucash-user@gnucash.org ] > Envoyé: Dimanche 1 Avril 2018 15:34:43 Objet: Re: Unrealized loss On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote: Hello. I have have had an "unrealized loss" showing on my balance sheet for years. I haven't bothered too much as the amount is extremely small. (€7.70). I had kind advice on this forum as to identify the date on which the loss showed up and the procedure to cancel it. I did find the date but stangely not the transaction. So I'm not going to keep trying to cancel the loss any longer. I read that, without actually "cancelling" the loss, it is possible to prevent it from showing. I know that this is not legal for a company, but my book keeping is fully personal so I'd like to know the procedure. “Cancelling” isn’t really the right term. You need to record the loss as either expense or negative income depending on how you handle capital gains. There’s an explanation of how to do this in [ [ https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] | [ https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] ] . Regards, John Ralls I have identified the day on which the unrealized lossed first appeared. I have drawn a transaction report for that day (and the day before). There is no transaction that can remotely explain the loss. I do not handle foreign currencies. Regarding shares I do not use trader accounts or split transactions including profits or losses. I do not enter share values into GC until the day I sell them. There is no way in the meantime GC can take into account a difference in value. Something might help identify where the problem comes from: I had another instance with an unrealized loss as big as my total yearly income. It went away a few weeks (or months I'm not sure) after it showed up. There is no way a single transaction (or ev
Re: Stock Spin-Out
On 02/21/18 10:41, Les wrote: Thanks Tommy for your input. There was not any information on either the spun-out company or the company that did the spin-out. (both companies are Canadian stocks.) I have sent email to both companies to determine my basis. On 02/21/2018 11:59 AM, Tommy Trussell wrote: On Tue, Feb 20, 2018 at 10:02 PM, nvsoar <nvs...@charter.net> wrote: Comment: It seems to me that a zero cost for the spun off shares is incorrect if a non-zero basis exists for the pre-spin off shares. A zero cost for the new shares will result in a higher than necessary capital gain when those shares are sold. The easiest way to determine the new basis for each of the remaining entities that I have found is to use the cost basis calculator at the link previously provided. nvsoar Usually here in the US, when a company announces a stock spin-off, the existing shareholders are provided a passel of materials, some of which include a determination by a tax attorney or the IRS describing how to calculate the basis of the spun-off shares. You can usually find the information at the spun-off company's web site (look for a link for "investor information") or as a document available from the company's stock transfer agent. I can imagine that sometimes such information may not be finalized at the time of spin-off, especially if the IRS objects to some part of it, but my impression is that these things are almost always pretty much settled before the time they occur because there's lots of money involved. And nobody wants any uncertainty when there's lots of money involved... For info - Here is an article that may be useful in understanding the rationale of determining the post spin off basis for both remaining entities. The basic idea is that the sum of the post-spinoff market value of both entities is the same as the pre-spinoff market value; and thus the pre-spin off basis is divided according to the post spin off market values. http://www.spinoffprofiles.com/spinoff-tax-basis-and-tax-treatment FWIW - I agree with Mr Trussel that in many cases the firm that initiates the spin off typically provides the percentages to determine the new basis for each of the spun off entities. When this is not the case then the cost basis.com tool or a manual calculation is called for. As far as I know, the IRS has not specified which of the stock price figures (open, close, high, low, average for the day) to be used for determining market value. http://www.spinoffprofiles.com/spinoff-tax-basis-and-tax-treatment nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Stock Spin-Out
On 02/20/18 11:35, Les wrote: There is a stock-split function in GC. However it doesn't appear to do spin-outs. In my case, the company doing the spin-out is doing a 5 to 1 and there are no fractional shares. I just assigned the cost at 0.00 per share. Les On 02/20/2018 01:27 PM, David Carlson wrote: Les, Usually a stock spin-off splits the before spin-off cost basis between the after spin-off stocks according to documents provided by the parent corporation to the SEC and shareholders which also explain how details such as fractional shares and various expenses are to be treated. The worksheet that nvsoar provided the link to helps with calculating details. I thought that there was also a stock split assistant built into GnuCash to construct the transactions. Check the help or tutorial manual s for that. David C On Feb 20, 2018 9:57 AM, "Les" <lellio...@gmail.com <mailto:lellio...@gmail.com>> wrote: Thanks for both replies. I used a zero price and the number of shares with a description. (John's procedure) But I was not sure if the procedure I used was correct (best). Regards, Les Comment: It seems to me that a zero cost for the spun off shares is incorrect if a non-zero basis exists for the pre-spin off shares. A zero cost for the new shares will result in a higher than necessary capital gain when those shares are sold. The easiest way to determine the new basis for each of the remaining entities that I have found is to use the cost basis calculator at the link previously provided. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Stock Spin-Out
On 02/19/18 15:25, John Coppock wrote: This is what I have been doing. I am new to Gnu Cash. I'm using Gnu Cash v.2.6.17 on Windows 10 in US dollars. In 'Tools/Security Editor', create the new spin-off security. In your brokerage account, create a new sub-account for the new spin-off security. Its Account Type will be stock (do this first), currency will be shares of the security you just created. If you don't see it show up after you created it, go to 'View/Filter by/Other' to show accounts with zero totals, In the new sub-account (tab between fields), enter the date of the spin-off, a description, on the next line choose 'Buy' for 'Action', enter the shares received in 'Shares', delete the value in 'Price', enter the basis of the shares received in 'Buy', on the next line enter the name of the parent Stock account, enter 0 for 'Shares', delete the value in 'Price', verify the value in 'Buy' is the same as the basis entered before, hit enter and you're done. I've found this seems to handle the basis change for both stocks. On 2/19/2018 1:37 PM, Les wrote: I recently had a stock that owned a significant part of a rather new company and decided to spin it out at a 5 to 1 rate. Can someone please explain how to do this in GC? Thanks, Les FWIW - Here is a resource for dealing with spin-off basis transactions - http://www.costbasistools.com/spinoff/calculator.php nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: How to create an asset with a reduced value compared to my regular currency (dollars)
On 12/06/17 12:44, adrian wrote: Tommy Trussell wrote Adrian: In the case at hand I spent $430 on the gift card and when I buy something that costs $100, I'm really only spending $86. That's what makes sense to me for how this ought to be counted. Since I don't know the category of the expense in advance, I can't just put in a $70 offset unless I put it as "misc", in which case I lose track of some information about how I allocated my money. I went back to your original question (remember that this is NOT a forum -- it's an email list that you're viewing through Nabble) Yeah, despite that I have been unable to actually subscribe to the list. But your point was you wanted more context, I suppose. I bought a $500 gift card for $430 this week. I would like to add this to gnucash as some kind of asset so that as I spend it, the correctly scaled amount gets transferred to the expense account I use. In other words, if I spend $100 from this account it's really only $86. I tried to do this by creating a security fund and then using the price editor to set the price to 0.86. But when I insert a transaction from the new account to an expense account, it doesn't apply the 0.86 factor. What is the right way to do what I want to do? I think you have demonstrated the difficulty with what you're trying to do-- you're trying to make a rebate card a different KIND of currency, which in one sense, it is. HOWEVER every time you make a purchase from that card it will require a currency exchange, which adds a level of complexity and may not produce the result you want. I'm sure you could make it work, but in the end, it's a lot easier to just offset the $70 against the expenses. TECHNICALLY you don't get benefit of the full amount you spent on the card until you have completely depleted the value of the card, but that would be a PITA (sorry for the acronym -- I mean "difficult"). I think the real answer is to go back and think about what it is you want to achieve. I'm not sure what exactly is unclear. I am thinking of the acquisition of this card not as a purchase, but as a shift of assets from one form to another. So instead of $430 in the bank I now have a different asset, namely $500 on the card. Yes, it's true, I don't benefit until I spend the money. But the same is true of money in the bank. But it's not really $500 on the card because I only spent $430 on it. It is exactly like a currency exchange, though it's not obvious to me why this means my goal is a very complex one. It seems pretty simple to have an exchange rate and have the card denominated in some currency, say the Gifta, that is equal to .86 dollars. When I buy something using the card I can go to the card's account and list the expenses in Giftas and they will be automatically translated by the 0.86 factor. (I assume that if I made an account denominated in, say GBP, that I would be able to get that to translate to the USD that I use for my regular accounts; after all, this is something that is important to many people.) Now actually I realized that the solution I was fiddling with can be made to work. As I mentioned before, I made an account and created a security and tried to set its price using the price editor. For some reason the Price Editor doesn't seem to do anything, but there is a column labeled "Price" in the account I made, and if I set this to 0.86 (which I have to do manually for every transaction, it seems) then things work as I was hoping. (And I notice that prices I enter in the ledger appear in the price editor even though the reverse doesn't seem to be the case.) It would be even nicer if I could set the price once and have that same price stay in effect until I change it, rather than having to enter it again for each transaction with the default price being "1". Why do I care? It's just so that my accounting correctly tracks my expenditures in different categories. I don't need to use accounting software to do price comparisons, but if I want to know how much I spent on Widgets this year---and I buy some using the card---the number will be inflated if I don't account for the discount. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html H. Seems to me that you received a $70.00 gift along with the card. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org 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: F::Q changes
On 11/12/17 18:02, David Carlson wrote: I cannot find Finance::Quote on my Ubuntu 16.04 computer that has GnuCash 6.12 installed. How can I update it? I have tried using Synaptic and even searching with files. David C snip Try GetDeb to update - http://www.getdeb.net/updates/Ubuntu/16.04/?q=gnucash nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org 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: Finance-Quote 1.42 released!
On 11/06/17 12:04, Fross, Michael wrote: Thank you so much Erik. I had a lot of trouble getting 1.40 and 1.41 working on windows, but 1.42 worked without issue using Alphavantage. I appreciate you taking the time to help us (all all of the other users of F:Q) out. If anyone is having issues getting it working on Windows with Activatestate Perl, I'd be happy to post about it, but it was really just installing F:Q 1.42 and then changing all of my securities to update via Alphavantage. I also had to add the API key to an environment variable. Regards, Michael snip Good news. Please advise the method to get and set up the API key for someone who has never heard of an API key. Thank you for your assistance to all involved. nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
Correct entries for fractional sale of a spun off stock
In reviewing the guide I have so far been unsuccessful in getting an appropriate double entry outcome. The situation - Aligent was spun off from Hewlett Packard with 305.12 shares with a basis of $1490.54. O.12 shares with a basis of $0.59 were sold for $9.24 which was transferred to the broker cash account, resulting in a capital gain of $8.65. The basis for the 305 remaining Agilent shares is therefore reduced by $0.59 to $1489.96. It is my understanding that I need to credit Income:CapitalGain by $8.65; for the Brkr:Agilent account - decrease the shares by 0.12 and credit an amount of $0.59. The other two entries need for double entry balance have eluded me. Thank you for your assistance, nvsoar ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
