Re: [GNC] Finance::Quote PreRelease 1.61_03

[Fross, Michael via gnucash-user]

Thanks Bruce.  I love the fact that you release updates as you and the team
make fixes, and not wait for a larger rollup.  Much appreciated.

On Tue, Apr 30, 2024 at 10:00 PM Bruce Schuck 
wrote:

> A few more fixes and additions to Finance::Quote. For those who are
> comfortable with the interim releases, 1.61_03 has been uploaded to CPAN.
>
>
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.61_03.tar.gz
>
> Or just "BPSCHUCK/Finance-Quote-1.61_03.tar.gz" when installing via
> "cpan" or "cpanm".
>
> The Fool.pm module has been fixed (but like Yahoo, who knows for how
> long?), method "fool". For the time being, only returns data for
> securities on NYSE, Nasdaq, and OTC exchanges.
>
> A new module for US traded stocks, StockData.pm, with default method
> "stockdata". This requires an API token from https://www.stockdata.org/.
> If passed in as an environment variable, set "STOCKDATA_API_KEY" to your
> token. Once installed "perldoc Finance::Quote::StockData" will display
> more information.
>
> I also discovered that the TwelveData module was not working because the
> method "twelvedata" was not returning a value for price or last. This is
> another module that requires an API, this one from
> https://twelvedata.com/. Set environment variable "TWELVEDATA_API_KEY"
> to your token. Once installed "perldoc Finance::Quote::TwelveData" will
> display more information.
>
> Regards,
>
> Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quotes Yahoo off the rails again?

[Fross, Michael via gnucash-user]

Thanks all. Yes, I just assumed the module name was the same. I’ll check
when I’m back at my computer, but I’m sure it wo4ks.

Much appreciated.

Michael

On Sun, Apr 14, 2024 at 5:02 PM David Reiser  wrote:

> yahoo_json not YahooJSON
>
>
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> On Apr 14, 2024, at 17:03, Fross, Michael via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> Thanks Bruce for the update.  I've installed it but must be doing something
> wrong.
>
> Syntax seems to work fine for YahooWeb, but I received an error if I do the
> same command with YahooJSON.  HTTP::CookieJar::LWP is installed and up to
> date. I'm not sure how to troubleshoot this effectively.
>
> Any pointers would be appreciated.
>
> Michael
>
> *--Yahoo JSON--*
> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
> YahooJSON aapl
> Finance::Quote retrieval failed with error Failed to parse result returned
> by Finance::Quote.
> Error message:
> (1): expected value
> Result:
>
> *--Yahoo Web--*
>
>
> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
> YahooWeb aapl
> aapl:
>  method => yahooweb
>high => 178.36
>  symbol => aapl
>last => 176.55
> success => 1
>name => Apple Inc.
>  volume => 101593300
>date => 04/12/2024
>currency => USD
>open => 174.26
> low => 174.21
>exchange => NasdaqGS - NasdaqGS Real Time Price
> isodate => 2024-04-12
>
> On Sun, Apr 14, 2024 at 3:48 PM david amaral via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> Thank you.Installed on windows 11 Gnucash 5.6 flawlesly in an admin
> comand window issued the command and all went without any errors.
>
>On Sunday, April 14, 2024 at 08:45:09 AM GMT-7, Bruce Schuck <
> bsch...@asgard-systems.com> wrote:
>
> On 4/13/24 20:08:20 -0700, Bruce S wrote:
>
> There is some miscellaneous housekeeping and cleanup that needs to be
> done before pushing a final release to CPAN. Plus I had some other
> changes that I was planning for v1.60 but haven't done yet. Instead of
> v1.60, I may upload v1.59_01 tomorrow so people can at least fetch the
> fix for YahooJSON before v1.60 is uploaded and indexed by CPAN.
>
>
> Pre-release F::Q v1.59_01 has been uploaded to CPAN.
>
> To install using cpan or cpanm you must specify the path.
>
> cpan> install BPSCHUCK/Finance-Quote-1.59_01.tar.gz
>
> Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quotes Yahoo off the rails again?

[Fross, Michael via gnucash-user]

Thanks Bruce for the update.  I've installed it but must be doing something
wrong.

Syntax seems to work fine for YahooWeb, but I received an error if I do the
same command with YahooJSON.  HTTP::CookieJar::LWP is installed and up to
date. I'm not sure how to troubleshoot this effectively.

Any pointers would be appreciated.

Michael

*--Yahoo JSON--*
C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
YahooJSON aapl
Finance::Quote retrieval failed with error Failed to parse result returned
by Finance::Quote.
Error message:
(1): expected value
Result:

*--Yahoo Web--*
C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
YahooWeb aapl
aapl:
  method => yahooweb
high => 178.36
  symbol => aapl
last => 176.55
 success => 1
name => Apple Inc.
  volume => 101593300
date => 04/12/2024
currency => USD
open => 174.26
 low => 174.21
exchange => NasdaqGS - NasdaqGS Real Time Price
 isodate => 2024-04-12

On Sun, Apr 14, 2024 at 3:48 PM david amaral via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  Thank you.Installed on windows 11 Gnucash 5.6 flawlesly in an admin
> comand window issued the command and all went without any errors.
>
> On Sunday, April 14, 2024 at 08:45:09 AM GMT-7, Bruce Schuck <
> bsch...@asgard-systems.com> wrote:
>
>  On 4/13/24 20:08:20 -0700, Bruce S wrote:
>
> > There is some miscellaneous housekeeping and cleanup that needs to be
> > done before pushing a final release to CPAN. Plus I had some other
> > changes that I was planning for v1.60 but haven't done yet. Instead of
> > v1.60, I may upload v1.59_01 tomorrow so people can at least fetch the
> > fix for YahooJSON before v1.60 is uploaded and indexed by CPAN.
>
> Pre-release F::Q v1.59_01 has been uploaded to CPAN.
>
> To install using cpan or cpanm you must specify the path.
>
> cpan> install BPSCHUCK/Finance-Quote-1.59_01.tar.gz
>
> Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> 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] Can't import .qif files from quicken since latest update

[Fross, Michael via gnucash-user]

Bryan, I believe "something" is purchased when you move money into an IRA.
For me, it's a money market fund with the share price a constant $1.

Michael

On Sat, Apr 6, 2024 at 5:28 PM Bryan B.  wrote:

> I've tried several different methods to export a .qif file from quicken and
> import it into GnuCash.
>
> The process of importing the file goes fine until I reach the part where
> the actual import occurs. Then I get this type of message:
>
> "Missing QIF investment action for transaction dated 08/31/2023."
>
> Upon investigation, it would seem that these transactions are from
> automated transfers from my bank account to an IRA fund. I believe these
> are money transfers, where the money is simply transferred without
> explicitly purchasing a security, and then the security is purchased later.
>
> When I opened and examined the .qif file, and did some conversation with
> ChatGPT-4, it would seem that I would have to put a line such as
> "N***XIn***" for each of the offending transactions. I did try that, and
> GnuCash still didn't accept those transactions (that I could see).
>
> Is anyone familiar with this problem already, or have any ideas on how to
> solve it?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] GNUCash Finance Quote Error with YahooWeb

[Fross, Michael]

Hello.  A few days ago I started to get the attached error when I attempted
to download quotes with GNUCash with YahooWeb as a source.

Running direct from the command line seems to work fine:

"C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe" --verbose -Q dump
YahooWeb AAPL
aapl:
high => 185.59
 low => 181.50
 success => 1
date => 01/08/2024
name => Apple Inc.
  method => yahooweb
last => 185.56
currency => USD
 isodate => 2024-01-08
  symbol => aapl
open => 181.99
  volume => 58101744
exchange => NasdaqGS - NasdaqGS Real Time Price

I'm using the latest gnucash version (v5.5), running on Windows 11Pro, and
have F:Q 1.59 installed, and I'm using YahooWeb as the source.

I have not heard anything about this on the list, so there is a good chance
it's me.  I have changed to other sources, and MarketWatch worked for most
of my symbols, but not all.  AlphaVantage also worked until it hit its
limit.  Seems like something with YahooWeb specifically.  I'd like to keep
using it as it seems fast and all of my symbols work with it.

Happy to help figure this out.  I'll take a look at the YahooWeb.pm file
tomorrow and see what I can find.

Michael
___
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] Moving from Quicken

[Fross, Michael]

I would also add that the ability to download from your bank is VERY
dependent on the bank's support of non-Quicken downloads.  My banks, for
example, no longer allow OFX (I'm in the US) downloads unless it's Quicken.

The good news is you can test all of this out in parallel before you
make your decision.  I left Quicken 9 years ago and have been much happier
in GNUCash, but your needs may differ.

Michael

On Sun, Jan 7, 2024 at 11:11 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> But THESE are done differently in standard double entry bookkeeping.
>
> - allow me to assign a category to each transaction.
> - create categories (or import quicken categories) and assign each as tax
> deductible or not.
>
> You will be creating ACCOUNTS and these can be in a hierarchy. Thus under
> the account "expenses" you could have two children, "tax deductible" and
> "non-tax deductible". Under these you would create child accounts.
>
> I suggest at a minimum you read the tutorial about the basics of double
> entry bookkeeping. A standard "101" text would be even better. The issue is
> that there can be only ONE hierarchy of accounts (called the chart of
> accounts, aka CoA) so when you want the effect of a transaction being in
> more than one "category" you have to give the CoA a finer structure, and
> for reports on just a "category" you may need to to account selection*
>
> Michael D Novack
>
> * quicker/easier to just run the full report, export that, and edit the
> raw report data to discard what you don't want.
>
> milliken wrote:
> > I've been frustrated using Quicken for years.  Maybe GNUcash will do
> what I want.
> >
> > My list of functions is small:
> > I use Quicken for personal accounting, mainly to categorize transactions
> for tax reporting.
> > Can GNUcash do these things:
> > - import data from a Quicken QDF file as a starting point.
> > - allow downloads of transactions from my bank accounts and credit cards.
> > - allow me to assign a category to each transaction.
> > - create categories (or import quicken categories) and assign each as
> tax deductible or not.
> > - report and summarize tax deductible transaction at tax time.
> >
> > That's all I care about.
>
>
>
>
>
>
> ___
> 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] I need basic help

[Fross, Michael]

A help to me was to turn off 'Use Formal Accounting Labels" in the settings
when I started (and have never enabled that.)  I feel it is much easier to
understand for non-accounting people.


On Fri, Oct 20, 2023 at 12:53 PM Mark via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Oct 20, 2023 09:06:46 Michael or Penny Novack  >:
>
> > That might not be of much help (understanding the terms "debit" and
> "credit")
> >
> > History might, …
>
>
> My point was that you don't *have* to learn all that before GnuCash will
> be useful to you. The history *is* helpful to understand the terms fully,
> but to start using GnuCash, you can start with learning how to enter where
> the money comes from and where it goes, and learn more as you need it.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Residual Processes After Closing GnuCash

[Fross, Michael]

Thanks, I'll check them out.

On Mon, Oct 16, 2023 at 12:10 PM Glenn Fowler  wrote:

> Hi,
>
> These are builds that have commits that have improvements and bug fixes
> that will be in the next release so my opinion is that they are better.
>
> However, the fix was done on Oct 2nd so if you want to grab the build from
> Oct 3rd there are only a couple of language translations and one fix for
> the stock assistant after the official 5.4 release:
> https://github.com/Gnucash/gnucash/commits/stable
>
>
___
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] Residual Processes After Closing GnuCash

[Fross, Michael]

Hello Glenn, thank you for the suggestion.  I'm tempted to move to it,
however, as a daily build I'm wondering if it's safe enough to leverage
with something as important as my financial data.  I understand it's in the
stable daily build folder, but I get worried.

 Any thoughts?

Michael

On Mon, Oct 16, 2023 at 9:57 AM Glenn Fowler  wrote:

> What I did is you can stay on v5.4 with that fix/patch by grabbing the
> latest build from here if you don't want to downgrade:
> https://code.gnucash.org/builds/win32/stable/
>
>
> On Mon, Oct 16, 2023 at 9:52 AM Maf. King  wrote:
>
> > On Monday, 16 October 2023 14:31:10 BST Paul Kroitor wrote:
> > >
> > > This started in 5.1 and I was told that it was a known issue from 5.1
> > > through 5.3, fixed in 5.4, but I am definitely running 5.4 (from a file
> > > called gnucash-5.4-1.setup from a file downloaded Oct 15th), and the
> > issue
> > > persists. Rebooting or killing the processes solves the immediate issue
> > but
> > > the behaviour remains.
> > >
> > >
> >
> > Hi Paul.
> >
> > My recollection is that this "ghost process" issue only came to light in
> > 5.4
> > for Windows.
> >
> > looking at bug https://bugs.gnucash.org/show_bug.cgi?id=799092 my read
> is
> > that
> > it is fixed for 5.5
> >
> > hth,
> > Maf.
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash 5.4 background process left running in Windows

[Fross, Michael]

In addition to Bill's question, is there any risk?  Do those "zombie"
processes have the data file open?  I just looked and GNUCash is not
running but I had two processes running in the background.  I killed them,
but then wondered if that is something I should have done

Michael

On Fri, Sep 29, 2023 at 3:45 PM WR D  wrote:

> I am not sure if this is something new with 5.4, but I notice when I exit
> from GnuCash (windows 11), there is a background process left running.
>
> In task manager the process is called "GnuCash Program File (32 bit)" ...
> it uses 0% CPU, takes 76.9MB memory, and 0% disk.  But it is always running.
>
> The reason I found this is that I observed something was locking up one of
> the Gnucash log files - I know this because I keep by Gnucash files on
> OneDrive and I now sometimes get sync errors due to log file being "in use"
> even after I shut down Gnucash.  I assume it is the background process that
> is using a log file preventing it from being synced properly even after
> GnuCash shuts down.
>
> I also observe the online finance quote retrieval has changed with 5.4.
> Specifically, previously there was always a window frame pop-up while quote
> retrieval was happening.  Since 5.4, this no longer happens.  The retrieval
> happens but there is no window showing anywhere ... did online quote
> retrieval move to a background process perhaps.
>
> I wonder if the background process issue is related to some change in how
> GnuCash triggers online quote retrievals?
>
> I am considering to revert back to previous GnuCash version to confirm the
> background process locking issue goes away.
>
> Regards,
> Bill
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] finance Quote Not working

[Fross, Michael]

As an FYI, on my windows 11 installation, the default location where
GNUCash installs itself is:

"C:\Program Files (x86)\gnucash"

and the full path to the CLI executable is:

"C:\Program Files (x86)\gnucash\bin\gnucash-cli.exe"

For command line guys like me, these paths are just crazy

Michael

On Sun, Aug 6, 2023 at 4:23 PM David H  wrote:

> On windows you'll need the double quotes around the .exe path because of
> the space in "Program Files"
>
> i.e.   "C:\Program Files\GnuCash\gnucash-cli.exe" -V --quotes dump nseindia
> RELIANCE
>
> OR
>
> you can also open a command prompt and change directory to C:\Program
> Files\GnuCash end then just run the command without the full path name i.e.
> gnucash-cli.exe -V --quotes dump nseindia RELIANCE
>
> Cheers David H.
>
>
> On Mon, 7 Aug 2023 at 05:36, Jim DeLaHunt  wrote:
>
> > Paras:
> >
> > On 2023-08-06 01:21, Paras Desai wrote:
> > > ...I tried to run the command prompt, and I received the following
> > > message.
> > >
> > > I run command from as an administrator,  the same message received as
> > > below.
> > >
> > > gnucash-cli' is not recognized as an internal or external command,
> > > operable program or batch file.
> > >
> > This message indicates a problem not with GnuCash or Perl, but of
> > learning how to use the command prompt. The message says that Windows
> > cannot find a file named "gnucash-cli" in the current directory. You fix
> > the problem by using the full path and exact filename for the GnuCash
> > command.
> >
> > Use File Explorer to find the directory where GnuCash is installed, and
> > a file named something like "gnucash-cli.exe" in that directory. Note
> > the full file path to that directory.
> >
> > Suppose that path is:
> >
> > C:\Program Files\GnuCash\gnucash-cli.exe
> >
> > (I don't use GnuCash on Windows, so I am not sure what the exact path
> > and file name are.)
> >
> > Then in place of "gnucash-cli", use that full path and file name. For
> > instance:
> >
> > C:\Program Files\GnuCash\gnucash-cli.exe -V --quotes dump nseindia
> RELIANCE
> >
> > That should give you the output similar to my example. If you get the
> > same error message as before, then there is probably something wrong in
> > the path or the file name.
> >
> > Learning more about using the Windows command prompt is a separate task,
> > and one that will probably help you for more things than just GnuCash.
> > According to a brief web search, here are a couple of pages that explain
> > the Windows Command Prompt:
> >
> > <
> >
> https://www.makeuseof.com/tag/a-beginners-guide-to-the-windows-command-line/
> > >
> > <
> >
> https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/windows-commands
> > >
> >
> > Teaching details about the Windows command prompt is out of the scope of
> > this list. A Windows support group would be a better place to learn
> > about it.
> >
> > Best regards,
> >   —Jim DeLaHunt
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote 1.57_02 - YahooWeb gets correct trading date and fixed pricing for single char symbols

[Fross, Michael]

I suppose I should have provided a bit more information.  F:Q 1.57_02 did
not give any errors.  I'm on Windows 11 with Strawberry Perl and am using
YahooWeb and AlphaVantage.

Michael

On Tue, Jul 18, 2023 at 7:46 AM Fross, Michael  wrote:

> Hi Bruce,
>
> I had some issues yesterday evening - GNC didn't update US stock prices
> since Friday 7/14 (I upgraded after this.)  I downgraded to the released
> version (1.57) and it worked fine.  I've re-upgraded and will test when the
> markets open this morning.  I'll try to narrow it down a bit (F:Q issue,
> GNC issue?)  And of course it could just be my machine.
>
> Just an FYI - more to come...
>
> Michael
>
> On Tue, Jul 18, 2023 at 7:39 AM Richard Ullger via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> Hi Bruce,
>>
>> Just confirming there were no issues updating prices after market close
>> yesterday.
>>
>> Arch Linux
>> Gnucash 4.14
>> Finance::Quote 1.57\_02
>> yahoojson
>> yahooweb
>> mstaruk
>>
>> Regards,
>>
>> Richard
>>
>> \ Original Message 
>> On 16 Jul 2023, 21:38, Bruce Schuck < bsch...@asgard-systems.com> wrote:
>>
>> >
>> > Greetings, Another beta pre-release for F::Q v1.58 has been uploaded to
>> CPAN. The URL used by YahooWeb (yahooweb) has been changed to the date is
>> pulled from web page. The issue with some single-character symbols getting
>> bad pricing has also been fixed, and labels 'open', 'high', 'low', and
>> 'volume' have been added. Again, not a production indexed release, you can
>> still install it using CPAN. $ cpan BPSCHUCK/Finance-Quote-1.57\_02.tar.gz
>> or $ cpanm BPSCHUCK/Finance-Quote-1.57\_02.tar.gz or $ perl -MCPAN -e shell
>> cpan> install BPSCHUCK/Finance-Quote-1.57\_02.tar.gz Bruce S.
>> \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
>> gnucash-user mailing list gnucash-user@gnucash.org To update your
>> subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please
>> remember to CC this list on all your replies. You can do this by using
>> Reply-To-List or Reply-All.___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote 1.57_02 - YahooWeb gets correct trading date and fixed pricing for single char symbols

[Fross, Michael]

Hi Bruce,

I had some issues yesterday evening - GNC didn't update US stock prices
since Friday 7/14 (I upgraded after this.)  I downgraded to the released
version (1.57) and it worked fine.  I've re-upgraded and will test when the
markets open this morning.  I'll try to narrow it down a bit (F:Q issue,
GNC issue?)  And of course it could just be my machine.

Just an FYI - more to come...

Michael

On Tue, Jul 18, 2023 at 7:39 AM Richard Ullger via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi Bruce,
>
> Just confirming there were no issues updating prices after market close
> yesterday.
>
> Arch Linux
> Gnucash 4.14
> Finance::Quote 1.57\_02
> yahoojson
> yahooweb
> mstaruk
>
> Regards,
>
> Richard
>
> \ Original Message 
> On 16 Jul 2023, 21:38, Bruce Schuck < bsch...@asgard-systems.com> wrote:
>
> >
> > Greetings, Another beta pre-release for F::Q v1.58 has been uploaded to
> CPAN. The URL used by YahooWeb (yahooweb) has been changed to the date is
> pulled from web page. The issue with some single-character symbols getting
> bad pricing has also been fixed, and labels 'open', 'high', 'low', and
> 'volume' have been added. Again, not a production indexed release, you can
> still install it using CPAN. $ cpan BPSCHUCK/Finance-Quote-1.57\_02.tar.gz
> or $ cpanm BPSCHUCK/Finance-Quote-1.57\_02.tar.gz or $ perl -MCPAN -e shell
> cpan> install BPSCHUCK/Finance-Quote-1.57\_02.tar.gz Bruce S.
> \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
> gnucash-user mailing list gnucash-user@gnucash.org To update your
> subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please
> remember to CC this list on all your replies. You can do this by using
> Reply-To-List or Reply-All.___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Yahoo Closed the Door on Finance API

[Fross, Michael]

You are correct Paul, but Yahoo-json has still been working.

On Fri, Jul 14, 2023 at 3:40 AM Paul Feakins  wrote:

> On 14/07/2023 05:14, Bruce Schuck wrote:
> > Some of us suspected this would come, getting reports of the Yahoo URL
> >
> https://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
> > and
> >
> https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
> > now returning a 404 (v11) or "Unauthorized" (v10).
> >
> > Sorry to say this, but more than likely the YahooJSON module (aka
> > yahoo_json) is going to be removed from Finance::Quote in the next
> > release. This is not to say that if someone can figure out a way to
> > successfully access Yahoo's https://query2.finance.yahoo.com/v?...
> > APIs, please pass on that info or better yet, have a go at reworking
> > the current module.
> >
> > There is already an issue raised on F::Q's GitHub,
> > https://github.com/finance-quote/finance-quote/issues/318. Please
> > refrain from "me too" comments. Unfortunately as I said in the
> > previous paragraph, this issue will likely be resolved by removing the
> > module.
> >
> As far as I know, and I may be wrong, this was shut down many years ago?
>
> Paul Feakins.
>
> ___
> 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] Two Instances as opposed to two separate files

[Fross, Michael]

I  run multiple instances at the same time, but you have to open different
data files. I’d keep them in different directories to be tidy.

I have two different icons each with a different name of the data file as
an argument.

There is a an argument to not auto open the last file(no -file?). I’m not
near my computer.

As a note, I don’t change any settings that are program wide with both
running.

Michael

On Fri, Jul 14, 2023 at 3:05 AM Paul Feakins  wrote:

>
> >
> >>
> >>> Question about a matter of setup.  I use Windows 11 - so
> >>> answers/information specific to that OS would be appreciated.
> >>>
> >>> First - can two instances of the program be loaded (exist in the
> system)
> >>> such that one instance opens a personal file and one opens a business
> file?
> >>> Second - if answer to question one is yes - is this a preference you
> can
> >>> set and are there advantages to doing it?
> >>> Third - if answer to question one is no - then is the only way to have
> >>> two separate data files is to load the program and force load the
> specific
> >>> file you want since the program always default opens to the last file
> you
> >>> dealt with?
> >>>
> >>> Answers, opinions and other information welcomed.  Thanks!  -- Ken
>
> I think you're overcomplicating this.
>
> If you want to load a specific .gnucash file then double-click it.
>
> Paul.
>
> ___
> 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] Maintain two accounts in same machine

[Fross, Michael]

Hello N.Srinivasan,

GNUCash supports an argument where you can simply specify the desired
.gnucash file.  I'm on windows, and I simply set up two GNUCash "icons",
each with a different .gnucash file as it's argument.  The lock files are
distinct and I don't believe there is any risk to having them both open.  I
do store the different files in different directories.

Is that what you are asking?

Michae

On Sat, Jul 1, 2023 at 8:01 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 7/1/2023 5:47 AM, Sergey Mende wrote:
> > You could try to `set HOME` environment variable in a batch file followed
> > by gnucash invocation. According to
> https://docs.gtk.org/gtk3/running.html
> > a gtk app should inspect it on Windows as well.
> > I can't verify this as I have no Windows, so please share your results.
> >
> > Sergey
> >
> Remember, if the question is "same machine" as opposed to "within the
> same user log in" this is trivial as separate data areas for each "user"
> *the computer does not "know" one human has multiple log ins.
>
> But we are probably correct that the person did not mean ask about "same
> machine" but "within the same log in"
>
> Michael D Novack
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Backup

[Fross, Michael]

GNUCash does backups by default if you use XML.  Every time you save there
is a backup made.  It sits in the same directory as your main data file (I
wish you could specify a specific folder.)

However, what the folks on this chain are talking about is a backup of
those files in case the hard drive fails or gets corrupted.  So, yes the
program creates backups, but you really need more than that.

Michael

On Wed, Jun 28, 2023 at 9:14 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 6/28/2023 7:18 AM, Maf. King wrote:
> > Hi James,
> >
> > I'm Maf, not David, and I can't tell you that from here.
> >
> > I would suggest that on a philosophical level, if you don't *know* that
> your
> > back-up strategy is working (and you can recover files from it at will),
> then
> > it might be time to rethink your strategy.
> >
> > good luck,
> > Maf.
> >
> And I strongly suggest that your backup strategy simply back up all your
> user data (and individually). In other words, back up the entire
> directory or directories (if not simply doing your user directory). Why?
>
> a) It is less work to set up. Might take a bit more space, but these
> days space is CHEAP.
>
> b) There will be no question whether some bit of data has been backed
> up. That's the risk when specifying file by file (or subdirectory by
> subdirectory). You might forget to add a new one.
>
> c) The structure will be the same in the backup as on the computer.
> Makes it easy to find if doing a restore of just one file, etc.
>
> d)  Relatively quick to make a second copy (of the first backup) to be
> stored safely elsewhere. For example, you might be making daily/weekly
> backups keeping the last N of them but make a second copy of the last
> each month and keep that "off site".
>
> e) I strongly suggest you include in the name of each backup directory
> the Julian date << from a person who in my working days experienced the
> hell week when a file was restored from the wrong backup at one of the
> world's larger "financials". And what got me my second big
> bonus/recognition and being made "honorary systems support" in the
> aftermath for devising a system to prevent that from ever happening again.
>
> Michael D Novack --- who had a house fire in 2006 that burned just the
> room computers were in but smoke/water damage affected backups kept
> elsewhere in the house. These now "live" in a fire box inside a dead
> fridge out in the barn/garage.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation

[Fross, Michael]

Hi Bruce.  I echo Murugan's comments - thank you and the team.

I've been using it the last few days with yahoo_JSON.  No issues.  I'll
have to try out a few of the others as I also think our days of using Yahoo
are very numbered.

Michael

On Fri, Jun 16, 2023 at 12:27 PM Bruce Schuck 
wrote:

> On 6/16/23 10:12 AM, Murugan Muruganandam wrote:
>
> > i checked YahooWeb module with different combinations including
> > symbols with .extensions , all the quotes were fetched correctly.
>
> Awesome, thank you for the response.
>
> Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote Status

[Fross, Michael]

Hi Bruce,

I installed 1.55_01 and switched my securities back to Yahoo_JSON.  I
didn't receive any errors after retrieving and it looked like all of the
securities had an updated date of Friday 5/26/2023.  Whoo hoo.  The totals
also compared correctly to my brokerage account.

I'll give the TwelveData a test later this weekend.

I'm on Windows 11 with GnuCash v5.1.

Thank you and kind regards,

Michael

On Sat, May 27, 2023 at 5:24 PM Bruce Schuck 
wrote:

> On 5/27/23 14:39, Fross, Michael wrote:
>
> > Thank you Bruce for the updates, and all the hard work.  Good news.
>
> Mostly I was just the gatekeeper on this, except needing to resolve a
> bunch of conflicts before merging a pull request (and some minor code
> tweaks).
>
> For those willing to test upcoming changes, a pre-release is available
> at
>
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.55_01.tar.gz
> .
>
> In CPAN one can install "BPSCHUCK/Finance-Quote-1.55_01.tar.gz".
>
> This does include the new TwelveData module (securities only, no
> currency exchange rates yet and needs an API key) in addition to the
> Yahoo fix.
>
> > On Sat, May 27, 2023 at 1:47 PM Bruce Schuck  > <mailto:bsch...@asgard-systems.com>> wrote:
>
> > The F::Q team hopes to push v1.56 to CPAN before the end of the U.S.
> > holiday weekend.
>
> Thank you.
>
> Bruce S.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote Status

[Fross, Michael]

Thank you Bruce for the updates, and all the hard work.  Good news.

Michael

On Sat, May 27, 2023 at 1:47 PM Bruce Schuck 
wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> The F::Q team hopes to push v1.56 to CPAN before the end of the U.S.
> holiday weekend.
>
> The Yahoo fix will be included, let's hope that Yahoo does not pull the
> plug on it for a while. Thank you to Paolo Maero for quickly
> contributing fixes for both the securities data and recently added
> currency exchange module that uses Yahoo.
>
> Also thanks to Vincent Lucarelli for contributing a new module that uses
> the TwelveData api (https://twelvedata.com). It's another one that
> requires an API key, but their free key allows 8 queries per minute. A
> bit better than the AlphaVantage throttling. I am not sure if will have
> a related currency rate module ready, but there is some cleanup I found
> needs to be done before it can be included. So while it may not make
> v1.56, it should definitely be in v1.57. In any case, sign up and get
> your API key now so you have it ready for when the module is released.
>
> Thank you.
>
> Bruce S.
> -BEGIN PGP SIGNATURE-
>
> iHkEARECADkWIQRzL0H5rBaeDPnpeL1IjAeprJFQBwUCZHJPvBscYnNjaHVja0Bh
> c2dhcmQtc3lzdGVtcy5jb20ACgkQSIwHqayRUAeV3ACg04d9QeQjxksH3RMyiGdv
> qGYe854AoMLy6MI0HsX0qq+GB2/e7qGzpHod
> =reC9
> -END PGP SIGNATURE-
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[Fross, Michael]

Thanks Bruce.  Worked great calling the v6 version of the API.

On Sat, May 6, 2023 at 2:13 PM Bruce Schuck 
wrote:

> Ken,
>
> I am currently evaluating which of the alternatives is the best
> replacement. I'm also a little hopeful that in the meantime the
> functionality of the current URL/API is restored before the time is
> spent to not only make the changes, but the related housekeeping
> necessary before pushing an official release to CPAN.
>
> In the mean time, for those savvy enough to find and edit the
> YahooJSON.pm file on their system, a quick fix is to change this line:
>
> my $YIND_URL_HEAD =
> 'https://query1.finance.yahoo.com/v7/finance/quote?symbols=';
>
> to:
>
> my $YIND_URL_HEAD =
> 'https://query1.finance.yahoo.com/v6/finance/quote?symbols=';
>
> Be wary that there may be multiple versions of the YahooJSON.pm file and
> a system, so be certain to modify the correct one.
>
> - Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How do I reply to a topic?

[Fross, Michael]

And I send them to a "gnucash-user" folder in gmail so they don't clog up
my inbox.

On Wed, May 3, 2023 at 10:04 AM R Losey  wrote:

> This is why I have these sent to gmail, which has plenty of room.
>
> On Tue, May 2, 2023 at 6:18 PM Ken Farley  wrote:
>
> > I have my account settings on the mail list to not send me any of the
> > topics directly. Instead, I prefer to browse through the discussions via
> > the following link:
> >
> > https://lists.gnucash.org/pipermail/gnucash-user/
> >
> > When I see a discussion I want to reply to, I click on the e-mail
> > address of the message I'm currently viewing, and am automatically taken
> > to my e-mail program with the To: field already filled in with
> > "gnucash-user@gnucash.org", subject Re: the topic I was looking at,, and
> > I just have to type my message (like this one) and send.
> >
> > I didn't like getting all the e-mails spewed into my mailbox - probably
> > less than 5% of them were something I would be interested in, due to my
> > particular use of the software, etc. Plus if I don't check my mail
> > diligently it would be packed with so much stuff...
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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 Quote IEXCloud

[Fross, Michael]

Thanks Murugan.   I never looked at the "Unknown" area in the
security editor.  I also use this on my command line quote program Quoter
<https://github.com/frossm/quoter>.  However, while it works great for my
US stocks, it doesn't seem to pull my mutual funds (i.e. FGILX).

I am glad YahooJSON appears to be working again, although who knows for how
long.

You've been really helpful - thank you.

Michael

On Fri, Apr 21, 2023 at 9:41 AM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> michael
>
> just got a free api key and tried the IEXCloud and it work perfectly no
> need to change any code
> enable get online quote ->select quote source as unknown -> choose
> iexcloud from drop down
>
> make sure you update environment file with IEXCLOUD_API_KEY
>
> good luck
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Murugan Muruganandam <
> m.muruganan...@hotmail.com>
> *Sent:* Friday, April 21, 2023 10:01 AM
> *To:* Fross, Michael ; Frank H. Ellenberger <
> frank.h.ellenber...@gmail.com>
> *Cc:* Gnucash 
> *Subject:* Re: [GNC] Price Quote IEXCloud
>
> michael
>
> There is already a unit available with file name IEXCloud.pm, i suggest
> you review the code and make it work and not rewrite the whole. you have to
> put in your IEXCLOUD_API_KEY in the environment variable just incase.
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> ____
> From: gnucash-user  hotmail@gnucash.org> on behalf of Murugan Muruganandam <
> m.muruganan...@hotmail.com>
> Sent: Thursday, April 20, 2023 11:26 AM
> To: Fross, Michael ; Frank H. Ellenberger <
> frank.h.ellenber...@gmail.com>
> Cc: Gnucash 
> Subject: Re: [GNC] Price Quote IEXCloud
>
> hi Michael
>
> I have done a package to pull mutual funds price , you can check the
> following link for reference
>
> https://github.com/Murugan-CL/gnucash-chile-mutual-fund-quote
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user  hotmail@gnucash.org> on behalf of Fross, Michael 
> Sent: Thursday, April 20, 2023 9:47 AM
> To: Frank H. Ellenberger 
> Cc: Gnucash 
> Subject: Re: [GNC] Price Quote IEXCloud
>
> Well that's embarrassing - I never looked at "Unknown" before.  I'll give
> it a shot.
>
> Michael
>
> On Thu, Apr 20, 2023 at 7:48 AM Frank H. Ellenberger <
> frank.h.ellenber...@gmail.com> wrote:
>
> > Isn't it  available, if you set "Type of Quote Source" to "unknown"?
> >
> > Am 20.04.23 um 14:19 schrieb Fross, Michael:
> > > I see there is a F::Q module for IEXCloud.  I've used this with an open
> > > source program I wrote to pull down quotes from the command line
> > > successfully.  However I don't see a way for a user to do this in
> > GNUCash.
> > > Is there a way to configure GNUCash to select other F::Q modules?
> > >
> > > Regards,
> > >
> > > Michael
> > >
> > > On Thu, Apr 20, 2023 at 7:14 AM Frank H. Ellenberger <
> > > frank.h.ellenber...@gmail.com> wrote:
> > >
> > >> Hi,
> > >>
> > >> nice to see you found a workaround.
> > >> The answer to your original posting is in
> > >>
> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106571.html
> > >>
> > >> Regrds
> > >> Frank
> > >>
> > >> Am 20.04.23 um 04:55 schrieb Steve Miller:
> > >>> Re the price quote issue w yahoo json, in the big picture is no
> biggie,
> > >>> cause alphaadvantage seems to work just fine, so will just switch all
> > >> over
> > >>> tomorrow to that source...
> > >>>
> > >>> On Wed, Apr 19, 2023 at 7:06 PM Steve Miller <
> > >> srmnonessential2...@gmail.com>
> > >>> wrote:
> > >>>
> > >>>> Running Version: 4.14
> > >>>> Build ID: 4.14+(2023-03-25)
> > >>>> Finance::Quote: 1.53
> > >>>>
> > >>>> *Never, ever got this before... did something break???  I've changed
> > >>>> nothing!  Help!  Have always used Yahoo json...*
> > >>>>
> > >>>> [image: Screenshot 2023-04-19 190342.png]
> > >>>>
> > >>>
> > >>>
> > >>> ___
> > >>> gnucash

Re: [GNC] Price Quote IEXCloud

[Fross, Michael]

Well that's embarrassing - I never looked at "Unknown" before.  I'll give
it a shot.

Michael

On Thu, Apr 20, 2023 at 7:48 AM Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Isn't it  available, if you set "Type of Quote Source" to "unknown"?
>
> Am 20.04.23 um 14:19 schrieb Fross, Michael:
> > I see there is a F::Q module for IEXCloud.  I've used this with an open
> > source program I wrote to pull down quotes from the command line
> > successfully.  However I don't see a way for a user to do this in
> GNUCash.
> > Is there a way to configure GNUCash to select other F::Q modules?
> >
> > Regards,
> >
> > Michael
> >
> > On Thu, Apr 20, 2023 at 7:14 AM Frank H. Ellenberger <
> > frank.h.ellenber...@gmail.com> wrote:
> >
> >> Hi,
> >>
> >> nice to see you found a workaround.
> >> The answer to your original posting is in
> >> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106571.html
> >>
> >> Regrds
> >> Frank
> >>
> >> Am 20.04.23 um 04:55 schrieb Steve Miller:
> >>> Re the price quote issue w yahoo json, in the big picture is no biggie,
> >>> cause alphaadvantage seems to work just fine, so will just switch all
> >> over
> >>> tomorrow to that source...
> >>>
> >>> On Wed, Apr 19, 2023 at 7:06 PM Steve Miller <
> >> srmnonessential2...@gmail.com>
> >>> wrote:
> >>>
> >>>> Running Version: 4.14
> >>>> Build ID: 4.14+(2023-03-25)
> >>>> Finance::Quote: 1.53
> >>>>
> >>>> *Never, ever got this before... did something break???  I've changed
> >>>> nothing!  Help!  Have always used Yahoo json...*
> >>>>
> >>>> [image: Screenshot 2023-04-19 190342.png]
> >>>>
> >>>
> >>>
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price Quotes

[Fross, Michael]

I see there is a F::Q module for IEXCloud.  I've used this with an open
source program I wrote to pull down quotes from the command line
successfully.  However I don't see a way for a user to do this in GNUCash.
Is there a way to configure GNUCash to select other F::Q modules?

Regards,

Michael

On Thu, Apr 20, 2023 at 7:14 AM Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Hi,
>
> nice to see you found a workaround.
> The answer to your original posting is in
> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106571.html
>
> Regrds
> Frank
>
> Am 20.04.23 um 04:55 schrieb Steve Miller:
> > Re the price quote issue w yahoo json, in the big picture is no biggie,
> > cause alphaadvantage seems to work just fine, so will just switch all
> over
> > tomorrow to that source...
> >
> > On Wed, Apr 19, 2023 at 7:06 PM Steve Miller <
> srmnonessential2...@gmail.com>
> > wrote:
> >
> >> Running Version: 4.14
> >> Build ID: 4.14+(2023-03-25)
> >> Finance::Quote: 1.53
> >>
> >> *Never, ever got this before... did something break???  I've changed
> >> nothing!  Help!  Have always used Yahoo json...*
> >>
> >> [image: Screenshot 2023-04-19 190342.png]
> >>
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[Fross, Michael]

I hope they've not removed it as a free data source.  That would be a shame.

Michael

On Wed, Apr 19, 2023 at 5:29 PM David H  wrote:

> Yes, I also saw the same error this morning.
>
> Cheers David H.
>
>
> On Thu, 20 Apr 2023 at 06:46, Fross, Michael  wrote:
>
>> I'm seeing the exact same situation, Murugan.  This worked yesterday so
>> something must have changed today.
>>
>> Switching to v6 in YahooJSON.pm fixed the issue for now, but not a good
>> long term solution.
>>
>> Michael
>>
>> On Wed, Apr 19, 2023 at 3:38 PM Murugan Muruganandam <
>> m.muruganan...@hotmail.com> wrote:
>>
>> > Today when i ran get quote got the following error message
>> >
>> > Finance::Quote reported a failure for symbol acn: Error retrieving quote
>> > for acn. Attempt to fetch the URL
>> > https://query1.finance.yahoo.com/v7/finance/quote?symbols=acn resulted
>> in
>> > HTTP response 401 (Unauthorized)
>> >
>> > When i queried the url i got the same error, if i change to v6 instead
>> of
>> > v7 , it is providing me the quotes correctly both in browser and in GNU
>> > (changed it in YahooJSON.pm)
>> >
>> > is this temperory or only happening to me?
>> >
>> >
>> > Saludos Cordiales
>> >
>> >
>> > Murugan
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[Fross, Michael]

I'm seeing the exact same situation, Murugan.  This worked yesterday so
something must have changed today.

Switching to v6 in YahooJSON.pm fixed the issue for now, but not a good
long term solution.

Michael

On Wed, Apr 19, 2023 at 3:38 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> Today when i ran get quote got the following error message
>
> Finance::Quote reported a failure for symbol acn: Error retrieving quote
> for acn. Attempt to fetch the URL
> https://query1.finance.yahoo.com/v7/finance/quote?symbols=acn resulted in
> HTTP response 401 (Unauthorized)
>
> When i queried the url i got the same error, if i change to v6 instead of
> v7 , it is providing me the quotes correctly both in browser and in GNU
> (changed it in YahooJSON.pm)
>
> is this temperory or only happening to me?
>
>
> Saludos Cordiales
>
>
> Murugan
> ___
> 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] GNC 5.0 Online Quotes Not Working

[Fross, Michael]

Thanks for the link Murugan.  I don't believe these are official releases,
so I'm assuming they may not have gone through all of the standard testing
/ reviews normally associated with a release.

I wonder if my fear is unfounded or if my assumption is even true...

Michael

On Tue, Apr 18, 2023 at 2:44 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> Adam
>
> this issue was fixed in the later releases, download and install the
> following release
>
>
> https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user  hotmail@gnucash.org> on behalf of Adam Griffis  >
> Sent: Tuesday, April 18, 2023 3:35 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] GNC 5.0 Online Quotes Not Working
>
> Hi All,
>
> GNC 5.0
> Finance::Quote 1.54
> Windows 11
>
> I sent this earlier today, but it wasn't from the account I was
> subscribed with so I'm not sure what happened to it. Sending --
> hopefully that's not an issue.
>
> I upgraded from 4.13 to 5.0, and now my online quotes functionality is
> not working correctly. When I run it from the price database window,
> you can see the cmd prompt open, but then it closes almost
> immediately.
>
> After running it, it DOES update one currency item (EUR), but none of
> the stocks get updated. In the security editor window, it shows what
> source is currently selected, but in the dropdown to change the
> source, everything is grayed out and can't be changed.
>
> I've also tried running it from the command line but with no success.
>
> Please see screenshots.
>
> Thanks!
> Adam
> ___
> 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] set up Gnucash on a new device

[Fross, Michael]

Hello Christopher - I don't think it's an executable.  Windows is trying to
find the program to open it with and can't find it in the store.  I'd
re-download it from the official store and turn on extension visibility per
David H.'s comment and try again.

Michael

On Mon, Apr 10, 2023 at 7:06 AM David H  wrote:

> Glenn
>
> Is it though?  That possibly depends on whether show file extensions is on
> or off.
>
> Cheers David Halverson
>
> On Mon, 10 Apr 2023 at 21:46, Glenn Fowler  wrote:
>
> > Hi,
> >
> > It's missing the ".exe* in the file name. Did you save it like that or
> did
> > you download it from a different source other than github or sourceforge?
> >
> >
> > On Mon, Apr 10, 2023, 6:51 AM Christopher Smallman via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> > > I am trying to find help with setting up my GnuCash programme on a new
> > > Windows 11  laptop.
> > >
> > > I have downloaded the correct version for Windows 11 but the exe. file
> > > will not open. I am being asked to search for an App in the store.
> >  There
> > > is of course no App in the store. How can I   successfully run
> > the
> > > programme? Screen shot of the message is attached
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Issues Retrieving Quotes with v5.0

[Fross, Michael]

So it sounds like this might be a Windows issue with retrieving quotes (I'm
running that latest v11).  I believe perl and the correct modules are
installed (Worked under v4.13 and I installed JSON::Parse) and it works
with the gnucash-cli, but just not within the program.

Happy to help troubleshoot if I can be of assistance.

Have a great day all.

Michael

On Wed, Mar 29, 2023 at 10:43 AM R Losey  wrote:

> I found the problem; I thought I had switched everything over to use JSON
> for prices, but I still had some using Alpha Vantage, and I don't have my
> key in the iMac version of GnuCash. Once I switched the few remaining
> items, the update is working fine.
>
>
> On Wed, Mar 29, 2023 at 10:18 AM R Losey  wrote:
>
> > Yes, I have an M1 iMac.
> >
> > Getting the right JSON::Parse for my architecture was what was needed...
> I
> > get data now.
> >
> > But it didn't give me the "want x86_64, have amd64" error... it just said
> > it wasn't installed.
> >
> > Checking with GnuCash...better; not greyed out, but not working properly.
> > I think something is failing, so it just stops on the others. I probably
> > need to figure out where the log file is to find out which item it cannot
> > get.
> >
> >
> > On Tue, Mar 28, 2023 at 1:34 PM David Reiser 
> wrote:
> >
> >> Is your iMac an Apple Silicon (M1) machine? It’s possible to get mixed
> >> architecture perl modules installed. If your gnucash-cli -Q error
> included
> >> something like “want x86_64, have amd64”, then you definitely have an
> >> incompatible version of JSON::Parse. The way around that is to enter (in
> >> Terminal):
> >>
> >> sudo arch -arch x86_64 cpan -f JSON::Parse
> >>
> >> After that finishes, since gnucash-cli quits at the first error, you
> need
> >>  to run gnucash-cli -Q again — both to ensure that the right
> architecture
> >> JSON::Parse got installed, and to check if there are any other perl
> errors.
> >>
> >> If necessary, run the above command repeatedly, substituting any new
> >> module names from arch-related error messages. When gnucash-cli -Q runs
> >> without complaint, you should be able to get quotes within gnucash 5.0
> >>
> >> Dave
> >> --
> >> Dave Reiser
> >> dbrei...@icloud.com
> >>
> >>
> >>
> >>
> >>
> >> On Mar 28, 2023, at 1:27 AM, R Losey  wrote:
> >>
> >> David, thank you.
> >>
> >> I did this on my iMac; it ran a LONG time with LOTS of output, and
> >> installed the development tools, but finally finished. Even though I'm a
> >> software engineer, it was kind of scary.
> >>
> >> But the "Get Quotes" is still greyed out, even though I ran the
> >> gnc-fq-update...
> >>
> >> When I attempt the gnucash-cli command, it fails, stating that
> >> Finance::Quote is missingcthe JSON::Parse module
> >>
> >>
> >> On Mon, Mar 27, 2023 at 3:49 PM David H  wrote:
> >>
> >> Michael,
> >>
> >> Is your "Get Quotes" button in Gnucash also greyed out?  I had to run
> >> gnc-fq-update in /Applications/Gnucash.app/Contents/Resources/bin in the
> >> terminal on macOS and let it update and then start Gnucash before the
> >> button became active. Same in windows 11 pro - open a command prompt as
> >> Administrator and use the command perl "C:\Program Files
> >> (x86)\gnucash\bin\gnc-fq-update" - you need the double quotes around the
> >> path because of the space in the path. After I did this it all seemed
> ok.
> >>
> >> Hope this helps,
> >>
> >> Cheers David H.
> >>
> >>
> >>
> >> On Tue, 28 Mar 2023 at 06:24, Fross, Michael  wrote:
> >>
> >> Hello everyone,
> >>
> >> I'm looking for a few pointers on how to troubleshoot an issue I'm
> having
> >> with v5 downloading quotes.  I had no issues with v4.13.  When I select
> >> "Tools|Price Database|GetQuotes" a shell opens and closes quickly and
> >> nothing is updated.
> >>
> >> I don't seem to have any issues with gnucash-cli.  Here are the results:
> >> ---
> >> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
> >> yahoo_json acn
> >> acn:
> >> isodate => 2023-03-27
> >> low => 270.64
> >>type => EQUITY
> >>name => acn (Accenture plc)
> >> 

Re: [GNC] Issues Retrieving Quotes with v5.0

[Fross, Michael]

Hello Murugan,

I've reinstalled Gnucash 5.  gnucash-cli.exe continues to work.
Actions|Stock Assistance is greyed out.  I still can't  update the quote
source in the security editor (greyed out) and doing an update flashes the
shell, but no updates are made.

Michael

On Tue, Mar 28, 2023 at 12:39 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> please discard my query, i did not read the instructions fully, i was able
> to use the same in Stock register.
>
> You can access it from Actions>Stock Assistant when the focus tab is the
> Accounts page or a Stock or Fund account register.
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Murugan Muruganandam <
> m.muruganan...@hotmail.com>
> *Sent:* Tuesday, March 28, 2023 2:04 PM
> *To:* Fross, Michael 
> *Cc:* Gnucash-User 
> *Subject:* Re: [GNC] Issues Retrieving Quotes with v5.0
>
> Also can you please check and confirm if you are able to access Stock
> Assistant from Actions menu,  it was appearing greyed out earlier , but
> after multiple install it has disappeared.
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: Fross, Michael 
> Sent: Monday, March 27, 2023 8:08 PM
> To: Murugan Muruganandam 
> Cc: Gnucash-User 
> Subject: Re: [GNC] Issues Retrieving Quotes with v5.0
>
> Hello David - yes the button is enabled.
>
> Thank you Murugan.  It's nice to know it's not just my crazy machine.
>
> Saludos Cordiales!
>
> Michael
>
> On Mon, Mar 27, 2023 at 5:34 PM Murugan Muruganandam <
> m.muruganan...@hotmail.com<mailto:m.muruganan...@hotmail.com>> wrote:
> hi Michael
>
> i have already logged a bug as i have also the same issue
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user  hotmail@gnucash.org<mailto:hotmail@gnucash.org>> on behalf of
> Fross, Michael mailto:mich...@fross.org>>
> Sent: Monday, March 27, 2023 5:20 PM
> To: Gnucash-User mailto:gnucash-user@gnucash.org
> >>
> Subject: [GNC] Issues Retrieving Quotes with v5.0
>
> Hello everyone,
>
> I'm looking for a few pointers on how to troubleshoot an issue I'm having
> with v5 downloading quotes.  I had no issues with v4.13.  When I select
> "Tools|Price Database|GetQuotes" a shell opens and closes quickly and
> nothing is updated.
>
> I don't seem to have any issues with gnucash-cli.  Here are the results:
> ---
> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
> yahoo_json acn
> acn:
>  isodate => 2023-03-27
>  low => 270.64
> type => EQUITY
> name => acn (Accenture plc)
>   pe => 25.180145
> exchange => Sourced from Yahoo Finance (as JSON)
>  eps => 10.88
> currency => USD
>   method => yahoo_json
>  success => 1
>   volume => 2805531
>close => 272
> date => 03/27/2023
>   year_range =>242.8 - 345.3
> last => 273.96
> open => 270.73
>div_yield => 1.5919117
>   symbol => acn
> high => 274.36
> ---
>
> Running gnucash with the "--log gnc.scm=debug"  shows the following error:
>
> * 15:11:29 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price
> retrieval failed: Failed to parse result returned by Finance::Quote.
> Error message:
> (1): expected value
>
>
> To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
> itself does not.
>
> I have Finance::Quote: 1.54 installed and it shows this in Help | About
>
> Lastly, if I check the security editor, it seems like every quote provider
> is greyed out.  This woudl suggest to me that gnucash doesn't think there
> is a valid Finance::Quote configured.
>
> I'd appreciate any pointers on how to dig deeper and determine what broke
> for me between 4.13 and 5.0.  Is anyone else having issues?
>
> I'm enjoying v5 quite a bit - congrats on the release.
>
> Michael
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Issues Retrieving Quotes with v5.0

[Fross, Michael]

Hello David - yes the button is enabled.

Thank you Murugan.  It's nice to know it's not just my crazy machine.

Saludos Cordiales!

Michael

On Mon, Mar 27, 2023 at 5:34 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> hi Michael
>
> i have already logged a bug as i have also the same issue
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail....@gnucash.org> on behalf of Fross, Michael 
> *Sent:* Monday, March 27, 2023 5:20 PM
> *To:* Gnucash-User 
> *Subject:* [GNC] Issues Retrieving Quotes with v5.0
>
> Hello everyone,
>
> I'm looking for a few pointers on how to troubleshoot an issue I'm having
> with v5 downloading quotes.  I had no issues with v4.13.  When I select
> "Tools|Price Database|GetQuotes" a shell opens and closes quickly and
> nothing is updated.
>
> I don't seem to have any issues with gnucash-cli.  Here are the results:
> ---
> C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
> yahoo_json acn
> acn:
>  isodate => 2023-03-27
>  low => 270.64
> type => EQUITY
> name => acn (Accenture plc)
>   pe => 25.180145
> exchange => Sourced from Yahoo Finance (as JSON)
>  eps => 10.88
> currency => USD
>   method => yahoo_json
>  success => 1
>   volume => 2805531
>close => 272
> date => 03/27/2023
>   year_range =>242.8 - 345.3
> last => 273.96
> open => 270.73
>div_yield => 1.5919117
>   symbol => acn
> high => 274.36
> ---
>
> Running gnucash with the "--log gnc.scm=debug"  shows the following error:
>
> * 15:11:29 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price
> retrieval failed: Failed to parse result returned by Finance::Quote.
> Error message:
> (1): expected value
>
>
> To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
> itself does not.
>
> I have Finance::Quote: 1.54 installed and it shows this in Help | About
>
> Lastly, if I check the security editor, it seems like every quote provider
> is greyed out.  This woudl suggest to me that gnucash doesn't think there
> is a valid Finance::Quote configured.
>
> I'd appreciate any pointers on how to dig deeper and determine what broke
> for me between 4.13 and 5.0.  Is anyone else having issues?
>
> I'm enjoying v5 quite a bit - congrats on the release.
>
> Michael
> ___
> 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] Issues Retrieving Quotes with v5.0

[Fross, Michael]

Hello everyone,

I'm looking for a few pointers on how to troubleshoot an issue I'm having
with v5 downloading quotes.  I had no issues with v4.13.  When I select
"Tools|Price Database|GetQuotes" a shell opens and closes quickly and
nothing is updated.

I don't seem to have any issues with gnucash-cli.  Here are the results:
---
C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --verbose -Q dump
yahoo_json acn
acn:
 isodate => 2023-03-27
 low => 270.64
type => EQUITY
name => acn (Accenture plc)
  pe => 25.180145
exchange => Sourced from Yahoo Finance (as JSON)
 eps => 10.88
currency => USD
  method => yahoo_json
 success => 1
  volume => 2805531
   close => 272
date => 03/27/2023
  year_range =>242.8 - 345.3
last => 273.96
open => 270.73
   div_yield => 1.5919117
  symbol => acn
high => 274.36
---

Running gnucash with the "--log gnc.scm=debug"  shows the following error:

* 15:11:29 ERROR  [gnc_prices_dialog_get_quotes_clicked()] Price
retrieval failed: Failed to parse result returned by Finance::Quote.
Error message:
(1): expected value


To me, it's odd that gnucash-cli.exe seems to work where the gnucash app
itself does not.

I have Finance::Quote: 1.54 installed and it shows this in Help | About

Lastly, if I check the security editor, it seems like every quote provider
is greyed out.  This woudl suggest to me that gnucash doesn't think there
is a valid Finance::Quote configured.

I'd appreciate any pointers on how to dig deeper and determine what broke
for me between 4.13 and 5.0.  Is anyone else having issues?

I'm enjoying v5 quite a bit - congrats on the release.

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to move a transaction with splits from one top-level account to another - take 2

[Fross, Michael]

When I notice I've placed a transaction in the wrong spot, I "jump" to the
matching transaction and correct the credit card.  For example:

I put my Walmart grocery into the CreditCard1 account instead of the
CreditCard2 account.  I noticed this in the CreditCard1 account.

1. "Jump" to the matching transaction.  So now I am in the Grocery account.
2. Change that transaction to be CreditCard2 instead of the incorrect
CreditCard1 account.
3. Press enter.

The transaction in Grocery is fine, but you'll find it's gone from
CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
friend.

Michael

On Wed, Jan 18, 2023 at 3:31 PM Xe Roy  wrote:

> I asked this question earlier but initial responses made me realize more
> detail was necessary.
>
> I am a newby to gnucash ... trying to switch from Quicken to gnucash.
> A mistake I regularly make is to enter a transaction into the wrong
> account.
> I'll have several accounts open and I just forget to switch.
> In Quicken, I just move the transaction (splits and all) to the new
> account.
> The Internet chatter I've found so far lead me to believe this feature is
> missing from gnucash.
> I hope that's not true because it would really cause me excessive hassle.
> I hope there is a way to move a transaction (including any splits) to
> another account.
>
> Here is an example which illustrates a typical situation:
> Let's say I have two credit cards, VISA and MASTER CARD.
> Each has their own top-level CREDIT CARD account in gnucash, and each has
> its own tab in gnucash.
> I meant to enter a transaction in VISA but accidently entered it in MASTER
> CARD.
> The transaction is for $10 with WALMART in the description.
> So, the main entry shows $10 and the splits show $5 to the clothing
> account and $5 to the food account.
> I want to move the entire WALMART transaction, including the splits, from
> the MASTER CARD top-level account to the VISA top-level account in one easy
> step.
> This is easily doable in Quicken by right-clicking anywhere in the
> transaction, clicking MOVE, and selecting the new account VISA.
> How is this done in gnucash?
>
>
>
> Sent from Outlook
> ___
> 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] Register column sizing

[Fross, Michael]

Hi John.  I enjoy the ability to double click column headers to auto-size
them.  I hope this is not impacted.

For description autosizing, it did take a little getting used to, but I
like it and use it.  I manage the other columns, mostly by double clicking
the title, and then let the description column fill in the rest.

Michael


On Fri, Jan 6, 2023 at 6:32 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I don't play with it too often these days, but if I do, I won't miss the
> auto-size or accidentally exposing the price column.
>
> Regards,
> Adrien
>
> On 1/5/23 9:40 PM, john wrote:
> > It would be really easy to turn off autosizing on the Description field
> and only a little work to figure out another way to handle the price and
> ditch that column. Would anyone miss it?
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash-user Digest, Vol 237, Issue 113

[Fross, Michael]

Hi Chris,

I, too, enter the receipts immediately.  If I buy something online, it's
actually exactly the same time as the purchase.  If it's a real store, it
gets entered once I'm home.  Having it default to "today" is the right
answer for me.

Michael

On Thu, Dec 29, 2022 at 5:23 PM Chris Skudder 
wrote:

>FWIW, I'm another who enters most txn's on the same day I make them.
>IMHO, one of the great and beautiful advantages of GnuCash over
>Quickbooks Online (which I must use to do our church's accounts) - is
>that GC opens basically instantaneously. There's no network latency, no
>login, no "let's make sure it's really you" and "let's verify your cell
>number," no clicking thru "Don't you want to sign up for our payroll
>service, and our credit card processing service" and Lord knows what
>else, before I can do what "I" want to do, versus what Intuit wants me
>to do.
>For me, I can open the computer from standby, open GnuCash, enter the
>txn, and stash the receipt "off the deck" somewhere, quite a bit faster
>than try to find receipts later, find time, remember what they're for,
>+ etc.
>Realizing everybody's different ... but my own 1 vote is to keep the
>date default "today", or at least to give a user the OPTION to default
>txn dates to today.
>So hooray for open source software, and for the talented and dedicated
>peep's who do the coding that I don't know how to do.
>Thank you to you all.
>Chris
>  __
>
>From: [1]gnucash-user-requ...@gnucash.org
>Sent: Thursday, December 29, 2022, 12:00 PM
>To: [2]gnucash-user@gnucash.org
>Subject: gnucash-user Digest, Vol 237, Issue 113
>
> On 12/28/2022 11:11 AM, R Losey wrote:
>
> That would be an interesting poll (about when one enters data)
>
> References
>
>1. mailto:gnucash-user-requ...@gnucash.org
>2. mailto:gnucash-user@gnucash.org
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote v1.54 Released

[Fross, Michael]

Hello R Losey,

*cpan update Finance::Quote *

worked for me.  Just another alternative.

Michael

On Tue, Dec 27, 2022 at 3:38 PM Bruce Schuck 
wrote:

> On 12/27/22 9:08 AM, R Losey wrote:
>
> > I have version 1.52 installed on Ubuntu 22.04LTS... it came as a
> > package.  What do I need to do to install the update? Is there a
> > script to run for updates? Do I need to build it myself?
>
> Dropped gnucash-devel from the Cc.
>
> The good folks on the GnuCash team will point you to "gnc-fq-update",
> which itself is small Perl wrapper script which calls CPAN.
>
> https://wiki.gnucash.org/wiki/Online_Quotes#gnc-fq-update
>
>
> https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_using_CPAN
>
> It takes Ubuntu/Canonical some time to update their packages, so they
> are usually at least a major release or two behind.
>
> Updating from F::Q v1.52 to v1.54 should be quick using CPAN. But
> therein lies the caveat with Perl and CPAN. Occasionally additional
> modules or updates to existing ones require compilation of C code. While
> the CPAN mechanism will take care of this, it will require a development
> environment. At the very least the basic gcc/g++ packages and gmake.
>
> - Bruce S.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF Import troubles

[Fross, Michael]

Hi Steve,

I was in the same situation when I first started about 7 years ago.  Read
through the guide.  It's really well written, easy to read, and answers a
lot of questions.

As for the imports, do some tests until you get comfortable.  I would just
export your checking account, then import that.  Figure out that
categories are now other accounts and instead of assigning a transaction to
a category for reporting, you debit one account and credit another.
Understand splits and you'll be set.  It's also a great time to really
think through your account strategy.

It's really not hard, but read through the guide and you'll get it.

Michael

On Tue, Dec 13, 2022 at 6:52 PM Steve Butler 
wrote:

> That is the classic double entry bookkeeping system that GnuCash uses.
>
> If you don't want that you need to use some other software.
>
> On Tue, Dec 13, 2022, 16:35 Steve Silva via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > Hi All,
> > I am trying out gnucash to replace Quicken.  I have Quicken convert my
> > accounts into a QIF file and import that to gnucash.  The whole process
> > seems to go well until I see the result.  It seems like all or most of
> the
> > register entries are duplicated, each with a debit and credit of the same
> > amount.  I have tried various permutations of exporting and importing but
> > these split transactions keeps showing up.  Is there someone who has seen
> > this issue and figured out a way around it?
> > Thanks, Steve
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

[Fross, Michael]

Hi Scott,

This took some getting used to when I moved from Quicken 7 years or so
ago.  The categories become accounts.  This is required for double entry
accounting and makes sense.  When you pay your electric bill, money moves
from checking to the electric company.  GNUCash has to show money moving
between accounts.  Once I got my head around it it was pretty simple.

Michael

On Sun, Dec 4, 2022 at 9:46 AM Scott Traurig 
wrote:

> Hi all:
>
> New user questions follow, I'm afraid...
>
> I have no trouble following the directions in the wiki for migrating from
> Quicken. I made the QIF file, imported it into GnuCash, and watched it very
> unhelpfully create 100 different accounts. The instructions do mentions
> this, and it's ability to match against Quicken categories is impressive,
> but it's not what I desire.
>
> In Quicken this account is a simple, flat, checking account. How can I take
> the 100 separate accounts and represent them in a simple, flat, single
> checking account register? Is there no way to do this?
>
> Thanks,
>
> Scott
> ___
> 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] Problem with missing balance in a parent account **FINAL POST**

[Fross, Michael]

Hi Jay.  You are correct.  A placeholder account as simply a "group" that
holds other accounts.  You can certainly reconcile accounts that are
"under" a placeholder account.

On a placeholder account, you can't get the reconcile button because you
can't open the transaction list.

However, if you use the menu item *Action|Reconcile* for a selected
placeholder account, it does open up a window with no transactions.  IMHO,
*Action|Reconcile* should be disabled if the selected account is a
placeholder.

Michael


On Mon, Oct 10, 2022 at 10:14 AM Jay Ridgley 
wrote:

> On 10/10/22 08:20, john wrote:
> > Please remember to copy the list on all replies.
> >
> > If you want the Reconcile button (and, contrary to what Robin Chatterjay
> wrote, Actions>Reconcile) to be active for your account, make it not a
> placeholder.
> >
> > Regards,
> > John Ralls
> >
> Thank you John,
>
> What is the purpose of a placeholder then, because on my system that was
> not changed for the account in question between 20.04 LTS and 22.04 LTS?
> I was under the impression that a placeholder was to allow an account to
> be a parent BUT not allow transactions to be posted directly.
>
>
> >
> >> On Oct 10, 2022, at 7:56 AM, Jay Ridgley 
> wrote:
> >>
> >> Good morning,
> >>
> >> After some additional research I believe that the ONLY problem is the
> grayed out reconcile button.
> >>
> >> I was confused about the balance showing in the Parent Account,
> Placeholder. It shows in the Reconcile Popup window.
> >>
> >> The ACTUAL trouble is the grayed out Reconcile Button, that first
> appeared for me in Ubuntu 22.04 LTS after the upgrade.
> >>
> >> Since I have found the workaround below, it is a matter of
> inconvenience. However it would be preferable to have it as it was in
> earlier releases (not grayed out).
> >>
> >> Regards
> >> Jay
> >>
> >> On 10/9/22 15:49, Jay Ridgley wrote:
> >>> Good afternoon,
> >>> Up until Ubuntu 22.04 The reconcile button was NOT grayed out for the
> type of account I am using (Parent account  and Placeholder). I am
> including an example of my account structure here:
> >>> Banking Account (Parent Account, Placeholder)
> >>>  Checkbook  (sub-account)(contains all checkbook transactions)
> >>>  Reserve (sub-account) (contains minimum account balance)
> >>>  Separate Purpose (sub account) (rental income & expenses)
> >>>  Checkbook Blind (sub-account) (amount held as a pad)
> >>> All transactions take place in the sub-accounts. For me it has worked
> successfully since I began using GnuCash (over 25 years ago).
> >>> I was advised of a workaround that allows me to continue using this
> arrangement until it can be fixed/changed to act as it did previously.
> >>> It is as follows:
> >>> Open Parent account
> >>> right click and choose reconcile from the drop down
> >>> Works just fine.
> >>> Would not be necessary if the Reconcile button was not grayed out.
> >>> My question boils down too: Is this change a bug or a "feature" and
> can it be put back the way it was?
> >>> Please advise how I should proceed.
> >>> Thanks,
> >>> Jay
> >>> On 10/8/22 07:50, David T. wrote:
>  That account register doesn't have any transactions in it, so it
> won't have any value either. Is it possible that in the past, you used a
> report to see the parent account balances, or even the Chart of Accounts?
> 
>  And if the account in the screen shot is a placeholder account, then
> you a) wouldn't be able to open the account by double clicking, b) be told
> on selecting Open that it was read only, and c) once opened, the entire
> register would be greyed out. The screen shot seems to show a normal
> account. It also shows a similarly-named tab next to the active tab.
> 
>  David T.
>  On Oct 8, 2022, at 1:51 PM, Jay Ridgley  > wrote:
> 
>   On 10/7/22 16:38, john wrote:
> 
> 
> 
>   On Oct 7, 2022, at 12:43 PM, Jay Ridgley
>    wrote:
> 
>   Good Morning,
> 
>   BRAND NEW to the list, have been using GnuCash on my
> Ubuntu
>   system for over 20 years, this is the first problem I
> have
>   encountered that I have not been able to resolve.
> 
>   I discovered that the balance amount that should appear
> in a
>   the parent account for my bank is missing. Therefore I am
>   unable to do this month's reconcile.
> 
>   The account was proper last month, and I was able to
> balance
>   my checkbook successfully. In the meantime I upgraded to
>   Ubuntu 22.04 LTS from 20.04 LTS every thing seems to
> running
>   properly, otherwise, including GnuCash.
> 
>   Today when I tried to reconcile my bank account I
> discovered
>   the amount of the balance is missing and the reconcile
>  

Re: [GNC] Wrong Regedit key in Wiki for setting MRU maxfiles on Windows version 4.11

[Fross, Michael]

Hello all.  I don't believe this "doubling" is a mistake.  Think of
"org.gnucash" as the "manufacturer" and "GnuCash" as the product.  If they
make another tool, it would be "org.gnucash.NewTool"

Michael

On Thu, Sep 15, 2022 at 3:25 AM Vincent Dawans  wrote:

> FYI somebody on Linux also confirmed that they have the double
> /org/gnucash/GnuCash/history  path as well.
>
> https://www.reddit.com/r/GnuCash/comments/xe3xty/possible_to_change_recently_opened_from_4_to_5/
>
> On Wed, Sep 14, 2022 at 9:58 AM Vincent Dawans  wrote:
>
> > Was happy to see it is now possible to change the number of recent files
> > in the menu as per instructions in the FAQ
> >
> >
> https://wiki.gnucash.org/wiki/FAQ#Q:_I_have_deleted_a_gnucash_file_from_my_computer._How_can_I_remove_that_file_from_the_File_menu.27s_short_list_.28MRU.29_as_well.3F
> >
> > However the FAQ says to create a DWord in
> > Computer\HKEY_CURRENT_USER\SOFTWARE\GSettings\org\gnucash\history
> >
> > Although I do have a history key in that location, it seems to have been
> > created from an earlier version. In the latest version 4.11, it was moved
> > to
> > Computer\HKEY_CURRENT_USER\SOFTWARE\GSettings\org\gnucash\GnuCash\history
> > (notice the double \gnucash\GnuCash\)
> > That is where I had to create the DWord for it to work
> >
> > I get a sense that the registry tree might have been moved by mistake
> with
> > an added GnuCash level in the recent version but that's where it is as of
> > version 4.11 on Windows. If possible please update the FAQ to mention
> this
> > second location based on version number
> >
> > I have been using gnuCash for years but this is my first email to the
> > list. A big thank you for all the hard work.
> >
> > Vincent Dawans
> >
> ___
> 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] Opening Gnucash

[Fross, Michael]

Richard, does your GNUCash file have a date string in the name?  If so,
then  you are inadvertently using a backup file.  Your filename should be

FILENAME.gnucash   (FILENAME is whatever you decided to call it)

If it looks like:

FILENAME.gnucash.20220909023225.gnucash  (insert a valid date time stamp)

then it's a backup file and you are working on a backup.  This is not what
you want.

If this is the case, do a File | SaveAs and call it NAME.gnucash and go
from there.

Michael


On Mon, Sep 12, 2022 at 12:15 PM Richard Barmann  wrote:

> I am using Windows 10.When I close Gnucash and return the next day I
> cannot find the correct up to date file fr0m the day before. I tried to
> save/ and then close Gnucash. I wll see if that works.
>
> Richard
>
> On 9/12/2022 10:25 AM, David Carlson wrote:
> > Richard,
> >
> > Do I understand correctly that after you download
> gnucash-4.11-1.setup.exe
> > from the link on gnucash.org and use it to install GnuCash.exe using
> > default  settings then the icon on the Windows 11 equivalent to the
> Windows
> > 10 icon that is supposed to start GnuCash doesn't work?  Also clicking on
> > the data file icon in file manager manager doesn't work either?  Yet if
> you
> > then run gnucash-4.9.setup.exe to revert to release 4.9 then that release
> > starts as expected and opens the correctdata file?
> >
> > If you are doing something different please explain.
> >
> >
> >
> > On Sun, Sep 11, 2022, 5:36 PM Richard Clarkson via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> >> Greg
> >>
> >> Thank you!
> >>
> >> As I mentioned GnuCash 4.9, Windows 11 (64 bit). Have tried opening from
> >> apps, from shortcut, directly from the GnuCash.exe in bin. I cannot open
> >> GnuCash from any version higher than 4.9. I see a circle for a few
> seconds
> >> while windows is try to open GnuCash and then nothing. I've tried
> opening
> >> from PowerShell too.
> >>
> >> Is there any way of seeing where the exe is getting stuck or if
> something
> >> is
> >> missing or if I need to update anything?
> >>
> >> I'm either go to have to stay on 4.9 or change to another program.
> >>
> >> Thanks you for your help.
> >>
> >> RIchard
> >>
> >> -Original Message-
> >> From: gnucash-user
> >>  On Behalf
> Of
> >> Greg Feneis
> >> Sent: 11 September 2022 14:59
> >> To: gnucash-user@gnucash.org
> >> Subject: Re: [GNC] Opening Gnucash
> >>
> >> Richard,
> >>
> >> You may want to provide a few more details.  Perhaps mention the
> version of
> >> GnuCash you're using, which OS you're using.  How do you open GnuCash,
> by
> >> starting the application or by clicking on a saved file?  And so on.
> >>
> >> Kind regards,
> >>
> >> Greg Feneis
> >>
> >>
> >>
> >>
> >> On Sat, Sep 10, 2022 at 6:36 AM Richard Barmann  wrote:
> >>
> >>> When IO open Gnucash to make some entries in the checking account It
> >>> opens a page from the past. How can I open the latest page with the
> >>> entries up to date.
> >>>
> >>> Richard Barmann
> >>>
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] GnuCash Windows Bundle 4.11-1 Released

[Fross, Michael]

Looks good on this end John.  Thank you very much!

Michael

On Sat, Jul 2, 2022 at 4:40 PM Gyle McCollam  wrote:

> John, Thanks to you and all involved with keeping this programing going.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of John Ralls 
> Sent: Saturday, July 2, 2022 4:33 PM
> To: gnucash-annou...@lists.gnucash.org  >
> Cc: gnucash-devel ; Gnucash Users <
> gnucash-user@gnucash.org>
> Subject: [GNC] GnuCash Windows Bundle 4.11-1 Released
>
> This fixes https://bugs.gnucash.org/show_bug.cgi?id=798559, Online
> Actions missing from menus.
>
> It restores File>Import>MT940 and other SWIFT formats, Actions>Online
> Actions, and Tools>Online Banking Setup.
>
> 63d98c5873e58191cbac5c6ba4f269528c67911d0d63e2dd114e2f1c12c328a7
> gnucash-4.11-1.setup.exe
>
> Downloads:
> https://code.gnucash.org/builds/win32/releases/gnucash-4.11-1.setup.exe
>
> https://downloads.sourceforge.net/gnucash/gnucash%20%28stable%29/4.11/gnucash-4.11-1.setup.exe
>
> https://github.com/Gnucash/gnucash/releases/download/4.11/gnucash-4.11-1.setup.exe
>
> 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, 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] Uneven line spacing in Accounts list since 4.11

[Fross, Michael]

I do see it as well in Windows 11, but I'd be surprised if the Windows
version has anything to do with it.

On Sat, Jul 2, 2022 at 8:01 AM Dennis West  wrote:

> Looks OK in Win 10
>
>
> On 7/2/2022 6:44 AM, B.A.J. Seesing wrote:
> > Dear Bill,
> > You're not the only one... A bug report was already filed for this.
> > Please refer to [1]https://bugs.gnucash.org/show_bug.cgi?id=798558
> for
> > details.
> > Regards,
> > Bart
> >
> > Message: 2
> > Date: Fri, 1 Jul 2022 10:00:14 +1000
> > From: [2]dull...@gmail.com
> > To: "'Gnucash Users'" [3]
> > Subject: [GNC] Uneven line spacing in Accounts list since 4.11
> > Message-ID: [4]<000601d88cdd$8c3ae280$a4b0a780$@hotmail.com>
> > Content-Type: text/plain; charset="us-ascii"
> >
> > I think since 4.11 (am using Windows 11 and a dark theme), I notice very
> odd
> > random line spacing in Account list window (the default window when I
> open
> > Gnucash)
> >
> > I see the lines for each sub-accounts are not evenly distributed -
> spacing
> > seems completely random (some have space above and below, others do not)
> >
> > I have attached a partial screenshot showing this uneven spacing for the
> > subaccounts  (if the mailing list supports attachments?)
> >
> > Regards,
> >
> > Bill
> >
> > References
> >
> > 1. https://bugs.gnucash.org/show_bug.cgi?id=798558
> > 2. mailto:dull...@gmail.com
> > 3. mailto:gnucash-user@gnucash.org
> > 4. mailto:000601d88cdd$8c3ae280$a4b0a780$@hotmail.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.
> ___
> 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] GNUCash 4.9

[Fross, Michael]

Hi Steve,

I bet the lock (.LCK) file is getting deleted and explorer's desktop is
just not refreshing.  After you close Gnucash, select the desktop with a
click and hit F5.  I bet the lock file icon goes away.

The log file won't, and shouldn't.  If you follow everyone's advice and put
it in another location (and then open Gnucash and do File|Open and select
the new location/file) you won't see it staring at you 

Michael

On Mon, Jan 3, 2022 at 12:36 PM Glenn Fowler  wrote:

> Hi Steve,
>
> Move your GnuCash files to somewhere else besides the desktop, like a
> documents Documents for example and then re-open in this new location. The
> lock and logs are normal but now you won't see them.
>
>
> On Mon, Jan 3, 2022 at 1:12 PM Derek Atkins  wrote:
>
> > Hi,
> >
> > On Mon, January 3, 2022 12:50 pm, Steve Mortimer wrote:
> > > I have been running Gnucash on this computer, Win10, for sometime now
> > > and have been having the same problem all along.  I have upgraded to
> > > version 4.9.  When I close the program there are two files that are not
> > > removed from the desktop and I have to go and delete the manually.  If
> I
> > > do not delete them manually after each time I close the program the
> > > program just keeps adding more of the same files to the desktop.
> > >
> > > The files are:
> > > 1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
> > > 1223GNUCASH.gnucash.201...cash.20220103114501.log
> > >
> > > What do I need to do so these files are deleted every time the program
> > > is closed?
> >
> > How are you closing the program?  Are you just clicking on the [X]?  Or
> > are you using File -> Quit?
> >
> > >
> > > Regards,
> > > Steve Mortimer
> >
> > > 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.
> >
> ___
> 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] Flatpak/Flatseal Gnucash fails to launch

[Fross, Michael]

Don’t forget the “run” command. In your paste it was missing.  See Geert’s
command.

On Tue, Nov 30, 2021 at 6:47 AM Elmar  wrote:

> On 11/30/21 3:13 AM, Geert Janssens wrote:
>
> > ... flaptak run org.gnucash.GnuCash
> Thank you for your kind reply, Geert.  I have been banging this around
> the Linuxmint forum as well with no resolution (See
> https://forums.linuxmint.com/viewtopic.php?f=90=362033=2101949#p2101949),
>
> and for some reason the software manager is not installing the flatpak
> programs so that they can be run.  Doing the above gives me the following:
>
> > ets@Shinobi ~ $ flatpak org.gnucash.GnuCash error:  >
> 'org.gnucash.GnuCash' is not a flatpak command. Did you mean >
> 'create-usb'? > > See 'flatpak --help'
>
> So no joy here so far. - Elmar
>
>
>
>
> ___
> 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] Formulas in Scheduled Transactions

[Fross, Michael]

Thanks Derekthat's what I thought the answer would be.  Much
appreciated.

Michael

On Tue, Nov 16, 2021 at 2:14 PM Derek Atkins  wrote:

> GnuCash SX does not have a "Get Account Balance As Of Date" function, so
> there is no way to get "OldAmount" here.
>
> -derek
>
> On Tue, November 16, 2021 3:02 pm, Fross, Michael wrote:
> > Hello all,
> >
> > I have a fixed annuity account which updates with a new total, but does
> > not
> > show the interest that contributes to that total.  Here is the simple
> > formula to calculate the interest:
> >
> > Interest = NewAmount - OldAmount
> >
> > I thought it would be interesting to have a monthly scheduled
> > transaction that would request the new value from me (which I get from my
> > brokerage).  The function would then subtract the current value of the
> > account (OldAmount) from the value I entered (NewAmount) and then add the
> > interest as a transaction in the account.
> >
> > While it's not a big deal to figure it out and just put in the interest,
> I
> > thought it would be fun to see if I can get GnuCash to do it, although I
> > admit I may be asking a bit too much of the scheduled transaction
> > capability.  Getting the NewAmount is probably as easy as adding a
> > variable
> > to the scheduled transaction.  Adding the interest as a variable is
> > probably something that can be done.  I'm not sure how I could get the
> > current amount in the scheme file to do the subtraction.
> >
> > Any thoughts on this?   Is it possible?  Pointers on where to begin?
> (I'm
> > been looking through the fin.scm file, but I didn't see much
> documentation
> > on this capability)
> >
> > Thanks in advance!
> >
> > Michael
> > ___
> > 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.

[GNC] Formulas in Scheduled Transactions

[Fross, Michael]

Hello all,

I have a fixed annuity account which updates with a new total, but does not
show the interest that contributes to that total.  Here is the simple
formula to calculate the interest:

Interest = NewAmount - OldAmount

I thought it would be interesting to have a monthly scheduled
transaction that would request the new value from me (which I get from my
brokerage).  The function would then subtract the current value of the
account (OldAmount) from the value I entered (NewAmount) and then add the
interest as a transaction in the account.

While it's not a big deal to figure it out and just put in the interest, I
thought it would be fun to see if I can get GnuCash to do it, although I
admit I may be asking a bit too much of the scheduled transaction
capability.  Getting the NewAmount is probably as easy as adding a variable
to the scheduled transaction.  Adding the interest as a variable is
probably something that can be done.  I'm not sure how I could get the
current amount in the scheme file to do the subtraction.

Any thoughts on this?   Is it possible?  Pointers on where to begin?  (I'm
been looking through the fin.scm file, but I didn't see much documentation
on this capability)

Thanks in advance!

Michael
___
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] Thank you

[Fross, Michael]

Well said Neil. They all deserve our thanks and gratitude.

Michael

On Mon, Sep 27, 2021 at 6:41 AM Neil Campbell  wrote:

> My congratulations and thanks to the Team for the production and release
> of GNUCash version 4.7. As this development is all done by professional
> volunteers, I really do say a hearty 'thank you’ for your effort and for
> allowing this to be open source. Much appreciated.
>
> Best regards.
> Neil
> neilcam...@gmail.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.
>
___
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] Newbie question

[Fross, Michael]

Hello Steve.  Welcome to GnuCash!

While I'm not an expert, in my experience, an opening balance is just a
normal transaction.  There are typically two splits.  (1) is a deposit into
the account, and (2) is a withdrawal from the Equity:Opening Balances
account.  Remember GnuCash used double entry accounting so the insert has
to match with a decrease elsewhere.

Good luck.

Michael

On Sun, Sep 26, 2021 at 4:40 PM Steve Welch via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi!
>
> I’m just getting started with GnuCash and have imported my QIF file from
> Moneydance.  Excited to take it for a spin!
> My question is regarding beginning (opening) account balances.  Moneydance
> has an opening balance field in the account setup window, but evidently
> that field isn’t accessible in GnuCash unless setting up a new account.
> The problem I seem to be having is that the beginning balances that had
> been in Moneydance did not import into Gnu, so my accounts are off.
> I am figuring I can manually enter an opening balance transaction for each
> account but wanted to make sure I wasn’t missing a more elegant (or
> obvious) solution.
>
> Thanks,
>
> Steve
> ___
> 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] GnuCash 4.6 Released

[Fross, Michael]

Absolutely. The generosity is humbling and very much appreciated.

On Mon, Jun 28, 2021 at 4:41 AM Mahon Finbar  wrote:

> +1
>
> On 28/06/2021 03:29, Stan Brown wrote:
> > On 2021-06-27 14:51, John Ralls wrote:
> >> The GnuCash development team announces GnuCash 4.6, the sixth release
> in the stable 4.x series
> >> Between 4.5 and 4.6, the following bugfixes were accomplished:
> > ...
> >
> > It's change logs like this that remind me what a massive effort GnuCash
> > is. My thanks to you and all the development team -- your work is very
> > much appreciated!
> >
> ___
> 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] GNUCash & Macros

[Fross, Michael]

You could look into AutoHotkey.  I use it to automate other non-GNUCash
things, but I don't see why it couldn't work, especially if you can do what
you need to do via keystrokes.

Michael

On Wed, May 26, 2021 at 10:15 AM Derek Atkins  wrote:

> HI,
>
> On Wed, May 26, 2021 11:09 am, Jack Frillman wrote:
> > I have repetitive task I do every day and I would like to reduce the
> > number of steps to do that task.
> >
> > More specifically I import stock/mutual fund and precious metal prices
> > from a CSV file. Currently I go through the multi-step process the GUI
> > walks you through. This is easy enough but I can be ultra lazy at times
> > and would like to execute that import process using a macro if possible.
>
> Thank you for explaining what you'd like to do.  Unfortunately, no, there
> is no way to automate those processes in the UI.  The closest thing you
> can do is write some scripts (in Python) to do the work.
>
> -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.
>
___
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] Thinking about Moving to MacOS from Win 10

[Fross, Michael]

For Windows, and I'm sure there are Mac solutions as well, I've been using
CryptSync with good success.  It copies from your hard drive to your cloud
directory on your computer and it encrypts it.  The cloud agent then sync's
that directory to the cloud provider.

https://github.com/stefankueng/CryptSync

Michael



On Tue, Apr 27, 2021 at 10:53 AM John Ralls  wrote:

>
>
> > On Apr 27, 2021, at 6:49 AM, Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
> >
> > On 4/26/2021 12:44 PM, Jack Frillman via gnucash-user wrote:
> >> Just copy the main data file.
> >> I copy it from my iMac to my Linux laptop for a backup and to a Windows
> 10  laptop for a backup to my Linux laptop.
> >> Any reports you create will require copying a different file though.
> >
> >
> > Just a suggestion from somebody who went through recovery after a house
> fire << we did have data recovery coverage and ONE of the drives of ONE of
> the computers was not too smoke damaged for the recovery lab to get the
> data from that one; the rest, no dice. And if we had not had that rider on
> our policy, the cost would have been prohibitive >>
> >
> > Maybe not every time, but once in a while, maybe monthly, make a copy of
> the data on your machines to either ROM medium or an external drive that
> will reside elsewhere (not in the same building). Ours (now) goes onto a
> drive that lives in a fire safe in the barn, only at risk of "same
> building" when brought into the house to make the backup. Of course you
> COULD use a "cloud server" but I do not care to allow third party access to
> my data.
> >
> > If you are a business, your accountant SHOULD be telling you to do this
> as "standard procedure" for a business.
>
> I guess the barn would be OK if you don't live in California where whole
> towns go up in smoke.
>
> Cloud storage is IMO an ideal backup medium because not only is it far
> away it's likely replicated to multiple data centers. If you're concerned
> that the cloud provider's encryption isn't sufficient you can layer your
> own on top of it. macOS provides an encrypted disk image that I've used for
> several years with Google Drive, but there are a couple of Windows
> solutions that have caused trouble in the past so test thoroughly before
> committing to any utility.
>
> 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.

Re: [GNC] Need help

[Fross, Michael]

Hello Glen,

As a note of encouragement, I also read it when I first started after
bumping my head into things which now seem obvious.  The authors did a very
nice job making it easily readable and walking you through step by step.
It doesn't answer every question, but it gives you the foundation which is
really needed to be successful.

Have fun with it and welcome to the community.

Michael

On Fri, Apr 16, 2021 at 8:40 AM David Carlson 
wrote:

> Glen,
> Welcome!
> Because it is so easy to make practice files and more practice files and
> delete and start over, you do not need to read the entire 311 pages before
> you start!
>
> Also, the only test is the one where you get a result that meets your
> needs.
>
> On Fri, Apr 16, 2021 at 6:05 AM Liz  wrote:
>
> > On Fri, 16 Apr 2021 12:54:33 +0200
> > "Glen Bailie"  wrote:
> >
> > > Dear Sirs,
> > >
> > > I am trying to set up a set of books, but have come across some
> > > problems for which I need help.
> > >
> > > !) How do I get into Accounts,
> > >
> > > 2) How do I do transactions from a bank cheque account, such as
> > > receipts and payments that are not from customers or vendors. For
> > > example bank charges, and subscriptions.
> > >
> > > 3) When I enter a new Vendor, I get the message " no valid vendor can
> > > be found" What is wrong  here?
> > >
> > >
> > >
> > > Would you please give me detailed instructions about solving the above
> > > problems.
> > >
> > > Regards,
> > >
> > > Glen Bailie
> > >
> >
> > Glen
> > Welcome here
> > I think that you would do well to read the concepts guide and tutorial,
> > which does have detailed explanations, and then start a set of books
> > simply to experiment with and practise in.
> >
> > https://code.gnucash.org/docs/C/gnucash-guide.pdf
> >
> > Warning, because it is detailed, it's 311 pages long.
> >
> > Then come back with your questions.
> >
> > Liz
> > ___
> > 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.
>
___
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] UK specific: MTD - Making Tax Digital

[Fross, Michael]

I suppose that depends on where you live Edward.  Many of us don't have to
deal with MTD.

On Sun, Jan 17, 2021 at 1:45 PM Edward Bainton 
wrote:

> Of the 6, I have to confess that I read it too hastily and I don't have to
> do VAT, so the VAT bridge won't be of interest to me.
>
> But crikey, if you can't use GnuCash for MTD, it's not much use anymore, is
> it?
>
> On Sun, 17 Jan 2021 at 19:05, Stephen M. Butler <
> stephen.m.butle...@gmail.com> wrote:
>
> > On 1/17/21 1:28 AM, Liz wrote:
> > > On Sun, 17 Jan 2021 02:52:19 -0600 (CST)
> > > "chr...@floatdene.com"  wrote:
> > >
> > >>   As there are only about 6 users interested, it is
> > >> definitely not worth the effort!
> > > While you have only counted 6 who have put up their hand so far, I
> > > think that there would be far more interested in a usable system. It
> > > doesn't include me, I live elsewhere.
> > >
> > > Liz
> > > _
> > I used to help out with a non-profit radio station.  For every response
> > they figured there were an additional 6-7 folks who where thinking the
> > same thing but didn't respond.  Based on marketing studies.
> >
> > --
> > 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.

Re: [GNC] ofx.chase.com?

[Fross, Michael]

Charles, I've had challenges getting it working for over a year.  Can you
share your settings you use to connect to Chase?

On Mon, Dec 14, 2020 at 8:41 AM Development  wrote:

> JPM does maintence on weekends.  Its possible that downstream systems were
> in the midst of maintenance/update/reboot.  Being the end of year there’s a
> rush before updates are paused for the holidays.
>
>
> Cheers,
> Bob
>
> > On Dec 14, 2020, at 09:29, David Reiser via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > 
> >>
> >>> HTTP-Status: 504 (Gateway Time-out)
> >
> > means that chase isn’t sending any data. No data, no transactions for
> Gnucash to detect.
> >
> > It has only been since yesterday. The system worked on Saturday, did not
> work Sunday or today yet. But they’re a bank, and ofx/qfx is probably
> pretty low on their emergency priority list. So today is likely the first
> day any employee will see the block and start working on it.
> > --
> > Dave Reiser
> > dbrei...@icloud.com
> >
> >
> >
> >
> >
> >> On Dec 14, 2020, at 8:03 AM, Charles Gagnon  wrote:
> >>
> >> Anyone else struggling with OFX at Chase. I've been using it for years
> >> without issues. Used it successfully last month. Since yesterday, on all
> >> accounts, I'm told there were no transactions to download. I tried using
> >> fixed date instead of "since last transfer" and no difference:
> >>
> >> [image: image.png]
> >>
> >> I do not think this is a Gnucash issue per say. Unless it's a OFX
> version
> >> thing. I googled around but can't find any indications of others having
> >> problems so I'm confused. Any ideas or pointers? What's a good next
> step?
> >> Is there an OFX mailing list or do I just reach out to Chase? Could
> this be
> >> just my setup broken?
> >>
> >> It connects and seems to establish a session with Chase but gets
> nothing.
> >> Log below...
> >>
> >> AqBanking v6.2.2.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 "24"
> >> Sending request...
> >> Connecting to server...
> >> Resolving hostname "ofx.chase.com" ...
> >> IP address is "159.53.44.44"
> >> Connecting to "ofx.chase.com"
> >> Connected to "ofx.chase.com"
> >> Using GnuTLS default ciphers.
> >> TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-128-GCM:AEAD
> >> Connected.
> >> Sending message...
> >> Message sent.
> >> Waiting for response...
> >> Receiving response...
> >> HTTP-Status: 504 (Gateway Time-out)
> >> Unlocking customer "24"
> >>
> >> --
> >> Charles Gagnon
> >> charlesg at unixrealm.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.
> >
> > ___
> > 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.

Re: [GNC] Fidelity and TD Ameritrade setup

[Fross, Michael]

David, where did you download the OFX file from Fidelity?  I've not seen
that.  Were you using AQ Banking (I've never been able to get it to work)?

Michael

On Mon, Nov 2, 2020 at 9:12 AM David Reiser via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Good to know.
>
> My Fidelity ofx data is up to date (I got a 10/30 dividend transaction in
> yesterday’s download).
>
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> > On Nov 2, 2020, at 10:06 AM, Kalpesh Patel 
> wrote:
> >
> > You may want to explore freeware product called PocketSense (at
> > https://sites.google.com/site/pocketsense/ and
> > https://pocketsense.blogspot.com/) by fine gentleman named Robert which
> is
> > to more or less degree has been kept up with modern times. Robert will
> > accept donation to Coffee Fund in case you want to contribute something
> > after finding it useful.
> >
> >
> >
> > It was made to be able to continue use of M$ Money online when they
> > discontinued that product. However, what I discovered was that it has
> > ability to combine and generate a single OFX file after scrapping number
> of
> > statements from various brokers, handles multiple accounts from a single
> > broker and ability to import manually downloaded OFX files for those that
> > are not readily support by the download interface into that single file.
> > Then it is matter of just importing that single file into GnuCash. Don't
> get
> > discouraged from the documentation if you do decide to plunge; it is way
> > easier then what is made out to be there - just need Python 2.7,
> configure a
> > file with OFX parameters (gotten from OFXHome at
> > https://www.ofxhome.com/index.php/home/directory/all)  and some
> > experimentation. I have been using this method since I moved over from
> > Quicken once they went the subscription model after somewhat painful
> > migration to GnuCash. It claims to be able to also download security
> pricing
> > as part of the process which I do not use at this time - GnuCash does a
> good
> > job on its own so I just use that provided facility. I basically run it
> when
> > I fire up my computer which collects various statements and then import
> it
> > in at that time and call it a day.
> >
> >
> >
> >
> >
> >
> >
> > Heads up for those that use aqbanking to connect brokers for download:
> >
> >
> >
> > Charles Schwab: recently they have closed off download of OFX based
> > statement and will only let you download CSV file after logging on to
> their
> > site. In order to continue OFX download, you have to be a Quicken
> subscriber
> > and few other that I cannot recall but very limited offering from the
> > conversation I had with their support folks.
> >
> > Fidelity:  the data on OFX server lags by a month or more.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ___
> > 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.

Re: [GNC] I'm still a bit confused about when things get saved.

[Fross, Michael]

What backup software did you decide to use Chris? I’ve written some scripts
to backup my Gnucash files, but have been looking at a more comprehensive
solution.

Michael

On Fri, Sep 11, 2020 at 3:02 AM Chris Green  wrote:

> On Thu, Sep 10, 2020 at 07:25:33PM -0700, John Ralls wrote:
>
> > Tried that with GnuCash? It isn't a macOS native app and probably
> doesn't
>
> > benefit from those features. I'd go for the UPS, but since recent
> financial
>
> > activity is generally pretty easy to recover and re-enter maybe the
> risk/payback
>
> > works out differently for you.
>
> >
>
> I run incremental backups of all the important data one my system,
>
> in particular I run hourly incremental backups of my 'home' directory
>
> (I use Linux) and this contains just about everything of significance.
>
>
>
> Thus I can never lose more than an hour's work and, if I want to go
>
> back to an earlier situation it's easy.  Since they're incremental
>
> backups if nothing changes then no extra space is consumed (except for
>
> a little overhead).
>
>
>
> Thus, on a separate drive, on my desktop system I have the following
>
> backups:-
>
> day-2  day-4  day-6  hour-1   hour-2  hour-4  hour-6  hour-8 week-1
> week-3  week-5
>
> day-1  day-3  day-5  day-7  hour-10  hour-3  hour-5  hour-7  hour-9
> week-2  week-4
>
>
>
> On a separate system, out in the garage well away from the house, I
>
> have another 'layer' of incremental backups at longer intervals (day,
>
> month, year) going back several years.
>
>
>
> --
>
> Chris Green
>
> ___
>
> 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] Import Transaction Matcher issue in v4

[Fross, Michael]

Hello everyone,

Just confirming the issue with Citibank QFX files.  They are changing the
FITID for the same transactions in the QFX downloads.  I'll reach out to
them, but I'm not optimistic

The download on Friday yielded the following for a specific transaction:

CREDIT
2020072112
54.00
202007210003
ACH Electronic Credit



The Download of the same account today for the same transaction yielded
this in the QFX file:

CREDIT
2020072112
54.00
202007210004
ACH Electronic Credit




On Mon, Jul 27, 2020 at 9:33 PM David Carlson 
wrote:

> Michael,
>
> Exactly.  The QFX file only contains the information that the bank would
> put on your monthly account statement along with the necessary
> infrastructure to identify which bank created the file and which account
> and the time frame which the file describes and sometimes some additional
> information that GnuCash may or may not use.  GnuCash has to synthesize the
> rest in order to create a list of full double-entry qualified
> transactions.  That is why the import wizard is so difficult for users to
> work with and even more difficult for developers to code.
>
> Unfortunately most of us are very sloppy technically in talking of the
> file as if it is a transaction list when it is really more like a bank
> statement.
>
> On Mon, Jul 27, 2020 at 8:57 PM Fross, Michael  wrote:
>
>> Hello David,
>>
>> In looking at the QFX file, I only see one side of the transaction.  This
>> file has 3 distinct transactions ( records) that are not related
>> and only one account ID is listed.
>>
>> Michael
>>
>> On Mon, Jul 27, 2020 at 5:56 PM David Carlson <
>> david.carlson@gmail.com> wrote:
>>
>>> There is another use case which GnuCash also needs to handle.  Some OFX
>>> files may contain both sides of an inter-account transfer between two
>>> accounts within the same bank because the OFX file can include multiple
>>> accounts.  In fact, I do that on a regular basis at one of my banks.  I do
>>> not test GnuCash's handling of these because I want to get the separate
>>> notes associated with each side and merge them together into the same
>>> transaction in my data file.  Thus I deliberately call both of them New
>>> rather than try to match them within the import process.  I have not
>>> checked to see if they have unique FITID's, but they would be under
>>> different ACCOUNTID's  and both can be accepted as New in release 2.6.19
>>> and prior, which is the latest version that I use.  I suppose ideally I
>>> would like gnuCash to detect this case and automatically apply the
>>> corresponding notes to both sides of the  transfer, so I don't have to do
>>> it manually.
>>>
>>> David Carlson
>>>
>>> On Mon, Jul 27, 2020 at 5:23 PM Fross, Michael 
>>> wrote:
>>>
>>>> Got it. Thanks.  Now I understand why it used to work.  And I certainly
>>>> wouldn't expect GnuCash to correct a bank's horrible behavior.  I'll
>>>> keep
>>>> an eye on the FITID and see if that's what they are doing.
>>>>
>>>> Thanks everyone for your help.  Much appreciated.
>>>>
>>>> Michael
>>>>
>>>> On Mon, Jul 27, 2020 at 5:13 PM Jean Laroche  wrote:
>>>>
>>>> > Ah, OK I get it now!
>>>> > Yes, you should check that from one day to the next, the FTID returned
>>>> > by citibank remains the same (for the same transaction). If not, then
>>>> > that's going to be a problem.
>>>> > What has changed recently with GC is that it not will not match a new
>>>> > imported transaction with one from the register that has an online id.
>>>> > Previous versions allowed that, so in your case, it's quite possible
>>>> > that from one day to the next, the same transaction would be given a
>>>> > different ID, but GC matched it to the same register transaction that
>>>> > was previously matched.
>>>> > So, on day 1, you'd match OFX1->Reg1, and on day two, you'd still
>>>> match
>>>> > OFX2 -> reg1, even though reg1 had already been matched to OFX1 the
>>>> > previous day. So you'd see OFX2 appear as "match" and not "Add".
>>>> >
>>>> > The correct behavior is that OFX2 actually has the same ID as OFX1,
>>>> and
>>>> > it's entirely skipped by GC. But it seems that your bank is messing
>>>> > their online ID, and this is what's causing the issue for you, 

Re: [GNC] Import Transaction Matcher issue in v4

[Fross, Michael]

Hello David,

In looking at the QFX file, I only see one side of the transaction.  This
file has 3 distinct transactions ( records) that are not related
and only one account ID is listed.

Michael

On Mon, Jul 27, 2020 at 5:56 PM David Carlson 
wrote:

> There is another use case which GnuCash also needs to handle.  Some OFX
> files may contain both sides of an inter-account transfer between two
> accounts within the same bank because the OFX file can include multiple
> accounts.  In fact, I do that on a regular basis at one of my banks.  I do
> not test GnuCash's handling of these because I want to get the separate
> notes associated with each side and merge them together into the same
> transaction in my data file.  Thus I deliberately call both of them New
> rather than try to match them within the import process.  I have not
> checked to see if they have unique FITID's, but they would be under
> different ACCOUNTID's  and both can be accepted as New in release 2.6.19
> and prior, which is the latest version that I use.  I suppose ideally I
> would like gnuCash to detect this case and automatically apply the
> corresponding notes to both sides of the  transfer, so I don't have to do
> it manually.
>
> David Carlson
>
> On Mon, Jul 27, 2020 at 5:23 PM Fross, Michael  wrote:
>
>> Got it. Thanks.  Now I understand why it used to work.  And I certainly
>> wouldn't expect GnuCash to correct a bank's horrible behavior.  I'll keep
>> an eye on the FITID and see if that's what they are doing.
>>
>> Thanks everyone for your help.  Much appreciated.
>>
>> Michael
>>
>> On Mon, Jul 27, 2020 at 5:13 PM Jean Laroche  wrote:
>>
>> > Ah, OK I get it now!
>> > Yes, you should check that from one day to the next, the FTID returned
>> > by citibank remains the same (for the same transaction). If not, then
>> > that's going to be a problem.
>> > What has changed recently with GC is that it not will not match a new
>> > imported transaction with one from the register that has an online id.
>> > Previous versions allowed that, so in your case, it's quite possible
>> > that from one day to the next, the same transaction would be given a
>> > different ID, but GC matched it to the same register transaction that
>> > was previously matched.
>> > So, on day 1, you'd match OFX1->Reg1, and on day two, you'd still match
>> > OFX2 -> reg1, even though reg1 had already been matched to OFX1 the
>> > previous day. So you'd see OFX2 appear as "match" and not "Add".
>> >
>> > The correct behavior is that OFX2 actually has the same ID as OFX1, and
>> > it's entirely skipped by GC. But it seems that your bank is messing
>> > their online ID, and this is what's causing the issue for you, along
>> > with the new GC behavior.
>> >
>> > I'm not sure how to fix your problem. It's clearly a bank issue but
>> > that's not terribly helpful as far as your problem goes. We should
>> > probably add an option to defeat the new GC import behavior,
>> > specifically for users like you whose bank send unreliable FTIDs/
>> >
>> > FYI, the new GC behavior was added because the old behavior was causing
>> > issues with people who had recurring daily transactions: imagine buying
>> > a cup of coffee every day: in that case GC will match all daily cups of
>> > coffee to the same register transaction (within a date range, of course)
>> > instead of adding the new one every day (which really is the correct way
>> > to do it).
>> >
>> >
>> >
>> > Jean
>> >
>> >
>> > On 7/27/20 2:45 PM, Fross, Michael wrote:
>> > > Hi Jean.  Let me try to better explain my issue.
>> > >
>> > > On most days, I download QFX files from my Checking and Credit Card
>> > > accounts and import them.  In this way I clear transactions and I can
>> > > see what's going on.  The next day I'll do so again, and the importer
>> > > skips those that have already been matched per your comment.s  I've
>> been
>> > > doing this for years and it's worked well.
>> > >
>> > > Since I updated to V4 the transactions that would have matched
>> > > previously now come up with "Match Missing!" in the importer.  I don't
>> > > want to add them as they would create duplicates.  Transactions that
>> are
>> > > not cleared seem to be able to be matched.  But those that are
>> > > previously cleared get the "Match Missing!" issue.
>> > >
&g

Re: [GNC] Import Transaction Matcher issue in v4

[Fross, Michael]

Got it. Thanks.  Now I understand why it used to work.  And I certainly
wouldn't expect GnuCash to correct a bank's horrible behavior.  I'll keep
an eye on the FITID and see if that's what they are doing.

Thanks everyone for your help.  Much appreciated.

Michael

On Mon, Jul 27, 2020 at 5:13 PM Jean Laroche  wrote:

> Ah, OK I get it now!
> Yes, you should check that from one day to the next, the FTID returned
> by citibank remains the same (for the same transaction). If not, then
> that's going to be a problem.
> What has changed recently with GC is that it not will not match a new
> imported transaction with one from the register that has an online id.
> Previous versions allowed that, so in your case, it's quite possible
> that from one day to the next, the same transaction would be given a
> different ID, but GC matched it to the same register transaction that
> was previously matched.
> So, on day 1, you'd match OFX1->Reg1, and on day two, you'd still match
> OFX2 -> reg1, even though reg1 had already been matched to OFX1 the
> previous day. So you'd see OFX2 appear as "match" and not "Add".
>
> The correct behavior is that OFX2 actually has the same ID as OFX1, and
> it's entirely skipped by GC. But it seems that your bank is messing
> their online ID, and this is what's causing the issue for you, along
> with the new GC behavior.
>
> I'm not sure how to fix your problem. It's clearly a bank issue but
> that's not terribly helpful as far as your problem goes. We should
> probably add an option to defeat the new GC import behavior,
> specifically for users like you whose bank send unreliable FTIDs/
>
> FYI, the new GC behavior was added because the old behavior was causing
> issues with people who had recurring daily transactions: imagine buying
> a cup of coffee every day: in that case GC will match all daily cups of
> coffee to the same register transaction (within a date range, of course)
> instead of adding the new one every day (which really is the correct way
> to do it).
>
>
>
> Jean
>
>
> On 7/27/20 2:45 PM, Fross, Michael wrote:
> > Hi Jean.  Let me try to better explain my issue.
> >
> > On most days, I download QFX files from my Checking and Credit Card
> > accounts and import them.  In this way I clear transactions and I can
> > see what's going on.  The next day I'll do so again, and the importer
> > skips those that have already been matched per your comment.s  I've been
> > doing this for years and it's worked well.
> >
> > Since I updated to V4 the transactions that would have matched
> > previously now come up with "Match Missing!" in the importer.  I don't
> > want to add them as they would create duplicates.  Transactions that are
> > not cleared seem to be able to be matched.  But those that are
> > previously cleared get the "Match Missing!" issue.
> >
> > Now, based on what you told me, the QFX file for a problem transaction
> > has a FITID that is one higher than the ONLINE_ID in the gnucash file
> > for the same transaction.  So the Match Missing items seems to be
> correct.
> >
> > If I duplicate the transaction, delete the original, it matches which I
> > assume is because there is not an ONLINE_ID associated with the new one.
> >
> > What I don't understand is if there is an issue with GNUCash, which is
> > why I asked if others are having the same issue, or if it is/was an
> > issue with CITIBANK QFX files.  If they changed the FITID for some
> > reason that would cause this.  Since no one else has said they are
> > having the issue, I'm assuming this is not a GNUCash issue.
> >
> > Does that better explain the issue?
> >
> > I really appreciate the time to respond and help me through this.
> >
> > Michael
> >
> >
> >
> >
> >
> >
> > On Mon, Jul 27, 2020 at 3:50 PM Jean Laroche  > <mailto:rip...@gmail.com>> wrote:
> >
> > There's a misunderstanding here.
> > This is what GC does:
> > - It looks at the OFX transaction, which always has an FITID.
> > - IF GC sees this FITID in one of the register transactions, it skips
> > the OFX transaction, because it's already been imported (when a
> > transaction gets imported from the ofx, the online_id is copied into
> > the
> > register transaction, that's how GC remembers it's already imported
> the
> > transaction).
> > - If the FITID is not found in the register, GC assumes that this is
> a
> > new transaction and attempts to match it with existing transactions
> in
> > your register. BUT:
>

Re: [GNC] Import Transaction Matcher issue in v4

[Fross, Michael]

Hi Christopher.  Alas I do not keep the QFX files.  I'll hang on to them
for now and see if the FIDID does change.

On Mon, Jul 27, 2020 at 4:20 PM Christopher Lam 
wrote:

> As I understand the ofx spec*, the fitid should be an invariant for the
> bank and account. By any chance do you have older qfx files to compare?
>
> * https://www.ofx.net/downloads.html
>
> On Tue, 28 Jul 2020, 4:34 am Fross, Michael,  wrote:
>
>> Thanks Jean / John for your thoughts.  There is a register entry that
>> matches, IMHO, very closely.   I increased the Match Display Threshold
>> from
>> 1 to 3, and then to 6 (which appears to be the highest value allowed.)
>> Every transaction from the import says "Match Missing."
>>
>> Digging around a bit, for the transaction in question, the QFX file
>> contains the FITID of 202007210003:
>>
>> 
>> CREDIT
>> 2020072112
>> 54.00
>> 202007210003
>> ACH Electronic Credit
>> Expenses
>> 
>>
>> My GNUCash file contains, for the same transaction has the online id being
>> 202007210002
>> 
>>   
>> online_id
>> 202007210002
>>   
>>
>> The online_ID is ...002 instead of ...003.  Changing the QFX file to match
>> the online_id value seemed to work.  Now my question is why would this be
>> different for *lots* of transactions.  Everything worked normally in v3,
>> but this would not have changed as part of the release.  I'll check a few
>> more problem transactions and see if I can detect a pattern.  Perhaps
>> Citibank is paying games
>>
>> Michael
>>
>> On Sun, Jul 26, 2020 at 4:57 PM jean laroche  wrote:
>>
>> > To get a match you have to have a transaction in the register that's
>> > sufficiently similar to the one you're importing, and that has not been
>> > imported/matched before.
>> > In your case, it could be one of these reasons (I can't see the image):
>> > - There's no matching transaction in your register (no existing
>> > transaction has amount close, and a date close to the imported one)
>> > - There's a matching transaction but it's already been matched to an
>> > imported transaction at some point so it's not available to be matched
>> > to the new imported one.
>> > - There's a matching transaction that's available, but the match score
>> > is below the threshold that allows the transaction to be shown as a
>> > potential match. Too large a date mismatch can cause that.
>> >
>> > Can you check whether you're in one of these 3 cases? If you're in case
>> > 3, you can lower the minimum matching threshold in the preferences and
>> > see if that helps.
>> > J.
>> >
>> >
>> > On 7/26/2020 2:44 PM, John Ralls wrote:
>> > > If there's no matching transaction already in the account then there's
>> > nothing to clear. In that case only adding or not makes sense.
>> > >
>> > > Regards,
>> > > John Ralls
>> > >
>> > >
>> > >> On Jul 26, 2020, at 1:56 PM, Fross, Michael 
>> wrote:
>> > >>
>> > >> Hello all,
>> > >>
>> > >> I sent this earlier this month and didn't see any reply so I thought
>> I
>> > >> would try again.   Has anyone else seen these issues?  I use Citibank
>> > and
>> > >> perhaps it's a Citibank issue, but I did not have this problem on v2
>> or
>> > v3.
>> > >>
>> > >> Thanks all.  I appreciate the help.
>> > >>
>> > >> Michael
>> > >>
>> > >>
>> > >> On Sat, Jul 4, 2020 at 9:48 AM Fross, Michael 
>> > wrote:
>> > >>
>> > >>> Hello all,
>> > >>>
>> > >>> I typically download QFX files from my banks every day or two,
>> import
>> > them
>> > >>> to clear them in Gnucash.  Worked great.  However, ever since
>> > upgrading to
>> > >>> v4, the importer seems to have trouble matching.  Most of the
>> imported
>> > >>> transactions are listed in the importer as (A)dd, but when I select
>> > >>> (C)lear for them it says match missing.
>> > >>>
>> > >>> This has occurred for several accounts.  Here is a simple credit
>> card
>> > >>> example, although for my checking account, there are dozens like
>> > this.  The
>> > >

Re: [GNC] Import Transaction Matcher issue in v4

[Fross, Michael]

Hi Jean.  Let me try to better explain my issue.

On most days, I download QFX files from my Checking and Credit Card
accounts and import them.  In this way I clear transactions and I can see
what's going on.  The next day I'll do so again, and the importer skips
those that have already been matched per your comment.s  I've been doing
this for years and it's worked well.

Since I updated to V4 the transactions that would have matched previously
now come up with "Match Missing!" in the importer.  I don't want to add
them as they would create duplicates.  Transactions that are not cleared
seem to be able to be matched.  But those that are previously cleared get
the "Match Missing!" issue.

Now, based on what you told me, the QFX file for a problem transaction has
a FITID that is one higher than the ONLINE_ID in the gnucash file for the
same transaction.  So the Match Missing items seems to be correct.

If I duplicate the transaction, delete the original, it matches which I
assume is because there is not an ONLINE_ID associated with the new one.

What I don't understand is if there is an issue with GNUCash, which is why
I asked if others are having the same issue, or if it is/was an issue with
CITIBANK QFX files.  If they changed the FITID for some reason that would
cause this.  Since no one else has said they are having the issue, I'm
assuming this is not a GNUCash issue.

Does that better explain the issue?

I really appreciate the time to respond and help me through this.

Michael






On Mon, Jul 27, 2020 at 3:50 PM Jean Laroche  wrote:

> There's a misunderstanding here.
> This is what GC does:
> - It looks at the OFX transaction, which always has an FITID.
> - IF GC sees this FITID in one of the register transactions, it skips
> the OFX transaction, because it's already been imported (when a
> transaction gets imported from the ofx, the online_id is copied into the
> register transaction, that's how GC remembers it's already imported the
> transaction).
> - If the FITID is not found in the register, GC assumes that this is a
> new transaction and attempts to match it with existing transactions in
> your register. BUT:
> . It only looks at register transactions that have NO FITID (i.e.,
> register transactions that you entered manually, typically)
> . Among those, it looks for transactions that match pretty closely
> for the date and the amount.
> . It picks the one with the highest matching score, if that score is
> above a user-adjustable threshold.
>
> So in the case you outline below, if the register transaction has the
> same FITID as your ofx transaction, the ofx transaction will NOT be
> imported (it will be just skipped).
>
> I think I don't quite understand the problem you're having. Is it that
> you're importing OFX transaction and they're not matching register
> transactions that you entered manually?
> Or is it that they're being imported despite the fact they were imported
> previously?
>
> J.
>
> On 7/27/20 1:31 PM, Fross, Michael wrote:
> > Thanks Jean / John for your thoughts.  There is a register entry that
> > matches, IMHO, very closely.   I increased the Match Display Threshold
> > from 1 to 3, and then to 6 (which appears to be the highest value
> > allowed.)  Every transaction from the import says "Match Missing."
> >
> > Digging around a bit, for the transaction in question, the QFX file
> > contains the FITID of 202007210003:
> >
> > 
> > CREDIT
> > 2020072112
> > 54.00
> > 202007210003
> > ACH Electronic Credit
> > Expenses
> > 
> >
> > My GNUCash file contains, for the same transaction has the online id
> > being 202007210002
> >  
> >
> >  online_id
> >  202007210002
> >
> >
> > The online_ID is ...002 instead of ...003.  Changing the QFX file to
> > match the online_id value seemed to work.  Now my question is why would
> > this be different for *lots* of transactions.  Everything worked
> > normally in v3, but this would not have changed as part of the release.
> > I'll check a few more problem transactions and see if I can detect a
> > pattern.  Perhaps Citibank is paying games
> >
> > Michael
> >
> > On Sun, Jul 26, 2020 at 4:57 PM jean laroche  > <mailto:rip...@gmail.com>> wrote:
> >
> > To get a match you have to have a transaction in the register that's
> > sufficiently similar to the one you're importing, and that has not
> been
> > imported/matched before.
> > In your case, it could be one of these reasons (I can't see the
> image):
> > - There's no matching transaction in your register (no 

Re: [GNC] Import Transaction Matcher issue in v4

[Fross, Michael]

Thanks Jean / John for your thoughts.  There is a register entry that
matches, IMHO, very closely.   I increased the Match Display Threshold from
1 to 3, and then to 6 (which appears to be the highest value allowed.)
Every transaction from the import says "Match Missing."

Digging around a bit, for the transaction in question, the QFX file
contains the FITID of 202007210003:


CREDIT
2020072112
54.00
202007210003
ACH Electronic Credit
Expenses


My GNUCash file contains, for the same transaction has the online id being
202007210002

  
online_id
202007210002
  

The online_ID is ...002 instead of ...003.  Changing the QFX file to match
the online_id value seemed to work.  Now my question is why would this be
different for *lots* of transactions.  Everything worked normally in v3,
but this would not have changed as part of the release.  I'll check a few
more problem transactions and see if I can detect a pattern.  Perhaps
Citibank is paying games

Michael

On Sun, Jul 26, 2020 at 4:57 PM jean laroche  wrote:

> To get a match you have to have a transaction in the register that's
> sufficiently similar to the one you're importing, and that has not been
> imported/matched before.
> In your case, it could be one of these reasons (I can't see the image):
> - There's no matching transaction in your register (no existing
> transaction has amount close, and a date close to the imported one)
> - There's a matching transaction but it's already been matched to an
> imported transaction at some point so it's not available to be matched
> to the new imported one.
> - There's a matching transaction that's available, but the match score
> is below the threshold that allows the transaction to be shown as a
> potential match. Too large a date mismatch can cause that.
>
> Can you check whether you're in one of these 3 cases? If you're in case
> 3, you can lower the minimum matching threshold in the preferences and
> see if that helps.
> J.
>
>
> On 7/26/2020 2:44 PM, John Ralls wrote:
> > If there's no matching transaction already in the account then there's
> nothing to clear. In that case only adding or not makes sense.
> >
> > Regards,
> > John Ralls
> >
> >
> >> On Jul 26, 2020, at 1:56 PM, Fross, Michael  wrote:
> >>
> >> Hello all,
> >>
> >> I sent this earlier this month and didn't see any reply so I thought I
> >> would try again.   Has anyone else seen these issues?  I use Citibank
> and
> >> perhaps it's a Citibank issue, but I did not have this problem on v2 or
> v3.
> >>
> >> Thanks all.  I appreciate the help.
> >>
> >> Michael
> >>
> >>
> >> On Sat, Jul 4, 2020 at 9:48 AM Fross, Michael 
> wrote:
> >>
> >>> Hello all,
> >>>
> >>> I typically download QFX files from my banks every day or two, import
> them
> >>> to clear them in Gnucash.  Worked great.  However, ever since
> upgrading to
> >>> v4, the importer seems to have trouble matching.  Most of the imported
> >>> transactions are listed in the importer as (A)dd, but when I select
> >>> (C)lear for them it says match missing.
> >>>
> >>> This has occurred for several accounts.  Here is a simple credit card
> >>> example, although for my checking account, there are dozens like
> this.  The
> >>> top portion shows the register with the Sprint bill cleared.  The date,
> >>> amount, and name (mostly) match.
> >>>
> >>> [image: image.png]
> >>>
> >>> Not sure if there is just something wrong with my setup or not.
> Perhaps a
> >>> bug?  Are others experiencing this?  Any ideas to get the matcher
> matching
> >>> again?  Something need to get cleared out?
> >>>
> >>> For those of us in the US, happy Independence Day.  Thank you all for
> your
> >>> assistance.
> >>>
> >>> Michael
> >>>
> >> ___
> >> 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-

Re: [GNC] Import Transaction Matcher issue in v4

[Fross, Michael]

Hello all,

I sent this earlier this month and didn't see any reply so I thought I
would try again.   Has anyone else seen these issues?  I use Citibank and
perhaps it's a Citibank issue, but I did not have this problem on v2 or v3.

Thanks all.  I appreciate the help.

Michael


On Sat, Jul 4, 2020 at 9:48 AM Fross, Michael  wrote:

> Hello all,
>
> I typically download QFX files from my banks every day or two, import them
> to clear them in Gnucash.  Worked great.  However, ever since upgrading to
> v4, the importer seems to have trouble matching.  Most of the imported
> transactions are listed in the importer as (A)dd, but when I select
> (C)lear for them it says match missing.
>
> This has occurred for several accounts.  Here is a simple credit card
> example, although for my checking account, there are dozens like this.  The
> top portion shows the register with the Sprint bill cleared.  The date,
> amount, and name (mostly) match.
>
> [image: image.png]
>
> Not sure if there is just something wrong with my setup or not.  Perhaps a
> bug?  Are others experiencing this?  Any ideas to get the matcher matching
> again?  Something need to get cleared out?
>
> For those of us in the US, happy Independence Day.  Thank you all for your
> assistance.
>
> Michael
>
___
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] Import Transaction Matcher issue in v4

[Fross, Michael]

Hello all,

I typically download QFX files from my banks every day or two, import them
to clear them in Gnucash.  Worked great.  However, ever since upgrading to
v4, the importer seems to have trouble matching.  Most of the imported
transactions are listed in the importer as (A)dd, but when I select
(C)lear for them it says match missing.

This has occurred for several accounts.  Here is a simple credit card
example, although for my checking account, there are dozens like this.  The
top portion shows the register with the Sprint bill cleared.  The date,
amount, and name (mostly) match.

[image: image.png]

Not sure if there is just something wrong with my setup or not.  Perhaps a
bug?  Are others experiencing this?  Any ideas to get the matcher matching
again?  Something need to get cleared out?

For those of us in the US, happy Independence Day.  Thank you all for your
assistance.

Michael
___
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] 4.0 and Change in Column Widths

[Fross, Michael]

Hello all,

Congrats on the 4.0 release.  Just installed and I'm looking forward to
setting column width defaults and have them apply across the register
type.  However, on Windows, I'm not seeing any extra options in the Windows
menu:

[image: image.png]

I was expecting
- Use as Default Layout for this Register Group
- Reset Default Layout for this Register Group

Lastly, it seems to remember different register widths per account.  At
least the ones I tried.

Is there something that needs to be done to enable this or am I
misunderstanding something?

Thanks all.

Michael
___
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] QIF file import still doesn't work with Gnucash 3.10

[Fross, Michael]

I have to keep importing the same QFX file over and over until I get
“nothing to import” message. If I don’t, it seems to miss transactions in
the file. Not sure about QIF, but Maybe it’s similar.

Michael

On Tue, May 5, 2020 at 10:53 PM Alan  wrote:

> Took the latest activity on one Chase credit card account and downloaded
> in QIF
> format. Each time, Gnucash went through the motions, but never prompted
> for a
> target account. Then (for only 7 transactions), took a few minutes and then
> brought up a screen attempting to match thousands of 10 year old
> transactions,
> which appear to be earlier failed QIF import attempts.
>
>
>
> But none of the NEW transactions (imported three times now) were read. And
> a
> transaction matching screen is totally wrong. These are new transactions so
> there's NOTHING to match. Same thing with the previous failed import
> attempts.
> No transactions to match.
>
>
>
> This is probably why Gnucash blew the QIF import from Quicken the first few
> times (was also broken in 3.08). Quicken's QIF export went nowhere.
> Thousands
> more transactions ignored, since Gnucash is not looking for any target
> account,
> and there could never be anything to "match." This makes it impossible to
> import
> previously audited, corrected, and reconciled transactions from Quicken.
>
> ___
> 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] AQ Banking Setup Wizard

[Fross, Michael]

Hello everyone,

Running v3.902 on Windows 10 64bit here and have a question.  When I select
Tools | Online Banking Setup and click to "Start AqBanking Wizard" nothing
happens.  The dialog doesn't launch the way it had previously.

I'm wondering if it's just me.  Can anyone else reproduce this with v3.902
on Windows?

Thank you.

Michael
___
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] Asking again - Finance::Quote

[Fross, Michael]

Hello Randy,

When last I installed it I had to make sure both the Strawberry\c\bin and
the Strawberry\Perl\bin in my path.  Maybe that will help?

Michael

On Sat, May 2, 2020 at 3:25 PM Randy Brachman  wrote:

> I asked for suggestions on this 9 days ago, but haven't gotten any.  Anyone
> have recommendations for where else I might get ideas?
>
> Windows 10 Pro 10.0.18362 on a Dell XPS 8300 x64 PC.
>
> gnucash version (Help/About):
> Version: 3.10
> Build ID: 3.10+(2020-04-11)
> Finance::Quote: -
>
> F::Q seems to be installed, having used the Windows "Install Online Price
> Retrieval" tool.
>
> gnc-fq-check,  gnc-fq-dump,  gnc-fq-helper,  gnc-fq-update all report
> successful completion and/or retrieval of data.
> gnc-fq-check:
> ("1.49" "adig" "aex" "aiahk" "alphavantage"   "yahoo_json" "yahoo_yql"
> "za" "za_unittrusts")
> gnc-fq-update:
> ... Updating database file ... Done!
> Date::Manip is up to date (6.81).
> Finance::Quote is up to date (1.49).
>
> gnc-fq-dump nyse ibm:
> perl gnc-fq-dump nyse ibm
> Finance::Quote fields Gnucash uses:
> symbol: ibm  <=== required
>   date: 05/01/2020   <=== recommended
>   currency: USD  <=== required
>   last: 121.8700 <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
>
> Strawberry Perl successfully installed.
> "This is perl 5, version 30, subversion 2 (v5.30.2) built for
> MSWin32-x64-multi-thread"
>
> gnucash Security Editor indicates >Warning: Finance::Quote not installed
> properly.<
> Entire area below "Quote Source Information" header is grayed out.
> Numerous uninstall and reinstall for gnucash, Perl, F::Q without any change
> to this situation.  As far as I can tell, everything else seems OK.
>
> Thanks for any help.
>
> *Randy Brachman *
>
> * -- *
> ___
> 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] Reconcile on Import Quick Question

[Fross, Michael]

Thanks Jean.  I'm sure I'm not the only one that imports without
reconciling.  I appreciate you looking into it.

Have a great day.

Michael

On Tue, Apr 28, 2020 at 10:42 AM Jean Laroche  wrote:

> It cannot be turned off at the moment, but I think given your
> experience, there should be an option to disable it.
> I'll look into adding that if other devs agree.
> Jean
>
> On 4/28/20 8:35 AM, Fross, Michael wrote:
> > Hello everyone.  I installed 3.902 this morning (after uninstalling the
> > previous version) and had a quick question.  I tend to download and
> import
> > from my bank accounts every day.  When I was doing so today, after the
> > import, the reconcile dialog appeared.  I only reconcile monthly when I
> get
> > my statements, so I looked to turn this off but could not find the
> option.
> > This did not occur in previous versions or I had figured out how to
> disable.
> >
> > I'm guessing I'm missing something, but I couldn't determine how to do
> > that.  Any pointers in the right direction?
> >
> > Thank you.
> >
> > Michael
> > ___
> > 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.

[GNC] Reconcile on Import Quick Question

[Fross, Michael]

Hello everyone.  I installed 3.902 this morning (after uninstalling the
previous version) and had a quick question.  I tend to download and import
from my bank accounts every day.  When I was doing so today, after the
import, the reconcile dialog appeared.  I only reconcile monthly when I get
my statements, so I looked to turn this off but could not find the option.
This did not occur in previous versions or I had figured out how to disable.

I'm guessing I'm missing something, but I couldn't determine how to do
that.  Any pointers in the right direction?

Thank you.

Michael
___
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] Scheduled Transaction Calculations

[Fross, Michael]

Hi John,

I got it to work, but one challenge remains.  The load-from-path seems to
crash Gnucash.  But copying the app-utils.scm to the fin.scm folder solves
the problem, but it's sloppy.

I'll need to play around with it.

Secondly, I it didn't like the name "days-in-prev-mon"  But I shortened it
and took out the dashes and that seems ok.  Here is what I inserted in
fin.scm:

;; Return number of days in the previous month
(load-from-path "C:\Program Files
(x86)\gnucash\share\gnucash\scm\gnucash\app-utils")
(define (gnc:numdayslastmon)
   (/
  (+ 1
 (- (gnc:get-end-prev-month) (gnc:get-start-prev-month))) 86400)
)


Thanks again for your help!

Michael

On Fri, Nov 1, 2019 at 3:25 PM Fross, Michael  wrote:

> Thanks John.  I'll give is a shot and report back.
>
> Michael
>
> On Fri, Nov 1, 2019 at 2:34 PM John Ralls  wrote:
>
>>
>>
>> > On Nov 1, 2019, at 9:36 AM, Fross, Michael  wrote:
>> >
>> > Hello all,
>> >
>> > I have a scheduled transaction that I pay monthly which is a fixed
>> amount
>> > per day.  I'd love to be able to have is automatically entrer based on
>> the
>> > number of days per month.  I pay on the 1st (or the first business day
>> > after that) so basically I'd like to use the following formula:
>> >
>> > Amount = NumDaysInPreviousMonth * AmountPerDay
>> >
>> > I looked through the guide
>> > <https://wiki.gnucash.org/wiki/Scheduled_Transactions> and didn't see
>> > anything.  It references fin.scm (link throws a 404 by the way) but I
>> > didn't see anything here that calculated the number of days in the
>> previous
>> > month (but perhaps I missed it in the SCM code.)
>> >
>> > This seems like a simple use case, am I missing something? Perhaps I'll
>> > need to write a function in fin.scm that can return the number of days
>> in a
>> > provided month.  No idea how to use scheme, but I'm sure I can figure it
>> > out.
>> >
>> > Thoughts?
>>
>> I fixed the link.
>>
>> The closest functions in GnuCash would be gnc:get-start-prev-month and
>> gnc:get-end-prev-month. They return time64 so you'd divide the difference
>> by 86400 (the number of seconds in a day) after adding in 1 second to
>> compensate for gnc:get-start-prev-month's returning the first second of the
>> month rather than the last second of the month before.
>>
>> You could try adding this to fin.scm:
>>
>> (load-from-path "gnucash/app-utils")
>> (define (gnc:days-in-prev-month) (/ ( + 1 (- (gnc:get-end-prev-month)
>> (gnc:get-start-prev-month 86400))
>>
>> Then use
>>   days-in-prev-month() * AmountPerDay
>> in your scheduled transaction. Replace "AmountPerDay" with the actual
>> numeric amount or the Since Last Run dialog will ask for the amount every
>> month.
>>
>> I've never actually tried doing anything like that, but it might work.
>>
>> 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] Scheduled Transaction Calculations

[Fross, Michael]

Thanks John.  I'll give is a shot and report back.

Michael

On Fri, Nov 1, 2019 at 2:34 PM John Ralls  wrote:

>
>
> > On Nov 1, 2019, at 9:36 AM, Fross, Michael  wrote:
> >
> > Hello all,
> >
> > I have a scheduled transaction that I pay monthly which is a fixed amount
> > per day.  I'd love to be able to have is automatically entrer based on
> the
> > number of days per month.  I pay on the 1st (or the first business day
> > after that) so basically I'd like to use the following formula:
> >
> > Amount = NumDaysInPreviousMonth * AmountPerDay
> >
> > I looked through the guide
> > <https://wiki.gnucash.org/wiki/Scheduled_Transactions> and didn't see
> > anything.  It references fin.scm (link throws a 404 by the way) but I
> > didn't see anything here that calculated the number of days in the
> previous
> > month (but perhaps I missed it in the SCM code.)
> >
> > This seems like a simple use case, am I missing something? Perhaps I'll
> > need to write a function in fin.scm that can return the number of days
> in a
> > provided month.  No idea how to use scheme, but I'm sure I can figure it
> > out.
> >
> > Thoughts?
>
> I fixed the link.
>
> The closest functions in GnuCash would be gnc:get-start-prev-month and
> gnc:get-end-prev-month. They return time64 so you'd divide the difference
> by 86400 (the number of seconds in a day) after adding in 1 second to
> compensate for gnc:get-start-prev-month's returning the first second of the
> month rather than the last second of the month before.
>
> You could try adding this to fin.scm:
>
> (load-from-path "gnucash/app-utils")
> (define (gnc:days-in-prev-month) (/ ( + 1 (- (gnc:get-end-prev-month)
> (gnc:get-start-prev-month 86400))
>
> Then use
>   days-in-prev-month() * AmountPerDay
> in your scheduled transaction. Replace "AmountPerDay" with the actual
> numeric amount or the Since Last Run dialog will ask for the amount every
> month.
>
> I've never actually tried doing anything like that, but it might work.
>
> 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] Scheduled Transaction Calculations

[Fross, Michael]

Hello all,

I have a scheduled transaction that I pay monthly which is a fixed amount
per day.  I'd love to be able to have is automatically entrer based on the
number of days per month.  I pay on the 1st (or the first business day
after that) so basically I'd like to use the following formula:

Amount = NumDaysInPreviousMonth * AmountPerDay

I looked through the guide
 and didn't see
anything.  It references fin.scm (link throws a 404 by the way) but I
didn't see anything here that calculated the number of days in the previous
month (but perhaps I missed it in the SCM code.)

This seems like a simple use case, am I missing something? Perhaps I'll
need to write a function in fin.scm that can return the number of days in a
provided month.  No idea how to use scheme, but I'm sure I can figure it
out.

Thoughts?

Thank you.

Michael
___
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 3.6 online banking with Chase, NEWFILEUID bug

[Fross, Michael]

Hi Dave,

Here are my quick notes on how I setup my Chase credit card download. Hope
it helps.


   1. Generated a Version 4 UUID here:
  1. https://www.uuidgenerator.net/version4
   2. Entered it in my user settings CLientUID field in the aqbanking
   wizard - without the dashes
   3. Changed the Header version to 103 (was 102)
   4. Connect and instant success!  Transactions and balance
   downloaded with no error messages in log.
   5. Go to your Chase Secure message box and allow the connection



AppID: QWIN

App Version: 2200

Header Version: 103


Michael

On Mon, Sep 23, 2019 at 10:07 PM David Reiser via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I’ve been using gnucash/aqbanking for several years to retrieve credit
> card transactions from Chase. I just checked my ofx.log file, and sending
> the NEWFILEUID with the .000 on the end does not affect my downloads.
> --
> Dave Reiser
> dbrei...@icloud.com
>
>
>
>
>
> > On Sep 23, 2019, at 10:47 PM, Eric Haszlakiewicz <
> hawicz+gnuc...@gmail.com> wrote:
> >
> > I've been trying to figure out why I'm not able to get GnuCash to connect
> > to Chase's online banking, and I think I've tracked down the difference
> > between a working request and the failing ones.
> >
> > Following
> >
> https://stackoverflow.com/questions/48157580/how-do-i-programmatically-download-my-bank-transactions-from-chase-without-using
> > and
> > the script it links to (
> > https://raw.githubusercontent.com/agtsai-i/ofx/master/ofx-ba-tfb.py), I
> was
> > able to successfully fetch an account list.
> > Comparing that to GnuCash's ofx.log, there are a handful of differences,
> > but the one that seems to be causing the problem is the NEWFILEUID
> header.
> > GnuCash sends a header that looks like:
> > NEWFILEUID:20190923223547.000
> >
> > While that python script sends a uuid, e.g.:
> > NEWFILEUID:83339694c9e8454391bb91ea0deb8839
> >
> > Chase does not like the GnuCash value, but merely dropping the ".000" off
> > the end seems to be enough to get things working.  So, I have a couple of
> > questions:
> > * Has this been fixed in a newer version of GnuCash?  I'm using GnuCash
> 3.6
> > because 3.7 just crashes (see my other email "GnuCash 3.7 crash in online
> > banking").
> > * Is there an easy way to tweak was GnuCash sends without needing a new
> > release?
> >
> > Thanks,
> > Eric
> > ___
> > 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.

Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

[Fross, Michael]

I agree as well. This was confusing to me when I started.

 I also think instead of putting a “Y” in the reconciled column in the
register, I would put a “R”.

Michael

On Mon, Aug 5, 2019 at 9:46 PM Robin Chattopadhyay 
wrote:

> +1
>
> On Mon, Aug 5, 2019 at 7:53 PM David Cousens 
> wrote:
>
> > I have raised bugs in the
> > code(https://bugs.gnucash.org/show_bug.cgi?id=797338) and documentation
> > (https://bugs.gnucash.org/show_bug.cgi?id=797337) proposing changing the
> > "U+R" and "R" tags in the import main matcher to "U+C" and "C" where the
> > curent use of R refers to the term reconciliation. The use of the term
> > reconciliation in this context may cause some confusion with the
> > reconciliation process of checking transactions for a period against an
> > external statement, particularly for new users. The import matcher does
> > not
> > assign a "reconciled" status to an imported transaction but does set it
> as
> > "c" cleared. You would not normally be importing transactions in which
> the
> > splits to the account being imported to are already reconciled, i.e.
> > marked
> > "y" in a register however this might occur if you are importing records
> > separately to a credit and a bank account where there are transfers
> > between
> > them (credit card payments). In this case the importer would flag the
> > record
> > not to be imported where there is an exact match to an existing
> > transaction.
> > AFAIK there is no checking of the reconciliation status of the existing
> > transaction in GnuCash in the matching process but I may not yet have dug
> > deeply enough.
> >
> > In a discussion with John Ralls and Frank Ellenberger over other changes
> > to
> > the import matcher documentation, I initially proposed "U+M" and "M".
> John
> > felt "U+C" and "C were more indicative and clearer.
> >
> > I am raising this here to canvas a wider audience before making the
> > changes.
> > Please comment here preferrably (or in the bug comments)  if you have any
> > objections/support  to the proposed change .
> >
> > As John has suggested this is copied from GnuCash Dev to GnuCash users to
> > further widen the input.
> >
> > David Cousens
> >
> >
> >
> > -
> > David Cousens
> > --
> > Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > 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.

Re: [GNC] Online price retrieval

[Fross, Michael]

Did you confirm that the following are in your path?  I had a few issues
until both were there.  perl/bin is probably added during installation, but
the c\bin entry was not for me.

C:\Strawberry\c\bin
C:\Strawberry\perl\bin

If you are not certain what that means, go to Control Panel, System,
Advanced System Settings, Environment Variables.

Make sure the two preceding directories are part of the PATH variable which
is a semi-colon delimited list of directories that are searched if you are
running an executable file that is not in your current directory.

If they are not there you can append the missing ones to the existing path
variable.  It doesn't really matter which as they are concatenated during
the actual search.

Hope this helps.

Michael
___
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

[Fross, Michael]

Hello. I just had to reinstall strawberry Perl on windows 10. I just
downloaded the 64 bit version and installed it.  Then make sure both it’s
perl/bin and the c/bin directories are in your path. I had to add the c/bin
manually. Without it cpan was unable to build correctly.

After I installed Date::Manip and Finance::Quote GC was able to down my
quotes per usual. I use yahoo-Json as my quote source.

Michael

On Mon, Jul 15, 2019 at 10:05 PM John Ralls  wrote:

> Please remember to copy the list on all replies. "Reply All" works well
> for most mail clients.
>
>
> Sounds like Strawberry Perl didn't get installed all the way. There should
> be a download in your downloads directory, but if there isn't you can
> download the latest version from http://strawberryperl.com/. Try
> installing it by hand. If it doesn't work there's a support link in the
> upper right corner of that page.
>
> Regards,
> John Ralls
>
>
> > On Jul 15, 2019, at 5:24 PM, duru...@netzero.net wrote:
> >
> > Thank you for your response.
> >
> > The Strawberry Perl folder does exist.
> > However, there is no object inside that folder named CPAN Client (Or CPAN
> > anything, for that matter).
> >
> > The contents of the Strawberry Perl folder are:
> >Perl (command line)
> >Strawberry Perl README
> >Strawberry Perl Release notes
> >Related websites
> >Tools
> >
> > On the off chance that it might work, I ran CPAN Client as a command
> from the
> > DOS prompt.
> >
> > The first error message was :
> >Couldn't fork at test.p1 line 44.
> >Client couldn't establish a connection to localhost at test.p1 line
> 57.
> >   dmake.exe:  Error code 153, while making "test_dynamic'
> >   EESTABR00/Crypt-HCE_SHA-0.75.tar.gz
> >
> > So it appearss that something is missing.
> >
> > Joe D.
> >
> >
> >
> > -- Original Message --
> > From: John Ralls 
> > To: "duru...@netzero.net" 
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Online price retrieval
> > Date: Mon, 15 Jul 2019 13:28:07 -0700
> >
> >
> >
> > > On Jul 14, 2019, at 6:06 PM, duru...@netzero.net wrote:
> > >
> > > Does anyone know (or think he/she knows) whether online price
> retrieval is supposed towork with windows version 6.1.7601?  I ran the
> install procedure, but it seems to havefailed.  It didn't leave a log file
> that I could identify, so I don't really know what to look at. Joe D.
> duru...@netzero.net
> > > 
> >
> > Yes, it should work on Win7.
> >
> > Look in the Start Menu for a folder named Strawberry Perl. If it's there
> then open it and pick "CPAN Client". You'll get a terminal window with a
> cpan>prompt. Tell it:
> >
> >  install Date::Manip
> >
> > and if that completes without errors
> >
> >  install Finance::Quote
> >
> > If they both complete successfully online quotes should work inside of
> GnuCash. If either fails or if the Strawberry folder is missing come back
> with details.
> >
> > Regards,
> > John Ralls
> >
> >
> >
> > 
> > Exposed: Big Pharma’s Lies About Diabetes
> > glucotype2.com
> > http://thirdpartyoffers.netzero.net/TGL3242/5d2d1970641fa19704e31st01duc
> >
>
> ___
> 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] Downgrading to 2.6.21

[Fross, Michael]

If you don't mind my asking, why are you downgrading?  What have you found
that you prefer in 2.6.21?

Michael

On Sat, Apr 6, 2019 at 1:26 PM Greg Feneis  wrote:

> Hi,
>
> I've done some work in 3.5 and I'm considering downgrading to 2.6.21.
>
> Can 2.6.21 work with the xml .gnucash file once it was changed and saved by
> 3.5?
>
> Kind regards,
>
> Greg
> ___
> 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] v3.5 Save Times

[Fross, Michael]

Hello devs,

Just wanted to say a big thank you for v3.5   I can't believe how fast my
XML file saves with the new version.  It was never that bad (~12 seconds on
my SSD) but now it saves in just a few.

Congrats on the release and all of the bug fixes and enhancements.

Michael
___
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] New User-Chase Bank Problems

[Fross, Michael]

Hello,

I remember spending a lot of time to get it to work with my Chase Freedom
card.  There were 2 things that needed be done.  #1, create a UUID and #2,
go onto the website after you try it and give access.

Summary:
1. Generated a Version 4 UUID here:
a. https://www.uuidgenerator.net/version4
2. Entered it in my user settings ClientUID field in the aqbanking wizard -
without the dashes
3. Changed the Header version to 103 (was 102)
4. Connect and instant success!  Transactions and balance downloaded with
no error messages in log.
Go to your Chase Secure message box and allow the connection

Thanks to Dave Reiser for figuring it out...I basically followed his
instructions.  If you'd like me to paste the entire email let me know.  I
saved it along with my summary above.

Michael

On Sat, Dec 15, 2018 at 7:32 PM David Reiser via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> > On Dec 15, 2018, at 8:10 PM, Michael Mantei  wrote:
> >
> > I was a user of Quicken for as long as I can remember.  I'm now trying
> to get serious about my finances and recently installed GNUCash on my
> Windows 10 system. I simply installed the software, and built my entire
> account structure manually, to match exactly what I wanted it to be. Now I
> need to connect to my bank (Chase) and can't do it.
> >
> > I'm using the AQBanking Wizard and have setup a user account and it
> won't connect.  I started reading lots of messages here then created a new
> user.  This one has the User Name and User Id set to the same name I used
> with Quicken. I used an online app to generate a Client UID. I've selected
> JPMorqan Chase Bank as my bank and took the defaults on the Bank Settings
> page. For the Application Settings, I have an Application ID of "QWIN". The
> application version is set to 2700 and the header version is set to 103.
> When I try to retrieve the account list, this is what I get:
> >
> >
> > 14:06:57 Retrieving SSL certificate
> > 14:06:57 Connecting to server...
> > 14:06:57 Using GnuTLS default ciphers.
> > 14:06:57 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> > 14:06:57 Signer not found
> > 14:06:57 Certificate is not trusted
> > 14:06:57 Connected.
> > 14:06:57 Disconnected.
> > 14:06:57 Connection ok, certificate probably received
> > 14:06:57 Operation finished, you can now close this window.
> >
> > The OFX.log file shows this:
> >
> > Sending:
> > -
> > OFXHEADER:100
> > DATA:OFXSGML
> > VERSION:103
> > SECURITY:NONE
> > ENCODING:USASCII
> > CHARSET:1252
> > COMPRESSION:NONE
> > OLDFILEUID:NONE
> > NEWFILEUID:20181214144405.000
> >
> > 20181214144405.000#NAME
> REMOVED#
> > #PASSWORD REMOVED#
> > ENGChase
> Bank1601QWIN22004f67a05f-bb69-45a7-ab66-d1f52dc4ef7120181214144405.000119691231
> >
> > -
> >
> > Anyone have any ideas what I am doing wrong? Your help would be greatly
> appreciated.
> >
> > SciFiGeek
> >
>
> The ofx log says you set the APPVER to 2200 instead of 2700. That probably
> matters.
>
> Another thing is that you’re likely to have to do is log into the Chase
> web site, and check your secure messages for one that asks you if you were
> the one trying to sign in with a previously unknown app (as identified by
> the new unique CLIENTUID). Once you’ve followed the steps in the Chase
> message, you’ll be in better shape. If you have no message yet, there’s a
> possibility that the Chase system doesn’t think your software is capable
> anyway (APPVER too low). Change the APPVER, try Aqbanking again, and then
> check your account messages online again.
>
> I only have Chase credit cards. I don’t know if the procedure is different
> for checking and savings accounts. Chase does by default charge a fee for
> checking/savings access via OFXDirectConnect. But since you’ve connected
> before, I’m assuming that isn’t causing you problems.
>
> I also don’t know if Chase has changed the out-of-band verification steps
> since the first round two years ago. Good luck.
>
>
> --
> Dave Reiser
> dbrei...@icloud.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.
___
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] AqBanking help for Citi CC

[Fross, Michael]

Hi Jim.  I think we can end this discussion.  I decided to install v3.3 on
another windows 10 machine.  It worked. There is either something broken on
my main machine (doubtful) or some security software my employer installed
is causing the issue (more probable.)

Your "username " discovery has really been helpful and I have it working.
I may just need to move my GNC installation to my home machine instead of
my work laptop.

Your generosity in helping me troubleshoot has been amazing.  Thank you so
much.

Michael

On Mon, Oct 29, 2018 at 12:35 AM Jim Maki via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> > Accquiring lock: Started.
>
> > Accquiring lock: 2812 of 6
>
> > <..>
>
> > Accquiring lock: 59984 of 6
>
> > Accquiring lock: 5 of 6
>
> > Accquiring lock: Finished.
>
> > 3:2018/10/28
>
> >
> 11-04-37:gwen(39044):C:/gcdev64/gnucash/releases/src/gwenhywfar-4.20.0/plugins/configmgr/dir/c
>
> > fgdir.c:  469: Could not lock group [shared/certs]: 2
>
> > 3:2018/10/28
>
> >
> 11-04-37:aqbanking(39044):C:/gcdev64/gnucash/releases/src/aqbanking-5.7.8/src/libs/aqbanking/b
>
> > anking_cfg.c:  303: Could not lock shared group [certs] (-109)
>
> > 4:2018/10/28
>
> >
> 11-04-37:aqbanking(39044):C:/gcdev64/gnucash/releases/src/aqbanking-5.7.8/src/libs/aqbanking/g
>
> > ui/abgui.c:  147: Could not lock certs db, asking user (-109)
>
> This is a file locking issue and you just have to delete the ".lck" files.
> For a description of file locking see:
>
>
> https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html#basics-backuplock2
>
> For the AqBanking directory on Windows containing the lock files, see
> table 2.4 in:
>
>
> https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-migrate-settings.html
>
> If you want real detail, I believe the actual locking code is fslock.c:
>
>
> https://github.com/cstim/gwenhywfar/blob/master/src/os/windows/fslock.c
>
> You'll see to lock a directory "D" they create a lock file "D/.dir.lck"
> and to lock a file "F" they lock "F.lck". These are the files you should
> delete.
>
> Those tidbits make me want to skim through the whole GnuCash Tutorial and
> Concepts Guide:
>
>  https://www.gnucash.org/docs/v3/C/gnucash-guide/
>
> > So it seems the account never gets configured into AQBanking...that's a
> hint I think. AQBanking does not record the account.
>
> Given Chase works for you but Citi only lacks the account setup, you're
> almost there. All you have to do is manually create the account part (given
> that you've created the user part).
>
> Start the AqBanking wizard: Tools ==> Online Banking Setup ... ==> Next
> ==> Start AqBanking Wizard.
>
> Edit the user you already created to verify it's correct, but don't use
> "Retrieve Account List". Once you're satisfied it's right, close the user
> and then click on Accounts ==> Create Account and fill it in (see below).
>
> Once you close the "AqBanking Setup" window just make sure it's mapped to
> the right GnuCash account and you should be good to go.
>
> For convenience, here's the configuration I posted before (updated to
> version 2900):
>
> AqBanking Setup
>
> ==>  User Settings
>
> >  User Name - "YOURUSERID"
>
> >  User Id - "YOURUSERID " (trailing space)
>
> >  Client UID - not specified
>
> ==>  Bank Settings
>
> >  Bank Name - "Citi Credit Card"
>
> >  Broker Id - "Citigroup"
>
> >  FID - "24909"
>
> >  ORG - "Citigroup"
>
> >  Server URL -
>
> "https://www.accountonline.com/cards/svc/CitiOfxManager.do;
>
> ==>  Application Settings
>
> >  Application ID - "QWIN"
>
> >  Application Version - "2900"
>
> >  Header Version - "103"
>
> >  No Special Settings
>
> ==>  Account Info
>
> >  Account Number - "YOUR CC NUMBER"
>
> >  Account Name - "Citigroup"
>
> >  IBAN - not specified
>
> >  Owner Name - not specified
>
> >  Currency - "US Dollar (USD)"
>
> >  Account Type - "Credit Card Account"
>
> ==>  Bank Info
>
> >  Country - "United States of America (US)"
>
> >  Bank Code - "www.accountonline.com"
>
> >  Bank Name - "www.accountonline.com"
>
> >  SWIFT BIC - not specified
>
> >  Selected User - the user you defined above
>
> Hope that helps.
>
>Jim
>
> ___
> 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:

Re: [GNC] AqBanking help for Citi CC

[Fross, Michael]

Thanks a lot for the help Jim.  I'm responded to your questions inline in
RED (assuming your mail client support colors) prefaced with [FROSS].

Your information is really helpful Jim and I appreciate the time you took
to respond.  Given I can download the Chase information successfully, it
seems like AQBanking is working.but not sure why CITI works on Ubuntu
but not Windows.  I could only test v3.2 on Ubuntu, so I think I'll
downgrade my Windows version to v3.2 and see if that works.  It's a bit
more of an "apples to apples" comparison.

Michael

On Sun, Oct 28, 2018 at 2:22 AM Jim Maki via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> Three areas of comment to some potential problem areas ...
>
>
>
> ===> Windows certificate bundle is OK
>
> To verify the Windows certificate file is not an issue I copied the the
> following certificate bundle from Windows to Ubuntu:
>  C:\Program Files (x86)\gnucash\share\gwenhywfar\ca-bundle.crt
>
> On Ubuntu, Citi's cert was validated using the Windows cert bundle via
> the following command:
>  curl ... \
>  --cacert ca-bundle.crt --capath . \
>  https://www.accountonline.com/cards/svc/CitiOfxManager.do
>
> So the Windows GnuCash certificate bundle is not the issue.
>
>
> ===> Error on gnutls_bye: -24 might be some password issue
>
> Looking at:
>
>  http://mcs.une.edu.au/doc/manual/gnutls.html
>
> the theme for error code -24 (GNUTLS_E_DECRYPTION_FAILED) was about
> passwords, either no password, password not in ASCII, wrong, ... . This
> is a certificate password vs your password which is passed in the OFX
> XML and not used in the connection setup.
>
>
>
> ===> Comparing your vs my system output - where does it differ?
>
>
> Can you compare your system with the following from my Windows 10?
>
> On a powershell terminal session see what's the default text encoding
> via "[System.Text.Encoding]::Default":
>
>PS===> [System.Text.Encoding]::Default
>
>IsSingleByte  : True
>BodyName  : iso-8859-1
>EncodingName  : Western European (Windows)
>HeaderName: Windows-1252
>WebName   : Windows-1252
>WindowsCodePage   : 1252
>IsBrowserDisplay  : True
>IsBrowserSave : True
>IsMailNewsDisplay : True
>IsMailNewsSave: True
>EncoderFallback   : System.Text.InternalEncoderBestFitFallback
>DecoderFallback   : System.Text.InternalDecoderBestFitFallback
>IsReadOnly: True
>CodePage  : 1252
>
> [FROSS]  My output matches yours.

>
> On a DOS terminal session get the OS version via "ver":
>
>===> ver
>Microsoft Windows [Version 10.0.17134.376]
>

[FROSS] Mine seem seems to be a bit of an older build:  Microsoft Windows
[Version 10.0.17134.345]

>
> On the same DOS terminal see the AqBanking version:
>
>===> cd "C:\Program Files (x86)\gnucash\bin"
>===> aqbanking-cli.exe  versions
>3:2018/10/27
> 21-25-19:gwen(5224):C:/gcdev64/gnucash/releases/src/gwenhywfar-4.20.0/src/base/i18n.c:
>
> 120: No translation found for WIN32 locale [English_United States.1252]
>Versions:
> AqBanking-CLI: 5.7.8
> Gwenhywfar   : 4.20.0.0
> AqBanking: 5.7.8.0
>

[FROSS]  I have the same version as you

>
> AqBanking version 5.7.8 looks like the latest:
>https://www.aquamaniac.de/sites/download/packages.php
>
> [FROSS]  I looked earlier as well.  Looks like there is a 5.9.9 beta, but
not a stable version.
https://www.aquamaniac.de/rdm/projects/aqbanking/files


> Run aqbanking-cli to show your accounts (note the locale error message):
>
>===> REM Show the account to work with
>===> aqbanking-cli  listaccs
>3:2018/10/27
> 20-20-43:gwen(8124):C:/gcdev64/gnucash/releases/src/gwenhywfar-4.20.0/src/base/i18n.c:
>
> 120: No translation found for WIN32 locale [English_United States.1252]
>Account www.accountonline.com   YOURCCACCOUNT www.accountonline.com
> Citigroup


[FROSS] This shows a Chase credit card, but not Citibank account.  GNUCash
shows the user defined, but I don't think I ever successfully connected to
my bank.  I get the "Error on gnutls_bye: -24" error when I first attempt
to contact the bank before I ever even enter in my account password.  When
setting up a new user, but before "Retrieve Accounts" the setup tool
reaches out to the bank.  I get the following output:

TITLE: Setting Up OFX DirectConnect User
---
10:56:12 Retrieving SSL certificate
10:56:12 Connecting to server...
10:56:12 Using GnuTLS default ciphers.
10:56:12 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
10:56:12 Signer not found
10:56:12 Certificate is not trusted
10:57:21 Connected.
10:57:21 Error on gnutls_bye: -24 (Decryption has failed.)
10:57:21 Disconnected.
10:57:21 Connection ok, certificate probably received
10:57:21 Operation finished, you can now close this window.

The attempt times out (I have to wait 30 seconds or so) 

Re: [GNC] AqBanking help for Citi CC

[Fross, Michael]

Hello everyone,

I was able to get the download to work without issue using Jim's "space"
modification on Ubuntu with Gnucash v2.6.19 and on v3.2.   I have been
unable to get v3.3 to download on Windows.

It seems to just be an issue with windows.  I don't get the

*Error on gnutls_bye: -24 (Decryption has failed.)*

in Ubuntu with either 2.6.19 or 3.2.

Michael

On Thu, Oct 25, 2018 at 9:15 AM Fross, Michael  wrote:

> Interesting!
>
> I installed the GNUCash v2.6.19 on Ubuntu (the one in the repo) and it
> worked fine!  I'm going to try v3.3 on Ubuntu and see if I can narrow this
> down to a windows problem (which is my assumption) or a 3.3 issue for me.
>
> Thanks.  I'll report back when I have additional information.
>
> Michael
>
> On Wed, Oct 24, 2018 at 9:17 AM Fross, Michael  wrote:
>
>> Hello Jim,
>>
>> This is great news.  I had the Citibank Credit Card download working for
>> years, but it broke early this year.  I've attempted to setup GNUCash based
>> on the above, but continue to struggle.  I receive the following error
>> during the initial bank connection:
>>
>> *Error on gnutls_bye: -24 (Decryption has failed.)*
>>
>> After looking at your OFX settings above, I used the following during the
>> GNUCash setup:
>>
>>- Create User - Select OFX
>>- Bank Name:  Citi Credit Card
>>- Broker Id:
>>- FID: 24909
>>- ORG: Citigroup
>>- Server URL:
>>https://www.accountonline.com/cards/svc/CitiOfxManager.do
>>- User Name: myusername
>>- User Id: myusername<--- I added a space per your comments
>>- Client UID:
>>- Emulated App: Quicken 2013
>>- Application ID: QWIN
>>- Application Version: 2400
>>- Header Version: 103
>>
>> After accepting the certificate , the log window has that error.  If I
>> retrieve accounts after this, I get the following:
>>
>> 09:12:27 Sending request...
>> 09:12:27 Using GnuTLS default ciphers.
>> 09:12:28 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
>> 09:12:28 Signer not found
>> 09:12:28 Certificate is not trusted
>> 09:13:31 Waiting for response...
>> 09:13:31 No message received
>> 09:13:31 Network error while waiting for response
>> 09:13:31 Operation finished, you can now close this window.
>>
>> I have a long password, but no special characters in it.  I'm on windows
>> and need to read up a bit more on how to get the OFX.log.  Setting the ENV
>> variable and starting GNUCash from the command session didn't seem to
>> produce one.
>>
>> I appreciate the guidance and the time.  I'm sure a lot of people use
>> Citi Cards and your debugging can benefit a lot of people.  Can you provide
>> any differences in your GNUCash config settings that what I have above?
>> I've tried a few variations but to no avail.
>>
>> Thank you!
>>
>> Michael
>>
>>
>> On Tue, Oct 23, 2018 at 11:12 PM Jim Maki via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>>
>>> I just successfully set up GnuCash to download Citi credit card data
>>> using AqBanking - for now all you have to do is add a space to the end
>>> of your userid (assuming everything else is correct).The issue seems to
>>> be with Citi ...
>>>
>>> When it consistently failed with code 403, I turned on OFX logging
>>> (export AQOFX_LOG_COMM=1), snagged the OFX request (from /tmp/ofx.log),
>>> formatted it to make it more readable, and created a bash script using
>>> curl to make the OFX request. Paradoxically it worked while the
>>> equivalent un-beautified GnuCash request failed.
>>>
>>> After little debugging, the key lines in the GnuCash ofx.log were:
>>>
>>> == OFX ==
>>> ...
>>> ... myuserid
>>> mypassword
>>> ...
>>> == OFX ==
>>>
>>> The above will work if you add a space either at the end of the
>>> "...myuserid" line, or before "" in the next line. At
>>> the GnuCash user interface level that involves adding a trailing space
>>> to the AqBanking userid for Citi.
>>>
>>> For reference, below is the OFX template file I use to feed my
>>> curl-based script. Eventually GnuCash makes an equivalent request.
>>> (Again, eliminate the leading spaces before "" and it, too
>>> fails.)
>>>
>>> == OFX ==
>>> OFXHEADER:100
>>> DATA:OFXS

Re: [GNC] AqBanking help for Citi CC

[Fross, Michael]

Interesting!

I installed the GNUCash v2.6.19 on Ubuntu (the one in the repo) and it
worked fine!  I'm going to try v3.3 on Ubuntu and see if I can narrow this
down to a windows problem (which is my assumption) or a 3.3 issue for me.

Thanks.  I'll report back when I have additional information.

Michael

On Wed, Oct 24, 2018 at 9:17 AM Fross, Michael  wrote:

> Hello Jim,
>
> This is great news.  I had the Citibank Credit Card download working for
> years, but it broke early this year.  I've attempted to setup GNUCash based
> on the above, but continue to struggle.  I receive the following error
> during the initial bank connection:
>
> *Error on gnutls_bye: -24 (Decryption has failed.)*
>
> After looking at your OFX settings above, I used the following during the
> GNUCash setup:
>
>- Create User - Select OFX
>- Bank Name:  Citi Credit Card
>- Broker Id:
>- FID: 24909
>- ORG: Citigroup
>- Server URL: https://www.accountonline.com/cards/svc/CitiOfxManager.do
>- User Name: myusername
>- User Id: myusername<--- I added a space per your comments
>- Client UID:
>- Emulated App: Quicken 2013
>- Application ID: QWIN
>- Application Version: 2400
>- Header Version: 103
>
> After accepting the certificate , the log window has that error.  If I
> retrieve accounts after this, I get the following:
>
> 09:12:27 Sending request...
> 09:12:27 Using GnuTLS default ciphers.
> 09:12:28 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> 09:12:28 Signer not found
> 09:12:28 Certificate is not trusted
> 09:13:31 Waiting for response...
> 09:13:31 No message received
> 09:13:31 Network error while waiting for response
> 09:13:31 Operation finished, you can now close this window.
>
> I have a long password, but no special characters in it.  I'm on windows
> and need to read up a bit more on how to get the OFX.log.  Setting the ENV
> variable and starting GNUCash from the command session didn't seem to
> produce one.
>
> I appreciate the guidance and the time.  I'm sure a lot of people use Citi
> Cards and your debugging can benefit a lot of people.  Can you provide any
> differences in your GNUCash config settings that what I have above?  I've
> tried a few variations but to no avail.
>
> Thank you!
>
> Michael
>
>
> On Tue, Oct 23, 2018 at 11:12 PM Jim Maki via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> I just successfully set up GnuCash to download Citi credit card data
>> using AqBanking - for now all you have to do is add a space to the end
>> of your userid (assuming everything else is correct).The issue seems to
>> be with Citi ...
>>
>> When it consistently failed with code 403, I turned on OFX logging
>> (export AQOFX_LOG_COMM=1), snagged the OFX request (from /tmp/ofx.log),
>> formatted it to make it more readable, and created a bash script using
>> curl to make the OFX request. Paradoxically it worked while the
>> equivalent un-beautified GnuCash request failed.
>>
>> After little debugging, the key lines in the GnuCash ofx.log were:
>>
>> == OFX ==
>> ...
>> ... myuserid
>> mypassword
>> ...
>> == OFX ==
>>
>> The above will work if you add a space either at the end of the
>> "...myuserid" line, or before "" in the next line. At
>> the GnuCash user interface level that involves adding a trailing space
>> to the AqBanking userid for Citi.
>>
>> For reference, below is the OFX template file I use to feed my
>> curl-based script. Eventually GnuCash makes an equivalent request.
>> (Again, eliminate the leading spaces before "" and it, too
>> fails.)
>>
>> == OFX ==
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:103
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:$OFX_DATETIME
>>
>> 
>> 
>> 
>> $OFX_DATETIME
>> $OFX_USER
>> $OFX_PW
>> ENG
>> 
>> $OFX_ORG
>> $OFX_FID
>> 
>> QWIN
>> 2400
>> 
>> 
>> 
>> 
>> $OFX_DATETIME
>> 1
>> 
>> 
>> $OFX_ACCOUNT
>> 
>> 
>> $OFX_STARTDATE
>> $OFX_ENDDATE
>> Y
>> 
>> 
>> 
>> 
>> 
>> == OFX ==
>>
>> If GnuCash did prettified SGML it would avoid this problem with Citi's
>> parsing.
>>
>>Jim
>>
>> _

Re: [GNC] AqBanking help for Citi CC

[Fross, Michael]

Thanks Jim.  I can't seem to get AQBanking to log correctly in Windows 10.
I'll compile it on Ubuntu and try it there.  Be back shortly :)

Michael

On Thu, Oct 25, 2018 at 12:50 AM Jim Maki via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
>  > I changed that to 2700 last night and both Chase and Citicards
> resumed working from within gnucash. I believe Quicken 2019 is
> AppVer=2800, but I’m not sure.
>
>
> Can you list your sanitized configuration parameters as I have? I'd like
> to compare them.
>
> And can you get your working (sanitized) ofx.log file? Does it differ
> from mine which has  followed by  on the first byte of
> the next line:
>
> >/== OFX == />/... />/... myuserid
> />/mypassword />/... />/== OFX ==
> /
>
> Here's why I'm so curious.
>
> My first test was to try Application Version 2700 and 2900: both worked
> with my blank-padded userid and both failed with my non-blank-padded
> userid. I suspect Liang's would also. But your's clearly wouldn't.
>
> So how could yours possibly work? One way is that somehow your OFXSGML
> interjects a tag between  and . So I fired up my
> trusty curl-based script doing just that by sticking the ""
> tag between:
>
>  ...
>
> 20181024221016.000MYUSERIDWITHOUTBLANK
>  ENG
>  MYPASSWORD
>  ...
>
>   And it worked without blank padding the userid (the results you
> found). So if your version of GnuCash based on your exact configuration
> inputs creates an OFXSGML file (ofx.log) different from mine (and
> Liang's) in just the right way, yours could work.
>
> Feedback would be appreciated. I'd like to see the magic that makes
> yours work. I was running 2.6.19 at first but am running 3.3 now.
>
>Jim
>
>
>
> ___
> 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] AqBanking help for Citi CC

[Fross, Michael]

Hello Jim,

This is great news.  I had the Citibank Credit Card download working for
years, but it broke early this year.  I've attempted to setup GNUCash based
on the above, but continue to struggle.  I receive the following error
during the initial bank connection:

*Error on gnutls_bye: -24 (Decryption has failed.)*

After looking at your OFX settings above, I used the following during the
GNUCash setup:

   - Create User - Select OFX
   - Bank Name:  Citi Credit Card
   - Broker Id:
   - FID: 24909
   - ORG: Citigroup
   - Server URL: https://www.accountonline.com/cards/svc/CitiOfxManager.do
   - User Name: myusername
   - User Id: myusername<--- I added a space per your comments
   - Client UID:
   - Emulated App: Quicken 2013
   - Application ID: QWIN
   - Application Version: 2400
   - Header Version: 103

After accepting the certificate , the log window has that error.  If I
retrieve accounts after this, I get the following:

09:12:27 Sending request...
09:12:27 Using GnuTLS default ciphers.
09:12:28 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
09:12:28 Signer not found
09:12:28 Certificate is not trusted
09:13:31 Waiting for response...
09:13:31 No message received
09:13:31 Network error while waiting for response
09:13:31 Operation finished, you can now close this window.

I have a long password, but no special characters in it.  I'm on windows
and need to read up a bit more on how to get the OFX.log.  Setting the ENV
variable and starting GNUCash from the command session didn't seem to
produce one.

I appreciate the guidance and the time.  I'm sure a lot of people use Citi
Cards and your debugging can benefit a lot of people.  Can you provide any
differences in your GNUCash config settings that what I have above?  I've
tried a few variations but to no avail.

Thank you!

Michael


On Tue, Oct 23, 2018 at 11:12 PM Jim Maki via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I just successfully set up GnuCash to download Citi credit card data
> using AqBanking - for now all you have to do is add a space to the end
> of your userid (assuming everything else is correct).The issue seems to
> be with Citi ...
>
> When it consistently failed with code 403, I turned on OFX logging
> (export AQOFX_LOG_COMM=1), snagged the OFX request (from /tmp/ofx.log),
> formatted it to make it more readable, and created a bash script using
> curl to make the OFX request. Paradoxically it worked while the
> equivalent un-beautified GnuCash request failed.
>
> After little debugging, the key lines in the GnuCash ofx.log were:
>
> == OFX ==
> ...
> ... myuserid
> mypassword
> ...
> == OFX ==
>
> The above will work if you add a space either at the end of the
> "...myuserid" line, or before "" in the next line. At
> the GnuCash user interface level that involves adding a trailing space
> to the AqBanking userid for Citi.
>
> For reference, below is the OFX template file I use to feed my
> curl-based script. Eventually GnuCash makes an equivalent request.
> (Again, eliminate the leading spaces before "" and it, too
> fails.)
>
> == OFX ==
> OFXHEADER:100
> DATA:OFXSGML
> VERSION:103
> SECURITY:NONE
> ENCODING:USASCII
> CHARSET:1252
> COMPRESSION:NONE
> OLDFILEUID:NONE
> NEWFILEUID:$OFX_DATETIME
>
> 
> 
> 
> $OFX_DATETIME
> $OFX_USER
> $OFX_PW
> ENG
> 
> $OFX_ORG
> $OFX_FID
> 
> QWIN
> 2400
> 
> 
> 
> 
> $OFX_DATETIME
> 1
> 
> 
> $OFX_ACCOUNT
> 
> 
> $OFX_STARTDATE
> $OFX_ENDDATE
> Y
> 
> 
> 
> 
> 
> == OFX ==
>
> If GnuCash did prettified SGML it would avoid this problem with Citi's
> parsing.
>
>Jim
>
> ___
> 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] V3.3 and Security Prices

[Fross, Michael]

That was it John.  Thank you.  I had never noticed that before.

On Sun, Sep 30, 2018 at 9:54 PM, John Ralls  wrote:

>
>
> > On Sep 30, 2018, at 7:33 PM, Fross, Michael  wrote:
> >
> > Hello everyone,
> >
> > Just installed v3.3 and I'm still seeing the fractional display in the
> > price column of security accounts.  I'm not sure if it's just me.  I'm
> > happy to test anything out and help in any way I can.
> >
> > All of my security accounts show the same behavior and I've confirmed I'm
> > running v3.3.
> >
> > Here is a screen shot:
> >
> >
> >
> >
> > Congrats on the release.  I've really fallen in love with GNUCash over
> the
> > last few years.
>
> Is Preferences>General Force Prices to display as decimals checked?
>
> I intended to make it default to checked but it seems not to be.
>
> 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] V3.3 and Security Prices

[Fross, Michael]

Hello everyone,

Just installed v3.3 and I'm still seeing the fractional display in the
price column of security accounts.  I'm not sure if it's just me.  I'm
happy to test anything out and help in any way I can.

All of my security accounts show the same behavior and I've confirmed I'm
running v3.3.

Here is a screen shot:




Congrats on the release.  I've really fallen in love with GNUCash over the
last few years.


Michael
___
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] - File Path for associated files

[Fross, Michael]

Geert, what I'm hearing you say is that someone actually built a time
machine and  went back in time and implemented my idea.  I didn't think it
was all that great of an idea, but what you are suggesting makes a lot of
sense. 

Thanks, I never noticed that!

Michael

On Wed, Sep 12, 2018 at 9:08 AM, Geert Janssens 
wrote:

> Op woensdag 12 september 2018 15:45:17 CEST schreef Fross, Michael:
> >  Directly editing the XML files is really scary to me.  Seems like it
> would
> > be simple, but scary.
> >
> > One idea for the future is to have a GNUCash configured Associated Files
> > directory.  This would be the root of all associated files.  In the
> > datafile, the filepath would originate from this directory.  A user could
> > move these files to a new location with a simple UI directory update in
> > preferences.
> >
> > For example:
> >
> > GNUCash Associated Directory=C:\Gnucash\AssociatedFiles
> >
> > Files:
> > C:\Gnucash\AssociatedFiles\file1
> > C:\Gnucash\AssociatedFiles\launderedmoney\file2
> > C:\Gnucash\AssociatedFiles\fencedgoods\file3
> >
> > Then in the XML files, the paths would be stored as:
> >
> > GNUCashAssociatedFiles/file1
> > GNUCashAssociatedFiles/launderedmoney\file2
> > GNUCashAssociatedFiles/fencedgoods\file3
> >
> > Thoughts?
> >
> It's there already (though perhaps only in 3.x):
> Preferences->General->Path Head for Transaction Association Files
>
> I have no idea if changing this would do anything with absolute path names
> already in the book. And I would doubt very much I would be able to do
> something with Windows paths on a linux system. But for future
> associations
> this should help.
>
> Geert
>
>
>
___
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] - File Path for associated files

[Fross, Michael]

 Directly editing the XML files is really scary to me.  Seems like it would
be simple, but scary.

One idea for the future is to have a GNUCash configured Associated Files
directory.  This would be the root of all associated files.  In the
datafile, the filepath would originate from this directory.  A user could
move these files to a new location with a simple UI directory update in
preferences.

For example:

GNUCash Associated Directory=C:\Gnucash\AssociatedFiles

Files:
C:\Gnucash\AssociatedFiles\file1
C:\Gnucash\AssociatedFiles\launderedmoney\file2
C:\Gnucash\AssociatedFiles\fencedgoods\file3

Then in the XML files, the paths would be stored as:

GNUCashAssociatedFiles/file1
GNUCashAssociatedFiles/launderedmoney\file2
GNUCashAssociatedFiles/fencedgoods\file3

Thoughts?

Michael

On Wed, Sep 12, 2018 at 8:23 AM, John Sears via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi,
>
> yep, I have no problem finding the files and opening them on the filing
> system ( naultilus) ..
>
> Although I have not done any mounting per se..  should I ?
>
>
>
>
> On 12/09/2018 21:17, Michael or Penny Novack wrote:
>
>> On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote:
>>
>> So my files were all stored on G:/documents/xxx.pdf
>>>
>>> Now that I have transferred to Linux, this path is not recognised - "
>>> GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf"
>>>
>>> Is there a way to bulk edit the paths of all the  links so that Linux
>>> will recognise  the SD path?  I would prefer not to go  into every
>>> single transaction to do this, as I have a lot of linked files.
>>>
>>> Or is there someway ( and this might be more of a Linux question) to map
>>> the SD card to the "file:///G" terminology.
>>>
>>> Thanks!
>>>
>>  Been a while since I used a 'nix operating system and I don't know what
>> modern linuxes might provide for "automounting". But in a traditional 'nix
>> environment you don't just stick in removable devices. You also have to
>> "mount" (and when removing, "umount") them.
>>
>> In other words, I think yours is a "new 'nix user" problem. Forget
>> gnucash for a moment. Can you put a file (say a document) on a removable
>> device and then plug that device into your 'nix machine and open it? The
>> path will not be the same as in Windows. The path to the data (in linux)
>> will depend on WHERE in the linux file system you mounted it? << The
>> "mount" command will have specified that >>
>>
>> Michael
>>
>> Michael D Novack
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 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.

Re: [GNC] Finance Quotes Using Yahoo json

[Fross, Michael]

Don't know what else to try other than perhaps some of the other F:Q quote
sources.  Of course after this discussion, I'm sure my Yahoo_JSON quotes
will soon start to fail... :-)

Michael

On Wed, Sep 5, 2018 at 9:54 AM, Dan Nelms  wrote:

> Hi Michael,
>
> I tried your securities (ACN and FBIOX) with yahoo_json. Got unable to
> retrieve...
>
> I tried a couple of my securities with alphavantage. It worked fine.
>
> I tried your sec with Yahoo together with mine with alphaV at same time.
> It got mine and yours were unable...
>
> I tried your securities with alphaV and got the prices fine.
>
> Results are the price database is working and alphavantage is working, but
> for me Yahoo json fails in all cases.
>
> Dan
>
> On 9/5/2018 6:09 AM, Fross, Michael wrote:
>
> Hello Dan,
>
> I just looked at my GNC Price Database and the following quotes are
> returned successfully for me with Yahoo_JSON.  Why don't you try a few of
> these and see if they work for you.  They are current as of September 4,
> 2018 for me.
>
> Stock:  ACN
> Fund: FBIOX, FBMPX, FCYIX
>
> Regards,
>
> Michael
>
> On Tue, Sep 4, 2018 at 3:29 PM, Dan Nelms  wrote:
>
>> Thanks Michael for your comments about using Yahoo_json for some of your
>> security quotes. My needs are also very mild, but they number more than 4.
>>
>> I am running GnuCash version 3.2, Finance::Quote 1.47 (Strawberry) on a
>> Windows 10 machine.
>>
>> I tried using Yahoo_json with the GnuCash security editor and each time I
>> get the "could not get quotes for the following" message. I tried 2
>> mutual funds, 2 NYSE stocks and 1 NASDAQ stock. They all failed. I tried
>> closing and restarting Gnucash just to be the changes in the security
>> editor got loaded, still all failures. Yahoo_json is either not working for
>> me or I am doing something wrong. Damn, I was hoping for an easy solution.
>>
>> Alphavantage works fine but only for the first 4 securities.
>>
>> Dan
>>
>> On 9/3/2018 6:59 AM, Fross, Michael wrote:
>>
>> Hello Dan,
>>
>> My needs are fairly mild, but yes I currently use Yahoo_JSON for all of
>> my quotes.  Most of my investments are in US mutual funds although I do
>> have several individual stocks.
>>
>> I simply use "*Single: Yahoo as JSON"* in the security editor.  I had
>> switched to AlphaVantage when everyone else did and it worked most of the
>> time, although it was very slow.  I think it's worse now so I'm happy
>> Yahoo_JSON continues to work...at least for the time being.  I pull down 37
>> quotes, so not that many but if Alphavantage allows 5 quotes / min, it
>> would take me 7+ minutes do download those.
>>
>> Now I don't believe it will handle currencies and I'm not sure about
>> non-US exchanges, but this does work for me.  You can always do the ones it
>> supports via Yahoo_JSON and just the others via AlphaVantage depending on
>> your situation.
>>
>> Michael
>>
>> On Sun, Sep 2, 2018 at 8:10 PM, Frank H. Ellenberger <
>> frank.h.ellenber...@gmail.com> wrote:
>>
>>> Hi Dan,
>>>
>>> Am 03.09.2018 um 00:10 schrieb Dan Nelms:
>>> > Micheal, I noticed in one of your replies to a user having
>>> Finance:Quote
>>> > problems that are still getting quotes from Yahoo_json for most of your
>>> > quotes. Are you doing that through the GnuCash Security setup? If so
>>> > what button do you use, ie Single, Multiple or Unknown? I would like to
>>> > try it. Thanks. Dan
>>>
>>> RTFM:
>>> https://code.gnucash.org/docs/C/gnucash-help/fq-sources.html
>>> #idm139753655191424
>>> ;-)
>>>
>>> Frank
>>>
>>>
>>
>>
>
>
___
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] Finance Quotes Using Yahoo json

[Fross, Michael]

Hello Dan,

I just looked at my GNC Price Database and the following quotes are
returned successfully for me with Yahoo_JSON.  Why don't you try a few of
these and see if they work for you.  They are current as of September 4,
2018 for me.

Stock:  ACN
Fund: FBIOX, FBMPX, FCYIX

Regards,

Michael

On Tue, Sep 4, 2018 at 3:29 PM, Dan Nelms  wrote:

> Thanks Michael for your comments about using Yahoo_json for some of your
> security quotes. My needs are also very mild, but they number more than 4.
>
> I am running GnuCash version 3.2, Finance::Quote 1.47 (Strawberry) on a
> Windows 10 machine.
>
> I tried using Yahoo_json with the GnuCash security editor and each time I
> get the "could not get quotes for the following" message. I tried 2
> mutual funds, 2 NYSE stocks and 1 NASDAQ stock. They all failed. I tried
> closing and restarting Gnucash just to be the changes in the security
> editor got loaded, still all failures. Yahoo_json is either not working for
> me or I am doing something wrong. Damn, I was hoping for an easy solution.
>
> Alphavantage works fine but only for the first 4 securities.
>
> Dan
>
> On 9/3/2018 6:59 AM, Fross, Michael wrote:
>
> Hello Dan,
>
> My needs are fairly mild, but yes I currently use Yahoo_JSON for all of my
> quotes.  Most of my investments are in US mutual funds although I do have
> several individual stocks.
>
> I simply use "*Single: Yahoo as JSON"* in the security editor.  I had
> switched to AlphaVantage when everyone else did and it worked most of the
> time, although it was very slow.  I think it's worse now so I'm happy
> Yahoo_JSON continues to work...at least for the time being.  I pull down 37
> quotes, so not that many but if Alphavantage allows 5 quotes / min, it
> would take me 7+ minutes do download those.
>
> Now I don't believe it will handle currencies and I'm not sure about
> non-US exchanges, but this does work for me.  You can always do the ones it
> supports via Yahoo_JSON and just the others via AlphaVantage depending on
> your situation.
>
> Michael
>
> On Sun, Sep 2, 2018 at 8:10 PM, Frank H. Ellenberger <
> frank.h.ellenber...@gmail.com> wrote:
>
>> Hi Dan,
>>
>> Am 03.09.2018 um 00:10 schrieb Dan Nelms:
>> > Micheal, I noticed in one of your replies to a user having Finance:Quote
>> > problems that are still getting quotes from Yahoo_json for most of your
>> > quotes. Are you doing that through the GnuCash Security setup? If so
>> > what button do you use, ie Single, Multiple or Unknown? I would like to
>> > try it. Thanks. Dan
>>
>> RTFM:
>> https://code.gnucash.org/docs/C/gnucash-help/fq-sources.html
>> #idm139753655191424
>> ;-)
>>
>> Frank
>>
>>
>
>
___
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] Finance Quotes Using Yahoo json

[Fross, Michael]

Hello Dan,

My needs are fairly mild, but yes I currently use Yahoo_JSON for all of my
quotes.  Most of my investments are in US mutual funds although I do have
several individual stocks.

I simply use "*Single: Yahoo as JSON"* in the security editor.  I had
switched to AlphaVantage when everyone else did and it worked most of the
time, although it was very slow.  I think it's worse now so I'm happy
Yahoo_JSON continues to work...at least for the time being.  I pull down 37
quotes, so not that many but if Alphavantage allows 5 quotes / min, it
would take me 7+ minutes do download those.

Now I don't believe it will handle currencies and I'm not sure about non-US
exchanges, but this does work for me.  You can always do the ones it
supports via Yahoo_JSON and just the others via AlphaVantage depending on
your situation.

Michael

On Sun, Sep 2, 2018 at 8:10 PM, Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Hi Dan,
>
> Am 03.09.2018 um 00:10 schrieb Dan Nelms:
> > Micheal, I noticed in one of your replies to a user having Finance:Quote
> > problems that are still getting quotes from Yahoo_json for most of your
> > quotes. Are you doing that through the GnuCash Security setup? If so
> > what button do you use, ie Single, Multiple or Unknown? I would like to
> > try it. Thanks. Dan
>
> RTFM:
> https://code.gnucash.org/docs/C/gnucash-help/fq-sources.
> html#idm139753655191424
> ;-)
>
> Frank
>
>
___
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] FinanceQuote Problems?

[Fross, Michael]

Also, it's doesn't have to be Alphavantage or nothing.  I'm still using
yahoo_json for most of my quotes and the ones it can't handle I use AV.

Michael

On Sat, Sep 1, 2018 at 5:45 PM, Glen Larsen  wrote:

> On Sat, Sep 1, 2018 at 11:03 AM GB  wrote:
>
> > [ ... ]
> > What am I doing wrong?  What did I not set properly in GnuCash inorder to
> > make the Finance Quotes work?
> >
>
> You did nothing wrong and there is nothing wrong with gnucash.
>
> Alphavantage only allows 5 quotes per minute. You, like me, are tracking
> more than that and gnucash is not providing this adjustment for a single
> quote source. Personally, I've written a python script to get this done
> using an SQLite backend and if I knew this problem would last a long time I
> would polish it up and make it public.
>
>
> > To get the latest, I am now resorting to manually populating all of the
> > security prices.  Which is a royal pain.  Any help or tips would be much
> > much appreciated !
> >
>
> Armed with the knowledge of the quotes/minute limit you could do this:
> 1. Open the security editor (Tools -> Security Editor)
> 2. Display the 'Get Quote' column by using the pulldown on the right and
> ticking 'Get Quotes'
> 3. Untick (double-click to get the editor) all of them except the first 4
> (they say 5 but I swear it is 4.)
> 4. In 'Price Database' dialog, 'Get Quotes'
> 4.1 Wait 60 less the time it took to do steps 3 and 4 in seconds
> 5. Untick, re-tick, repeat as necessary.
>
> That has got to be marginally better than manual entry.
>
> This is also a good time to review your list of securities and untick 'Get
> Quotes' for stocks you have sold off (0 in your portfolio).
> ___
> 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] GnuCash Theme Library

[Fross, Michael]

Hello everyone,

GnuCash, via GTK, has a very rich ability to change the fonts and colors
and customize how GnuCash looks.  However, I think it's safe to say that
it's not a trivial exercise for the average user.

However, the recent discussions between Adrien, GTI, Peter, and others have
made a lot of progress, IMHO, in understanding how CSS can control the look
at feel.  I'm also sure there is much more than could be discovered and
documented.

Therefore, I'd like to create a GnuCash Theme Library in the Wiki where
people who create custom GTK-3.0.css theme files can share them.  Other
users can download the files (instructions will be provided by platform in
the library) and try them out or use them as a base for their own tweaking.

I was thinking of including the following information for each uploaded
theme (* denotes a required field):
  - Theme Name*
  - Author*
  - Date*
  - Version*
  - Description*
  - Screenshot (no financial data please)
  - Link to download file*

I also think it would very useful to have a template file with every
settable option in it that we know about with a brief description about
each one detailing what it does.  That would really encourage people to
download and tweak, or discover areas of customization they didn't know
could be.

While I'm new to MediaWiki, I'd be happy to spend time creating this theme
library.  However, I'd like to get feedback on what we should include and
overall thoughts on this and I'll see what I can do.

Thank you very much,

Michael
___
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] Change text color

[Fross, Michael]

I've been following this thread but have no yet had a chance to implement
the color customization.  I hope all of this great stuff gets into the
Wiki.  It would be also really interesting to have a master CSS file that
has all of the known options in it so that folks can just download that and
tweak it (hopefully with verbose comments.)

Thank you for all of the work and experimentation on this thread!

Michael

On Thu, Aug 2, 2018 at 9:48 AM, Peter Jackson  wrote:

> Many thanks. It works nicely.
> Peter
>
>
> Nurton Court
> Middleton-on-the-Hill
> Ludlow SY8 4BD
> Tel: 01568 750 248 Mob: 07955 586 476
>
> On 2 August 2018 at 15:34, GT-I9070 H  wrote:
>
> > Em qui, 2 de ago de 2018 às 05:28, Peter Jackson 
> > escreveu:
> >
> >> Adrien,I have been following this with interest and have made changes in
> >> my
> >> Windows 10 system. Many thanks. I am wondering if you could you tell me
> >> how
> >> I can customise the Notebook Tabs, which, in Preferences, Windows, I
> have
> >> set to Top.
> >> Thanks,
> >>
> >
> >  Hi Peter,
> >
> > I've written this here before, here it is:
> >
> > /* Tab Label Settings */
> > notebook tab label {
> >   color: blue;
> >   font-size: 15;
> > }
> >
> > For more properties you can play with these:
> > https://www.w3schools.com/cssref/pr_text_color.asp
> >
> >
> > Regards
> > GTI
> >
> ___
> 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] Dark theme on Windows

[Fross, Michael]

The bug has been added.  Please let me know how I can help.

https://bugzilla.gnome.org/show_bug.cgi?id=796669

Regards,

Michael

On Mon, Jun 25, 2018 at 9:16 AM, Fross, Michael  wrote:

> Sure.  Will do.  I had this issue with v2.x as well.
>
> On Mon, Jun 25, 2018 at 8:26 AM, Geert Janssens <
> geert.gnuc...@kobaltwit.be> wrote:
>
>> Thanks for the followup Michael.
>>
>> Normally GnuCash should detect a dark theme and adjust text color
>> accordingly.
>> If it doesn't, that's a bug then. Can you file this in bugzilla ?
>>
>> Thanks,
>>
>> Geert
>>
>> Op maandag 25 juni 2018 14:32:12 CEST schreef Fross, Michael:
>> > Hello Geert.
>> >
>> > This worked for me in Windows (although I used Adwaita-Slim instead of
>> > Adwaita.)
>> >
>> > I prefer the dark themes, but in the registers, the text is black on
>> "dark"
>> > and very hard to read.  I know I can change around the row colors, but I
>> > don't know how to change the text color.  Any idea?
>> >
>> > Michael
>> >
>> > On Sun, Jun 24, 2018 at 5:14 PM, Geert Janssens <
>> geert.gnuc...@kobaltwit.be>
>> > wrote:
>> > > I have come across the following combination of settings to enable a
>> > > default
>> > > dark theme on linux. Creating a file settings.ini in
>> $HOME/.config/gtk-3.0
>> > > with this contents
>> > >
>> > > [Settings]
>> > > gtk-application-prefer-dark-theme=true
>> > > gtk-theme-name=Adwaita
>> > >
>> > > gives me the default Adwaita-dark theme. I would be interested to
>> know if
>> > > this
>> > > also works on Windows (the file should be created in
>> > > %LOCALAPPDATA%\gtk-3.0
>> > > instead).
>> > >
>> > > If so this could be added to our wiki here:
>> > > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes
>> > >
>> > > Can someone run this experiment and report back ?
>> > >
>> > > Thanks,
>> > >
>> > > Geert
>> > >
>> > >
>> > > ___
>> > > 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] Dark theme on Windows

[Fross, Michael]

Sure.  Will do.  I had this issue with v2.x as well.

On Mon, Jun 25, 2018 at 8:26 AM, Geert Janssens 
wrote:

> Thanks for the followup Michael.
>
> Normally GnuCash should detect a dark theme and adjust text color
> accordingly.
> If it doesn't, that's a bug then. Can you file this in bugzilla ?
>
> Thanks,
>
> Geert
>
> Op maandag 25 juni 2018 14:32:12 CEST schreef Fross, Michael:
> > Hello Geert.
> >
> > This worked for me in Windows (although I used Adwaita-Slim instead of
> > Adwaita.)
> >
> > I prefer the dark themes, but in the registers, the text is black on
> "dark"
> > and very hard to read.  I know I can change around the row colors, but I
> > don't know how to change the text color.  Any idea?
> >
> > Michael
> >
> > On Sun, Jun 24, 2018 at 5:14 PM, Geert Janssens <
> geert.gnuc...@kobaltwit.be>
> > wrote:
> > > I have come across the following combination of settings to enable a
> > > default
> > > dark theme on linux. Creating a file settings.ini in
> $HOME/.config/gtk-3.0
> > > with this contents
> > >
> > > [Settings]
> > > gtk-application-prefer-dark-theme=true
> > > gtk-theme-name=Adwaita
> > >
> > > gives me the default Adwaita-dark theme. I would be interested to know
> if
> > > this
> > > also works on Windows (the file should be created in
> > > %LOCALAPPDATA%\gtk-3.0
> > > instead).
> > >
> > > If so this could be added to our wiki here:
> > > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes
> > >
> > > Can someone run this experiment and report back ?
> > >
> > > Thanks,
> > >
> > > Geert
> > >
> > >
> > > ___
> > > 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.