[GNC] AQ Banking fail?

2023-06-09 Thread Keith Bellairs
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

Re: [GNC] Price quotes

2023-05-22 Thread Keith Bellairs
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. > &g

[GNC] Price quotes

2023-05-22 Thread Keith Bellairs
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

[GNC] Fwd: USAA Online Actions stopped working

2022-08-22 Thread Keith Bellairs
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

[GNC] USAA Online Actions stopped working

2022-08-22 Thread Keith Bellairs
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

[GNC] Slow load; bogus "hang"

2021-11-13 Thread Keith Bellairs
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

[GNC] Finance Quote never mind

2021-05-01 Thread Keith Bellairs
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

[GNC] Finance Quote fail

2021-05-01 Thread Keith Bellairs
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

Re: [GNC] TD Ameritrade OFX Direct

2021-02-15 Thread Keith Bellairs
ons. 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 f

[GNC] TD Ameritrade OFX Direct

2021-02-15 Thread Keith Bellairs
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

Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support

2021-02-14 Thread Keith Bellairs
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

Re: [GNC] USAA FSB requires newer QWIN support

2021-02-13 Thread Keith Bellairs
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

Re: [GNC] USAA FSB requires newer QWIN support

2021-01-28 Thread Keith Bellairs
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:

Re: [GNC] gnucash-user Digest, Vol 214, Issue 9

2021-01-05 Thread Keith Bellairs
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

[GNC] Mac OS update

2020-11-28 Thread Keith Bellairs
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 ___

Re: [GNC] Stock Split assistant

2020-08-23 Thread Keith Bellairs
t 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 wro

[GNC] Stock Split assistant

2020-08-22 Thread Keith Bellairs
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

Re: [GNC] Stock split assistant fail

2020-08-13 Thread Keith Bellairs
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

[GNC] Stock split assistant fail

2020-08-13 Thread Keith Bellairs
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

[GNC] AppleCard OFX file

2020-03-01 Thread Keith Bellairs
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

Re: [GNC] Online Banking setup

2020-02-12 Thread Keith Bellairs
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

[GNC] Online Banking setup

2020-02-12 Thread Keith Bellairs
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,

[GNC] Apple Card exports

2020-02-05 Thread Keith Bellairs
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

[GNC] Apple Card csv

2020-02-03 Thread Keith Bellairs
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?

Re: [GNC] QFX import matching

2019-04-11 Thread Keith Bellairs
e 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 > >

Re: [GNC] QFX import matching

2019-03-30 Thread Keith Bellairs
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, >

Re: [GNC] QFX import matching

2019-03-30 Thread Keith Bellairs
gt; 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. T

Re: [GNC] MySQL

2019-03-06 Thread Keith Bellairs
sword, 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 Sav

Re: [GNC] MySQL

2019-03-06 Thread Keith Bellairs
> 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

[GNC] MySQL

2019-03-05 Thread Keith Bellairs
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

Re: [GNC] Currency Database empty

2019-02-16 Thread Keith Bellairs
s > > > > > 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 err

Re: [GNC] Currency Database empty

2019-02-16 Thread Keith Bellairs
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) > > Fi

[GNC] Currency Database empty

2019-02-16 Thread Keith Bellairs
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

Re: [GNC] accrual of property tax payments

2019-02-12 Thread Keith Bellairs
y 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: > >

[GNC] accrual of property tax payments

2019-02-10 Thread Keith Bellairs
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

[GNC] Fwd: MacOS Display

2018-09-21 Thread Keith Bellairs
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 p

[GNC] MacOS Display

2018-09-21 Thread Keith Bellairs
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

[GNC] macOS gnc 3.2

2018-08-27 Thread Keith Bellairs
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

[GNC] More Price Editor questions

2018-08-05 Thread Keith Bellairs
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

[GNC] Price Tool fail

2018-08-04 Thread Keith Bellairs
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:

Re: [GNC] Trivial feature - View zero accounts

2018-05-23 Thread Keith Bellairs
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 "

[GNC] Trivial feature - View zero accounts

2018-05-23 Thread Keith Bellairs
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

Re: Trading Accounts for Securities

2018-02-22 Thread Keith Bellairs
stribution 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

Re: Trading Accounts for Securities

2018-02-22 Thread Keith Bellairs
ZED 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 show

Trading Accounts for Securities

2018-02-21 Thread Keith Bellairs
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

Annual High Balance Report?

2018-02-07 Thread Keith Bellairs
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

Re: Price editor unbalances accounts

2017-09-05 Thread Keith Bellairs
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 &

Price editor unbalances accounts

2017-09-04 Thread Keith Bellairs
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