Price editor unbalances accounts
The price editor makes unbalanced entries in my accounts by increasing (or decreasing) the value of securities without the needed balancing entry to income. In US tax terms the gain (loss) is an "unrealized" gain (loss) so there's no need to pay tax on it, so some people might not want it show up as income. But I would really like it if my trial balance actually balanced. Has anyone looked at this "problem"? Keith ___ 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: Price editor unbalances accounts
Been a gnucash user for years and never understood what Most Recent meant. BS w/ most recent shows my accounts to be almost in balance. Thanks, Keith On Tue, Sep 5, 2017 at 12:04 AM, John Ralls <jra...@ceridwen.us> wrote: > > > > On Sep 4, 2017, at 7:43 PM, Keith Bellairs <ke...@bellairs.org> wrote: > > > > The price editor makes unbalanced entries in my accounts by increasing > (or > > decreasing) the value of securities without the needed balancing entry to > > income. In US tax terms the gain (loss) is an "unrealized" gain (loss) so > > there's no need to pay tax on it, so some people might not want it show > up > > as income. But I would really like it if my trial balance actually > > balanced. > > > > Has anyone looked at this "problem"? > > No, the Price Editor doesn’t do anything at all to your accounts. The > Accounts page shows the value of your securities according to the latest > prices in the price database, but if you look at the account registers > you’ll see that there’s no transaction that reflects price changes. > > When you run reports you can select what price to apply to assets. > “Nearest in time” will generally cause the report to show “book value” with > no unrealized gains or losses; “Most Recent” will price assets at the most > recent price found in the price database. The other two, “Average Cost” and > “Weighted Average” use averages of the prices actually paid for the > non-default-currency assets but average all purchases in different ways. > > If you actually want to book unrealized gains (and unless a > certified/chartered accountant tells you that you do, you don’t) you must > create the transactions yourself. > > Regards, > John Ralls > > ___ 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: [GNC] Trivial feature - View zero accounts
Great idea. I did not know about the "right click filter by" on register windows. Right click context menu for accounts window would be perfect. On Wed, May 23, 2018 at 12:19 PM, David Carlson <david.carlson@gmail.com > wrote: > Keith, > > I did not know about the "View > Filter by.." options being different in > the Accounts window until I read your post. I think that it would make > more sense to have the "View > Filter by..." appear as the first selection > in the pop-up list when you right click in the page, similar to the way it > works when you right click in other account register windows. > I think that would be a cool feature. > > David C > > > On Wed, May 23, 2018 at 10:30 AM, Keith Bellairs <ke...@bellairs.org> > wrote: > >> I close accounts at year end. So if "view zero accounts" is not set, all >> my >> income and expense accounts disappear. To find them I have to go to >> "View->File By->Other" just to see them. Then when I want to turn them off >> again to get rid of historical clutter I have to go the same way. >> >> It would be cool to have an icon on the main window to toggle the Show >> Zero >> feature. >> >> But it is a feature request and the developers do important work, so I am >> sure it is also low priority. >> >> Thanks for the great accounting system. >> >> Keith >> ___ >> 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.
[GNC] Trivial feature - View zero accounts
I close accounts at year end. So if "view zero accounts" is not set, all my income and expense accounts disappear. To find them I have to go to "View->File By->Other" just to see them. Then when I want to turn them off again to get rid of historical clutter I have to go the same way. It would be cool to have an icon on the main window to toggle the Show Zero feature. But it is a feature request and the developers do important work, so I am sure it is also low priority. Thanks for the great accounting system. Keith ___ 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.
Annual High Balance Report?
The US requires a report showing the highest balance in each foreign (non-US) account during the previous year. FinCEN From 114 (FBAR) (superseding TD F 90-22.1) Is there a way to generate that info? Keith ___ 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: Trading Accounts for Securities
Thanks, Derek. I get that. I guess trading accounts do not provide for a use case I need. Keith On Wed, Feb 21, 2018 at 12:10 PM, Derek Atkins <de...@ihtfp.com> wrote: > Hi, > > Trading accounts do not show you UNREALIZED gains. They exist to help you > balance out REALIZED gains once you have a sale transaction. > > -derek > > On Wed, February 21, 2018 12:00 pm, Keith Bellairs wrote: > > I started looking at using trading accounts but I may be missing > > something. > > > > The trading account created by gnucash for a stock shows as a balance the > > number of shares in the account. This is also the balance shown in the > > asset account for that stock. > > > > Transactions for all stocks post to the USD (in my case) trading account. > > So the USD trading account seems to show the aggregate of purchases, > > sales, > > gains. losses etc. of all the stocks - sort of like the amount of money I > > have on the table for trading. But I would rather see the realized gains > > in > > an income account. And I can see the total unrealized gain(loss) in an > > advanced portfolio report. > > > > I had guessed that unrealized gains would somehow be reflected in the > > trading account when the value of the underlying security is updated. In > > that way the trading account would look like the marginable value of my > > stocks. Then I looked at the documentation. The examples only show > > realized > > gains being posted. So again, the actual asset account for a security > > provides me more info. I guess I could manually post unrealized gain to > > the > > trading account each time I look up the price of a security, since the > > Trading Account - USD does not have to match the real amount of cash on > > hand. > > > > In the end I do not see that I get anything from using trading accounts. > I > > can see that they would be useful for currency if I had to track the > > exchange rate on every foreign currency transaction. But the IRS lets me > > use an average rate for my CDN income(expense). > > > > Am I using trading accounts wrong? > > > > Keith > > ___ > > 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. > > > > > -- >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 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: Trading Accounts for Securities
When I set up a trading account for a USD stock, gnucash diligently added transactions in the trading account for the stock and for USD. The stock trading account simply tracks the number of shares in the account (which is what the asset account for the stock already does). The USD trading account shows the amount spent or received. So the trading USD account shows dollar amounts for all stock transactions in USD. I did not see a way to set up trading accounts for the currency side of each stock separately, but there may well be a way. When I sell a security I post a debit to the checking account the money goes into, a credit to the security at the PURCHASE price. The remaining out of balance amount is the capital gain (loss). That is pretty simple. For a traditional IRA, I post dividends to an Income:Deferred IRA:FB account. The income is not taxable in the current year, and at year-end I will close it to equity. But its nice to know. No need really to track your basis since it is all taxed as ordinary income when distributed. If you want to keep IRA out of "income" you could just as well post the dividend to an Equity:Deferred Income account. Then when you take a distribution you can debit Equity:Deferred Income and credit Income:IRA Distribution. YMMV Keith On Thu, Feb 22, 2018 at 4:57 PM, Stan Brown <the_stan_br...@fastmail.fm> wrote: > On 2018-02-21 12:00, Keith Bellairs wrote: > > > In the end I do not see that I get anything from using trading accounts. > I > > can see that they would be useful for currency if I had to track the > > exchange rate on every foreign currency transaction. But the IRS lets me > > use an average rate for my CDN income(expense). > > > > Am I using trading accounts wrong? > > I'm kind of wondering what they could do for me, and you've fueled my > doubts. > > I have three Vanguard accounts (taxable, Roth IRA, and traditional IRA) > and a company 401(k) to which I'm currently contributing. > > The 401(k) has "fake funds" -- they're not traded on any exchange, or if > they are then the customer service rep couldn't give me valid ticket > symbols. So I have to keep track of that myself and post realized gains > or losses in dollars, not shares. > > The Vanguard funds are all invested in subsets of the same about eight > mutual funds -- for instance, all three have VTI and VXUS, and two have > BND -- so GnuCash could look up values there. But I'm not clear on what > that would buy me, with my "set it and forget it" portfolio. > > For the two IRAs I don't need to do any tax accounting: the Roth is tax > free and any withdrawal from the traditional will be ordinary income. > > The taxable account has just two Vanguard funds in it, and that's not > going to change. But since dividends are reinvested automatically, every > month there are purchases of fractional shares, which I'd have to tell > GnuCash about. Is that worth it, or am I better off to stick with the > spreadsheet I've already developed, and just make one-off entries in > GnuCash, in dollars not shares, when I buy or sell (which will be rarely)? > > -- > Regards, > Stan Brown > Tompkins County, New York, USA > http://BrownMath.com > http://OakRoadSystems.com > ___ 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.
Trading Accounts for Securities
I started looking at using trading accounts but I may be missing something. The trading account created by gnucash for a stock shows as a balance the number of shares in the account. This is also the balance shown in the asset account for that stock. Transactions for all stocks post to the USD (in my case) trading account. So the USD trading account seems to show the aggregate of purchases, sales, gains. losses etc. of all the stocks - sort of like the amount of money I have on the table for trading. But I would rather see the realized gains in an income account. And I can see the total unrealized gain(loss) in an advanced portfolio report. I had guessed that unrealized gains would somehow be reflected in the trading account when the value of the underlying security is updated. In that way the trading account would look like the marginable value of my stocks. Then I looked at the documentation. The examples only show realized gains being posted. So again, the actual asset account for a security provides me more info. I guess I could manually post unrealized gain to the trading account each time I look up the price of a security, since the Trading Account - USD does not have to match the real amount of cash on hand. In the end I do not see that I get anything from using trading accounts. I can see that they would be useful for currency if I had to track the exchange rate on every foreign currency transaction. But the IRS lets me use an average rate for my CDN income(expense). Am I using trading accounts wrong? Keith ___ 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] Price Tool fail
Just tried to run the price tool and it reported unable to retrieve for all of 2 but my securities. Has there been a recent change? Keith ___ 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] More Price Editor questions
Since the price upload was failing I tried manually updating security prices and found that the editor is unbelievably slow. Could be that the price server is just timing out waiting for the editor. (I have many years worth of price data and its acting like its doing a bubble sort on all the prices every time it is touched.) While the price editor is churning gnc is completely non responsive. I am in Ubuntu 16.04 LTS and the gnucash packaged with it is 2.6.17 built 2017-07-04. Is there a later build available? And has any work been done on the price editor? I think that's the only thing I am having trouble with, but it would be worth an upgrade. Keith ___ 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] macOS gnc 3.2
After 20 years on a linux desktop, I find myself in an iMac. I have gnc 2.6.21 running in macOS 10.13.6. I see that I was offered the "stable" 3.2 package as a download. But it seems like I saw a lot of folks with issues with 3.2. Should I upgrade? Keith ___ 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] Fwd: MacOS Display
Never mind. Problem solved. It is MacOS Dock preferences has a "prefer tabs" setting that I had changed. -- Forwarded message ------ From: Keith Bellairs Date: Fri, Sep 21, 2018 at 12:04 PM Subject: MacOS Display To: gnucash-user email group All of a sudden Gnucash popups like the price editor are showing up as a new tab in the same window as the registers. It looks horrible (popup expanded to full size of window) and the mouse position is not being correctly sensed. I assume I must have changed some Preference, but I don't know what. Any suggestions? GnuCash 2.6.21 macOS 10.13.6 Keith Vermont ___ 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] MacOS Display
All of a sudden Gnucash popups like the price editor are showing up as a new tab in the same window as the registers. It looks horrible (popup expanded to full size of window) and the mouse position is not being correctly sensed. I assume I must have changed some Preference, but I don't know what. Any suggestions? GnuCash 2.6.21 macOS 10.13.6 Keith Vermont ___ 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] QFX import matching
I have manually assigned the account dozens of times. GNC 3.4 MacOS 10.14.3 Mojave Sent from my iPhone > On Mar 29, 2019, at 13:47, David Carlson wrote: > > Keith, > > The OFX importer may require manually assigning the Groceries account a few > times at the matching step during the first imports from your bank, but then > it should be remembering the Groceries account because you have Bayesian > matching enabled. If you are accepting the completed manual assignments and > allowing the import to complete, it should be working. Just for reference it > might help to know your OS and GnuCash release to see if there is some bug in > that process. > > David Carlson > >> On Fri, Mar 29, 2019 at 10:39 AM Keith Bellairs wrote: >> I import qfx from my checking account. I shop at my local food coop almost >> daily. The transactions all have descriptions like: >> OFX ext. info: |Trans type:Generic debit|Memo:BUFFALO M BUFF HARDWICK VT >> POS PURCHASE/PIN DDA 098894 >> with varying dates and amounts, of course. >> >> They never match and each one must be manually updated with the account >> Groceries. >> >> My Preferences look like this: >> [image: image.png] >> >> Is there something I should be tweaking? >> >> Keith >> ___ >> 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. > > > -- > 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 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] QFX import matching
Thanks for the hint, David. But its more broken than that. Many/most of my imports match correctly. The groceries one has been manually assigned dozens or hundreds of times and the match algo always fails. Do any of the parameters in the preferences make a difference? The memo field in the imported qfx file is kind of long for this company: BUFFALO M BUFF HARDWICK VT POS PURCHASE/PIN DDA 098894 and it is always the same. It has a special character in it. Somehow it baffles the import matcher. Sorry, I forgot the basic info, but the matcher has failed this way for (probably) years: Gnucash 3.4 MacOS 10.14.3 Keith On Fri, Mar 29, 2019 at 6:26 PM Keith Bellairs wrote: > I have manually assigned the account dozens of times. GNC 3.4 MacOS > 10.14.3 Mojave > > Sent from my iPhone > > On Mar 29, 2019, at 13:47, David Carlson > wrote: > > Keith, > > The OFX importer may require manually assigning the Groceries account a > few times at the matching step during the first imports from your bank, but > then it should be remembering the Groceries account because you have > Bayesian matching enabled. If you are accepting the completed manual > assignments and allowing the import to complete, it should be working. > Just for reference it might help to know your OS and GnuCash release to see > if there is some bug in that process. > > David Carlson > > On Fri, Mar 29, 2019 at 10:39 AM Keith Bellairs > wrote: > >> I import qfx from my checking account. I shop at my local food coop almost >> daily. The transactions all have descriptions like: >> OFX ext. info: |Trans type:Generic debit|Memo:BUFFALO M BUFF HARDWICK VT >> POS PURCHASE/PIN DDA 098894 >> with varying dates and amounts, of course. >> >> They never match and each one must be manually updated with the account >> Groceries. >> >> My Preferences look like this: >> [image: image.png] >> >> Is there something I should be tweaking? >> >> Keith >> ___ >> 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. >> > > > -- > 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 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] MySQL
gnucash.trace is empty. Of some interest, I did a Save As to sqlite and it worked. So the xml data is acceptable to that DB. XML -> sqlite OK XML -> mysql NG sqlite -> mysql NG I tried to do a Save As from the sqlite db to MySQL. That Save As ground away for a few minutes and then threw the same bad data error. So I am guessing that I have a problem with my mysql server. But of course the error log for mysql is clean. There may be some mysql magic I am missing. Since I don't live there I may not push on it much longer. Keith On Wed, Mar 6, 2019 at 11:44 AM Colin Law wrote: > On Wed, 6 Mar 2019 at 15:36, Keith Bellairs wrote: > > > > Yes, the Save As selection is not grayed out. So I assumed the drivers > were > > in the Mac package. > > > > My MySQL instance is up and running. > > > > But I get a gnc error when I try to do the Save As. > > > > Have a look in the gnucash trace file to see if it says anything more > helpful > > Colin > ___ 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] MySQL
Yes I can connect using the mysql command line tool. No, the gnucash db has not been created. But I cannot use the mysqlworkbench shell. It complains about a missing connector (python?) Also, gnc get the "bad data" error even if I try to "save as" with a bad password, no password, or no user id. So it doesn't look like it is really hitting the db at all. Keith On Wed, Mar 6, 2019 at 3:28 PM Colin Law wrote: > On Wed, 6 Mar 2019 at 19:09, Keith Bellairs wrote: > > > > gnucash.trace is empty. > > > > Of some interest, I did a Save As to sqlite and it worked. So the xml > data is acceptable to that DB. > > > > XML -> sqlite OK > > XML -> mysql NG > > sqlite -> mysql NG > > > > I tried to do a Save As from the sqlite db to MySQL. That Save As ground > away for a few minutes and then threw the same bad data error. So I am > guessing that I have a problem with my mysql server. But of course the > error log for mysql is clean. > > > > There may be some mysql magic I am missing. Since I don't live there I > may not push on it much longer. > > Can you connect to the database using the command line utility with > that user/pwd you specified? > Has it created the database when you look from the command line? > > Colin > ___ 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] MySQL
For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is my xml file exportable to mysql? If so, is there a writeup? I tried a couple of obvious things (save as, make myself a dba, create Gnucash schema in mysql) and made no progress. Keith ___ 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] Currency Database empty
Thanks, guys. I have reverted to Version: 3.3 Build ID: 3.3+ (2018-09-29) Finance::Quote: 1.47 and currencies show up correctly in the price tool. Also, a couple that I entered and could not see when running 3.4 in MacOS were actually entered correctly. When using 3.3 I can see the new exchange rates. GNC is the best. Keith On Sat, Feb 16, 2019 at 6:36 PM John Ralls wrote: > The only reason to not CC the list is if you're specifically invited to > send confidential data to a developer. > > You're right, it's bug 797046. I'd mistaken that for Windows only this > morning when looking over the bug reports, but Mike Alexander had seen it > on MacOS too. As you probably surmised it's fixed in git. Unfortunately > there aren't any MacOS nightlies for you to try so your best bet is to use > GnuCash 3.3 until 3.5 comes out. > > Regards, > John Ralls > > > > > On Feb 16, 2019, at 3:20 PM, Keith Bellairs wrote: > > > > John, > > > > As you might expect, fixing the broken date allowed gnc to start > without adding warnings to the trace file. Thanks for the pointer. > > > > The currency error in the price db is still there - currency exchange > rates do not display and cannot be added (or maybe are added and do not > display). I ran gnc with --debug, but the 23M file is a little unwieldy. > > > > Related to the https://bugs.gnucash.org/show_bug.cgi?id=797046 bug? I > am using MacOS. > > > > I stopped cc to the Gnucash users while this works out. > > > > Keith > > > > On Sat, Feb 16, 2019 at 3:11 PM John Ralls wrote: > > Seems you've got a bad date in your price database and it's messed up > the in-memory pricedb. Make a copy of your data file, decompress it if > necessary, and open it in a text editor. search for "201-12-11" and correct > it. Be sure to save as plain text if you're using TextEdit. Open the saved > file in GnuCash and see if that's fixed it. > > > > Regards, > > John Ralls > > > > > On Feb 16, 2019, at 8:40 AM, Keith Bellairs > wrote: > > > > > > John, > > > > > > xml backend. > > > > > > not running with -debug but trace has some of these: > > > * 10:50:08 WARN [gnc_dmy2time64_internal()] Date > computation error from Y-M-D 201-12-11: Year is out of valid range: > 1400.. > > > * 10:56:13 CRIT xmlNodePtr time64_to_dom_tree(const > char *, const time64): assertion 'time != INT64_MAX' failed > > > * 10:56:13 CRIT xmlNodePtr time64_to_dom_tree(const > char *, const time64): assertion 'time != INT64_MAX' failed > > > > > > But the date error does not seem to be coming from the Price Database > tool. (Restarted gnc, went to price tool, tired to add currency exchange, > failed - but no CRIT trace. The WARN appeared when gnc was started and > before using price tool.) > > > > > > Keith > > > > > > > > > > > > On Sat, Feb 16, 2019 at 11:25 AM John Ralls > wrote: > > > > > > > > > > On Feb 16, 2019, at 8:02 AM, Keith Bellairs > wrote: > > > > > > > > Version: 3.4 > > > > Build ID: 3.4+ (2018-12-30) > > > > Finance::Quote: 1.47 > > > > MacOS 10.14.3 (recent update) > > > > > > > > Recently moved up from gnc 2 to 3.4. Opened Price Database tool and > ran get > > > > quotes, as I have done for years. Got the alert box that it couldn't > get > > > > CAD. That's not a surprise. Update to prices was completed and I > went to > > > > hand enter a new CAD/USD price. No CAD or USD price history shows > (there > > > > should have been 15 years worth). So I selected ADD to at least have > the > > > > current exchange rate. After clicking Apply and / or OK, no exchange > rate > > > > was added and the set of exchange rates is still empty. > > > > > > > > Is this known? Is there a fix? > > > > > > I thought that I'd seen something similar from last month but I can't > find it. What backend are you using? Are there any useful messages in the > trace file [1]? > > > > > > Regards, > > > John Ralls > > > > > > [1] https://wiki.gnucash.org/wiki/Tracefile > > > > > > > ___ 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] Currency Database empty
Version: 3.4 Build ID: 3.4+ (2018-12-30) Finance::Quote: 1.47 MacOS 10.14.3 (recent update) Recently moved up from gnc 2 to 3.4. Opened Price Database tool and ran get quotes, as I have done for years. Got the alert box that it couldn't get CAD. That's not a surprise. Update to prices was completed and I went to hand enter a new CAD/USD price. No CAD or USD price history shows (there should have been 15 years worth). So I selected ADD to at least have the current exchange rate. After clicking Apply and / or OK, no exchange rate was added and the set of exchange rates is still empty. Is this known? Is there a fix? Keith ___ 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] Currency Database empty
John, xml backend. not running with -debug but trace has some of these: * 10:50:08 WARN [gnc_dmy2time64_internal()] Date computation error from Y-M-D 201-12-11: Year is out of valid range: 1400.. * 10:56:13 CRIT xmlNodePtr time64_to_dom_tree(const char *, const time64): assertion 'time != INT64_MAX' failed * 10:56:13 CRIT xmlNodePtr time64_to_dom_tree(const char *, const time64): assertion 'time != INT64_MAX' failed But the date error does not seem to be coming from the Price Database tool. (Restarted gnc, went to price tool, tired to add currency exchange, failed - but no CRIT trace. The WARN appeared when gnc was started and before using price tool.) Keith On Sat, Feb 16, 2019 at 11:25 AM John Ralls wrote: > > > > On Feb 16, 2019, at 8:02 AM, Keith Bellairs wrote: > > > > Version: 3.4 > > Build ID: 3.4+ (2018-12-30) > > Finance::Quote: 1.47 > > MacOS 10.14.3 (recent update) > > > > Recently moved up from gnc 2 to 3.4. Opened Price Database tool and ran > get > > quotes, as I have done for years. Got the alert box that it couldn't get > > CAD. That's not a surprise. Update to prices was completed and I went to > > hand enter a new CAD/USD price. No CAD or USD price history shows (there > > should have been 15 years worth). So I selected ADD to at least have the > > current exchange rate. After clicking Apply and / or OK, no exchange rate > > was added and the set of exchange rates is still empty. > > > > Is this known? Is there a fix? > > I thought that I'd seen something similar from last month but I can't find > it. What backend are you using? Are there any useful messages in the trace > file [1]? > > Regards, > John Ralls > > [1] https://wiki.gnucash.org/wiki/Tracefile > > ___ 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] accrual of property tax payments
Thanks, Derek. The issue has been around for years, I guess. Looking at invoices, for a cash basis user the invoice should get posted to payables when received and the payable is reversed to expense on the date the payment is actually made. For an accrual basis user the expense could be posted immediately to the (past, present, or future) "due date". If it's in the future it won't show up in current P, which is correct. I found that I could not edit the dates on the expense transactions that were created by the business logic, so all 4 quarters show up as expenses on the day I posted the invoice. That doesn't seem right in anyone's world. But the invoice logic is overkill for me. I'll go back to scheduled transactions. For my purposes scheduling 4 transactions is fine. Keith On Mon, Feb 11, 2019 at 5:23 PM Derek Atkins wrote: > Keith Bellairs writes: > > > My property tax is payable in 4 installments -- August, November, > February, > > and May. I have tried to set this up with my town as the vendor and 4 > > payments. > > > > When I ran my income statement for last year, I see that the future > > liabilities have been posted with the date that the bill was posted, not > > the date that the bill is due. So all of my 2019 payments show as tax > > expense in 2018. > > > > Is there a way to have the vendor bills show up dated with the due date > > instead of the date posted? > > See: https://bugs.gnucash.org/show_bug.cgi?id=95700 > > This is talking about customer invoices, but vendor bills use the same > logic. Note the date of the bug report. > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >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 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] accrual of property tax payments
My property tax is payable in 4 installments -- August, November, February, and May. I have tried to set this up with my town as the vendor and 4 payments. When I ran my income statement for last year, I see that the future liabilities have been posted with the date that the bill was posted, not the date that the bill is due. So all of my 2019 payments show as tax expense in 2018. Is there a way to have the vendor bills show up dated with the due date instead of the date posted? Keith ___ 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] QFX import matching
Derek, The online banking preference for bayesian matching is checked. The problem is most obvious, however, when I am importing a qfx file. When I use actions -> online actions -> get transactions the matching algorithm seems to work. Is the matching algo supposed to be applied for the File -> Import -> Import OFX/QFX case? Is there a separate preference for that case? Keith On Thu, Apr 11, 2019 at 11:16 AM Derek Atkins wrote: > Hi, > > Keith Bellairs writes: > > > Thanks for the hint, David. But its more broken than that. Many/most of > my > > imports match correctly. The groceries one has been manually assigned > > dozens or hundreds of times and the match algo always fails. Do any of > the > > parameters in the preferences make a difference? > > > > The memo field in the imported qfx file is kind of long for this company: > > BUFFALO M BUFF HARDWICK VT POS PURCHASE/PIN DDA 098894 > > and it is always the same. It has a special character in it. Somehow it > > baffles the import matcher. > > > > Sorry, I forgot the basic info, but the matcher has failed this way for > > (probably) years: > > Gnucash 3.4 > > MacOS 10.14.3 > > Are you sure you have Bayesian Matching turned on in your preferences? > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >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 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 Banking setup
Just upgraded my Mac from GNC 3.5 to 3.8. Online banking setup was apparently lost. Online actions for a couple of accounts now report as not set up. Bummer. They had worked flawlessly before. So I went to the online banking tool to set them up again. When I get to the Retrieve Accounts button, the wizard reports that it worked - connection to my bank seems to be OK. But no accounts are visible. This was dead simple in 3.5 so I don't know what I am missing. Along the way in the wizard I didn't see any accounts in the Accounts tab. Also did not see a configuration option "Supports Account List Downloads" check box that is mentioned in the wiki I can go back to downloading an OFX so the problem is not critical. But what happened? Keith ___ 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] AppleCard OFX file
Apple has added ability to export Apple credit card transactions in ofx format. When I tried to import their ofx file, ended up with an empty transaction matching window in gnucash. I think Apple's sgml ofx data is buggy. There is no closing tag in the header info. I edited the ofx and added the tag. After that the gnucash import worked correctly in GNC 3.7 on my Mac. The corrected set of tags looks like this: Apple Card So that worked this month. Keith ___ 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] Apple Card exports
There is a rumor that OFX exports are planned. The option to export transactions will show up when a monthly statement is available. The Apple Card transactions are exported in a Share Sheet format with a CSV document, but in the future, Apple also plans to add an OFX option. Sent from my iPhone ___ 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] Apple Card csv
I have been using GNC for a long, long time. So I have an account for each of my credit cards. I can update the accounts with ofx/qfx downloads. I see that Apple only allows csv downloads from that card. I have never used the csv upload to GNC. Does anyone have experience with Apple's csv files? If they don't upload cleanly that's a deal breaker for me. Keith ___ 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 Banking setup
3.7 is a fix. Thanks, John On Wed, Feb 12, 2020 at 7:30 PM John Ralls wrote: > > > > On Feb 12, 2020, at 9:47 AM, Keith Bellairs wrote: > > > > Just upgraded my Mac from GNC 3.5 to 3.8. Online banking setup was > > apparently lost. Online actions for a couple of accounts now report as > not > > set up. Bummer. They had worked flawlessly before. > > > > So I went to the online banking tool to set them up again. When I get to > > the Retrieve Accounts button, the wizard reports that it worked - > > connection to my bank seems to be OK. But no accounts are visible. This > was > > dead simple in 3.5 so I don't know what I am missing. Along the way in > the > > wizard I didn't see any accounts in the Accounts tab. Also did not see a > > configuration option "Supports Account List Downloads" check box that is > > mentioned in the wiki > > > > I can go back to downloading an OFX so the problem is not critical. But > > what happened? > > A new version of AQBanking that's necessary for German FinTS users but > wasn't quite ready for OFX DirectConnect users. Install 3.7 for now, we > hope that it will work again for 3.9. > > 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.
Re: [GNC] Stock Split assistant
Two things. 1. The number of shares field is parsed according to the preference. In my case that means that "4000" is parsed into "40.00" I like not having to put in the decimal point when entering currency values. 2. I had the "fractions traded" on my stock set to 1/1. In that case the stock split assistant interpreted "40" as "0.40". A value less than 1 whole share was discarded by the split tool. When I changed the security fractions to 1/100, a split of "40" yielded 10.40 shares, as expected. Keith On Sun, Aug 23, 2020 at 9:55 AM Ove Grunnér wrote: > I wonder if that is related to "Fractions Traded" on the particular Share. > if you open "Security Editor" and check, do you have "1/100" as "Fractions > Traded"? > > On Sat, 22 Aug 2020 at 16:09, Keith Bellairs wrote: > >> I have found that the "Shares" field in the Stock Split Details window >> parses the entry according to my numbers preference for currency value >> entries. For example, entering 4000 is parsed into 40.00. (My preferences >> in General -> Numbers is set to automatic decimal point.) If I enter "40" >> without a decimal point the transaction is treated as a no-op because the >> stock is set up to only trade in whole numbers. 40 is parsed as 0.4. >> >> Anyway, I spent some time thinking the stock split tool did not work. Just >> a data entry issue. Apple and Tesla are doing forward splits at the end of >> the month so the stock split tool is useful. >> >> Keith >> ___ >> 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.
[GNC] Stock Split assistant
I have found that the "Shares" field in the Stock Split Details window parses the entry according to my numbers preference for currency value entries. For example, entering 4000 is parsed into 40.00. (My preferences in General -> Numbers is set to automatic decimal point.) If I enter "40" without a decimal point the transaction is treated as a no-op because the stock is set up to only trade in whole numbers. 40 is parsed as 0.4. Anyway, I spent some time thinking the stock split tool did not work. Just a data entry issue. Apple and Tesla are doing forward splits at the end of the month so the stock split tool is useful. Keith ___ 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] Stock split assistant fail
Hi, On my Mac Using Version: 4.1 Build ID: 4.1+(2020-07-25) Finance::Quote: 1.47 When I enter the data for a stock split of a stock, the assistant does a no-op. No transaction is created (that I have found). Is this a known problem or is it just me? Keith ___ 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 split assistant fail
I was doing the TSLA 5-1 split. I put 40 in Shares. Empty New Price (tried an amount too). Next out of Cash in lieu. Apply in Stock Split Finish. And nada. Cancel and Back buttons are active. Apply is grayed. Cancel cancels and Back goes back. Maybe it’s Elon Sent from my iPhone > On Aug 13, 2020, at 16:25, John Ralls wrote: > > > >> On Aug 13, 2020, at 10:55 AM, Keith Bellairs wrote: >> >> Hi, >> On my Mac Using Version: 4.1 >> Build ID: 4.1+(2020-07-25) >> Finance::Quote: 1.47 >> >> When I enter the data for a stock split of a stock, the assistant does a >> no-op. No transaction is created (that I have found). Is this a known >> problem or is it just me? >> > > I just booked (maybe a little ahead of time) the AAPL split and it worked > fine. Must be you. ;-) > > What did you put in the Shares box? > > 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.
[GNC] Mac OS update
I noticed that when I updated to Mac OS 11.0.1 I lost Finance Quote and had to find the wiki page to do a fresh install of FQ. https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Perl_on_Unix Is that normal or did I mess up the upgrade? Keith ___ 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] gnucash-user Digest, Vol 214, Issue 9
Re: [GNC] Entering a sell in a stock account has magic number changer In my experience the automatic decimal point preference has been broken for a while. I have used it for decades to save keystrokes. But in my MacOS version of GNC 4.x it became almost impossible to enter the number of stock shares in a security account. Sometimes forcing a decimal point worked, sometimes not. I solved the problem with the mentioned workaround: turn off automatic decimal point. And retrain yourself to start typing decimal points. Keith Date: Tue, 5 Jan 2021 15:03:12 -0600 > From: Adrien Monteleone > To: gnucash-u...@lists.gnucash.org > Subject: Re: [GNC] Entering a sell in a stock account has magic number > changer > Message-ID: > Content-Type: text/plain; charset=UTF-8; format=flowed > > Sounds like a preference issue. > > Check Preferences > Numbers, Date & Time > Automatic decimal point, and > turn it off if it is checked. (you can also alter the number of decimal > places in the very next preference) > > If you don't have that preference turned on (checked) then something > else is at play. > > I don't recall if that preference is on by default. I have had it off as > long as I can recall (several years) and GnuCash is generally not in the > habit of changing your preferences on upgrade, so if it was off before, > it should still be off. > > Regards, > Adrien > > On 1/5/21 9:27 AM, David G. Pickett via gnucash-user wrote: > > I see the same divide by 100 when I duplicate an old transaction, split, > and enter a value, then leave that cell.? It is never proper to modify > inputs without a dialog except to reformat trailing zeros after the > decimal, add comma thousands separators and similar presentation artifacts. > > > > > > -Original Message- > > From: David G. Pickett > > To: gnucash-user@gnucash.org > > Sent: Tue, Jan 5, 2021 10:18 am > > Subject: Re: Entering a sell in a stock account has magic number changer > > > > Plus, if I enter a value and tab or shift-tab, it divides it by 100.? If > I enter a number, I expect it to tay put unless there is a dialog asking my > permission to change it!! > > > > > > -Original Message- > > From: David G. Pickett > > To: gnucash-user@gnucash.org > > Sent: Tue, Jan 5, 2021 10:14 am > > Subject: Entering a sell in a stock account has magic number changer > > > > I am trying to enter my RMD sales of securities, and when I enter the > value, price or shares it gets divided by 100 gratuitously with no dialog, > and if I adjust all three numbers and accept a price change, it divides > other numbers gratuitously.? This is very counter-intuitive, frustrating, > time-wasting!? If the 3 numbers do not agree and I choose a price > recalculate, my entered shares and value should be unchanged!? This is such > a bad upgrade from past behaviors! > > > > -- > > ___ 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] USAA FSB requires newer QWIN support
I have the same issue. Downloaded online banking transactions from USAA until today. GNC 4.2 on Big Sur. Please post if you solve it. Keith ___ 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] Finance Quote never mind
Ooops. Just looked at the mailing list message in my Inbox. Problem solved. Keith ___ 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] Finance Quote fail
I am using gnc 4.4 and FQ quotes have been retrieved flawlessly. I must have broken something. Now the gnc-fq-check and gnc-fq-update fail (MacOS 11.3 Big Sur update just installed). Get Quotes in the Price Database is also grayed out, of course. The gnc-fq-update output is a bit grim: Test Summary Report --- t/00-use.t (Wstat: 512 Tests: 1 Failed: 0) Non-zero exit status: 2 Parse errors: Bad plan. You planned 19 tests but ran 1. t/currency_lookup.t (Wstat: 512 Tests: 0 Failed: 0) Non-zero exit status: 2 Parse errors: Bad plan. You planned 12 tests but ran 0. t/quote.t(Wstat: 512 Tests: 0 Failed: 0) Non-zero exit status: 2 Parse errors: Bad plan. You planned 28 tests but ran 0. Files=66, Tests=1, 8 wallclock secs ( 0.13 usr 0.11 sys + 5.99 cusr 1.25 csys = 7.48 CPU) Result: FAIL Failed 3/66 test programs. 0/1 subtests failed. make: *** [test_dynamic] Error 255 ECOCODE/Finance-Quote-1.49.tar.gz one dependency not OK (DateTime::Format::Strptime); additionally test harness failed /usr/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports ECOCODE/Finance-Quote-1.49.tar.gz root@Judys-Desktop 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 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] TD Ameritrade OFX Direct
Thanks. I'll take a look at ofx.py. I was puzzled since the wizard setup in GNC goes to a place that brings back no data. But Quicken gets both the portfolio and transactions. Anyway, I'm more of a buy and hold kind of guy, so not that much data entry. If I were a day trader it would be a bigger deal. Keith On Mon, Feb 15, 2021 at 11:44 AM David Reiser wrote: > As of late last year, Martin was going to see if he could make the > stocks/mutual funds ofx transaction work well in aqbanking. I don’t know > how far he got, since he doesn’t have any of his own accounts to test that > functionality with. > > You might not be doing anything wrong. And fixing it might not do you any > good. > > I use ofx.py to download TDAmeritrade transactions. Then File>Import in > Gnucash works, since the import function goes through libofx to parse the > transactions. Libofx has handled stock/mutual fund transactions pretty well > for me. > -- > Dave Reiser > dbrei...@icloud.com > > > > > > > On Feb 15, 2021, at 11:20 AM, Keith Bellairs wrote: > > > > Quicken is able to download brokerage account transactions from > Ameritrade. > > > > I can configure Online Banking in GNC with my user info, retrieve > accounts, > > and link the accounts to my GNC accounts. But when I try to Get > > Transactions the ameritrade server accepts my connection and returns a > HTTP > > status 400. No transactions. But Quicken sees and downloads them. > > > > Does anyone use online banking with Ameritrade? If so, what am I doing > > wrong? > > > > Keith > > > > Here's the GNC Online Banking connection Window: > > > > AqBanking v6.2.5.0stable > > Sending jobs to the bank(s) > > Sorting commands by account > > Sorting commands by account > > Sorting commands by provider > > Send commands to providers > > Send commands to provider "aqofxconnect" > > Locking customer "13" > > Sending request... > > Connecting to server... > > Resolving hostname "ofxs.ameritrade.com" ... > > IP address is "198.200.171.142" > > Connecting to "ofxs.ameritrade.com" > > Connected to "ofxs.ameritrade.com" > > Using GnuTLS default ciphers. > > TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD > > Connected. > > Sending message... > > Message sent. > > Waiting for response... > > Receiving response... > > HTTP-Status: 400 (400) > > Unlocking customer "13" > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > 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.
Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support
My USAA checking and credit card seem to be working. My users/0.conf is using this client UID: I got it from quicken's OFXlog.txt file. char clientUid="39E0E763-4E1E-4918-9528-D6EBAC94EF5D" Notably when the online action in GNC challenges for the account password the required response is now the "Access PIN". No longer the web site account password. Yet another password to track. I cannot believe its working again. Thanks everyone. Keith _ Date: Sun, 14 Feb 2021 11:12:26 -0800 From: John Ralls To: Randy Johnson Cc: gnucash-de...@gnucash.org, gnucash-user@gnucash.org Subject: Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support Message-ID: Content-Type: text/plain; charset=us-ascii Well, there's a UUID in that URL, but I just tried using it for the ClientUUID and got "The user cannot signon because he or she entered an invalid user ID or password." Using the one scraped from Quicken for MacOS and reported in https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html works. That leads me to believe that USAA is using the ClientUUID as an API key. Quicken may have registered one or many. I think the only way to find that out is for more users to set up MITMs with different versions of Quicken and retrieve the ClientUUIDs for comparison. This makes me a bit leery of publishing it on the wiki, because if Quicken or USAA catch on that it's been compromised they might change it and lock us out again. 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.
[GNC] TD Ameritrade OFX Direct
Quicken is able to download brokerage account transactions from Ameritrade. I can configure Online Banking in GNC with my user info, retrieve accounts, and link the accounts to my GNC accounts. But when I try to Get Transactions the ameritrade server accepts my connection and returns a HTTP status 400. No transactions. But Quicken sees and downloads them. Does anyone use online banking with Ameritrade? If so, what am I doing wrong? Keith Here's the GNC Online Banking connection Window: AqBanking v6.2.5.0stable Sending jobs to the bank(s) Sorting commands by account Sorting commands by account Sorting commands by provider Send commands to providers Send commands to provider "aqofxconnect" Locking customer "13" Sending request... Connecting to server... Resolving hostname "ofxs.ameritrade.com" ... IP address is "198.200.171.142" Connecting to "ofxs.ameritrade.com" Connected to "ofxs.ameritrade.com" Using GnuTLS default ciphers. TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD Connected. Sending message... Message sent. Waiting for response... Receiving response... HTTP-Status: 400 (400) Unlocking customer "13" ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] USAA FSB requires newer QWIN support
A couple of questions.
1. Where is the config file to be edited? (I'm on MacOS so a file name is
probably all I need.) Or is this all doable in the wizard?
2. Is userName my login id on the USAA website or my member number? In the
previous version it was member number, not login id.
Thanks for digging this out.
Keith
Message: 1
Date: Fri, 12 Feb 2021 22:29:36 -
From: Bob White
To: gnucash-user@gnucash.org
Cc: "gnucash-de...@gnucash.org"
Subject: Re: [GNC] USAA FSB requires newer QWIN support
Message-ID:
Content-Type: text/plain;charset=utf-8;format=flowed
I got new USAA OFX download working with GNC 4.4.1.
It's mainly a configuration task.
-- User config --
int uniqueId=""
char backendName="aqofxconnect"
char userName=""
char userId=""
char customerId=""
char country="us"
char bankCode="314074269"
int lastSessionId="0"
data {
? backend {
? ? char bankName="USAA Federal Savings Bank"
? ? char org="USAA Federal Savings Bank"
? ? char fid="67811"
? ? char serverAddr="https%3A%2F%2Fdf3cx-services.1fsapi.com
[GNC] Slow load; bogus "hang"
MacOS 11.6.1 Gnucash 4.8 45 MB sql data file Recent update to 4.8 from 4.4. Startup was deceptively slow so Mac activity monitor showed gnucash process not responding. An OS error report window showed up saying that a hung process was detected. After I closed that window guncash finished loading without error. Keith ___ 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] USAA Online Actions stopped working
I was using gnc 4.9 in MacOS Big Sur and successfully downloading checking and credit card transactions from USAA Fed Savings Bank. Just upgraded to gnc 4.11 and MacOS Monterey 12.5.1. "Get Transactions" now fails. The connection window shows the following uninformative error: Status for signon request: Success (Code 0, severity "INFO") The server successfully processed the request. Status for transaction statement request: General error (Code 2000, severity "ERROR") Error other than those specified by the remaining error codes. (Note: Servers should provide a more specific error whenever possible. Error code 2000 should be reserved for cases in which a more specific code is not available.) Unlocking customer "12" Do I need to reconfigure my Online Banking Setup? It has been working for years and I have no idea how I set it up. Is there a way to recover the setup that was working? Keith ___ 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] Fwd: USAA Online Actions stopped working
Apparently user error. Online import working fine today. -- Forwarded message - From: Keith Bellairs Date: Sun, Aug 21, 2022 at 9:36 PM Subject: USAA Online Actions stopped working To: gnucash-user email group I was using gnc 4.9 in MacOS Big Sur and successfully downloading checking and credit card transactions from USAA Fed Savings Bank. Just upgraded to gnc 4.11 and MacOS Monterey 12.5.1. "Get Transactions" now fails. The connection window shows the following uninformative error: Status for signon request: Success (Code 0, severity "INFO") The server successfully processed the request. Status for transaction statement request: General error (Code 2000, severity "ERROR") Error other than those specified by the remaining error codes. (Note: Servers should provide a more specific error whenever possible. Error code 2000 should be reserved for cases in which a more specific code is not available.) Unlocking customer "12" Do I need to reconfigure my Online Banking Setup? It has been working for years and I have no idea how I set it up. Is there a way to recover the setup that was working? Keith ___ 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] Price quotes
Thanks. The FQ update fixed it (for now, I guess). Keith On Mon, May 22, 2023 at 1:26 PM Kalpesh Patel wrote: > F::Q was updated to version 1.55 which has a fix in it, albeit most likely > short term until Yahoo shuts off that spigot. In any platform you can > install/upgrade F::Q manually. Just run following two commands in CMD or > shell > > perl -MCPAN -e shell > install Finance::Quote > > # first command will put you in the CPAN command prompt. If doing so for > first time, accept all defaults which are likely to work fine as they are > sane setting. > # second command should install module and missing dependencies, and > upgrade > any dependencies if out of date. > > > > For Windows platform this is what it should look like: > > Microsoft Windows [Version 10.0.22621.1702] > (c) Microsoft Corporation. All rights reserved. > > C:\Users\kalpesh>perl -MCPAN -e shell > Unable to get Terminal Size. The Win32 GetConsoleScreenBufferInfo call > didn't work. The COLUMNS and LINES environment variables didn't work. at > C:\Strawberry\perl\vendor\lib/Term/ReadLine/readline.pm line 410. > > cpan shell -- CPAN exploration and modules installation (v2.28) > Enter 'h' for help. > > cpan> install Finance::Quote > Database was generated on Mon, 22 May 2023 03:54:49 GMT > Finance::Quote is up to date (1.55). > > cpan>exit > C:\Users\kalpesh> > > > PS: there has been lengthy conversation about yahoo_json not working on > this > list and a workaround/temporary fix for it. BTW it is not the modules fault > that it is not working. Yahoo now requires a cookie and a matching crumb in > order for API to work properly on the back-end. > > > -Original Message- > From: Murugan Muruganandam > Sent: Monday, May 22, 2023 10:55 AM > To: Keith Bellairs ; gnucash-user email group > > Subject: Re: [GNC] Price quotes > > Keith > > you need to give more details on the GNU version and also the Finance quote > version. if you have not updated, you need to get the latest version where > the yahoo issue is fixed > > > > > Saludos Cordiales > > > Murugan > > > From: gnucash-user > on behalf of > Keith Bellairs > Sent: Sunday, May 21, 2023 3:40 PM > To: gnucash-user email group > Subject: [GNC] Price quotes > > I was using yahoo_json and it started failing to return anything. I > switched > my securities over to Alphavantage and it works. But it is an order of > magnitude slower.Any word on Yahoo? > > Keith > ___ > 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] Price quotes
I was using yahoo_json and it started failing to return anything. I switched my securities over to Alphavantage and it works. But it is an order of magnitude slower.Any word on Yahoo? Keith ___ 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] AQ Banking fail?
I have been using online actions to get transactions from USAA Fed Savings Bank for some time. Today it failed: [image: image.png] Has anyone seen updated info on using AQ banking at this bank? Gnucash 5.1 Macos Ventura 13.4 AQBanking v6.5.4.0stable Keith ___ 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.
