Re: [GNC] Importing to Gnucash

[Kalpesh Patel]

When you are at the 'Import Preview' window/step, you can click on the arrow 
pointing downward next to label of each column which will expand to all 
available assignments that can be done for that column. You can select from 
that drop down list. Each column is individually controlled so that you can 
assign it however you like. Additionally, after you are satisfied with setting 
up the import how you like it to be, you can type in a name underneath the 
'Load and Save Setting' and then clicking button that looks like arrow pointing 
down on top of a underscore right of the input field.  Next time you can click 
the down arrow button in the same area to select and recall back previously 
saved setting. 

-Original Message-
From: Ronald Solomon  
Sent: Friday, July 05, 2024 12:09 PM
To: Users GnuCash 
Subject: [GNC] Importing to Gnucash

I want to import from a CSV file It has both debit and credit transactions.
When I am labeling the CSV columns I don't see where I label Withdrawal and 
deposit. My deposits are in one column and withdrawals are in another column.
I have set up a test GNUCash file and am running test data. It sees the 
transactions however, it negates the amount to 0

--
Ron Solomon DC
Integrative Health PHMA PA
Phone 252 671 2306
Fax 252 69310684
The reason you have a headache is not that you need more aspirin.


___
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] CSV Importer - Debit vs Credit

[Kalpesh Patel]

On Windows, those three lines turns to millions of lines ☹.

I just stick with shell in case of *NIX or good old batch on Windows. In theory 
it is just adding a single comma before or after the value column based on 
value of another column. 


-Original Message-
From: Paul Kroitor  
Sent: Thursday, July 04, 2024 1:17 PM
To: 'Kalpesh Patel' ; gnucash-user@gnucash.org
Subject: Re: [GNC] CSV Importer - Debit vs Credit

I can easily write a little Python thingie and put it in my right-click menu, 
but it's just an added annoyance in this increasingly annoying world.

-Original Message-
From: Kalpesh Patel 
Sent: Thursday, July 4, 2024 12:59 PM
To: 'Paul Kroitor' ; gnucash-user@gnucash.org
Subject: RE: [GNC] CSV Importer - Debit vs Credit

Sadly, you will have to do some pre-processing before import. Put minus sign in 
front of debits or credits, depending upon how the book is setup. GNUCash does 
not have a conditional way of importing data in CSV by looking at a column. CSV 
files can be edited in any text editor.

-Original Message-
From: Paul Kroitor 
Sent: Thursday, July 04, 2024 11:30 AM
To: gnucash-user@gnucash.org
Subject: [GNC] CSV Importer - Debit vs Credit

I'm sure this has been asked in a dozen different variations over the years but 
I'm now faced with the issue myself since I now need to use CSV for downloading 
(I hate TD Bank, who have removed the OFX download option). I can't immediately 
find any old messages describing this particular issue, so I thought I'd just 
ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a 
different column (D or C) depending on a different field's value. This must be 
fairly common - am I just blind? 






___
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] CSV Importer - Debit vs Credit

[Kalpesh Patel]

As an after-thought, put minus sign in front of lines with credits and
payments to minimize number of edits, and then adjust your amount column as
withdrawal (or credit based upon your books settings). The minus sign will
move the amount over to "deposit" side. Once you are satisfied how it
imports, you can save that as a template to use it next time in the future
so you don't have to figure it out again.

-Original Message-----
From: Kalpesh Patel  
Sent: Thursday, July 04, 2024 12:59 PM
To: 'Paul Kroitor' ; 'gnucash-user@gnucash.org'

Subject: RE: [GNC] CSV Importer - Debit vs Credit

Sadly, you will have to do some pre-processing before import. Put minus sign
in front of debits or credits, depending upon how the book is setup. GNUCash
does not have a conditional way of importing data in CSV by looking at a
column. CSV files can be edited in any text editor.

-Original Message-
From: Paul Kroitor  
Sent: Thursday, July 04, 2024 11:30 AM
To: gnucash-user@gnucash.org
Subject: [GNC] CSV Importer - Debit vs Credit

I'm sure this has been asked in a dozen different variations over the years
but I'm now faced with the issue myself since I now need to use CSV for
downloading (I hate TD Bank, who have removed the OFX download option). I
can't immediately find any old messages describing this particular issue, so
I thought I'd just ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a
different column (D or C) depending on a different field's value. This must
be fairly common - am I just blind? 



___
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] CSV Importer - Debit vs Credit

[Kalpesh Patel]

Sadly, you will have to do some pre-processing before import. Put minus sign
in front of debits or credits, depending upon how the book is setup. GNUCash
does not have a conditional way of importing data in CSV by looking at a
column. CSV files can be edited in any text editor.

-Original Message-
From: Paul Kroitor  
Sent: Thursday, July 04, 2024 11:30 AM
To: gnucash-user@gnucash.org
Subject: [GNC] CSV Importer - Debit vs Credit

I'm sure this has been asked in a dozen different variations over the years
but I'm now faced with the issue myself since I now need to use CSV for
downloading (I hate TD Bank, who have removed the OFX download option). I
can't immediately find any old messages describing this particular issue, so
I thought I'd just ask.

 

Simplified, TD Bank CSV downloads only basically have four fields:

*   Date
*   Description
*   "Debit" or "Credit"
*   Amount (always positive)

 

Import works fine, except that I can't see any way (short of pre-editing the
file) to get the CSV importer to understand that the amount field goes in a
different column (D or C) depending on a different field's value. This must
be fairly common - am I just blind? 



___
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 I have two GnuCash releases installed in Windows 11

[Kalpesh Patel]

I don't think two different version of GNUCash can exist on Windows machine 
(install of new version will uninstall the previously installed one). However, 
there is nothing that precludes you from going back one minor version if you 
needed to. In that case, you just simply uninstall the latest version and then 
install the previous version.

If you want to go with David C's route, you can employ VirtualBox to run 
another instance of the OS and test it out there before upgrading on the main 
system. 

-Original Message-
From: David Carlson  
Sent: Thursday, July 04, 2024 11:15 AM
To: Lipp F. 
Cc: GnuCash users group 
Subject: Re: [GNC] Can I have two GnuCash releases installed in Windows 11

I run multiple versions of GnuCash by putting them on different computers.
This can be done either by using separate machines or by setting up one or more 
virtual machines in a program similar to Oracle Virtualbox.



On Thu, Jul 4, 2024 at 9:33 AM Lipp F.  wrote:

> I am a bit behind and I would like to test a newer release before 
> upgrading. Can I do it on Windows 11?
> ___
> 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.
>


--
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
-
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 Online Quotes/Price Database

[Kalpesh Patel]

There is more than one way to install it, thankfully.

With the procedure I provided, it least keeps screen output intact to denote or 
capture the error when it fails...

-Original Message-
From: David H  
Sent: Friday, June 14, 2024 9:11 PM
To: david amaral 
Cc: gnucash-user@gnucash.org; Kalpesh Patel ; 
sba...@gmail.com; cho...@gmail.com
Subject: Re: [GNC] Problem with Online Quotes/Price Database

I use the simple way on Windows.  Go To the Start Menu and the Gnucash folder 
under "G" within it - click on "Install Online Price Retrieval for Gnucash", 
let it do it's thing.  I use this whenever a new Finance Quote module has been 
installed and it works every time, also installs Strawberry Perl if required.

Cheers David H.

On Sat, 15 Jun 2024 at 04:11, david amaral via gnucash-user 
 wrote:
>
>  dont know why this happened but.shoud be cd Program Files 
> (x86)\gnucash\bin perl gnc-fq-check (should get some info) if not 
> install/reinstall finance quote cpanm Finance::Quote perl 
> gnc-fq-update close all apps and reboot should fix your problem
>
>
>
> On Friday, June 14, 2024 at 11:05:26 AM MST, david amaral via 
> gnucash-user  wrote:
>
>   Had same problem and this resolved it open CMD windowcd Program 
> Files (x86)\gnucash\binperl gnc-fq-check (should get some info)if not 
> install/reinstall finance quotecpanm Finance::Quote perl gnc-fq-update 
> close all apps and reboot should fix your problem
>
> On Friday, June 14, 2024 at 10:33:05 AM MST, Kalpesh Patel 
>  wrote:
>
>  It is very likely that when you uninstalled Strawberry Perl, it also 
> uninstalled Finance::Quote library which is needed to download quotes.
>
> At a Windows' CMD (Command line) console, you should be able to installed it.
> Instructions are as follows:
>
> 1) At the command prompt execute following to bring up CPAN shell:
> perl -MCPAN -e shell
>
> 2) In CPAN shell type in following command (this might trigger 
> initialization question for CPAN module since it will be seen as being run 
> for first time.
> accepting all defaults setting is fine so answer 'Y' when prompted):
> install Finance::Quote
>
> Get your favorite drink and enjoy it while all dependencies are 
> downloaded and installed. If all goes well then you should see 
> following (or similar) message at completion of step 2:
> Finance::Quote is up to date (1.62).
>
> Once finished, I recommend you reboot and then launch GNUCash. If 
> everything works as it suppose to, the button will be no longer greyed out.
>
> Hope that helps.
>
>
> > On Jun 13, 2024, at 1:25 AM, Steve Barru  wrote:
> >
> > I am using GnuCash v4.12 on a 64-bit Windows 11 laptop to keep 
> > track of personal finances. I am retired and my income consists of 
> > Social Security and distributions from investments in funds and 
> > occasionally, stocks. I live outside of the US and am tracking 
> > dual-currencies with GnuCash. When I started running GnuCash in Jan 
> > 2023, I set up the Online Price Retrieval module for equities and 
> > forex quotations. I have been using the Price Database tool to fetch 
> > quotes on a more or less monthly basis and this has worked 
> > seamlessly until May 2024 when I got an error message telling me 
> > there was a problem with the database or something to that effect. Beyond 
> > periodic Windows updates, no changes to my system that I know of.
> >
> > Since then I have uninstalled and then reinstalled the Strawberry 
> > Perl app that runs the online quote service; the version installed is 
> > 5.32.1001.
> > After the installation, I ran the Price Database tool and the Get 
> > Quotes button on the right of the screen was grayed out. I got a new 
> > Alpha Vantage API key hoping that might solve the problem. It did 
> > not; the Get Quotes button is still grayed out.
> >
> > Looking for suggestions how to troubleshoot this, hopefully that are 
> > not exceptionally technical. Thanks for any help with this.
> >
> > Best,
> > Steve
> >
> > --
> > steve barru photographs <http://stevebarru.com!@#?>?#@!
> > Mobile: +84 393 022 059
> > Hoi An, Vietnam
> >
>
> ___
> 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 preferenc

Re: [GNC] Problem with Online Quotes/Price Database

[Kalpesh Patel]

It is very likely that when you uninstalled Strawberry Perl, it also
uninstalled Finance::Quote library which is needed to download quotes.

At a Windows' CMD (Command line) console, you should be able to installed it.
Instructions are as follows:

1) At the command prompt execute following to bring up CPAN shell:
perl -MCPAN -e shell

2) In CPAN shell type in following command (this might trigger initialization
question for CPAN module since it will be seen as being run for first time.
accepting all defaults setting is fine so answer 'Y' when prompted):
install Finance::Quote

Get your favorite drink and enjoy it while all dependencies are downloaded and
installed. If all goes well then you should see following (or similar) message
at completion of step 2:
Finance::Quote is up to date (1.62).

Once finished, I recommend you reboot and then launch GNUCash. If everything
works as it suppose to, the button will be no longer greyed out.

Hope that helps.


> On Jun 13, 2024, at 1:25 AM, Steve Barru  wrote:
>
> I am using GnuCash v4.12 on a 64-bit Windows 11 laptop to keep track of
> personal finances. I am retired and my income consists of Social Security
> and distributions from investments in funds and occasionally, stocks. I
> live outside of the US and am tracking dual-currencies with GnuCash. When I
> started running GnuCash in Jan 2023, I set up the Online Price Retrieval
> module for equities and forex quotations. I have been using the Price
> Database tool to fetch quotes on a more or less monthly basis and this has
> worked seamlessly until May 2024 when I got an error message telling me
> there was a problem with the database or something to that effect. Beyond
> periodic Windows updates, no changes to my system that I know of.
>
> Since then I have uninstalled and then reinstalled the Strawberry Perl app
> that runs the online quote service; the version installed is 5.32.1001.
> After the installation, I ran the Price Database tool and the Get Quotes
> button on the right of the screen was grayed out. I got a new Alpha Vantage
> API key hoping that might solve the problem. It did not; the Get Quotes
> button is still grayed out.
>
> Looking for suggestions how to troubleshoot this, hopefully that are not
> exceptionally technical. Thanks for any help with this.
>
> Best,
> Steve
>
> --
> steve barru photographs ?#@!
> Mobile: +84 393 022 059
> Hoi An, Vietnam
>

___
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] Delete acct + move txns - can't specify acct

[Kalpesh Patel]

Is there any reason why not just simply rename account and then re-parent the 
account to where you actually want the transaction to show in the account list 
rather than delete the account and move the transactions during delete? 

-Original Message-
From: Mark at Lorimark  
Sent: Monday, June 03, 2024 8:19 AM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Delete acct + move txns - can't specify acct

Yes, pretty basic simple small business file, checking, savings, CD's...

~mark petryk
~w:http://www.lorimarksolutions.com

On 6/3/24 07:17, Derek Atkins wrote:
> I presume the accounts have the same currency?
> I honestly do not recall what algorithm is used to choose options there.
> 
> -derek
> 


___
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] Delete a trading account => crash

[Kalpesh Patel]

Ah, go to the contra cash account for the transaction and do it over there...
thanks for that tip! 

-- Original Message --
Received: Sun, 19 May 2024 05:38:58 PM EDT
From: Fred Tydeman 
To: Kalpesh Patel Cc: Gnucash Users

Subject: Re: [GNC] Delete a trading account => crash

> By mistake, I had two Asset accounts for the same stock, but with different
> spellings.
> That is what produced the two similar Trading accounts.
> 
> So, I ended up doing in the Cash account that did the buys and sells:
> In split view mode: change the stock asset account from one to the other,
> press Enter, that got me a popup to adjust the number of shares.
> Press Enter and all was fixed.
> 
> Doing that was a lot easier than deleting and re-entering the transactions.
> 
> When I was done, one stock asset account and one trading account were
> both empty, so could be deleted.  I also deleted the wrong spelling in the
> Security editor.
> 
> On Sun, May 19, 2024 at 9:28 AM Kalpesh Patel 
wrote:
> 
> > That is the behavior, sadly, where it goes back to what the original
> > transaction was. It is undesired but it is there and not likely to be
> > fixed.. (I run into it when I want to duplicate the transaction and then
> > just update the quantity)
> >
> > To get around, you technically have to enter the entire transaction from
> > beginning to end. Work around is to "modify" transaction is to open up
the
> > transaction, select first row from split view, go to first column
highlight
> > what is in it, copy it to clipboard, delete it, paste it from clipboard
> > (correct as you need to during this paste phase). Rinse-&-repeat for all
> > columns across for all rows in the transaction... you can minimize this
by
> > doing cut-&-paste to only the Shares, Buy and Sell columns and let it
> > calculate the Price column. It does get crazy when you have
multi-currency
> > enabled and/or are dividend reinvestment transactions ...
> >
> >
> > -Original Message-
> > From: Fred Tydeman 
> > Sent: Sunday, May 19, 2024 1:04 AM
> > To: Gnucash Users 
> > Subject: [GNC] Delete a trading account => crash
> >
> > Running GnuCash 4.14 on Fedora Linux.
> >
> > Due to a mistake on my part, I have two Trading accounts:
> >   IVR-PC
> >   IVRPRC
> > for the same security.
> >
> > First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy
> > transaction from the cash account. However, when I pressed Enter, Gnucash
> > undid my change.
> >
> > Then, I tried deleting Trading:IVRPRC account and moving its transactions
> > to Trading: IVR-PC.
> > That crashed Gnucash.
> >
> > I am now running a Check & Repair all (takes many minutes).
> >
> >
> >
> 


___
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] Delete a trading account => crash

[Kalpesh Patel]

That is the behavior, sadly, where it goes back to what the original 
transaction was. It is undesired but it is there and not likely to be fixed.. 
(I run into it when I want to duplicate the transaction and then just update 
the quantity)

To get around, you technically have to enter the entire transaction from 
beginning to end. Work around is to "modify" transaction is to open up the 
transaction, select first row from split view, go to first column highlight 
what is in it, copy it to clipboard, delete it, paste it from clipboard 
(correct as you need to during this paste phase). Rinse-&-repeat for all 
columns across for all rows in the transaction... you can minimize this by 
doing cut-&-paste to only the Shares, Buy and Sell columns and let it calculate 
the Price column. It does get crazy when you have multi-currency enabled and/or 
are dividend reinvestment transactions ...


-Original Message-
From: Fred Tydeman  
Sent: Sunday, May 19, 2024 1:04 AM
To: Gnucash Users 
Subject: [GNC] Delete a trading account => crash

Running GnuCash 4.14 on Fedora Linux.

Due to a mistake on my part, I have two Trading accounts:
  IVR-PC
  IVRPRC
for the same security.

First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy 
transaction from the cash account. However, when I pressed Enter, Gnucash undid 
my change.

Then, I tried deleting Trading:IVRPRC account and moving its transactions to 
Trading: IVR-PC.
That crashed Gnucash.

I am now running a Check & Repair all (takes many minutes).


___
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] Question about OFX imports

[Kalpesh Patel]

I do see a good reason to do so, at least in my use case. 

I am imagining case where if I were to download good number of transfers 
transactions  (I do so for last three months in a moving window fashion through 
CSV, QIF and OFX imports), I could end up needing to touch many other accounts, 
possibly ones that were already reconciled after import would entail needless 
download again, and then re-imports again  for those accounts, especially now 
that description can be appended from two sides of import of a transaction. 
Since CSV and QIF already permits reimport and reconciliation window, having 
the same capabilities on OFX/QFX would make the behavior consistent amongst 
three heavily used import methods in the States. I do not see any adverse 
effect from permitting it. If it finds same FITID, permit to update, update and 
reconcile existing one or just reconcile existing one. Just a thought

-Original Message-
From: Jean Laroche  
Sent: Monday, May 13, 2024 6:19 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Question about OFX imports

Also, you definitely would not want to double-import the same transaction, so 
there isn't a good reason to want to mock with the FITID. What *could* be 
useful (but in extremely rare cases) would be to force a re-import of the same 
transaction despite the fact that it's been imported previous, while avoiding a 
duplication (i.e. the second import would update the existing transaction 
instead of being skipped altogether). But I don't see a good reason to 
implement that at this point... Deleting the existing one achieves the same 
result for these rare cases.

Jean

On 5/13/24 3:12 PM, David Reiser via gnucash-user wrote:
>> On May 13, 2024, at 17:50, David Carlson  wrote:
>>
>> Now it is my turn to ask a question.
>>
>> My bank recently had an issue with the description text for a few 
>> transactions that resulted in the transactions being reposted with 
>> corrected descriptions.  Now I am trying to import the corrected 
>> transactions but they do not appear in the OFX importer even though 
>> they are in the file generated by the bank.
>>
>> My question is: If I delete the previously imported transactions, can 
>> I import the corrected transactions?
> yes.
>
>> A corollary; is there any way to check, edit or remove the FITID 
>> value of a transaction that prevents the duplicate import without 
>> doing tricks in the OFX file before importing?
> only if you are willing to risk damaging your datafile editing it outside of 
> gnucash. The FITID values are stored as a key/value pair like:
>
>  
>online_id
>20180906246910059666
>  
>
> and finding specific transactions in the raw XML is harder than you might 
> imagine. The online_id is not available to the user anywhere in the gnucash 
> interface.
>
> I have never tried editing a gnucash SQL file outside of gnucash.
>
>> --
>> David Carlson
>> ___
>
> --
> 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
> -
> 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] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)

[Kalpesh Patel]

That was it. Rounding down to 9 decimal places works. 

Thank you!

-Original Message-
From: John Ralls  
Sent: Wednesday, May 08, 2024 10:13 PM
To: Kalpesh Patel 
Cc: GnuCash User 
Subject: Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q
(v1.61_02)

Kalpesh,

I think your price has too many digits. Try rounding it to 10E-9.

Regards,
John Ralls

> On May 8, 2024, at 09:05, Kalpesh Patel  wrote:
> 
> Hi GNC User community -
> 
> 
> 
> I am developing a second F::Q module of my own. The first one works 
> fine but second one seems to NOT want to work no matter what. I am in 
> middle of debugging it and it has stomped me why not so hoping someone 
> might be able to help me zero in where I am falling sort on the flow 
> for it. I am working with F::Q v1.61_02 and GNC v4.14 
> (4.14+(2023-03-25) build) running on Windows 11. (Note: I don't 
> believe any interface change has taken place in GNC v5.x that would cause
this but correct me here if I am wrong.).
> 
> 
> 
> Invoking GNC with debug shows that return value is #f, which means 
> something went wrong (run_executor is the "label" for my module and 
> other modules work fine from the debug output):
> 
> 
> 
> 11:19:24 DEBUG  handling-request: (currency INR USD)
> 
> * 11:19:24 DEBUG  results: ((INR (symbol . INR) (gnc:time-no-zone
.
> 2024-05-08 11:19:11) (last . 3/250) (currency . USD)))
> 
> * 11:20:38 DEBUG  ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY
> 
> * 11:20:39 DEBUG  handling-request: (tsp C S L2030 I)
> 
> * 11:20:43 DEBUG  results: ((C (symbol . C) (gnc:time-no-zone .
> 2024-05-07 12:00:00) (last . 812423/1) (currency . USD)) (S 
> (symbol . S) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 4009/50) 
> (currency . USD))
> (L2030 (symbol . L2030) (gnc:time-no-zone . 2024-05-07 12:00:00) (last .
> 237163/5000) (currency . USD)) (I (symbol . I) (gnc:time-no-zone .
> 2024-05-07 12:00:00) (last . 42507/1000) (currency . USD)))
> 
> * 11:20:43 DEBUG  handling-request: (run_executor BK)
> 
> * 11:20:43 DEBUG  results: (#f)
> 
> * 11:20:43 DEBUG  handling-request: (yahoojson ^NYA)
> 
> * 11:20:44 DEBUG  results: ((^NYA (symbol . ^NYA) 
> (gnc:time-no-zone . 2024-05-08 12:00:00) (last . 2247813/125) 
> (currency . USD)))
> 
> 
> 
> Following is debug run from command line of gnc-fq-dump (which 
> provides all necessary fields for quote to be valid as it does not 
> show '** This stock quote cannot be used by GnuCash!' message):
> 
> 
> 
> C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" 
> -v run_executor BK
> 
> {snip}
> 
> ### [Wed May  8 11:34:40 2024]   %info : {
> 
> ###'BKISIN' => '-',
> 
> ###'BKcurrency' => 'USD',
> 
> ###'BKdate' => '05/08/2024',
> 
> ###'BKisodate' => '2024-05-08',
> 
> ###'BKmethod' => 'run_executor',
> 
> ###'BKprice' =>
'57.64500045776367',
> 
> ###'BKsuccess' => '1',
> 
> ###'BKsymbol' => 'BK',
> 
> ###'BKtimezone' => 'EDT'
> 
> ###  }
> 
> Finance::Quote fields Gnucash uses:
> 
>  symbol: BK   <=== required
> 
>date: 05/08/2024   <=== recommended
> 
> currency: USD  <=== required
> 
>last:  <=\
> 
> nav:  <=== one of these
> 
>   price: 57.64500045776367<=/
> 
> timezone: EDT  <=== optional
> 
> 
> 
> All fields returned by Finance::Quote for stock BK
> 
> 
> 
> stock   field  value
> 
> -   -  -
> 
> BK   ISIN: -
> 
> BK   currency: USD
> 
> BK   date: 05/08/2024
> 
> BKisodate: 2024-05-08
> 
> BK method: run_executor
> 
> BK  price: 57.64500045776367
> 
> BKsuccess: 1
> 
> BK symbol: BK
> 
> BK   timezone: EDT
> 
> 
> 
> 
> 
> C:\Users\kalpesh>
> 
> 
> 
> When running same command via YahooJSON following is the output which 
> works fine (I see that it does have more information returned back):
> 
> 
> 
> C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" 
> -v yahoojson BK
> 
> {snip}
> 
> Finance::Quote f

Re: [GNC] Update on financequote?

[Kalpesh Patel]

Your query seems to be garbled up but from what I make out from it: yes, F::Q 
works fine as of v1.61_03 release if that is what you are asking.

-Original Message-
From: interesse  
Sent: Friday, May 10, 2024 7:29 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Update on financequote?

Hello everyone,

Is there any news on the problem with financequote not being able to access 
online courses?

Or is there somewhere I can see the current status? I haven't found anything 
online, but I'm new to it, so maybe I've overlooked it.

Thank you very much!

Best regards, Marco



___
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] Importing historical stock prices to GnuCash in Windows

[Kalpesh Patel]

You may want to look at 
https://github.com/ka-patel/dl_quotes/tree/main/yfinance which is Python 
based...

-Original Message-
From: sunfis...@yahoo.com  
Sent: Friday, May 10, 2024 2:59 AM
To: Leung Wing Cheong 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows

Of course there is. The csv importer can handle any price data, including 
historical data, as long as you supply the proper dates along with the other 
data elements. 

The challenge is gathering that price data in the first place. It used to be 
possible to retrieve unlimited price quotes from a number of online sources, 
but those days are gone, sadly. 

At one point in the past, I used a perl module to retrieve monthly prices for 
all my commodities and put them into the GnuCash price history, but the module 
depended on Yahoo!, which no longer allows that level of data gathering. 

⁣David T.​

On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong 
 wrote:
>Hi,
>Is there any way to import historical stock prices to GnuCash in 
>Windows?
>Thanks,
>Wing
>___
>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] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)

[Kalpesh Patel]

Hi GNC User community -

 

I am developing a second F::Q module of my own. The first one works fine but
second one seems to NOT want to work no matter what. I am in middle of
debugging it and it has stomped me why not so hoping someone might be able
to help me zero in where I am falling sort on the flow for it. I am working
with F::Q v1.61_02 and GNC v4.14 (4.14+(2023-03-25) build) running on
Windows 11. (Note: I don't believe any interface change has taken place in
GNC v5.x that would cause this but correct me here if I am wrong.).

 

Invoking GNC with debug shows that return value is #f, which means something
went wrong (run_executor is the "label" for my module and other modules work
fine from the debug output):

 

11:19:24 DEBUG  handling-request: (currency INR USD)

* 11:19:24 DEBUG  results: ((INR (symbol . INR) (gnc:time-no-zone .
2024-05-08 11:19:11) (last . 3/250) (currency . USD)))

* 11:20:38 DEBUG  ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY

* 11:20:39 DEBUG  handling-request: (tsp C S L2030 I)

* 11:20:43 DEBUG  results: ((C (symbol . C) (gnc:time-no-zone .
2024-05-07 12:00:00) (last . 812423/1) (currency . USD)) (S (symbol . S)
(gnc:time-no-zone . 2024-05-07 12:00:00) (last . 4009/50) (currency . USD))
(L2030 (symbol . L2030) (gnc:time-no-zone . 2024-05-07 12:00:00) (last .
237163/5000) (currency . USD)) (I (symbol . I) (gnc:time-no-zone .
2024-05-07 12:00:00) (last . 42507/1000) (currency . USD)))

* 11:20:43 DEBUG  handling-request: (run_executor BK)

* 11:20:43 DEBUG  results: (#f)

* 11:20:43 DEBUG  handling-request: (yahoojson ^NYA)

* 11:20:44 DEBUG  results: ((^NYA (symbol . ^NYA) (gnc:time-no-zone
. 2024-05-08 12:00:00) (last . 2247813/125) (currency . USD)))

 

Following is debug run from command line of gnc-fq-dump (which provides all
necessary fields for quote to be valid as it does not show '** This stock
quote cannot be used by GnuCash!' message):

 

C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v
run_executor BK

{snip}

### [Wed May  8 11:34:40 2024]   %info : {

###'BKISIN' => '-',

###'BKcurrency' => 'USD',

###'BKdate' => '05/08/2024',

###'BKisodate' => '2024-05-08',

###'BKmethod' => 'run_executor',

###'BKprice' => '57.64500045776367',

###'BKsuccess' => '1',

###'BKsymbol' => 'BK',

###'BKtimezone' => 'EDT'

###  }

Finance::Quote fields Gnucash uses:

symbol: BK   <=== required

  date: 05/08/2024   <=== recommended

  currency: USD  <=== required

  last:  <=\

   nav:  <=== one of these

 price: 57.64500045776367<=/

  timezone: EDT  <=== optional

 

All fields returned by Finance::Quote for stock BK

 

stock   field  value

-   -  -

BK   ISIN: -

BK   currency: USD

BK   date: 05/08/2024

BKisodate: 2024-05-08

BK method: run_executor

BK  price: 57.64500045776367

BKsuccess: 1

BK symbol: BK

BK   timezone: EDT

 

 

C:\Users\kalpesh>

 

When running same command via YahooJSON following is the output which works
fine (I see that it does have more information returned back):

 

C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" -v
yahoojson BK 

{snip}

Finance::Quote fields Gnucash uses:

symbol: BK   <=== required

  date: 05/08/2024   <=== recommended

  currency: USD  <=== required

  last: 57.605   <=\

   nav:  <=== one of these

 price:  <=/

  timezone:  <=== optional

 

All fields returned by Finance::Quote for stock BK

 

stock   field  value

-   -  -

BK  close: 57.4

BK   currency: USD

BK   date: 05/08/2024

BK  div_yield: 2.8397212

BKeps: 3.99

BK   exchange: NYSE

BK   high: 57.75

BKisodate: 2024-05-08

BK   last: 57.605

BKlow: 57.12

BK method: yahoo_json

BK   name: BK (The Bank of New York Mellon Cor)

BK   open: 57.23

BK pe: 14.437344

BKsuccess: 1

BK symbol: BK

BK   type: EQUITY

BK volume: 730814

BK year_range:39.65 - 58.28

 

 

C:\Users\kalpesh>

 

Given that, why would GNC not accept the pricing? Does it have to be in a
particular order what is returned back, or 

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

[Kalpesh Patel]

My bad here ... since working with Perl 5.005 ... 

-- Original Message --
Received: Fri, 03 May 2024 02:37:19 PM EDT
From: "Kalpesh Patel" 
To: Bruce Schuck , GnuCash User
Cc: Kalpesh Patel , Fred
Tydeman 
Subject: Re: [GNC] Finance::Quote PreRelease 1.61_03

> Hi Bruce,
> 
> Indeed it is old school way to generate make file and install Perl modules.
I
> do recall doing so on many iterations since working with Perl 5.10 days
when
> CPAN was in its infancy for couple of Financial Houses I was employed at
that
> were big time into Perl. Especially trying to build SSLeay module with
> OpneSSL, z-lib (or was it libz) and other dependent libraries' headers on
SUN
> Ultra Sparc 2's back then. What a nightmare (or fun) that was...  
> 
> Anyways I was more interested in making sure that Fred had generated
correctly
> and not adopted from somewhere else that might be somewhat bastardized one.
I
> also got thrown off a bit in that when I cloned the repo for 1.61_03, it
> didn't have Makefile.PL so it was more to make sure it was installed from
> correct source.
> 
> I looked at Makefile.PL for 1.61 source at CPAN and it does NOT have CPAN
> listed in PREREQ_PM or in %FallbackPrereqs. Might be worth adding to it...
> 
> 
> -- Original Message --
> Received: Fri, 03 May 2024 11:30:22 AM EDT
> From: Bruce Schuck 
> To: GnuCash User Cc: Kalpesh Patel
> , Fred Tydeman 
> Subject: Re: [GNC] Finance::Quote PreRelease 1.61_03
> 
> > On May 2, 2024 at 23:44:53 EDT Kalpesh wrote:
> > 
> > > That is possible that there is no depend target in the make file. 
> > > Just curious how you built/get the make file for it?
> > 
> > Kalpesh,
> > 
> > The old school method of installing Perl modules.
> > 
> > The makefile is created by running "perl Makefile.PL". Then one would 
> > execute "make", "make test", and "make install". When I first started 
> > using Perl, there was no "cpan" or "cpanm" that automated much of the 
> > process. Fetching prerequisites and installing them is one of the major 
> > reasons for using cpan/cpanm. It's been such a long time since I had 
> > used the OG module install method that I forgot that it does not have a 
> > mechanism for fetching and installing dependencies. Back in the day the 
> > dependencies were typically noted in the module's README file and one 
> > had to manually retrieve and install them.
> > 
> > This method is definitely not for Perl novices. These days it's more for 
> > those who display masochistic tendencies...
> > 
> > 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 PreRelease 1.61_03

[Kalpesh Patel]

Hi Bruce,

Indeed it is old school way to generate make file and install Perl modules. I
do recall doing so on many iterations since working with Perl 5.10 days when
CPAN was in its infancy for couple of Financial Houses I was employed at that
were big time into Perl. Especially trying to build SSLeay module with
OpneSSL, z-lib (or was it libz) and other dependent libraries' headers on SUN
Ultra Sparc 2's back then. What a nightmare (or fun) that was...  

Anyways I was more interested in making sure that Fred had generated correctly
and not adopted from somewhere else that might be somewhat bastardized one. I
also got thrown off a bit in that when I cloned the repo for 1.61_03, it
didn't have Makefile.PL so it was more to make sure it was installed from
correct source.

I looked at Makefile.PL for 1.61 source at CPAN and it does NOT have CPAN
listed in PREREQ_PM or in %FallbackPrereqs. Might be worth adding to it...


-- Original Message --
Received: Fri, 03 May 2024 11:30:22 AM EDT
From: Bruce Schuck 
To: GnuCash User Cc: Kalpesh Patel
, Fred Tydeman 
Subject: Re: [GNC] Finance::Quote PreRelease 1.61_03

> On May 2, 2024 at 23:44:53 EDT Kalpesh wrote:
> 
> > That is possible that there is no depend target in the make file. 
> > Just curious how you built/get the make file for it?
> 
> Kalpesh,
> 
> The old school method of installing Perl modules.
> 
> The makefile is created by running "perl Makefile.PL". Then one would 
> execute "make", "make test", and "make install". When I first started 
> using Perl, there was no "cpan" or "cpanm" that automated much of the 
> process. Fetching prerequisites and installing them is one of the major 
> reasons for using cpan/cpanm. It's been such a long time since I had 
> used the OG module install method that I forgot that it does not have a 
> mechanism for fetching and installing dependencies. Back in the day the 
> dependencies were typically noted in the module's README file and one 
> had to manually retrieve and install them.
> 
> This method is definitely not for Perl novices. These days it's more for 
> those who display masochistic tendencies...
> 
> 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 PreRelease 1.61_03

[Kalpesh Patel]

That is possible that there is no depend target in the make file. Just curious 
how you built/get the make file for it?

 

Nonetheless as Bruce mentioned, something is amiss with your Perl install. At 
minimum, install perl-CPAN module using dnf package manager (which I believe is 
the OS package manager for Fedora). Further see 
https://www.cyberciti.biz/faq/install-perl-in-fedora-linux-using-dnf-command/ 
to understand how-to install Perl correctly and then 
https://packages.fedoraproject.org/pkgs/perl-CPAN/perl-CPAN/ to review the 
perl-CPAN installation information.

 

Hope this helps.

 

From: Fred Tydeman  
Sent: Thursday, May 02, 2024 11:40 AM
To: Kalpesh Patel 
Cc: Bruce Schuck ; GnuCash User 

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

 

make depend

fails (as there is no 'depend' target in the makefile).

 

On Thu, May 2, 2024 at 6:16 AM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

If you are installing it into the system installed perl, which most likely you 
are doing so with a su switch user utility, then correct way to do so would be 
to:

# sudo su -
# cd 
# make depend
# make
# make test
# make install
# make clean

___
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 PreRelease 1.61_03

[Kalpesh Patel]

If you are installing it into the system installed perl, which most likely you 
are doing so with a su switch user utility, then correct way to do so would be 
to:

# sudo su -
# cd 
# make depend
# make
# make test
# make install
# make clean

(space and then followed by a dash is important on the first command).

-Original Message-
From: Fred Tydeman  
Sent: Wednesday, May 01, 2024 10:39 PM
To: Bruce Schuck 
Cc: GnuCash User 
Subject: Re: [GNC] Finance::Quote PreRelease 1.61_03

On my Linux systems, after some searching, I found that I needed:
  dnf install perl-ExtUtils-MakeMake*
to get me started.
Running perl Makefile.PL
got me several warnings of other missing perl files.
After doing a bunch of dnf install perl-... for them, 'make' and 'make test' 
ran But, 'make install' failed due to permission issues.
Does it need 'su' to do the install?



On Wed, May 1, 2024 at 7:09 PM Fred Tydeman  wrote:

> I am running Fedora Linux 26
> I downloaded the Finance::Quote.
> When I run:  perl Maklefile.pl
> I get:  Can't locate ExtUtils/MakeMaker.pm So, can you point me to 
> more complete documentation?
>
> On Tue, Apr 30, 2024 at 8: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-Quot
>> e-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::Quote PreRelease 1.61_03

[Kalpesh Patel]

"Gets nothing on my linux." sounds like those modules have not been initialized 
as your system is NOT running in an "island" configuration since sudo make 
install works. This might possibly be an outbound firewall issue although if 
wget and/or curl works then not.

Run following:
perl -MCPAN -e shell

to see if you get 'cpan>' prompt. If not then most likely CPAN module is not 
installed on your system which would be unusual as it comes with modern perl. 
Not sure which type of Linux you are running but generally if a Perl library is 
named Foo::Bar on CPAN (CPAN is named CPAN), the Debian/Ubuntu package will be 
named libfoo-bar-perl and for Fedora/Redhat it will be named perl-Foo-Bar.

If you have cpan modules installed then it is a good idea to initialize it by 
executing 'o conf commit' at CPAN shell prompt of 'cpan>'.

-Original Message-
From: Fred Tydeman  
Sent: Wednesday, May 01, 2024 11:50 PM
To: Bruce Schuck 
Cc: GnuCash User 
Subject: Re: [GNC] Finance::Quote PreRelease 1.61_03

Running: sudo make install
worked.  I was able to get stock quotes again.  So thank you.

Trying:
  cpan
  cpanm
  locate cpan
Gets nothing on my linux.

  dnf list cpan*
gets: cpanspec.noarch


On Wed, May 1, 2024 at 8:07 PM Bruce Schuck 
wrote:

> On 5/1/24 7:39 PM, Fred Tydeman wrote:
>
> > On my Linux systems, after some searching, I found that I needed: 
> > dnf install perl-ExtUtils-MakeMake* to get me started. Running perl 
> > Makefile.PL got me several warnings of other missing perl files.
> > After doing a bunch of dnf install perl-... for them, 'make' and 
> > 'make test' ran But, 'make install' failed due to permission issues.
> > Does it need 'su' to do the install?
>
> People not familiar with the "manual" method of installing should use 
> cpan or cpanm. To install an interim release
>
> "cpanm BPSCHUCK/Finance-Quote-1.61_03.tar.gz" or "cpan 
> BPSCHUCK/Finance-Quote-1.61_03.tar.gz".
>
> Depending how cpan(m) is configured, super user permissions may or may 
> not be required. Typically when running cpan or cpanm, the install 
> process will ask for the user's sudo password to install modules.
>
> When I would install using the "perl Makefile.PL; make; make test; 
> make install" steps, I would become root or use sudo to execute "make 
> install". But again, most people should utilize cpan or cpanm. The 
> install tool provided by GnuCash utilizes CPAN.
>
> There is a brief overview of installing modules at 
> https://www.cpan.org/modules/INSTALL.html which doesn't mention the 
> legacy "perl Makefile.PL" method. As I mentioned in my post though, 
> "For those who are comfortable with the interim releases". Comfortable 
> being the operative word.
>
> 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] Identify error transaction in QIF import

[Kalpesh Patel]

While this is not specific to the problem at hand (which others have provided 
work around - namely fall back to GNC 5.5 which likely is to have better 
success), given that I went through the migration while back (circa GNC v4.3) 
to import data since at least 1993, these are the lessons I've learned:

Don't try to export as a one giant file from Quicken and import into GNC. I 
highly recommend you do one account per export file and then import. If it 
succeeds, make a backup copy of GNC file and go onto next one. The order of 
import I suggest your perform is first the investment accounts with greatest 
number of transactions as the very first one going down to least number of 
transactions. Then do banking account, credit card accounts and finally any 
other ones if you have. Optionally, once import is done, download transactions 
from your banks, etc., as an OFX and import them.  Not sure if you are in the 
States or not but some of the large financial institutions allow you to go back 
up to 10 years of downloads.  You are NOT likely to succeed if you try to do so 
in one leap...

Quicken's 'File-Operations'->'Validate and  Repair' is not likely to help you 
fix Quicken export errors. Sadly there is good deal of ambiguity in qif spec 
which causes headaches. These sort of exceptions requires manual fixes. QIF 
file is a text file and can be edited easily if you find the transactions that 
is causing the issue (format can be found at 
https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm#:~:text=A%3A%20The%20Quicken%20interchange%20format,that%20supports%20the%20QIF%20format.).
 Divide and conquer is going to be the operations to find the transaction that 
is an issue in the exported file - break up file into two; import one and if it 
succeeds then the error is in the other file; divide that problematic one into 
two again and continue to this path until transaction that is causing the 
problem is found.

If anything, what is recommended be done in Quicken is to 
'File-Operations'->'Validate and  Repair', followed by 
'File-Operations'->'Copy'. Perform this at least three times but each time open 
the new copy created by previous step. After the last iteration, you can rename 
the '...CpyCpyCpy...' file to original name and then perform export one account 
at a time as previously mentioned. 

Before doing all this, export out the account tree from the Quicken. You can do 
this in the QIF Export window by just selecting 'Account list' only and then 
import it into GNC before importing any accounts and related transactions.
   
Also I suggest you look at the messages archive of this list and review past 
messages on this specific topic. There is wealth of that info. 

Hope this helps. 

-Original Message-
From: hh8...@gmail.com  
Sent: Sunday, April 28, 2024 7:43 AM
To: 'Joseph Keithley' 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Identify error transaction in QIF import

Hi,

 

Thanks for the advice.  I run Quicken -> Validate and Repair File and it 
reported a few errors that I fixed.

 

However, I still get the same error message

 

Missing QIF investment action for transaction dated 9/19/2019



I opened the QIF in text editor and searched for 9/19’19.  There are about 10 
instances in a few banking accounts.  Then all others are !Type:Prices

 

I have more than 20 years of records and more than 100 accounts.  It will be 
very difficult to do this one by one.

 

Is it possible for the error message to be more specific and pointing to exact 
transaction?

 

Thanks

 

From: Joseph Keithley 
Sent: Sunday, April 21, 2024 11:47 AM
To: hh8...@gmail.com
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Identify error transaction in QIF import

 

The first thing I did before I exported my 150mb Quicken file to a qif was to 
run the Validate and Repair in the File menu under File Operations.  Sometimes 
the Quicken data file gets corrupted and you have to repair transactions.  That 
may help you track down if the issue is with your Quicken file or GnuCash.

 

I tried to export my Quicken file as a single qif and then import it into 
GnuCash.  That approach was a complete disaster.  I assume that since my 
Quicken file was so large, GnuCash couldn't really handle the conversion 
directly.  

 

In order for me to finally get my Quicken file imported into GnuCash, after ten 
different attempts, I exported one account at a time, one year at a time, until 
I had all the data exported. Then I imported each into GnuCash.  I then had to 
make a number of manual edits and corrections to the GnuCash file but that was 
largely due to my unfamiliarity with GnuCash.

 

The bottom line is, one way to make the import easier is to stick to 
exporting/importing one account at a time.  When you then import the next 
account, matching up transactions will be much easier.  I also found that 
having the account structure already setup in GnuCash, mimicing the same 
account names and categories in 

Re: [GNC] Any bank that still functions well with AqBanking? Does Paypal?

[Kalpesh Patel]

Bryan - GNC does not have extensive of online download capabilities as Quicken 
does; rightfully so -- that is what Quicken provides in return for purchasing a 
license for, and that is what Quicken already offers and does well. Most of us, 
if not all, who came over from Quicken world that wanted to unshackle from 
their yearly subscription model tend to rely on downloading the data directly 
from financial institution using OFX/QFX (preferred), QIF or CSV format and 
then import it in. There may be here and there that may be using off-line 
programs (like I using modified PocketSense scripts from  
http://sites.google.com/site/pocketsense/) to download them in OFX format that 
is importable. Nonetheless GNC model is mostly tied to export from financial 
institution and import it in into GNC; how you export it out is all up to your 
creativity ... 

-Original Message-
From: Bryan B.  
Sent: Tuesday, April 23, 2024 2:18 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Any bank that still functions well with AqBanking? Does Paypal?

I'm trying to switch from Quicken to GnuCash.

The AqBanking feature did not work with my two banks.

The primary thing I still love about Quicken is that I can simply click a 
button and it downloads transactions across all my accounts. It's a huge time 
saver.

To switch to GnuCash, I would have to at the very least consolidate all my 
frequently used accounts into one bank that either downloads automatically 
through the AqBanking feature, or perhaps through some API script that I would 
have to create and manage (ugh), or, as a last option, log in to every day and 
download the transaction reports.

Does anyone know of any method, bank, or whatever that allows for automating 
the transaction download feature that speeds up the process?

Bryan


___
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] F::Q Dependencies list

[Kalpesh Patel]

In case you are interested in seeing what packages are needed for F::Q, go
to this site..

 

https://cpandeps.grinnz.com/?dist=Finance-Quote

_version==runtime_version=v5.38.2=table

 

___
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] Finance-Quote 1.60 released!

[Kalpesh Patel]

I was able to reproduce the issue in Frankfurt so it definitely is "geo" based 
issue; specifically EU countries. Attached is a drop in replacement 
YahooJSON.pm module that works with EU and other regions if anyone wants to use 
it before new package is released that incorporates these changes.


-Original Message-
From: Bruce Schuck  
Sent: Thursday, April 18, 2024 1:31 PM
To: gnucash-user@gnucash.org
Cc: kalpesh.pa...@usa.net
Subject: Re: GNC] Finance-Quote 1.60 released!

On Thu, 18 Apr 2024 16:13:34 +0200, Klaus writes:

> I am located in Germany and only one cookie is returned. Here is the 
> top of the output of 'curl --include https://login.yahoo.com':

Klaus,

Thank you for posting that. It helps confirm this is a geo related issue.

Thank you to David Crowe for pointing out 
https://developer.yahooinc.com/datax/guide/gdpr/cookiemapping/ on 
https://github.com/finance-quote/finance-quote/issues/373. I suspect GDPR 
compliance is related to the YahooJSON issue.

Additional testing did indicate that the module does work from an Albanian IP 
address. I guess while this is being researched, users with EU IP addresses can 
not use the 'yahoo_json' quote method.

I believe Kalpesh is going to stand up an AWS EC2 instance in an EU region for 
further investigation. Very much appreciated.

Bruce S


YahooJSON.pm
Description: Binary data
___
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.60 released!

[Kalpesh Patel]

Bruce -- Sorry, saving cookies part wasn't for you.

Any ways it definitely appears to be tied to geo location. Another gentleman 
out of Germany is NOT getting those cookies either.

I'll see if I can spin up EC2 in different regions to build the trend and then 
propose changes to the module that could accommodate both sides. I need to 
confirm if subtle changes to the URI is also geo based or not to make it logic 
work better.

-Original Message-
From: Bruce Schuck  
Sent: Wednesday, April 17, 2024 3:40 PM
To: 'GnuCash User' 
Cc: rull...@protonmail.com; adam.grif...@gmail.com; Kalpesh Patel 

Subject: Re: [GNC] Finance-Quote 1.60 released!

On 4/17/24 11:57 AM, Kalpesh Patel wrote:

> You can also save cookies to a file named cookies.txt as follows: 
> #curl -c cookies.txt https://login.yahoo.com -I

> and then following to display 11 characters crumb by using cookies 
> saved in previous command: #curl -H "user-agent: Mozilla/5.0 
> (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like
> Gecko) Chrome/39.0.2171.95 Safari/537.3" -b cookies.txt 
> https://query2.finance.yahoo.com/v1/test/getcrumb

I'm not interested in saving the cookies at this time. I've been having a 
discussion with another user having the same (or similar) issue. In debug mode 
his cookie jar has only 1 cookie, the "AS=v=1=..." cookie.

### [Wed Apr 17 08:59:30 2024]cookie_jar : bless( {
### COOKIES => {
### 'login.yahoo.com' => {
### '/' => {
### AS => [
### 0,
###
'v=1=pdMraThU=A6620c4d1|itU7Kpb.2SoujXrNK8pQPMi...
### undef,
### 1,
### 1,
### undef,
### 1,
### {
### HttpOnly => undef
### }
### ]
### }
### }
### }
### }, 'HTTP::Cookies' )

The other 3 cookies that I get can see in debug mode are not in the cookie jar. 
My theory is that for those it is not working, they are not getting all 4 
cookies.

Bruce S


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

Re: [GNC] Finance-Quote 1.60 released!

[Kalpesh Patel]

   
undef,
### 
{
### 
  HttpOnly => undef,
### 
  SameSite => 'None'
### 
}
### 
  ]
### 
  }
### 
 },
###  
'login.yahoo.com' => {
### 
'/' => {
### 
 AS => [
### 
 0,
### 
 
'v=1=ZpPpXAWp=A662166f6|wy8UEd7.2SrgMZFNCyRJFuJ88rkOfc7f2KNA89u_WuZ6fXrY8xzJ07zjmdHjjnVL7tUTSw9uOSzz31wvEds3TZq7h7j7PYLUObzbyEjzTF2bq9g.9kTJ2emMatlgJP1V5BfRD7rzwA6LUYRRf3NJ2o4nE8UA9THS9pfojIhzfHE.zV82j.SFjuZaLiyo1qU7JOYKwW5rSnnrKLYDx_5LOF3xDsgPPsgB97CPalhkcGNN0Sfewon4rGTiq1xRAFC_P7moFihb9KK5ejN6TlswyksxWcImt6DpMaWxzQImS9rS4v_iM_IcHfyWSt4k6CankWWAtD0dCdmEuq5BJ8SRDpDwwjyWAPV8arKd8r9JVaDS1ODV.13EknVzp3Wi8WTpRiQYTeYhzBy0IpwYgEdFnEmFBkOXRfykYsYcQ60Dg1rUQZhWg8SJVk.ch9FNELrRVHCBaHJ6CK5d2BZPWKpFLz7NHK0POU5_rrRYjLhveOX7ISsG6GJxBSNCFuff4Aas0BbFL3mVc2X8hCzveGWCtO5TuXTkPrzJtHAVVzgQFrjQVsAVKycNM6I0lfvHNb23em30BKc7Kvc86pUxfXRBZi68mBBsCrm2isD6O9tKLgl7FovOZX4YtQAX2rNY6n.4Gen1pY5gTRCfU5iL.4gCjjmGt6Vvgtjlsvo0tXBSTUPmZvGwx97JON.atz7LDy9O2qALAskB04PnUhUXaH5thOOHFPYF92AB2w7f4j3IZMwHD.UFuWZc7EsaRG_5989fHZ9FtPyH94Ut6vqlInUkL_xXQuwmODh2RyYuCAoJCTwD~A',
### 
 undef,
### 
 1,
### 
 1,
### 
 undef,
### 
 1,
### 
 {
### 
   HttpOnly => undef
### 
 }
### 
   ]
### 
   }
### 
  }
###}
###   }, 'HTTP::Cookies' )
### [Wed Apr 17 14:31:18 2024] crumb : '8CJLZDzzDDN'


-Original Message-
From: Bruce Schuck  
Sent: Wednesday, April 17, 2024 1:50 PM
To: GnuCash User 
Cc: kalpesh.pa...@usa.net; rull...@protonmail.com; adam.grif...@gmail.com
Subject: Re: [GNC] Finance-Quote 1.60 released!

Wed Apr 17 11:58:37 EDT 2024, Kalpesh Patel writes:

> Is this happening on Windows 10 with Strawberry perl?

> There is one other user is having problem getting secure cookies on 
> Windows 10 which is what this appears to be as well. It is related to
> some Perl's SSL package being broken or not installed correctly but
> haven't been able to pinpoint it.

Wednesday, April 17, 2024 5:44 AM, Richard Ullger writes:

> yahoojson and yahooweb are not working for me either in v1.60 and 
> they didn't work in 1.59_01.
WRT "yahooweb", Yahoo made changes to their finance pages. The URL used 
for the web scrape, aside from some formatting changes that break the 
module, also returns a huge amount of header information (over 16k bytes 
when I fetch it using curl). While I have a fix for the large amount of 
header information, work needs to be done to change the parsing to 
retrieve the data (see 
https://github.com/finance-quote/finance-quote/issues/377).

WRT "yahoo_json" (which now allows it to be called "yahoojson"), some 
users are reporting the same. Turning debug on within Perl has so far 
indicated that not all the required cookies are being returned.

 From using "curl" the following cookies should be retrieved:

AS=v=...

A1=d=..

Re: [GNC] Finance-Quote 1.60 released!

[Kalpesh Patel]

Richard,

Is this happening on Windows 10 with Strawberry perl? 

There is one other user is having problem getting secure cookies on Windows 10 
which is what this appears to be as well. It is related to some Perl's SSL 
package being broken or not installed correctly but haven't been able to 
pinpoint it.  

-Original Message-
From: Richard Ullger  
Sent: Wednesday, April 17, 2024 5:44 AM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Finance-Quote 1.60 released!

On Wed, 17 Apr 2024 08:23:38 +0200
"Adam Griffis"  wrote:

> Yes, I have the AlphaVantage api key set. But that's not the issue --
> I'm not pulling from AlphaVantage. I'm pulling from YahooJSON.
> 
> If I understand correctly, the 1.60 update should include a fix to get
> YahooJSON working again, resolving the "cookie and crumb" issue.
> However, YahooJSON is still giving me the same error. Is an API key
> required for YahooJSON now?
> 
> Thanks,
> Adam

yahoojson and yahooweb are not working for me either in v1.60 and they
didn't work in 1.59_01.

I have perl-http-cookiejar installed.

perl-finance-quote has been dropped from the arch repos to the AUR.
It's still at 1.59 in the AUR so I've taken the PKGBUILD and modified
it for 1.60.

I am currently running gnucash v4.14.

The output for yahoojson is...

gnc-fq-dump -v yahoojson AEI.L
Finance::Quote fields Gnucash uses:
symbol: AEI.L<=== required
  date: **
 missing **<=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock AEI.L

stock   field  value
-   -  -
AEI.Lerrormsg: Error retrieving quote for AEI.L. Attempt to
fetch the URL
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbols=AEI.L={"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid
Cookie"}}}=price,summaryDetail,defaultKeyStatistics resulted in
HTTP response 401 (Unauthorized)
AEI.Llast: **missing**
AEI.L nav: **missing**
AEI.L   price: **missing**
AEI.L success: 0
AEI.L  symbol: AEI.L


The output for yahooweb is...

gnc-fq-dump -v y
ahooweb AEI.L
Finance::Quote fields Gnucash uses:
symbol: AEI.L (deduced)  <=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last: **missing**  <=\
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock AEI.L

stock   field  value
-   -  -
AEI.Lerrormsg: 500 Header line too long (limit is 8192)
AEI.Llast: **missing**
AEI.L nav: **missing**
AEI.L   price: **missing**
AEI.L success: 0

--
Richard

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

[Kalpesh Patel]

I have always wondered why two are not in sync...

-Original Message-
From: Bruce Schuck  
Sent: Sunday, April 14, 2024 6:14 PM
To: David Reiser ; Fross, Michael 
Cc: david amaral ; gnucash-user@gnucash.org
Subject: Re: [GNC] Finance Quotes Yahoo off the rails again?

On 4/14/24 3:02 PM, David Reiser wrote:

> yahoo_json not YahooJSON

Yeah... I've made that mistake myself many times. The original author of the 
YahooJSON module chose to name the method (aka subroutine with the name used in 
the Security Editor and on the command line) "yahoo_json". 
Most other modules, the main method has the same name as the module except all 
lower case. I probably should add to the method hash so both 'yahoo_json' and 
'yahoojson' work.

Oh yeah, I'm assuming it's working now that you used the method name?

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 Quotes Yahoo off the rails again?

[Kalpesh Patel]

Verbose; not terse ...  

gnucash-cli.exe --verbose -Q dump yahoo_json aapl

-Original Message-
From: David Reiser  
Sent: Sunday, April 14, 2024 6:02 PM
To: Fross, Michael 
Cc: david amaral ; gnucash-user@gnucash.org; Bruce Schuck 

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

yahoo_json not YahooJSON

--
Dave Reiser
dbrei...@icloud.com





> On Apr 14, 2024, at 17:03, Fross, Michael via gnucash-user 
>  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::quote YahooJSON

[Kalpesh Patel]

I am currently using modified YahooJSON.pm module for my needs and seems to be 
working from the States. It is pulling data so far. Head over to 
https://github.com/ka-patel/dl_quotes/blob/main/FinanceQuote/YahooJSON.pm if 
you are interested in its early release before Bruce can do his vetting and get 
it into the main line release of F::Q. Of course I am also interested in its 
feedback. 

Keep in mind that this will introduce dependency on HTTP::CookieJar::LWP module 
(https://metacpan.org/pod/HTTP::CookieJar::LWP) which you can install from CPAN 
using your normal methods of module installation. Transcript of install below...

Microsoft Windows [Version 10.0.22631.3447]
(c) Microsoft Corporation. All rights reserved.

C:\Users\kalpesh>perl -MCPAN -e shell
Unable to get Terminal Size. The Win32 GetConsoleScreenBufferInfo call didn't 
work. The COLUMNS and LINES environment variables didn't work. at 
C:\Strawberry\perl\vendor\lib/Term/ReadLine/readline.pm line 410.

cpan shell -- CPAN exploration and modules installation (v2.28)
Enter 'h' for help.

cpan> install HTTP::CookieJar::LWP
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Database was generated on Fri, 12 Apr 2024 11:19:08 GMT
Updating database file ... Done!
HTTP::CookieJar::LWP is up to date (0.014).

cpan> upgrade HTTP::CookieJar::LWP
All modules are up to date for HTTP::CookieJar::LWP

cpan> exit
Lockfile removed.

C:\Users\kalpesh>
 

-Original Message-
From: Bruce Schuck  
Sent: Thursday, April 11, 2024 10:39 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Finance::quote YahooJSON

On 4/11/24 17:29:59 +, Greg wrote:

> I'm sure the Dev's are working on it, but do we have any idea what 
> happened?  My log shows 401 type errors (Unauthorized) so I thought 
> I'd add some diagnostics in case it helps anyone.

> Hoping for some good news (and I'm sure I'm not alone on that).

> I really appreciate this great working mail list and thanks for those 
> who devlop/fix/maintain the program.

It's important to note that these APIs are likely not meant for direct access. 
Which is why the previous APIs that the YahooJSON.pm all became unusable at 
some point. This would be why you cannot find official documentation for the 
APIs online like you can for APIs like the AlphaVantage which limits what you 
can retrieve for free.

I've had less time to work on F::Q the last few months, so I'm not sure when 
I'll be able to either rework the module to use the v8 API or test and 
implement Kalpesh Patel's changes. Hopefully in the next week or so, but if 
someone else wants to step up and create a pull request at 
https://github.com/finance-quote/finance-quote that would be a great help.

On 4/11/24 12:48:09 -0600 (MDT), Terrence Branscombe wrote:

> I've just noticed that my last stock price update occurred on March 
> 28. * 11:11:36 ERROR  [parse_quotesource_error()]

> Unrecognized Finance::Quote Error Wide character in subroutine entry 
> at C:/Strawberry/perl/site/lib/Finance/Quote/Cdnfundlibrary.pm line 
> 80.
It appears the format of page Cdnfundlibrary.pm uses to scrape the data from 
fundlibrary.com has had major changes. The Fundata.pm module
(idata.fundata.com) has also stopped working for the same reason. See Issue 
https://github.com/finance-quote/finance-quote/issues/366 and discussion 
https://github.com/finance-quote/finance-quote/discussions/364.

Unfortunately both modules are likely going to be disabled and then removed 
from Finance::Quote. The Fool.pm module has also recently stopped working and 
it will also be disabled in the next release of F::Q.

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 YahooJSON

[Kalpesh Patel]

You may want to review my personal project at 
https://github.com/ka-patel/dl_quotes ...

-Original Message-
From: Geoff  
Sent: Thursday, April 11, 2024 7:57 AM
To: fromvendor ; 'GnuCash User eMail List' 

Subject: Re: [GNC] Finance::quote YahooJSON

 > Is there a way to import data to the price database?  I could create a > CSV 
 > or the like and just update the numbers from day to day until this > gets 
 > resolved.

Yes, you can:-

File / Import / Import Prices from a CSV file ...

You only need 5 columns:-
(1) Namespace
(2) Symbol
(3) Date
(4) Price
(5) Currency

See attached.

Regards

Geoff
=

On 11/04/2024 4:41 pm, fromvendor wrote:
> I've tried Advantech, Motley, and Rowe.  All failed (different, but fails for 
> all of them).
> 
> I put in manual entries for now.  Is there a way to import data to the price 
> database?  I could create a CSV or the like and just update the numbers from 
> day to day until this gets resolved.
> 
> Thanks all,
> -g
> 
> -Original Message-
> From: fromven...@outtacyte.com
> Sent: Thursday, April 11, 2024 1:27 AM
> To: GnuCash User eMail List
> Subject: RE: [GNC] Finance::quote YahooJSON
> 
> OK, I just noticed in my log that I got bit by this.  What other source do 
> you recommend for the nonce?  I only have 3 to get updated.
> -greg
> 
> For help with any of our services, please reach out to our Helpdesk:  
> helpd...@outtacyte.com
> 
> OuttaCyTE / Greg's Helpdesk
> E-Mail: helpd...@outtacyte.com
> Phone: 830-672-9068, Dial ext. 852 to reach a staff person during 
> office hours
> 
> -Original Message-
> From: gnucash-user 
> [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On 
> Behalf Of Bruce Schuck
> Sent: Wednesday, April 10, 2024 4:26 PM
> To: GnuCash User eMail List
> Subject: Re: [GNC] Finance::quote YahooJSON
> 
> Wed Apr 10 16:12:21 EDT 2024 Jacob Larsen wrote:
> 
>> Did something happen to the YahooJSON module in Finance::Quote? Or 
>> perhaps more likely the Yahoo API? I get this now, using 
>> Finance::Quote version 1.59:
> 
> Unfortunately Yahoo once again made some changes with respect to the 
> API URLs. F::Q team is aware and an issue has been opened, but so far 
> no determination if it can be corrected or when. For now the best 
> suggestion is to select a different source.
> 
> 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.

___
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] Split Transactions Version 5.6

[Kalpesh Patel]

Just to add some distinction, if you are coming from Intuit's Quicken world 
then its split is not same as GNC's split  ... the way I think is, split 
happens when "one" side of the transaction in double entry is broken down into 
multiple segments -- example: going out to a restaurant with a friend where you 
"split" the payment for the bill (cash from multiple people pays one bill; cash 
is one side of the transaction while bill is the other side). Of course both 
sides of the transaction can have split.

-Original Message-
From: Michael or Penny Novack  
Sent: Wednesday, April 10, 2024 6:25 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Split Transactions Version 5.6

Best not to think of the two sides of a transaction as "splits". In double 
entry bookkeeping there are ALWAYS two sides of every transaction.  It would be 
silly to think of every transaction as split.

Confusion for new users is perhaps because gnucash allows a shortcut method of 
entry when the transaction has only one debit account and one credit account. 
While that is in effect a special case, the overwhelming majority of 
transactions will only affect two accounts. So it is very worthwhile to have a 
time saving shortcut.

But I question if that's the best way to LEARN using gnucash, especially if you 
are learning double entry bookkeeping at the same time. If you have never done 
double entry bookkeeping before, other software or back in the old days of pen 
and ink on paper (or spreadsheets could mimic
that) I suggest learning without the shortcut.

Turn on "journal mode" for transaction entry. This will more closely mimic the 
old days (and typical accounting texts). Transactions were first entered into a 
book called the "journal". Each entry would have a date, a list of accounts 
being debited (that is, possibly more than one) each with an amount, a list of 
accounts being credited (again possibly more than one) with their amounts, and 
finally a description. Our old books had a box to check whether posted to the 
journal, but with gnucash or similar software, when you hit enter automatically 
posted << transcription errors during posting were the bane of our existence -- 
the computer will never transpose digits, etc. >>

See, so far no mention of "splits". That comes into p;lay only when we use the 
shortcut.

If the transaction involves only two accounts, gnucash will let you enter that 
transaction directly in the ledger starting with EITHER. In this mode you enter 
date, check number if any, amount (you don't have to specify account because 
you are IN that account) and then select the other account <> In other words, you didn't have to enter in the (virtual) 
journal. But what if there is more than one debit or more than one credit. Now 
we have to hit the "split" 
button, which puts us in journal entry mode.

That's all that "split" means in gnucash, either the debit side or the credit 
side (or both) are split into more than one account making up that side of the 
transaction.


Michael D Novack





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

Re: [GNC] Recording transactions (date)

[Kalpesh Patel]

" WOULD honor the check " -- that is the price to be paid because of automation 
where date, whether hand written out or otherwise, cannot be deciphered 
correctly 100% of the time by the check processing equipment and its OCR, but 
the check number is in MICR line which is decipherable by all check processing 
equipment, hence able to "stop" it.

Even though check might say valid XX days or valid until some date, I bet it 
would get processed just like a postdated check would when deposited. Of course 
payer can take an exception with the bank but nonetheless the payee's bank 
check processing equipment would not hold it off.

-Original Message-
From: R Losey  
Sent: Wednesday, April 10, 2024 12:31 AM
To: stepbystepf...@comcast.net
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Recording transactions (date)

On Tue, Apr 9, 2024 at 4:37 PM Michael or Penny Novack < 
stepbystepf...@comcast.net> wrote:

> On 4/9/2024 12:50 PM, R Losey wrote:
> > Thanks; I wasn't sure if those (cash vs accrual) were the correct terms.
> >
> > Legally, are you saying that if I write a check for $50 and send it 
> > to my uncle, it's "paid" whether or not he ever cashes it?
> >
> > As as aside, I am actually in this situation; I sent e check many 
> > years
> ago
> > to someone who has never cashed it; when I asked about it, the 
> > person
> told
> > me that they had no intention of cashing the check, but also 
> > couldn't
> find
> > it to return it, so I've been carrying that check now for years. 
> > Sadly,
> the
> > cost of issuing a "stop check" is not worth it, and the bank says it 
> > will honor a check, no matter how old, so I don't see any way out of this.
>
> What are the laws of your jurisdiction and/or the banking customs? Or 
> the rules of your bank as to how long they will consider a check "live"
> (will honor it if presented).
>

I'm in Texas; I specifically asked the bank and they said that they WOULD honor 
the check, regardless of how old it was. This surprised me greatly, as I worked 
in a bank in Illinois, and we would hold any check that was "old" (I think 
perhaps six months). They suggested I issue a "stop check", but as I noted, 
it's not worth it.




> Most places I have ever lived, most banks I have dealt with, have 
> definite rules that apply unless the check itself specifies a shorter 
> period. Haven't you ever gotten a check marked "void after 60 days" 
> (or
> whatever)
>

Certainly, but I didn't expect this situation and I didn't write any such thing 
on the check.



> Your bank told you WILL HONOR or CAN HONOR? It is common for banks to 
> say CAB HONOR to relieve themselves of liability in a case where they 
> did honor a check after the date their policy (or jurisdiction laws) 
> specify. In other words, "we normally will not honor checks more than 
> six months old but can honor a check no matter how old".
>

I thought they said "WILL HONOR"




> But back to where this started, you paid your uncle on the date you 
> gave him that check.
>

Right, but this wasn't any kind of legal debt; he had visited and done us some 
favors, and we tried to thank him by sending him a check. He said he wouldn't 
take it, but he couldn't find it to give it back. He may have thrown it out; he 
just couldn't remember what he did with it. Thus, I am still considering an 
outstanding check, even though it is probably safe to consider it gone.



_
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.

Re: [GNC] Recording transactions (date)

[Kalpesh Patel]

In the end, monies is what is “float”. That is what I remember from finance 
course number of decades ago; it is more of money function rather than time 
function.

 

Anyways, I also have pondered with that “delay” between when one has “started” 
the transaction and when one has “completed” the transaction. The way I am 
dealing with it is to denote the transaction on the day I actually made it and 
then when reconciling it update the date as it appears on financial institution 
side. If one really wants to account for it then there would be an intermediary 
“floats” account to which you would post the transaction when “started” and 
then when it “completes”, another transaction would be posted from that 
“floats” account into the final account. This “floats” account would always be 
running close to zero unless a check sent that has never been cashed which 
would show up here. I would think that this “floats” would be a liability 
account…

 

 

From: R Losey  
Sent: Tuesday, April 09, 2024 12:44 PM
To: Kalpesh Patel 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Recording transactions (date)

 

I thought "floating a check" means that one issues a check, knowing that there 
isn't money to cover it, but planning to deposit funds before the check is 
presented for cashing.

 

But perhaps you mean "float time" -- that may well be the correct term. I was 
just interested in knowing what people here (many of whom have a closer 
acquantaintence with accounting than I do) thought about using the actual date 
of the transaction versus using the cleared date of the transaction.

 

Clearly, the "cleared" date is when the money actually transfers, but (to my 
mind), one doesn't have an accurate picture of one's finances if there is 
pending money to be removed from an account.

 

 

 

On Tue, Apr 9, 2024 at 7:26 AM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

In the states, isn't that what is called "floats"?

-Original Message-
From: Liz mailto:ed...@billiau.net> > 
Sent: Monday, April 08, 2024 6:50 PM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] Recording transactions (date)

On Mon, 8 Apr 2024 17:11:37 -0500
R Losey mailto:rlo...@gmail.com> > wrote:

> Since I first learned about recording transactions, I have always
> dated a transaction on the date I wrote the check; similarly, when
> entering credit card transactions, I use the date that I actually
> used the credit card.
> 
> Recently, however, I was having a discussion with a friend and he
> said that he uses the bank or credit card date of entry for all of
> his transactions.
> 
> I thought this was strange - probably because it is different from the
> method I've used all of my life. Perhaps I am the odd one... or
> perhaps it's merely a matter of choice, so I thought I'd bring it up
> to this list to see what people think about it.
> 
> From (a very brief) research about this topic, perhaps this is the
> difference between cash basis accounting and accrual accounting?
> 
> 
> After thinking about it for a bit, one issue with using the date that
> the transactions occur is the reports, especially if one has repeating
> transactions.  For example, if the satellite service bill is paid each
> month on the 28th, using my method, I record a transaction on the
> 28th. My friend will see it on the 29th or 30th, but if the weekend
> or holiday hits just right, it can be the 1st or 2nd before he sees
> it. In the long run everything should be the same, but the monthly
> sub-totals can look odd. Checks can be even worse... someone may hang
> onto one for weeks.
> 
> I'd appreciate thoughts on the topic.

I think it is a philosophical difference.
There are legal ramifications, especially when you are spending money.
If you future date transactions you may spend money you don't actually
have. In my jurisdiction a business doing this is in big trouble, for
"trading while insolvent". 
It is not the difference between cash and accrual accounting, but is
part of the differences.

Liz


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




 

-- 

_
Richard Losey
rlo...@gmail.com <mailto: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.

Re: [GNC] Recording transactions (date)

[Kalpesh Patel]

In the states, isn't that what is called "floats"?

-Original Message-
From: Liz  
Sent: Monday, April 08, 2024 6:50 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Recording transactions (date)

On Mon, 8 Apr 2024 17:11:37 -0500
R Losey  wrote:

> Since I first learned about recording transactions, I have always
> dated a transaction on the date I wrote the check; similarly, when
> entering credit card transactions, I use the date that I actually
> used the credit card.
> 
> Recently, however, I was having a discussion with a friend and he
> said that he uses the bank or credit card date of entry for all of
> his transactions.
> 
> I thought this was strange - probably because it is different from the
> method I've used all of my life. Perhaps I am the odd one... or
> perhaps it's merely a matter of choice, so I thought I'd bring it up
> to this list to see what people think about it.
> 
> From (a very brief) research about this topic, perhaps this is the
> difference between cash basis accounting and accrual accounting?
> 
> 
> After thinking about it for a bit, one issue with using the date that
> the transactions occur is the reports, especially if one has repeating
> transactions.  For example, if the satellite service bill is paid each
> month on the 28th, using my method, I record a transaction on the
> 28th. My friend will see it on the 29th or 30th, but if the weekend
> or holiday hits just right, it can be the 1st or 2nd before he sees
> it. In the long run everything should be the same, but the monthly
> sub-totals can look odd. Checks can be even worse... someone may hang
> onto one for weeks.
> 
> I'd appreciate thoughts on the topic.

I think it is a philosophical difference.
There are legal ramifications, especially when you are spending money.
If you future date transactions you may spend money you don't actually
have. In my jurisdiction a business doing this is in big trouble, for
"trading while insolvent". 
It is not the difference between cash and accrual accounting, but is
part of the differences.

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] ANNOUNCE: GnuCash 5.6 Released

[Kalpesh Patel]

... to the point of auto backup taking place at a set frequency by setting it 
up ... that is in: 

Edit --> Preferences --> General: Auto-save time interval

-Original Message-
From: Geoff  
Sent: Tuesday, April 02, 2024 6:21 AM
To: Dave parker ; Gnucash Users 
Subject: Re: [GNC] ANNOUNCE: GnuCash 5.6 Released

Hi Dave, and welcome to the wonderful world of GnuCash!

My experience is with Windows 10.  Download the new version and it will 
uninstall the previous version for you.

https://wiki.gnucash.org/wiki/Installation#Windows

And always take a backup.

https://wiki.c2.com/?BackupEarlyBackupOften

Regards

Geoff
=

On 2/04/2024 11:54 am, Dave parker via gnucash-user wrote:
> I am pretty new to Gnucash.  Do I need to uninstall and install the newer 
> version?  Is there a link I just click on for the update?  Just don't know.
> 
> What is the procedure to update to the new version of Gnucash?
> Thanks for all you do for Gnucash.
> Dave Parker
> 
> Dave's Oil and Synthetics
> Independent AMSOIL Dealer #5682897
> 919-222-8362
> https://davesoilandsynthetics.myamsoil.com/
>   
> 
>  On Sunday, March 31, 2024 at 07:36:56 PM EDT, John Ralls 
>  wrote:
>   
>   The GnuCash development team announces GnuCash 5.6, the seventh release in 
> the stable 5.x series.
> Between 5.5 and 5.6, the following bugfixes were accomplished:
> 


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

[Kalpesh Patel]

Not sure if anyone answered it or not but really it is a moving target in terms 
you have to match up which source provides which quotes. Internet is always 
moving and these data sourcer/aggregator always update along with it as they 
add/modify/remove what they offer... no one offers entire universe out there 
for free although yahoo json has been a good source.

You can also custom write your own way of pulling them which some of us have 
done. If not you can always import prices using csv importation method. Take a 
look at https://github.com/ka-patel/dl_quotes which might be a starting point 
(fyi: this is not sanctioned by F::Q or GNC; strictly my own personal project 
in spare time)

-Original Message-
From: David G. Pickett  
Sent: Thursday, March 28, 2024 10:59 PM
To: Gnucash Users 
Subject: Re: [GNC] Finance Quotes Yahoo off the rails again?

 So anyone care to recommend a source setting for quotes that works?

___
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] Imported Transactions Show as Cleared

[Kalpesh Patel]

Which format are you exporting as?

Not sure which column you are seeing but this is the order I see when I import 
using CSV importer:

Date
Amount
Description
Memo
A
U+C
C
Info
Additional Comments

Out of those, if there is a tick mark in "A" column then the transaction will 
be added as a new; a check mark in "U+C" means update and clear the 
transaction; a check mark in "C" means clear the transaction; and no check mark 
in these three column means ignore the transaction and do nothing with it. If 
there is check mark in front of "U+C" or "C" and then if you double click that 
transaction then another window will pop up that will show you any additional 
transactions that may match out of which you can select which is the actual 
match for that specific transaction. 

-Original Message-
From: Tom Balazs  
Sent: Monday, April 01, 2024 3:30 PM
To: Post to GnuCash User 
Subject: [GNC] Imported Transactions Show as Cleared

I'm using Android Financisto+. I export transactions out of that. Then I import 
those into GnuCash. But why does GnuCash mark them as Cleared? In the Import 
Preview window I see a column Financisto+ created called Status and the 
transactions get "2" in that field. Is that the "Reconciled / Cleared" column? 
What number should I put there?


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

[Kalpesh Patel]

Looking at "ERROR 429: Too Many Requests." I am guessing that they are 
throttling your queries because number of requests from IP address you have 
exceeds what they believe to be a normal person browsing would be making... 

-Original Message-
From: David G. Pickett  
Sent: Wednesday, March 27, 2024 3:12 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Finance Quotes Yahoo off the rails again?

URLs are scraped off, so here I am on a plain text email client with more info 
on the bug.  It looks like something on the web does not like some clients:

 From quote log:

* AMEX:DXJ Finance::Quote reported failure with error: Error retrieving quote 
for DXJ. Attempt to fetch the URL 
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
resulted in HTTP response 500 (Internal Server Error)

Trying with wget:

dgp@dgp-p6803w:~
$ wget
'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics'
 
| timex wc
--2024-03-26 14:18:10--
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)... 
69.147.82.60, 69.147.82.61
Connecting to query2.finance.yahoo.com
(query2.finance.yahoo.com)|69.147.82.60|:443... connected.
HTTP request sent, awaiting response... 429 Too Many Requests
2024-03-26 14:18:25 ERROR 429: Too Many Requests.

   0   0   0
real 15.11
user 0.00
sys 0.00
dgp@dgp-p6803w:~
$ wget
'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics'
 
| timex wc
--2024-03-26 14:19:34--
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics
Resolving query2.finance.yahoo.com (query2.finance.yahoo.com)... 
69.147.82.60, 69.147.82.61
Connecting to query2.finance.yahoo.com
(query2.finance.yahoo.com)|69.147.82.60|:443... connected.
HTTP request sent, awaiting response... 429 Too Many Requests
2024-03-26 14:19:50 ERROR 429: Too Many Requests.

   0   0   0
real 15.17
user 0.00
sys 0.00
dgp@dgp-p6803w:~
$

With Google Chrome, get:

https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=DXJ=price,summaryDetail,defaultKeyStatistics

{"quoteSummary":{"result":[{"summaryDetail":{"maxAge":1,"priceHint":{"raw":2,"fmt":"2","longFmt":"2"},"previousClose":{"raw":107.84,"fmt":"107.84"},"open":{"raw":108.56,"fmt":"108.56"},"dayLow":{"raw":108.38,"fmt":"108.38"},"dayHigh":{"raw":108.88,"fmt":"108.88"},"regularMarketPreviousClose":{"raw":107.84,"fmt":"107.84"},"regularMarketOpen":{"raw":108.56,"fmt":"108.56"},"regularMarketDayLow":{"raw":108.38,"fmt":"108.38"},"regularMarketDayHigh":{"raw":108.88,"fmt":"108.88"},"dividendRate":{},"dividendYield":{},"exDividendDate":{},"payoutRatio":{},"fiveYearAvgDividendYield":{},"beta":{},"trailingPE":{"raw":12.077986,"fmt":"12.08"},"forwardPE":{},"volume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"regularMarketVolume":{"raw":515869,"fmt":"515.87k","longFmt":"515,869"},"averageVolume":{"raw":1097601,"fmt":"1.1M","longFmt":"1,097,601"},"averageVolume10days":{"raw":120,"fmt":"1.28M","longFmt":"1,277,770"},"averageDailyVolume10Day":{"raw":120,"fmt":"1.28M","longFmt":"1,277,
 
770"},"bid":{"raw":108.82,"fmt":"108.82"},"ask":{"raw":108.83,"fmt":"108.83"},"bidSize":{"raw":1200,"fmt":"1.2k","longFmt":"1,200"},"askSize":{"raw":900,"fmt":"900","longFmt":"900"},"marketCap":{},"yield":{"raw":0.0293,"fmt":"2.93%"},"ytdReturn":{},"totalAssets":{"raw":4416737792,"fmt":"4.42B","longFmt":"4,416,737,792"},"expireDate":{},"strikePrice":{},"openInterest":{},"fiftyTwoWeekLow":{"raw":68.18,"fmt":"68.18"},"fiftyTwoWeekHigh":{"raw":109.28,"fmt":"109.28"},"priceToSalesTrailing12Months":{},"fiftyDayAverage":{"raw":100.636,"fmt":"100.64"},"twoHundredDayAverage":{"raw":90.06975,"fmt":"90.07"},"trailingAnnualDividendRate":{"raw":0.0,"fmt":"0.00"},"trailingAnnualDividendYield":{"raw":0.0,"fmt":"0.00%"},"navPrice":{"raw":107.95631,"fmt":"107.96"},"currency":"USD","fromCurrency":null,"lastMarket":null,"volume24Hr":{},"volumeAllCurrencies":{},"circulatingSupply":{},"algorithm":null,"maxSupply":{},"startDate":{},"tradeable":false},"defaultKeyStatistics":{"maxAge":1,"priceHint":{"raw"
 
:2,"fmt":"2","longFmt":"2"},"enterpriseValue":{},"forwardPE":{},"profitMargins":{},"morningStarOverallRating":{},"morningStarRiskRating":{},"category":"Japan
Stock","bookValue":{},"priceToBook":{},"annualReportExpenseRatio":{},"ytdReturn":{"raw":0.22916919,"fmt":"22.92%"},"beta3Year":{"raw":0.43,"fmt":"0.43"},"totalAssets":{"raw":4416737792,"fmt":"4.42B","longFmt":"4,416,737,792"},"yield":{"raw":0.0293,"fmt":"2.93%"},"fundFamily":"WisdomTree","fundInceptionDate":{"raw":1150416000,"fmt":"2006-06-16"},"legalType":"Exchange
Traded

Re: [GNC] gnucash suggestions

[Kalpesh Patel]

 by Michelangelo

   iv.  
Security/currency: Michelangelo (Michelangelo di Lodovico Buonarroti Simoni)

 v.  Smallest 
fraction: Use Commodity Value

   vi.  Account 
Color: 

  vii.  Notes: 


viii.  Account 
Type: Stock

ix.  Parent 
Account: Asset-Famous Paintings.

 x.  Click OK 
and done

 

Now when you buy a painting  say for a million dollar, you would enter a 
transaction as follows:

 

-  Withdraw one million from account named “Asset-Checking Account”

-  Withdraw one share from account named “Trading-ARTIST- Michelangelo 
di Lodovico Buonarroti Simoni”

-  Deposit one share into account named “Assets-Famous Paintings-The 
Creation of Adam”

-  Deposit one million dollar into account named “Trading-CURRENCY-USD”

 

There is however a drawback to this – it only works for a single painting by a 
single artist, which is fine for my use case. If there are multiple painting to 
be held by a single artist then step 1) of defining artist as an security would 
have to be unique by being a bit creative with so it is unique. I do so by 
defining full name as “The Creation of Adam by Michelangelo” (painting x by 
artist y format) and adjusting rest of the attributes accordingly. As the 
painting appreciates, it can be tracked in price database.

 

I am sure there is better way to do so, so comments and/or suggestion are 
welcome…

 

 

From: David Warren  
Sent: Tuesday, March 19, 2024 4:58 PM
To: Kalpesh Patel 
Cc: R Losey ; Tommy Trussell ; J. 
A. Harris ; gnucash-user@gnucash.org
Subject: Re: [GNC] gnucash suggestions

 

Thanks Kalpesh.

The art bucket makes sense to me.

I understand having individual paintings be individual assets (like individual 
stocks)

But I don't quite know what you mean when you suggest setting up artists as 
"securities".  Would you mind explaining further?  (If I have a brokerage 
account with individual stocks or bonds, I also think of each of those stocks 
or bonds as "securities".  Hence my confusion with this 'higher level' proposed 
"security" for an artist.)

 

Thanks

 

On Tue, Mar 19, 2024 at 11:24 AM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

Just in case this is lost or not known, a new namespace can be created by 
simply specifying text in the namespace field when defining a "new" commodity 
or security. Existing commodity or security can be shuffled or put under a new 
namespace by editing the security and simply typing in new string in the 
namespace field. Only one that cannot be changed or added into is the 
"Currencies" namespace and what it contains. "FUNDS" (for mutual funds?) and 
"NYSE" (for securities/stocks?) are, I believe, carried forward as historical 
but when creating a new file, "FUNDS" and "NYSE" are not created, at least not 
on the Window version of 4.18 GNC that I am testing on.

I actually use this capability and have created namespace for exchanges to 
place security into where it is traded (according to Yahoo since I screen 
scrape for EOD updates via Python script), as well as tracking investments in 
paintings by artists where artist is a "security" and each painting is an 
"asset" under a "brokerage" account. It works well.

As for tracking things like miles earned, etc., I believe there is always 
in-direct way of finding conversion ratio, albeit it may change every time you 
use it but it is there. More so as different airlines have different conversion 
rates so this only make sense to set it up that way. Just an idea with one time 
setup (*PLEA - Accounting SMEs please weight in if this doesn't look right*): 
create a new name space called "Airline Mileage", create each airline mileage 
program as a commodity under it, and then create an parent asset account called 
"Earned Mileage" and then you can track mileage that is earned from each 
program. All those "bonus" miles that are earned are one way or another 
convertible to official "Currency".


-Original Message-
From: R Losey mailto:rlo...@gmail.com> > 
Sent: Monday, March 18, 2024 6:51 PM
To: Tommy Trussell mailto:tommy.truss...@gmail.com> >
Cc: J. A. Harris mailto:prod...@harrisja.us> >; 
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] gnucash suggestions

On Mon, Mar 18, 2024 at 5:43 PM Tommy Trussell mailto:tommy.truss...@gmail.com> >
wrote:

> On Sun, Mar 17, 2024 at 4:3

Re: [GNC] gnucash suggestions

[Kalpesh Patel]

Just in case this is lost or not known, a new namespace can be created by 
simply specifying text in the namespace field when defining a "new" commodity 
or security. Existing commodity or security can be shuffled or put under a new 
namespace by editing the security and simply typing in new string in the 
namespace field. Only one that cannot be changed or added into is the 
"Currencies" namespace and what it contains. "FUNDS" (for mutual funds?) and 
"NYSE" (for securities/stocks?) are, I believe, carried forward as historical 
but when creating a new file, "FUNDS" and "NYSE" are not created, at least not 
on the Window version of 4.18 GNC that I am testing on.

I actually use this capability and have created namespace for exchanges to 
place security into where it is traded (according to Yahoo since I screen 
scrape for EOD updates via Python script), as well as tracking investments in 
paintings by artists where artist is a "security" and each painting is an 
"asset" under a "brokerage" account. It works well.

As for tracking things like miles earned, etc., I believe there is always 
in-direct way of finding conversion ratio, albeit it may change every time you 
use it but it is there. More so as different airlines have different conversion 
rates so this only make sense to set it up that way. Just an idea with one time 
setup (*PLEA - Accounting SMEs please weight in if this doesn't look right*): 
create a new name space called "Airline Mileage", create each airline mileage 
program as a commodity under it, and then create an parent asset account called 
"Earned Mileage" and then you can track mileage that is earned from each 
program. All those "bonus" miles that are earned are one way or another 
convertible to official "Currency".


-Original Message-
From: R Losey  
Sent: Monday, March 18, 2024 6:51 PM
To: Tommy Trussell 
Cc: J. A. Harris ; gnucash-user@gnucash.org
Subject: Re: [GNC] gnucash suggestions

On Mon, Mar 18, 2024 at 5:43 PM Tommy Trussell 
wrote:

> On Sun, Mar 17, 2024 at 4:37 PM J. A. Harris  wrote:
>
> > On 3/17/24 15:54, Michael or Penny Novack wrote:
> > > Those are "commodities"
> >
> > I am aware of that.  Currencies, Funds, and NYSEs are all particular
> > types of Commodities. There is no current support in gnucash for
> > defining Commodities other than those three types.
> >
>
> I wanted to keep track of mileage for corporate reimbursement purposes, so
> I created a "FUND" with the symbol "Miles" abbreviated "M," and I created a
> Liability account called Mileage, whose currency is Miles, with a contra
> liability account called "Driving Owed," whose currency is Dollars. Every
> time I enter "Miles" in the register, I make sure its exchange value in
> Driving Owed dollars matches the current IRS reimbursement rate (which can
> sometimes change multiple times during the year).
>
> When the company does a reimbursement for Driving Owed, a bank transaction
> happens so the contra account to Driving Owed is the corporate bank
> account.
>
> Maybe this is a perversion of the system somehow, but it seems to work for
> me.
>
> It seems if you wanted to keep track of Credit Card Points or Airline Miles
> or whatever, you could create a similar "currency" or "fund" that matches
> your specification. But I presume there is some reason it doesn't work for
> you in the same way mileage does in my example.
>
>
You're not alone; I do something similar; for tracking the bonus points for
retailer "Fred", I created a "stock"  with the Symbol FBP (Fred Bonus
Points) and use it to track points in and out of the bonus account.

-- 
_
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.

Re: [GNC] Help

[Kalpesh Patel]

No one other than your self can remove you from the list.

Visit https://lists.gnucash.org/mailman/options/gnucash-user and follow 
instructions on that page. If the password is unknown, it can be reset there as 
well.

-Original Message-
From: Anon20x  
Sent: Sunday, March 17, 2024 7:11 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Help

Please unsub me from the list, thankyou.




On Monday, March 18th, 2024 at 8:47 AM, gnucash-user-requ...@gnucash.org 
 wrote:

> 
> 
> Send gnucash-user mailing list submissions to gnucash-user@gnucash.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit 
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to 
> gnucash-user-requ...@gnucash.org
> 
> You can reach the person managing the list at 
> gnucash-user-ow...@gnucash.org
> 
> When replying, please edit your Subject line so it is more specific 
> than "Re: Contents of gnucash-user digest..."
> 
> 
> Today's Topics:
> 
> 1. gnucash suggestions (J. A. Harris)
> 2. Re: UNSUBCRIBE and Lemmy.World (Kalpesh Patel) 3. Re: gnucash 
> suggestions (Michael or Penny Novack) 4. Re: UNSUBCRIBE and 
> Lemmy.World (Michael or Penny Novack) 5. Re: gnucash suggestions (J. 
> A. Harris) 6. Re: gnucash suggestions (Stan Brown (using GC 4.14)) 7. 
> Re: Separating tax years for payments in next year (NoobAlice) 8. Re: 
> gnucash-user Digest, Vol 252, Issue 33 (Anon20x)
> 
> 
> --
> 
> Message: 1
> Date: Sun, 17 Mar 2024 12:15:28 -0400
> From: "J. A. Harris" prod...@harrisja.us
> 
> To: gnucash-user@gnucash.org
> Subject: [GNC] gnucash suggestions
> Message-ID: a1a89c31-e2f6-4c09-8433-55658ab15...@harrisja.us
> 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> I have been using gnucash for almost 10 years now.? I have downloaded 
> the source code and even made some changes to it that I consider 
> improvement.? There are other changes that I think would be a good 
> idea.? If this is not the place to share such comments, I apologize.
> 
> 1. I use gnucash on a computer with a large screen,? I have a source 
> code modification that adds including the Assoc and Notes fields to 
> the single-line Basic Ledger view.? For me, those fields are too 
> important to require going double-line (which cuts in half the entries 
> in the window) and there is plenty of room on a desktop monitor to 
> accommodate the extra width needed. I think this would be a nice 
> option for many users.
> 2. Add a new Generic and INC+EXP account.? No doubt this violates 
> basic accounting rules but for an amateur like me, it is useful to 
> have a single book in which I can separate sections like reserves, 
> retirement, and operating items.? Accounts of type Generic could have 
> sub-accounts of any type.? Accounts of type INC+EXP would act as an 
> Income account and as Expense account. For example, if there were a 
> mixture of Income and Expense accounts under a INC+EXP account, a 
> search in the tax system for Income accounts would find them and a 
> search for Expense accounts would find them.? As it stands now, that 
> top level account must be either Income or Expense and Income accounts 
> are not found if the top-level account is Expense and vice-versa. 
> (With an INC+EXP type, it would also permit restricting subaccounts 
> under Income to be just Income and under Expense just Expense.) 3. 
> Sorting occurs in many different places: in register displays, in 
> reports, in the listing of accounts in the transfer field, etc.? If 
> the natural sort organization for my accounts is by account code, I 
> find it confusing inconvenient when that is not the default sorting 
> used in reports, budgets, transfer menu, etc.
> 4. Give the users the ability to create new "currencies".? There are a 
> number of occasions where I have assets which have a dollar value but 
> the accounting of that asset uses a different measure.? Some examples 
> include airline loyalty points, miles driven that have a tax deduction 
> value, etc. ? Doing this through FUND or NYSE does not work because 
> those things cannot be used in account types where Currencies can be 
> used.
> 
> 
> --
> 
> Dr. J. A. Harris
> 
> 
> --
> 
> Message: 2
> Date: Sun, 17 Mar 2024 12:39:32 -0400
> From: "Kalpesh Patel" kalpesh.pa...@usa.net
> 
> To: gnucash-user@gnucash.org
> 
> Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World
> Message-ID: 000e01da7889$b0f5c380$12e14a80$@usa.net
> 
> Content-Type: text/plain; charset="utf-8"
> 
> If the e-m

Re: [GNC] UNSUBCRIBE and Lemmy.World

[Kalpesh Patel]

If the e-mail client is configured via IMAP access to email server, then 
whatever email is deleted on your client is also removed from your server so 
you don't need to clean up multiple times... IMAP keeps "one" view for all of 
the email clients that access those emails.

My outlook client is configured to move messages to 'Deleted Item' and then it 
is further configured to delete them permanently after 30 days. One rule has 
multiple email addresses of all the sources which should go to 'Deleted Items' 
automatically.

Go to explore the capabilities of the tools to employ for various tasks... 


-Original Message-
From: Michael or Penny Novack  
Sent: Saturday, March 16, 2024 7:41 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World

On 3/16/2024 5:40 PM, Ken Farley wrote:
> Unsubscribing isn't done by the list, it's just posts of questions 
> like yours.
>
> To unsubscribe, you need to go to:
>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> To be honest, I don't allow the deluge of emails to come to me, 
> either. Too many to have to sift through every day.

<< not about gnucash -- but about this specific issue >>

If you are an EMAIL user (not WEBMAIL) then your email client (Outlook, 
Thunderbird, etc.) almost certainly provides a facility for you to create 
"message filter rules". You can then add a rule so that emails coming from a 
particular source (say this email list) get moved to a dedicated folder instead 
of appearing in your inbox). The only emails that show up in the inbox here are 
ones for which I haven't written a rule.

Then you either sift through them in this other folder or not depending on 
whether you have time. Nor do they have to take up space in that folder forever 
as you can specify retention policy for that folder.

Webmail users --- I have no idea if whatever provider you are using offers 
similar facilities.

Michael D Novack




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

Re: [GNC] Error Retrieving Gold Price for Price Database

[Kalpesh Patel]

Appreciate that explanation. 

It is indeed considered as currency in that ISO 4217 which is
internationally maintained.

I guess there needs to be a deviation between ISO's symbols and how
Exchanges maintains symbols for quotes, and rightfully so.

Follow on questions then, and which I think I answered it already but in
case it isn't correct, how should one track its daily Exchange rate since
Currencies namespace is not mutable?


-Original Message-
From: john  
Sent: Saturday, March 09, 2024 10:35 AM
To: Kalpesh Patel 
Cc: Adrien Monteleone ; Damon Hudac
; gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Error Retrieving Gold Price for Price Database

XAU is a currency because ISO 4217 says it is, along with XBA (silver), XPT
(platinum), and XPD (Palladium). They're supposed to represent a troy ounce
of the respective metal. Keep in mind that ISO-4217 is a banking industry
specification and doesn't necessarily apply to anything you as an individual
investor might be doing, nor does the fact that GnuCash recognizes the
symbol mean that Alphavantage or any other quote aggregator will necessarily
use it for reporting.

Regards,
John Ralls


> On Mar 9, 2024, at 15:42, Kalpesh Patel  wrote:
> 
> Most likely the case ... I am not sure how XAU was determined to be a
currency when in fact it is an Index. I suspect it is historical carried
forward ...
> 
> Anyways, '^XAU' and 'GC=F' (or 'SI=F') will need to be added manually as
attributes in the Currency namespace are not modifiable (at least I couldn't
do so on Windows platform one) in the Security Editor.
> 
> 
> 
> -Original Message-
> From: Adrien Monteleone 
> Sent: Friday, March 08, 2024 12:53 PM
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Error Retrieving Gold Price for Price Database
> 
> But XAU no longer works with Alphavantage at least. GC=F (SI=F for
> silver) works fine.
> 
> Regards,
> Adrien
> 
> On 3/7/24 10:50 AM, Kalpesh Patel wrote:
>> Oh!
>> 
>> XAU symbol is indeed named Gold in Currencies name space which seems 
>>  ...
> 
> 
> 
> ___
> 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] Error Retrieving Gold Price for Price Database

[Kalpesh Patel]

Most likely the case ... I am not sure how XAU was determined to be a currency 
when in fact it is an Index. I suspect it is historical carried forward ...

Anyways, '^XAU' and 'GC=F' (or 'SI=F') will need to be added manually as 
attributes in the Currency namespace are not modifiable (at least I couldn't do 
so on Windows platform one) in the Security Editor.



-Original Message-
From: Adrien Monteleone  
Sent: Friday, March 08, 2024 12:53 PM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Error Retrieving Gold Price for Price Database

But XAU no longer works with Alphavantage at least. GC=F (SI=F for
silver) works fine.

Regards,
Adrien

On 3/7/24 10:50 AM, Kalpesh Patel wrote:
> Oh!
> 
> XAU symbol is indeed named Gold in Currencies name space which seems 
>  ...



___
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] Bill total does not match real total

[Kalpesh Patel]

I remember EBCDIC being used heavily during mid '80's on Fortran punch cards...

-Original Message-
From: Fred Tydeman  
Sent: Thursday, March 07, 2024 10:08 AM
To: stepbystepf...@comcast.net
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Bill total does not match real total

Actually, DFP (decimal floating point) has been part of gcc since 2005.
DFP is now part of standard C (C23).  DFP was first proposed for C in 2003
N1016  01-Sep-2003 
Mak, Extension for the programming language C to support decimal floating-point 
arithmetic

Intel 8080 and x86 CPUs both have a limited instruction set for BCD (binary 
coded decimal).

The first computer I ever used (in 1967), the IBM 1620, used BCD floating-point.


___
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] Error Retrieving Gold Price for Price Database

[Kalpesh Patel]

Oh! 

XAU symbol is indeed named Gold in Currencies name space which seems
 ...

-Original Message-
From: Kalpesh Patel  
Sent: Thursday, March 07, 2024 11:44 AM
To: 'Damon Hudac' 
Cc: 'gnucash-user@gnucash.org' 
Subject: RE: [GNC] Error Retrieving Gold Price for Price Database

I don't believe GNC by default contains Gold in the currency namespace. It
is likely added.

For Yahoo purposes thus yahoo_json, XAU or Philadelphia Gold and Silver
Index is an index at Nasdaq so query would require caret ('^') prefix so the
symbol is '^XAU' (without quotes).

For Gold spot prices, the 'GC=F' symbol pulls from yahoo_json...


-Original Message-
From: Damon Hudac  
Sent: Wednesday, March 06, 2024 5:36 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Error Retrieving Gold Price for Price Database

I installed GnuCash from flathub. I'm running GnuCash v5.5. 
Finance::Quote is v1.58.

In the security editor, in the "currencies" namespace, gold is listed under
symbol XAU.

I have the box checked for "Get Online Quotes."
"Type of quote source" is Single --> Currency

Whenever I click "Get Quotes" in the price database, the price for gold
fails with this error:

"Quotes for the following commodities were unavailable or unusable:
* CURRENCY:XAU Finance::Quote reported failure set no error."

I have quotes for Canadian dollars set up identically and those work fine
when I update the quotes. Does anyone know how to configure this to retrieve
gold prices?

If it helps, I do have an Alphavantage API key and use that all the time to
update stock prices.

Thank you!


___
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] Error Retrieving Gold Price for Price Database

[Kalpesh Patel]

I don't believe GNC by default contains Gold in the currency namespace. It
is likely added.

For Yahoo purposes thus yahoo_json, XAU or Philadelphia Gold and Silver
Index is an index at Nasdaq so query would require caret ('^') prefix so the
symbol is '^XAU' (without quotes).

For Gold spot prices, the 'GC=F' symbol pulls from yahoo_json...


-Original Message-
From: Damon Hudac  
Sent: Wednesday, March 06, 2024 5:36 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Error Retrieving Gold Price for Price Database

I installed GnuCash from flathub. I'm running GnuCash v5.5. 
Finance::Quote is v1.58.

In the security editor, in the "currencies" namespace, gold is listed under
symbol XAU.

I have the box checked for "Get Online Quotes."
"Type of quote source" is Single --> Currency

Whenever I click "Get Quotes" in the price database, the price for gold
fails with this error:

"Quotes for the following commodities were unavailable or unusable:
* CURRENCY:XAU Finance::Quote reported failure set no error."

I have quotes for Canadian dollars set up identically and those work fine
when I update the quotes. Does anyone know how to configure this to retrieve
gold prices?

If it helps, I do have an Alphavantage API key and use that all the time to
update stock prices.

Thank you!


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

[Kalpesh Patel]

Is your F::Q up to date? Last version released is 1.59. Version can be 
displayed by navigating to 'Help' --> 'About' window. It should say 
"Finance::Quote x.xx" somewhere in the middle of the window. What ever number 
is x.xx is the version of the installed F::Q.

It also could be that it is a transient error due to Yahoo taking a maintenance 
window if it is the version that is latest and greatest. If not then time to 
update it, to keep up with Yahoo constantly moving the goal post.


-Original Message-
From: Ruaraidh Sackville Hamilton  
Sent: Wednesday, March 06, 2024 3:33 AM
To: Gnucash Users 
Subject: Re: [GNC] Yahoo json unauthorized

(Correction. It seems to work for most but not all funds; and has failed for 
all LSE securities)

On Wed, 6 Mar 2024 at 08:25, Ruaraidh Sackville Hamilton < 
ruaraidh...@gmail.com> wrote:

> I recently had to change to "Yahoo as JSON" quotes when Alphavantage 
> changed their access rules, and for a while it worked no problem. 
> Today it doesn't. For each security I get an error message of the form 
> " ... Attempt to fetch the URL 
> https://query1.finance.yahoo.com/v7/finance/quote?symbols=[...] 
> resulted in HTTP response 401 (Unauthorized)".
>
> Can anyone suggest a solution?
>
> Ruaraidh
>


___
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 get a report in a format which is easy to edit?

[Kalpesh Patel]

If are you going from HTML to PDF then that sounds like the method employed
by that converter and not GNC itself.

Once you run the report, if you look at the top of the report window, there
is 'Make PDF' button/icon (at least I see it on Windows version of it).
Pressing that should save it as a true PDF formatted file.

On Windows platform, I just ran a report, saved it as PDF using afore-said
method and was able to edit individual "cells" in ABBYY FineReader PDF app.

Since GNC is cross-platform, I don't think that behavior is likely to be
different between Windows, Linux or Mac. Platform might customize how the
dialogues are displayed at each step but the underlying facility is like to
function in same manner.

-Original Message-
From: Chris Green  
Sent: Wednesday, March 06, 2024 2:56 AM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] How to get a report in a format which is easy to edit?

On Wed, Mar 06, 2024 at 10:09:03AM +1100, Alan Hopkins wrote:
> 
> Additionally, there are pdf editors out there that do a good job (some 
> are
> cross-platform) - my pdf's produced from GnuCash are all editable (I 
> use
> Linux) - not graphic images - maybe look for another driver/app to 
> achieve what you need?

This is what I'm after.  I'm all Linux based but so far whatever route I
take to get from GnuCash's HTML to PDF I end up with a PDF file with images
rather than text in it.

What do you use to convert to PDF?

--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] reports

[Kalpesh Patel]

There are also non-report way to export transactions  latter one after 
focusing a specific register ...

File --> Export --> Export Transaction to CSV

-- OR --

File --> Export --> Export Active Register to CSV

-Original Message-
From: Adrien Monteleone  
Sent: Friday, March 01, 2024 8:20 PM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] reports

The 'best' is up to you to figure out based on your needs and what you want to 
see or do with the spreadsheet.

Three possibilities immediately come to mind:

1. Budget Report — Even without using GnuCash to budget, it can still show 
consolidated Actuals by period, quarter, year, etc.

2. Account Report - Run this while viewing a checking register. You'll have to 
do this for each account separately.

3. Transaction Report - Can get you everything from multiple accounts and can 
sort and subtotal in various ways. Date ranges are highly customizable.

---

Are you *certain* you want to export transactions based on their link to a 
checking account? Checking accounts are just sources of funds, not why you are 
spending the money.

For budgeting purposes, you more likely want the transactions that touch your 
Expense accounts.

Regards,
Adrien

On 3/1/24 3:44 PM, Dennis Powless wrote:
> I'm using excel to budget.  I'm looking for the best report to export 
> data to excel that will show all transactions from my checking 
> accounts.  Which report is the best for this?  I'm using windows and 
> the latest version of gnucash for windows.



___
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] Saving to MySQL 8.0.36

[Kalpesh Patel]

Wild guess but could it be your MAC's and/or Windows host firewall settings?

Sinwows? Wow, you really hate Windoz$ that much but yet run MySQL on it
which was born on Linux...

-Original Message-
From: Ira Fuchs  
Sent: Wednesday, February 28, 2024 9:01 PM
To: Gnucash 
Subject: [GNC] Saving to MySQL 8.0.36

I am trying to save my Gbucash data to MySQl v8.0.36 on a newly installed
MySQL instance on WIndwos 10. Gnucash is running on a Mac and I also have a
MySQL instance on that machine running v .8.0.22. I have no problem saving
the gnucash data to the local MySQL instance but when I try to save it to
the WIndows instance, I get a non-specific error. My MySQL client can login
from the Mac to the Sinwows instance without problem so I know that I have
both connectivity and the correct userid/passwd. 
Can anyone please help me to diagnose why gnucash will not save to the
Windows instance. I also tried creating a user entry for the same userid but
specifying the Mac ip and Standard authentication. This also failed to work.
What am I missing?

___
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] Opening a particular register

[Kalpesh Patel]

Hi GNC user community -

 

Is there a way to open a specific account register when GNC is launched?

 

I have created a top level account that are "Notes and other reminders"
which I would love to see it open up when launched. They are mostly "no
value" transactions. While it is unusual use of it, it works for its
intended purposes, hence the query. The Scheduled Transaction is probably an
overkill for this purpose, besides being requiring multiple steps get it to
schedule it up and most of the transactions are a one time event that takes
place in the future so dropping it in the register is great holding place,
and it doesn't clutter real registers.

___
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] Trouble importing bills via csv

[Kalpesh Patel]

Some financial orgs include commas as thousands, hundreds thousands, etc., 
separator in CSV to beautify the display. They treat it as a free format string 
value...

A single opening and a single closing double quotes, I believe, are ignored by 
the importer ... correct me if I am wrong.

-Original Message-
From: David H  
Sent: Saturday, February 24, 2024 7:02 PM
To: Alan Johnson 
Cc: Adrien Monteleone ; 
gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Trouble importing bills via csv

Alan,

Your file imports fine here after I add the vendor, create the Accounts Payable 
liability, remove the header line and remove the double quotes that you have 
plastered around every field for some reason which probably causes the other 
errors.

It might pay to read up on Gnucash Bills Importing at 
https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and 
the examples therein :-

You'll note a complete absence of double quotes in the following example and no 
header line.

Hope this helps,

Cheers David H.


Note on double quotes

If you use the field separator character within a field, the field value should 
be enclosed in double quotes. Only for the fields description (desc) and notes, 
can you also include a double quote within a quoted field value, by doubling 
the double quote. E.g. "This field value uses the separator, and a ""quoted"" 
word", would be imported as This field value uses the separator, and a "quoted" 
word.

Example content for two bills; one of 2 entries, and one of 3 entries. The 
first is saved and posted, the second only saved. Using comma field separator, 
decimal point and dd/mm/ date format.

1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and 
Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts
Payable;;X
1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic 
principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts
Payable;;X
1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate 
Guide;pc;Expenses:Books;1;10.01;;;
1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & 
drinks;pc;Expenses:Dining;1;10.01;;;
1205;15/12/2018;2044;PO 21099;;16/12/2018;UG 
course;pc;Expenses:Education;1;10.01;;;



On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user < 
gnucash-user@gnucash.org> wrote:

> I tried that with the same result. GNC says it ignored that line, and 
> that's fine.
>
> I'm concerned with the error messages indicating that the vendor and 
> accounts don't exist. Have I input that data incorrectly?
>
> Feb 24, 2024 13:00:20 Adrien Monteleone :
>
> > Although you should be able to have header row(s), perhaps remove it 
> > and
> try again.
> >
> > The Documentation for this is worded oddly, but the samples provided
> don't show header info at all.
> >
> >
> https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoi
> ces.html
> >
> > Regards,
> > Adrien
> >
> > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote:
> >> Hello,
> >> I'm having some issues importing a bill via CSV. I set up a trial 
> >> run and I'm getting the below errors.  Vendor "05" does not 
> >> exist, however that is the vendor ID for Amazon in my file.  It 
> >> says account "Liabilities:Accounts Payable" does not exist (but it 
> >> does). It says the Expense account also does not exist (but it 
> >> does) and then it proceeds to ignore the line.
> >> How do I correct this for proper import? I've had the same issue on 
> >> the Customer invoice import side as well.
> >> This is on Ubuntu with Flatpak 5.5
> >> Here is the raw CSV import:
> >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"ac
> >> tion 
> >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"t
> >> axab 
> >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted"
> >> ;"memo_posted";"accu_splits"
> >> "111-7425790-5888250";05/11/23;"05";;;05/11/23;"Low Profile 
> >> Fuse
> >> Kit";;"Expenses:Auto:2016 Big
> >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabil
> >> itie
> >> s:Accounts Payable";;"N"
> >
> > ___
> > 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 

Re: [GNC] Problem install Finance::Quote

[Kalpesh Patel]

Slight correction ...

Instead of:
- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.

It should be:
- Run 'sudo find / -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.


-- Replace dot after the find string with a forward slash.


-Original Message-
From: Kalpesh Patel  
Sent: Monday, February 19, 2024 1:11 PM
To: 'Gustavo Taouil' 
Cc: 'gnucash-user@gnucash.org' 
Subject: RE: [GNC] Problem install Finance::Quote

I am on Windows platform but most likely one of two issues likely on the
Perl front as it seems to be universal across platform:

Since you forced installed LWP::Protocol::https module, it skipped install
of one or more under lying dependent modules so it is broken at its heart
even though physically it is present. IMHO, if Perl is configured correctly
then there is hardly need to force install modules other than in extremely
few rare cases. This also means your CPAN module for Perl is not likely to
be configured correctly to retrieve dependent modules and install them as
necessary. 

-- OR --

Your GNC install is looking at Perl that is entirely located in a different
location and it isn't finding all the required modules there.

Former is likely to issue. Also may I ask how you came to conclusion that
installing OpenSSL via brew package manager will be sufficient on Mac to get
F::Q up and running? You may want to review documentation at
https://finance-quote.sourceforge.net/index.html to become familiar. 

While commands you listed might work, I like to use following (not sure how
they will behave on your system at this point though) after Perl CPAN module
is properly configured:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Test2'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Finance::Quote'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install JSON::Parse'

If things are broken in the process of install then fix them; don't skip
them!

As for Perl's CPAN module, normally if the CPAN's 'prerequisites_policy'
setting (configured with 'follow' option), 'build_requires_install_policy'
setting (with 'yes') and 'make' settings (with fully qualified path to a
make that is found by search or compatible one) are properly set then that
should have installed all pre-requisite dependencies automatically. These
are the sane defaults that gets configures with when CPAN module is
initialized. In case there is interest for the CPAN module configuration
settings, refer to https://metacpan.org/pod/CPAN#Config-Variables link.

Perl sadly does not have a way to uninstall a module on its own. The
unofficial way to do is to delete (safer to rename!?!?) the module's Perl
files and then attempt to install it again.

- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.
- Rename 'Finance' directory under .../lib/perl5/... subtree (with perhaps
.bak extension).
- Rerun the installer as mentioned above using modified commands.
 
With the current state of it, YMMV though.

-Original Message-
From: Gustavo Taouil  
Sent: Friday, February 16, 2024 5:34 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Problem install Finance::Quote

Hi Guys, I tried to install Finance::Quote in my new mac (M3) with Sonoma
macOs. I Use these lines of command to install:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Test2
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
Finance::Quote
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
JSON::Parse

Now, I was receiving theses kind of messages when I tried to update quotes:


* B3:IVVB11.SA Finance::Quote reported failure with error: 501 Protocol
scheme 'https' is not supported (LWP::Protocol::https not installed)


I already force the install of LWP::Protocol::https and I installed the
opensll with the command: brew install openssl, but it's not working.

My perl is installed in /usr/bin/perl and my version is 5.30.3

anyone can help me?






___
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 install Finance::Quote

[Kalpesh Patel]

The gentleman having issues is on newer silicon Mac but Perl's maintenance is 
universal across platforms.

Strawberry Perl is indeed installed when you run 'Install Online Price 
Retrieval for GnuCash' script on Windows...

-Original Message-
From: david amaral  
Sent: Monday, February 19, 2024 2:02 PM
To: Kalpesh Patel 
Cc: GnuCash List 
Subject: Re: [GNC] Problem install Finance::Quote

If you are onWindows platform, I sugguest you download  perl for windows.
https://strawberryperl.com/
It may resolve all your problems as it is compatible dow windows.
It is what I have and there are no issues with gnucash






On Monday, February 19, 2024 at 11:12:06 AM GMT-7, Kalpesh Patel 
 wrote: 





I am on Windows platform but most likely one of two issues likely on the Perl 
front as it seems to be universal across platform:

Since you forced installed LWP::Protocol::https module, it skipped install of 
one or more under lying dependent modules so it is broken at its heart even 
though physically it is present. IMHO, if Perl is configured correctly then 
there is hardly need to force install modules other than in extremely few rare 
cases. This also means your CPAN module for Perl is not likely to be configured 
correctly to retrieve dependent modules and install them as necessary. 

-- OR --

Your GNC install is looking at Perl that is entirely located in a different 
location and it isn't finding all the required modules there.

Former is likely to issue. Also may I ask how you came to conclusion that 
installing OpenSSL via brew package manager will be sufficient on Mac to get 
F::Q up and running? You may want to review documentation at 
https://finance-quote.sourceforge.net/index.html to become familiar. 

While commands you listed might work, I like to use following (not sure how 
they will behave on your system at this point though) after Perl CPAN module is 
properly configured:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e 
'install Test2'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e 
'install Finance::Quote'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e 
'install JSON::Parse'

If things are broken in the process of install then fix them; don't skip them!

As for Perl's CPAN module, normally if the CPAN's 'prerequisites_policy'
setting (configured with 'follow' option), 'build_requires_install_policy'
setting (with 'yes') and 'make' settings (with fully qualified path to a make 
that is found by search or compatible one) are properly set then that should 
have installed all pre-requisite dependencies automatically. These are the sane 
defaults that gets configures with when CPAN module is initialized. In case 
there is interest for the CPAN module configuration settings, refer to 
https://metacpan.org/pod/CPAN#Config-Variables link.

Perl sadly does not have a way to uninstall a module on its own. The unofficial 
way to do is to delete (safer to rename!?!?) the module's Perl files and then 
attempt to install it again.

- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the 
location where it is installed.
- Rename 'Finance' directory under .../lib/perl5/... subtree (with perhaps .bak 
extension).
- Rerun the installer as mentioned above using modified commands.

With the current state of it, YMMV though.

-Original Message-
From: Gustavo Taouil 
Sent: Friday, February 16, 2024 5:34 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Problem install Finance::Quote

Hi Guys, I tried to install Finance::Quote in my new mac (M3) with Sonoma 
macOs. I Use these lines of command to install:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Test2 sudo 
env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Finance::Quote 
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i JSON::Parse

Now, I was receiving theses kind of messages when I tried to update quotes:


* B3:IVVB11.SA Finance::Quote reported failure with error: 501 Protocol scheme 
'https' is not supported (LWP::Protocol::https not installed)


I already force the install of LWP::Protocol::https and I installed the opensll 
with the command: brew install openssl, but it's not working.

My perl is installed in /usr/bin/perl and my version is 5.30.3

anyone can help me?






___
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

Re: [GNC] Problem install Finance::Quote

[Kalpesh Patel]

I am on Windows platform but most likely one of two issues likely on the
Perl front as it seems to be universal across platform:

Since you forced installed LWP::Protocol::https module, it skipped install
of one or more under lying dependent modules so it is broken at its heart
even though physically it is present. IMHO, if Perl is configured correctly
then there is hardly need to force install modules other than in extremely
few rare cases. This also means your CPAN module for Perl is not likely to
be configured correctly to retrieve dependent modules and install them as
necessary. 

-- OR --

Your GNC install is looking at Perl that is entirely located in a different
location and it isn't finding all the required modules there.

Former is likely to issue. Also may I ask how you came to conclusion that
installing OpenSSL via brew package manager will be sufficient on Mac to get
F::Q up and running? You may want to review documentation at
https://finance-quote.sourceforge.net/index.html to become familiar. 

While commands you listed might work, I like to use following (not sure how
they will behave on your system at this point though) after Perl CPAN module
is properly configured:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Test2'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install Finance::Quote'
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' perl -MCPAN -e
'install JSON::Parse'

If things are broken in the process of install then fix them; don't skip
them!

As for Perl's CPAN module, normally if the CPAN's 'prerequisites_policy'
setting (configured with 'follow' option), 'build_requires_install_policy'
setting (with 'yes') and 'make' settings (with fully qualified path to a
make that is found by search or compatible one) are properly set then that
should have installed all pre-requisite dependencies automatically. These
are the sane defaults that gets configures with when CPAN module is
initialized. In case there is interest for the CPAN module configuration
settings, refer to https://metacpan.org/pod/CPAN#Config-Variables link.

Perl sadly does not have a way to uninstall a module on its own. The
unofficial way to do is to delete (safer to rename!?!?) the module's Perl
files and then attempt to install it again.

- Run 'sudo find . -name Quote | xargs ls -al | grep Finance' to find the
location where it is installed.
- Rename 'Finance' directory under .../lib/perl5/... subtree (with perhaps
.bak extension).
- Rerun the installer as mentioned above using modified commands.
 
With the current state of it, YMMV though.

-Original Message-
From: Gustavo Taouil  
Sent: Friday, February 16, 2024 5:34 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Problem install Finance::Quote

Hi Guys, I tried to install Finance::Quote in my new mac (M3) with Sonoma
macOs. I Use these lines of command to install:

sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i Test2
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
Finance::Quote
sudo env ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64'cpan -f -i
JSON::Parse

Now, I was receiving theses kind of messages when I tried to update quotes:


* B3:IVVB11.SA Finance::Quote reported failure with error: 501 Protocol
scheme 'https' is not supported (LWP::Protocol::https not installed)


I already force the install of LWP::Protocol::https and I installed the
opensll with the command: brew install openssl, but it's not working.

My perl is installed in /usr/bin/perl and my version is 5.30.3

anyone can help me?






___
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] Looking how to automatically download transactions from Capital One

[Kalpesh Patel]

Matatia -

First check https://www.ofxhome.com/index.php/home/directory to make sure that 
CapitalOne is still supporting OFX downloads. Ditto for PayPal...

If OFX download is still a live thing, then you can generate a client UID (see 
https://www.tenforums.com/tutorials/130522-generate-globally-unique-identifier-guid-windows.html
 for Windows platform or goto https://www.uuidgenerator.net/ to generate one 
online). Then you can add that UUID as 'Client ID" in AqBanking setup screen. 
With UUID, you will have to play with whether Capital One wants all alpha to be 
upper cases or it will tolerate lowered cases, and whether it wants dash 
separators or not  (experimenting is going to be your friend).

See more details in the document at 
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect for it.

If you "tech savvy" then you can also manually edit the corresponding AqBanking 
configuration file somewhere in 'C:\Users\\aqbanking' (cd 
%USERPROFILE%\aqbanking) tree for Windows if you are familiar with it. Looking 
at Chase's example at 
https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings shows that you 
can add 'clientuid = ' stanza to the config for Capital One once 
you find the corresponding AqBanking config file. 

This is I am going off my head

-Original Message-
From: Matatia Chetrit  
Sent: Friday, February 16, 2024 11:56 AM
To: gnucash-user@gnucash.org
Subject: [GNC] Looking how to automatically download transactions from Capital 
One

bs"d

Hello. I looked for ways to automatically download transactions from Capital 
One.
I tried the Online Banking Setup interface of Aq Banking  - OFX Didn't work 
with the credentials:

CapitalOne (Banking)https://ofx.capitalone.com/ofx/103/process.ofx
**OFX Version=103;APPID=MDNC;APPVER=2012. Must have CLIENTUID set.
1001Capital One Whatever your routing number is 


  "id" = "md:1052"
  "access_type" = "OFX"
  "ofx_version" = "103"
  "fi_name" = "Capital One Bank (Not Credit Cards)"
  "bootstrap_url" =
"https://onlinebanking.capitalone.com/ofx/process.ofx;
  "fi_id" = "1001"
  "uses_fi_tag" = "y"
  "app_id" = "MDNC"
  "fi_org" = "Hibernia"
  "app_ver" = "2012"
}
{
  "id" = "md:2019"
  "uses_fi_tag" = "y"
  "access_type" = "OFX"
  "fi_name" = "Capital One Bank (Not Credit Cards)"
  "bootstrap_url" = "https://ofx.capitalone.com/ofx/103/process.ofx;
  "fi_id" = "1001"
  "ofx_version" = "103"
  "app_id" = "MDNC"
  "fi_org" = "Capital One"
  "app_ver" = "2012"

tried OFX Direct Connect, EBICS, Offline Backend & HBCI. Nothing worked. Any 
Suggestions? 

I also have another paypal account - tried to log in paypal transactions - with 
paypal interface that didn't work either.

If you have info on that as well that would also be helpful.


Thanks in advance.
Matatia Chetrit
==



7 Noahide Torah Laws for All People
1 Being Faithful to G∙d - Don't Worship Idols - Object,Animal,Man
2 Respect of Integrity of Family - Prohibition of Immoral Relations- 
Adultery,Bestiality,Homosexuality& Incest
3 Respect of Human Life - Don't Murder
4 Respect of G∙d- Don't Blaspheme
5 Respect of Property-Don't Steal
6 Law & Order-Establish Courts of Law
7 Respect of Creatures-Don't Eat Limb taken from live animal
http://www.jerusalemlife.com/?p=1473 




___
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 UI problem...

[Kalpesh Patel]

I believe it should work for Linux as well as they all use the standard
framework underneath across all platforms. Experiment and let us know the
results so others on other platforms can benefit. Double clicking the header
or dragging the vertical bar between the column headers are your friends for
resizing those columns. 

-- Original Message --
Received: Sat, 10 Feb 2024 02:44:21 PM EST
From: Robert Heller 
To: "Kalpesh Patel" Cc: Tommy Trussell
,    Kalpesh Patel ,GNU
Cash User 
Subject: Re: [GNC] GNC UI problem...

> At Sat, 10 Feb 2024 14:36:39 -0500 "Kalpesh Patel" 
wrote:
> 
> > 
> > My bad... both instances should be double left clicks for Windows
platform...
> > 
> 
> I'm using Linux...
> 
> > 
> > If you can get the cursor on top of the vertical bar between the column
> > headers, then you can adjust columns individually but by double left
clicking
> > the header label it will resize to largest text size in that column except
for
> > the description column which will shrink to remove the horizontal scroll
bar
> > at the bottom by the double left clicks. 
> > 
> > The list is cc'ed on the replies... 
> > 
> > -- Original Message --
> > Received: Sat, 10 Feb 2024 02:14:10 PM EST
> > From: Tommy Trussell 
> > To: Kalpesh Patel Cc: Robert Heller
> > , GNU Cash User 
> > Subject: [GNC] GNC UI problem...
> > 
> > > If you find Kalpesh Patel's procedure useful, let the list know. I
think
> > > the FAQ could be worded a bit more helpfully
> > > 
> > > On Sat, Feb 10, 2024 at 1:08 PM Kalpesh Patel

> > wrote:
> > > 
> > > > Double click the left button on the label of each column from right
to
> > left
> > > > direction. And then lastly go back to the heading 'Description" and
> > double
> > > > click right button to shrink it so that scroll bars go away.
> > > >
> > > >
> > > > Date:   Sat, 10 Feb 2024 12:47:28 -0500 (EST)
> > > > From:   Robert Heller 
> > > > To: gnucash-user@gnucash.org 
> > > > Subject:[GNC] GNC UI problem...
> > > > I am using Version: 4.14 Build ID: 4.14+(2023-03-25) Finance::Quote:
> > 1.50,
> > > > built from source on a RPi 2 running bullseye Raspbian GNU/Linux 11.
> > > >
> > > > How do I get the collumns past the Description to be wider
(readable)?
> > > > Everything I have tried only makes it worse.
> > > >
> > > > --
> > > > Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
> > > > Deepwoods Software -- Custom Software Services
> > > > http://www.deepsoft.com/ -- Linux Administration Services
> > > > hel...@deepsoft.com -- Webhosting Services
> > > >
> > > > ___
> > > > 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.
> > > >
> > > 
> > 
> > 
> > 
> > 
> 
> -- 
> Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel...@deepsoft.com   -- Webhosting Services
> 


___
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 UI problem...

[Kalpesh Patel]

My bad... both instances should be double left clicks for Windows platform...


If you can get the cursor on top of the vertical bar between the column
headers, then you can adjust columns individually but by double left clicking
the header label it will resize to largest text size in that column except for
the description column which will shrink to remove the horizontal scroll bar
at the bottom by the double left clicks. 

The list is cc'ed on the replies... 

-- Original Message --
Received: Sat, 10 Feb 2024 02:14:10 PM EST
From: Tommy Trussell 
To: Kalpesh Patel Cc: Robert Heller
, GNU Cash User 
Subject: [GNC] GNC UI problem...

> If you find Kalpesh Patel's procedure useful, let the list know. I think
> the FAQ could be worded a bit more helpfully
> 
> On Sat, Feb 10, 2024 at 1:08 PM Kalpesh Patel 
wrote:
> 
> > Double click the left button on the label of each column from right to
left
> > direction. And then lastly go back to the heading 'Description" and
double
> > click right button to shrink it so that scroll bars go away.
> >
> >
> > Date:   Sat, 10 Feb 2024 12:47:28 -0500 (EST)
> > From:   Robert Heller 
> > To: gnucash-user@gnucash.org 
> > Subject:[GNC] GNC UI problem...
> > I am using Version: 4.14 Build ID: 4.14+(2023-03-25) Finance::Quote:
1.50,
> > built from source on a RPi 2 running bullseye Raspbian GNU/Linux 11.
> >
> > How do I get the collumns past the Description to be wider (readable)?
> > Everything I have tried only makes it worse.
> >
> > --
> > Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
> > Deepwoods Software -- Custom Software Services
> > http://www.deepsoft.com/ -- Linux Administration Services
> > hel...@deepsoft.com -- Webhosting Services
> >
> > ___
> > 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 251, Issue 22

[Kalpesh Patel]

Double click the left button on the label of each column from right to left
direction. And then lastly go back to the heading 'Description" and double
click right button to shrink it so that scroll bars go away.

 
Date:   Sat, 10 Feb 2024 12:47:28 -0500 (EST)
From:   Robert Heller 
To: gnucash-user@gnucash.org 
Subject:[GNC] GNC UI problem...
I am using Version: 4.14 Build ID: 4.14+(2023-03-25) Finance::Quote: 1.50,
built from source on a RPi 2 running bullseye Raspbian GNU/Linux 11.

How do I get the collumns past the Description to be wider (readable)?
Everything I have tried only makes it worse.

--
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software -- Custom Software Services
http://www.deepsoft.com/ -- Linux Administration Services
hel...@deepsoft.com -- Webhosting Services

___
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] Any official Spanish PGC accounting tree out there?

[Kalpesh Patel]

As a FYI: If some has that tree already setup manually, they can export it out 
from GNC, transport it, and then import it back in into GNC. I have not done 
this process so YMMV. 

-Original Message-
From: Maria Inmaculada de la Torre  
Sent: Wednesday, February 07, 2024 1:27 PM
To: Nens Nens 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Any official Spanish PGC accounting tree out there?

Hello Nens,

As far as I know there are no off-the-self accounts tree based in the "Plan 
General Contable" but you should be able to recreate it entirely quite easily, 
I have adapted my system to an accounts plan that is used by a major accounting 
software provider in the country where I live and then I have made quite a few 
changes to improve reporting using that plan. It is very easy to do the 
accounts tree but obviously you would need to do it manually and it will take 
you some time.

I hope this helps.

Regards,


Inma

On Wed, 7 Feb 2024 at 16:56, Nens Nens  wrote:

> Hi from Barcelona,
>
> we are about to start a modest home business, and we would like to 
> keep accounting records according to Spanish "Plan General Contable" 
> official numbering system. Is there any off-the-shelf accounts tree 
> with the basic numeration publicly available?
>
> Thanks in advance!
>
> 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] GnuCash with Interactive Brokers

[Kalpesh Patel]

Correct, it is initially set to blank and it sadly does not take any hints from 
any of those fields at this time. Training the matcher is the only way to 
populate its heuristics. 

-Original Message-
From: km22  
Sent: Tuesday, February 06, 2024 6:28 PM
To: Kalpesh Patel 
Cc: Steve Butler ; Gyle McCollam 
; GnuCash Users 
Subject: Re: [GNC] GnuCash with Interactive Brokers

Understood. My point was more around whether there is a specific field in the 
GnuCash securities setup which if matched with a specific field in the OFX xml 
would result in the manual click-based becoming unnecessary?

I have dozens of bonds in the portfolio which are painful to manually match. 
But they all have unique identifiers (CUSIPs and IBKR contract ids) which I 
wish GnuCash could leverage in the matching stage. As of now it does not seem 
to attempt any type of best guess when a new security is being imported from 
the OFX. 

Thanks,
Ken


> On 7 Feb 2024, at 02:57, Kalpesh Patel  wrote:
> 
> Yap, one time deal. It remembers for next time and it won't ask unless it 
> encounters something new.
> 
> It is similar to us learning to walk in our childhood ...  
> 
> -Original Message-
> From: Steve Butler 
> Sent: Tuesday, February 06, 2024 1:21 AM
> To: km22 
> Cc: Kalpesh Patel ; Gyle McCollam 
> ; GnuCash Users 
> Subject: Re: [GNC] GnuCash with Interactive Brokers
> 
> That is true for the first time.  After that it will learn the matches you 
> make and only ask for new ones.
> 
>> On Tue, Feb 6, 2024, 16:35 km22 via gnucash-user 
>> 
>> wrote:
>> 
>> Thanks.
>> 
>> 
>> Upon importing the OFX I am prompted to match the different bonds in 
>> the statement with the relevant asset in GnuCash:
>> 
>> This is quite a manual process having to match these manually 
>> one-by-one.  Do you know whether there is a way for me to define the 
>> assets in GnuCash so this mapping is more automated? (Or at least 
>> where GnuCash is able to select the best match for me to review?)
>> 
>> 
>> Since it reads "Please note that the exchange code of the commodity 
>> you select will be overwritten" does this mean that if I set the 
>> ISIN/CUSIP correctly in GnuCash the mapping would be more seamless?
>> 
>> 
>> 
>> 
>> 
>> 
>>> On 2024-02-05 22:17, Kalpesh Patel wrote:
>>> 
>>> Ken, as Gyle mentioned, they are sibling to each other. In terms of 
>>> technical specs, QFX is modified OFX format which contains 
>>> additional Intuit’s non-XML header but GNC treats them both equal as 
>>> it simply ignores that header. From the transaction wise they both 
>>> will contain identical data.
>>> 
>>> *From:*Gyle McCollam 
>>> *Sent:* Monday, February 05, 2024 8:59 AM
>>> *To:* Kalpesh Patel ; km22 
>>> *Cc:* gnucash-user@gnucash.org
>>> *Subject:* Re: [GNC] GnuCash with Interactive Brokers
>>> 
>>> It doesn't "prefer" either, in fact the import is OFX/QFX.
>>> 
>>> Thank You,
>>> 
>>> *Gyle McCollam*
>>> 
>>> Gyle McCollam
>>> 
>>> gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email
>>> 
>>> 
>>> 
>>> 
>>> *From:*gnucash-user
>>>  on behalf of
>>> km22 via gnucash-user 
>>> *Sent:* Monday, February 5, 2024 4:54 AM
>>> *To:* Kalpesh Patel 
>>> *Cc:* gnucash-user@gnucash.org 
>>> *Subject:* Re: [GNC] GnuCash with Interactive Brokers
>>> 
>>> Hi Kalpesh,
>>> 
>>> Thanks for your reply. IBKR offers these "Third-party Downloads":
>>> 
>>> 1. Quicken Web Connect -> which generate a QFX file
>>> 
>>> 2. GainsKeeper
>>> 
>>> 3. TradeLog
>>> 
>>> 4. MS Money -> which generates a OFX file
>>> 
>>> 
>>> Do you know whether GnuCash prefers OFX or QFX?
>>> 
>>> I have downloaded both and will experiment with them.
>>> 
>>> Thanks,
>>> 
>>> Ken
>>> 
>>> 
>>> 
>>> On 2024-02-05 10:27, Kalpesh Patel wrote:
>>>> While I am NOT with Interactive Broker, your best bet is to see if
>>> you can download transactions in OFX (Open Financial Exchange) or 
>>> QFX (Quicken Financial Exchange) format. That would be the best 
>>> format and I believe most broker-dealers support that format as a 
>>> download method from their web portal.
>>>> 
>>>&

Re: [GNC] GnuCash with Interactive Brokers

[Kalpesh Patel]

Yap, one time deal. It remembers for next time and it won't ask unless it 
encounters something new. 

It is similar to us learning to walk in our childhood ...  

-Original Message-
From: Steve Butler  
Sent: Tuesday, February 06, 2024 1:21 AM
To: km22 
Cc: Kalpesh Patel ; Gyle McCollam ; 
GnuCash Users 
Subject: Re: [GNC] GnuCash with Interactive Brokers

That is true for the first time.  After that it will learn the matches you make 
and only ask for new ones.

On Tue, Feb 6, 2024, 16:35 km22 via gnucash-user 
wrote:

> Thanks.
>
>
> Upon importing the OFX I am prompted to match the different bonds in 
> the statement with the relevant asset in GnuCash:
>
> This is quite a manual process having to match these manually 
> one-by-one.  Do you know whether there is a way for me to define the 
> assets in GnuCash so this mapping is more automated? (Or at least 
> where GnuCash is able to select the best match for me to review?)
>
>
> Since it reads "Please note that the exchange code of the commodity 
> you select will be overwritten" does this mean that if I set the 
> ISIN/CUSIP correctly in GnuCash the mapping would be more seamless?
>
>
>
>
>
>
> On 2024-02-05 22:17, Kalpesh Patel wrote:
> >
> > Ken, as Gyle mentioned, they are sibling to each other. In terms of 
> > technical specs, QFX is modified OFX format which contains 
> > additional Intuit’s non-XML header but GNC treats them both equal as 
> > it simply ignores that header. From the transaction wise they both 
> > will contain identical data.
> >
> > *From:*Gyle McCollam 
> > *Sent:* Monday, February 05, 2024 8:59 AM
> > *To:* Kalpesh Patel ; km22 
> > *Cc:* gnucash-user@gnucash.org
> > *Subject:* Re: [GNC] GnuCash with Interactive Brokers
> >
> > It doesn't "prefer" either, in fact the import is OFX/QFX.
> >
> > Thank You,
> >
> > *Gyle McCollam*
> >
> > Gyle McCollam
> >
> > gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email
> >
> > 
> > 
> >
> > *From:*gnucash-user
> >  on behalf of 
> > km22 via gnucash-user 
> > *Sent:* Monday, February 5, 2024 4:54 AM
> > *To:* Kalpesh Patel 
> > *Cc:* gnucash-user@gnucash.org 
> > *Subject:* Re: [GNC] GnuCash with Interactive Brokers
> >
> > Hi Kalpesh,
> >
> > Thanks for your reply. IBKR offers these "Third-party Downloads":
> >
> > 1. Quicken Web Connect -> which generate a QFX file
> >
> > 2. GainsKeeper
> >
> > 3. TradeLog
> >
> > 4. MS Money -> which generates a OFX file
> >
> >
> > Do you know whether GnuCash prefers OFX or QFX?
> >
> > I have downloaded both and will experiment with them.
> >
> > Thanks,
> >
> > Ken
> >
> >
> >
> > On 2024-02-05 10:27, Kalpesh Patel wrote:
> > > While I am NOT with Interactive Broker, your best bet is to see if
> > you can download transactions in OFX (Open Financial Exchange) or 
> > QFX (Quicken Financial Exchange) format. That would be the best 
> > format and I believe most broker-dealers support that format as a 
> > download method from their web portal.
> > >
> > > -Original Message-
> > > From: km22
> > > Sent: Sunday, February 04, 2024 4:57 AM 
> > > To:gnucash-user@gnucash.org
> > > Subject: [GNC] GnuCash with Interactive Brokers
> > >
> > > Hi Gnucash Users,
> > >
> > > Does anyone on this mailing list have a method for importing
> > transactions from Interactive Brokers (IBKR) to GnuCash? (Especially 
> > multi-currency users.)
> > >
> > > I currently enter all transactions manually but would like to
> > explore ways of importing transactions.
> > >
> > > Please share your approach if so.
> > >
> > > Thanks,
> > >
> > > Ken
> > >
> > >
> > >
> > >
> > ___
> > 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 with Interactive Brokers

[Kalpesh Patel]

Ken, as Gyle mentioned, they are sibling to each other. In terms of
technical specs, QFX is modified OFX format which contains additional
Intuit's non-XML header but GNC treats them both equal as it simply ignores
that header. From the transaction wise they both will contain identical
data.  

 

From: Gyle McCollam  
Sent: Monday, February 05, 2024 8:59 AM
To: Kalpesh Patel ; km22 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] GnuCash with Interactive Brokers

 

It doesn't "prefer" either, in fact the import is OFX/QFX.

 

Thank You,   

Gyle McCollam

Gyle McCollam

gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
km22 via gnucash-user mailto:gnucash-user@gnucash.org> >
Sent: Monday, February 5, 2024 4:54 AM
To: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >
Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] GnuCash with Interactive Brokers 

 

Hi Kalpesh,

Thanks for your reply. IBKR offers these "Third-party Downloads":

1. Quicken Web Connect -> which generate a QFX file

2. GainsKeeper

3. TradeLog

4. MS Money -> which generates a OFX file


Do you know whether GnuCash prefers OFX or QFX?

I have downloaded both and will experiment with them.

Thanks,

Ken



On 2024-02-05 10:27, Kalpesh Patel wrote:
> While I am NOT with Interactive Broker, your best bet is to see if you can
download transactions in OFX (Open Financial Exchange) or QFX (Quicken
Financial Exchange) format. That would be the best format and I believe most
broker-dealers support that format as a download method from their web
portal.
>
> -Original Message-
> From: km22mailto:k...@gmx.com> >
> Sent: Sunday, February 04, 2024 4:57 AM
> To:gnucash-user@gnucash.org
> Subject: [GNC] GnuCash with Interactive Brokers
>
> Hi Gnucash Users,
>
> Does anyone on this mailing list have a method for importing transactions
from Interactive Brokers (IBKR) to GnuCash? (Especially multi-currency
users.)
>
> I currently enter all transactions manually but would like to explore ways
of importing transactions.
>
> Please share your approach if so.
>
> Thanks,
>
> Ken
>
>
>
>
___
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.

Re: [GNC] GnuCash with Interactive Brokers

[Kalpesh Patel]

While I am NOT with Interactive Broker, your best bet is to see if you can 
download transactions in OFX (Open Financial Exchange) or QFX (Quicken 
Financial Exchange) format. That would be the best format and I believe most 
broker-dealers support that format as a download method from their web portal. 

-Original Message-
From: km22  
Sent: Sunday, February 04, 2024 4:57 AM
To: gnucash-user@gnucash.org
Subject: [GNC] GnuCash with Interactive Brokers

Hi Gnucash Users,

Does anyone on this mailing list have a method for importing transactions from 
Interactive Brokers (IBKR) to GnuCash? (Especially multi-currency users.)

I currently enter all transactions manually but would like to explore ways of 
importing transactions.

Please share your approach if so.

Thanks,

Ken




___
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] transaction impossible to reconcile

[Kalpesh Patel]

I have ran into this situation in the past. Even though you update certain 
items and balances, when you save it it reverts back to what it was originally 
there ... (I think it is a bug but haven't looked into it further). The way I 
have worked around is to fake it to look like a "new" transaction by updating 
ALL of the Shares, Price, Buy and Sell items for all splits. Even if the value 
is same, copy it into clipboard (in windows ctrl+insert), delete and then put 
it back from clip-board (shift+insert). You of course certainly can change any 
value if needed to correct it.  

-Original Message-
From: Mattia Rizzolo  
Sent: Wednesday, January 24, 2024 7:20 AM
To: gnucash-user@gnucash.org
Subject: [GNC] transaction impossible to reconcile

I'm fixing up a couple of old transactions that I didn't really record 
correctly, and here is one that is baffling me.

Attached you can find a screenshot of the journal.

What happened is that this company issued some options to its shareholders to 
to some capital increase.

So, the regular stock effectively got "split-off" for its option (that is also 
regularly traded, etc).
I've done pretty much the same in other situations with more standard business 
spin-offs (the O → ONL one comes to mind), but somehow here gnucash is refusing 
to let me go.
What is going on?

--
regards,
Mattia Rizzolo

GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
More about me:  https://mapreri.org : :'  :
Launchpad user: https://launchpad.net/~mapreri  `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-

___
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 ignore account

[Kalpesh Patel]

It is not "That is how this old version Quicken does dates of form 20xx" but 
more or so thank Intuit for proprietary touch to QIF file format where they 
left good deal of ambiguities. It has behaved like that up to 2017 version 
which the latest version I had used. You will have to normalize them in to a 
consist format. I had used *NIX's crude sed script on thousands of transactions 
in the past to fix them during migration (WSL is fine) ... 

I hope the code comes intact ... no error checking and there should be no 
special characters or white spaces in the file name

#!/bin/bash

set -x

iam=$1
cat ${iam} > ${iam}.orig

sed -i.tmp -e "s+' 0+/2000+g" ${iam}
sed -i.tmp -e "s+' 1+/2001+g" ${iam}
sed -i.tmp -e "s+' 2+/2002+g" ${iam}
sed -i.tmp -e "s+' 3+/2003+g" ${iam}
sed -i.tmp -e "s+' 4+/2004+g" ${iam}
sed -i.tmp -e "s+' 5+/2005+g" ${iam}
sed -i.tmp -e "s+' 6+/2006+g" ${iam}
sed -i.tmp -e "s+' 7+/2007+g" ${iam}
sed -i.tmp -e "s+' 8+/2008+g" ${iam}
sed -i.tmp -e "s+' 9+/2009+g" ${iam}
sed -i.tmp -e "s+'10+/2010+g" ${iam}
sed -i.tmp -e "s+'11+/2011+g" ${iam}
sed -i.tmp -e "s+'12+/2012+g" ${iam}
sed -i.tmp -e "s+'13+/2013+g" ${iam}
sed -i.tmp -e "s+'14+/2014+g" ${iam}
sed -i.tmp -e "s+'15+/2015+g" ${iam}
sed -i.tmp -e "s+'16+/2016+g" ${iam}
sed -i.tmp -e "s+'17+/2017+g" ${iam}
sed -i.tmp -e "s+'18+/2018+g" ${iam}
sed -i.tmp -e "s+'19+/2019+g" ${iam}
sed -i.tmp -e "s+'20+/2020+g" ${iam}
sed -i.tmp -e "s+'21+/2021+g" ${iam}
sed -i.tmp -e "s+'22+/2022+g" ${iam}
sed -i.tmp -e "s+'23+/2023+g" ${iam}
sed -i.tmp -e "s+'24+/2024+g" ${iam}
sed -i.tmp -e "s+/81+/1981+g" ${iam}
sed -i.tmp -e "s+/82+/1982+g" ${iam}
sed -i.tmp -e "s+/83+/1983+g" ${iam}
sed -i.tmp -e "s+/84+/1984+g" ${iam}
sed -i.tmp -e "s+/85+/1985+g" ${iam}
sed -i.tmp -e "s+/86+/1986+g" ${iam}
sed -i.tmp -e "s+/87+/1987+g" ${iam}
sed -i.tmp -e "s+/88+/1988+g" ${iam}
sed -i.tmp -e "s+/89+/1989+g" ${iam}
sed -i.tmp -e "s+/90+/1990+g" ${iam}
sed -i.tmp -e "s+/91+/1991+g" ${iam}
sed -i.tmp -e "s+/92+/1992+g" ${iam}
sed -i.tmp -e "s+/93+/1993+g" ${iam}
sed -i.tmp -e "s+/94+/1994+g" ${iam}
sed -i.tmp -e "s+/95+/1995+g" ${iam}
sed -i.tmp -e "s+/96+/1996+g" ${iam}
sed -i.tmp -e "s+/97+/1997+g" ${iam}
sed -i.tmp -e "s+/98+/1998+g" ${iam}
sed -i.tmp -e "s+/99+/1999+g" ${iam}


-Original Message-
From: Fred Tydeman  
Sent: Saturday, January 20, 2024 6:36 PM
To: Geoff 
Cc: Gnucash Users 
Subject: Re: [GNC] QIF import ignore account

On Sat, Jan 20, 2024 at 3:02 PM Geoff  wrote:

> Hmmm...
>
> When I try importing that file into GnuCash 5.5 it crashes silently, 
> and the trace file contains just one line:
>
> * 09:56:13  WARN  Failed to open application manifest 
> `C:\Program 
> Files\WindowsApps\Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe\AppxManifest.xml'
>
> for package #38
> (`Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe'):
> error code 0x2
>
> As I said in my previous reply, when it comes to investment 
> transactions, cut your losses with the QIF Importer and use the CSV 
> Importer instead.  It just works.
>

I am getting the QIF file from Quicken for DOS v8.7 of 1996.
It can only export as QIF.


> P.S. You have a quote instead of a slash between the day and the year:
>
>  > D1/19'24


That is how this old version Quicken does dates of form 20xx


___
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] Compare two sets of accounts?

[Kalpesh Patel]

Unix diff utility would be very handy to compare csv files...

Make use of  -i -E -Z -b -w -B  and -c options.

-Original Message-
From: Adrien Monteleone  
Sent: Friday, January 19, 2024 8:00 PM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Compare two sets of accounts?

Along with the idea of exporting your present book via CSV, when you get back 
the file from the accountant, export that book as CSV too. Then do a diff on 
the CSV files.

Those should be less messy to read than the XML.

You could then take the diff results as a CSV and import them.

Regards,
Adrien

On 1/19/24 7:50 AM, Simon Roberts wrote:
> Does GNC provide any mechanism for comparing two versions of the same 
> set of accounts?
> 
> I'll be sending my books to my accountant soon, and I imagine they 
> will have some corrections/adjustments. I'll be giving them a laptop 
> with GNC installed, so they can most easily browse, and it occurs to 
> me that they could also make their changes in place. But, unless they 
> write down separately every entry they create or change, I would need 
> to somehow re-integrate their work with my "master" file. Either that, 
> or I'd have to freeze my bookkeeping while they're working on things, 
> and that's likely to take too long to be acceptable.
> 
> With the hostage-taker's rent-ware that I used to use, there was a 
> specific mechanism for an "accountant's copy" and a means to merge the 
> changes back automatically. But I've failed to find this in the docs 
> for GNC (quite possibly as a result of poor / uninspired searching!)
> 
> Is this supported directly? Is this something folks have found an 
> approach for? I suppose, as a not quite worst case, I could simply 
> diff the XML file itself, but that's going to produce results that 
> will be somewhat messy, at best. But at least I'd know something about what 
> changed.
> 
> What ideas can you offer (or manual pages, if I've failed that
> embarrassingly!)



___
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] F::Q Interface to GNC for pricing update

[Kalpesh Patel]

Looking at the data structure returned by F::Q that is consumed by GNC, am I
correct in understanding that GNC is currently designed to consume only one
quote for one or more security per firing to update 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.

Re: [GNC] Enhancement: Future sched txn update if updated template.

[Kalpesh Patel]

I don't think it is matter of how many SXs you have for how many transactions 
but is more like if there are already scheduled transaction fired from a given 
SX, and then you update the template for that SX, how do you back-fill all auto 
added transactions from that fired SX. Remember that these auto created 
transactions show up in the reports which could be used for multitudes of 
reason, for example to understand outlay of monies for a year (which is 
different than budgeting IMHO).

-Original Message-
From: David Carlson  
Sent: Wednesday, January 17, 2024 7:42 AM
To: David H 
Cc: Gyle McCollam ; Gnucash Users 
; David G. Pickett 
Subject: Re: [GNC] Enhancement: Future sched txn update if updated template.

An SX can be constructed to have at least two separate register transactions, 
and probably as many as 12 register transactions but they may be limited to 
firing on the same schedule and date.  I have one SX wth two register 
transactions that has been in service for several months.

On Wed, Jan 17, 2024 at 1:09 AM David H  wrote:

> * think * not honk - spellcheck? Fat fingers ?
>
> On Wed, 17 Jan 2024 at 5:07 pm, David H  wrote:
>
> > I honk he’s talking about having 1 template but the transactions 
> > have already been created 12 months in advance. I.e. he wants to 
> > update the created tens based on an updated template after the fact.
> >
> > Regards David H.
> >
> > On Wed, 17 Jan 2024 at 10:43 am, Gyle McCollam 
> wrote:
> >
> >> Instead of having 11 or 12 sx templates, why not have one that 
> >> fires monthly?
> >>
> >>
> >>
> >> Sent from Samsung Galaxy smartphone.
> >>
> >>
> >>
> >>  Original message 
> >> From: "David G. Pickett via gnucash-user" 
> >> 
> >> Date: 1/16/24 6:18 PM (GMT-05:00)
> >> To: Gnucash Users 
> >> Subject: [GNC] Enhancement: Future sched txn update if updated template.
> >>
> >> I schedule my periodic transactions a year in advance, but with 
> >> constant inflation, often the amount goes up.  It'd be nice to have 
> >> a way to, by interactive option after I update the template, have 
> >> gnucash update the already generated future transactions to match 
> >> an updated template transaction, so I do not need to update 11 or 12 more 
> >> places.
> >> ___
> >> 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.
>


--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Feature request: Import assistant, room for big improvements

[Kalpesh Patel]

If you make a mistake or error in import, are you going back to Bayesian 
matcher to tell it that a mistake was made? Those is via 'Tools' -> 'Import 
Match Editor' navigation 
There is also 'Show matched information' check box that gives you everything on 
both sides of the transaction. If you select 'U+C' or 'C', you can also double 
click on it to give you more information on all matching transactions.

-Original Message-
From: Christopher Lam  
Sent: Tuesday, January 16, 2024 1:56 AM
To: davidcousen...@gmail.com
Cc: GnuCash users group 
Subject: Re: [GNC] Feature request: Import assistant, room for big improvements

On Tue, 16 Jan 2024, 2:13 pm David Cousens, 
wrote:

>
> I haven't yet imported anything under v5.5. but will be catching up in 
> a few days. Being able to edit/add data to the description and or memo 
> fields would be something I would find useful too as the imported bank 
> data often has limited info about what the purchase was for


(Bis) have you tried right click the transaction(s) during the import matching 
process?


>
>
> David Cousens
>
>
>
>
> On Mon, 2024-01-15 at 22:48 -0600, David Carlson wrote:
> > Which import assistant is being discussed here?  The Generic 
> > assistant behind the OFX and QIF imports is quite limited in placing 
> > new
> transactions
> > into the desired account or in matching incoming transactions to 
> > correct pre-existing transactions, but the new CSV transaction 
> > importer is
> better,
> > if harder to configure optimally.  Also, I think they all have 
> > changed in recent GnuCash releases, so tell us which release you are 
> > currently
> using.
> >
> > I doubt that the Generic assistant can be improved very much unless 
> > it is completely rewritten.
> >
> >
> > On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce 
> wrote:
> >
> > > 
> > >
> > >
> > > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > > >
> > > > 
> > > > No, I would call that the description.
> > > > -derek
> > > > Sent using my mobile device. Please excuse any typos.
> > > >
> > > > > On January 15, 2024 23:06:07 Phyllis Bruce 
> > > > > 
> wrote:
> > > > >
> > > > > Thanks, David.  I think I am being unclear.  My research 
> > > > > provides
> what
> > > you
> > > > > call the transfer account for unmatched items.  That's all good.
> It is
> > > the
> > > > > memo field which I use to remind me of what I did that is not
> available
> > > in
> > > > > the reconciliation screen.  For instance I want to remember 
> > > > > that I
> paid
> > > > > Amazon for *smart plugs*, or Sandi paid me $70 for *her share 
> > > > > of
> > > groceries
> > > > > at Christmas*.  Would you call that the "action"?
> > > > >
> > > > > On Mon, Jan 15, 2024 at 3:21 PM David Cousens <
> davidcousen...@gmail.com
> > > >
> > > > > wrote:
> > > > >
> > > > > > Ulrich,
> > > > > >
> > > > > > There is nothing to stop you supplying the transfer account
> > > information in
> > > > > > an
> > > > > > import record if it is available. There is a header which 
> > > > > > can be
> > > assigned
> > > > > > to the
> > > > > > appropriate column of your input file for the transfer account.
> > > > > >
> > > > > > The first time you import with a given account name in he 
> > > > > > record
> you
> > > will
> > > > > > be
> > > > > > asked to specify the internal GnuCash account to which it
> corresponds.
> > > > > > After
> > > > > > that it will be matched to that account.
> > > > > >
> > > > > > The Bayesian process only assigns a probable account in 
> > > > > > cases
> where
> > > > > > the
> > > > > > import
> > > > > > record does not specify the  transfer account.
> > > > > >
> > > > > > David Cousens
> > > > > >
> > > > > > > On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > > > > > > Hello fellow GnuCash users,
> > > > > > >
> > > > > > > I wonder if there are plans on improving the import 
> > > > > > > filter, for
> > > importing
> > > > > > > bank transfers.
> > > > > > > The situation now is, that some hidden engine tries to 
> > > > > > > learn
> from
> > > doing.
> > > > > > > But the truth is, that even after one year of importing 
> > > > > > > bank
> > > transfers, I
> > > > > > > have to check every single transaction, since errors keep
> occurring.
> > > If I
> > > > > > > miss an error, this transaction is put in the wrong ledger
> account.
> > > > > > >
> > > > > > > E-boekhouden.nl uses an import assistant where you can 
> > > > > > > specify
> a
> > > ledger
> > > > > > > account number, other keywords and/or amounts of money. 
> > > > > > > The
> import
> > > > > > > assistant puts the transactions into the right ledger 
> > > > > > > account,
> with
> > > far
> > > > > > > less errors than with GnuCash. In fact, only where a 
> > > > > > > specific keyword, leger number or amount is missing, or 
> > > > > > > where no import rule is
> made
> > > for a
> > > > > > > specific payment, the transaction has to be placed into 
> > > > > > > the
> right
> > > 

Re: [GNC] Feature request: Import assistant, room for big improvements

[Kalpesh Patel]

Use the 'Append' capabilities to keep both sets of information in the 
description firld. In the matcher window you will see a ability to check box at 
the bottom of the matches. Albeit it changes your workflows and with few import 
iteration you'll be able to keep track of both info. I wish there was per 
transaction selection rather than all or nothing deal for that import iteration.

-Original Message-
From: David Cousens  
Sent: Tuesday, January 16, 2024 1:13 AM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Feature request: Import assistant, room for big improvements

>From memory David the import matcher process is common to all the front 
>ends to
read different file formats. It's been a while since I went through the code 
after Geert rewrote the CSV front end but I doubt that it has changed all that 
much. I have found the Bayesian matcher works fairly well apart from a few 
specific transactions where there is insufficient information in the data 
record to correctly assign. I typically only have to manually assign may be 10 
records out of more than 50-60 records imported for my credit card account each 
month.

I haven't yet imported anything under v5.5. but will be catching up in a few 
days. Being able to edit/add data to the description and or memo fields would 
be something I would find useful too as the imported bank data often has 
limited info about what the purchase was for 
 

David Cousens




On Mon, 2024-01-15 at 22:48 -0600, David Carlson wrote:
> Which import assistant is being discussed here?  The Generic assistant 
> behind the OFX and QIF imports is quite limited in placing new 
> transactions into the desired account or in matching incoming 
> transactions to correct pre-existing transactions, but the new CSV 
> transaction importer is better, if harder to configure optimally.  
> Also, I think they all have changed in recent GnuCash releases, so tell us 
> which release you are currently using.
> 
> I doubt that the Generic assistant can be improved very much unless it 
> is completely rewritten.
> 
> 
> On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce  wrote:
> 
> > 
> > 
> > 
> > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > > 
> > > 
> > > No, I would call that the description.
> > > -derek
> > > Sent using my mobile device. Please excuse any typos.
> > > 
> > > > On January 15, 2024 23:06:07 Phyllis Bruce  wrote:
> > > > 
> > > > Thanks, David.  I think I am being unclear.  My research 
> > > > provides what
> > you
> > > > call the transfer account for unmatched items.  That's all good.  
> > > > It is
> > the
> > > > memo field which I use to remind me of what I did that is not 
> > > > available
> > in
> > > > the reconciliation screen.  For instance I want to remember that 
> > > > I paid Amazon for *smart plugs*, or Sandi paid me $70 for *her 
> > > > share of
> > groceries
> > > > at Christmas*.  Would you call that the "action"?
> > > > 
> > > > On Mon, Jan 15, 2024 at 3:21 PM David Cousens 
> > > >  > > 
> > > > wrote:
> > > > 
> > > > > Ulrich,
> > > > > 
> > > > > There is nothing to stop you supplying the transfer account
> > information in
> > > > > an
> > > > > import record if it is available. There is a header which can 
> > > > > be
> > assigned
> > > > > to the
> > > > > appropriate column of your input file for the transfer account.
> > > > > 
> > > > > The first time you import with a given account name in he 
> > > > > record you
> > will
> > > > > be
> > > > > asked to specify the internal GnuCash account to which it corresponds.
> > > > > After
> > > > > that it will be matched to that account.
> > > > > 
> > > > > The Bayesian process only assigns a probable account in cases 
> > > > > where the import record does not specify the  transfer 
> > > > > account.
> > > > > 
> > > > > David Cousens
> > > > > 
> > > > > > On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > > > > > Hello fellow GnuCash users,
> > > > > > 
> > > > > > I wonder if there are plans on improving the import filter, 
> > > > > > for
> > importing
> > > > > > bank transfers.
> > > > > > The situation now is, that some hidden engine tries to learn 
> > > > > > from
> > doing.
> > > > > > But the truth is, that even after one year of importing bank
> > transfers, I
> > > > > > have to check every single transaction, since errors keep occurring.
> > If I
> > > > > > miss an error, this transaction is put in the wrong ledger account.
> > > > > > 
> > > > > > E-boekhouden.nl uses an import assistant where you can 
> > > > > > specify a
> > ledger
> > > > > > account number, other keywords and/or amounts of money. The 
> > > > > > import assistant puts the transactions into the right ledger 
> > > > > > account, with
> > far
> > > > > > less errors than with GnuCash. In fact, only where a 
> > > > > > specific keyword, leger number or amount is missing, or 
> > > > > > where no import rule is made
> > for a
> > > > > > specific payment, the transaction has to 

Re: [GNC] Install Finance::Quotes

[Kalpesh Patel]

While I am not on Mac, I recall that the SSL portion of LWP was very hard to 
compile/install on the *NIX side, especially the needed SSLeay module for older 
Perl versions which used to be a separate and standalone build.

From below SUDO command, it looks you are trying to build for all three 
architecture types so I am SUSPECTING that SSLeay for ARM may not be available 
for Perl 5.3 version. 

-Original Message-
From: Gustavo Taouil  
Sent: Sunday, January 14, 2024 2:58 PM
To: gnucash-user@gnucash.org
Subject: [GNC] Install Finance::Quotes

Hi Guys, please help me!

I have MacBook Pro m3 with macOS Sonome. I followed the instructions in wiki 
page of Gnucash to install the Finance::Quote. I use this command in terminal :

sudo ARCHFLAGS='-arch arm64 -arch arm64e -arch x86_64' 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update

The command installs several packages in pearl 5.3 folder but didn’t install 
Finance::Quote. Debugging the code I found that I can’t install the package 
LWP::Protocol::https.


Has anyone had a problem like this?



Thanks 

Gustavo








___
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

[Kalpesh Patel]

Old but still good source of information: 
https://www.bogleheads.org/forum/viewtopic.php?t=234157

If the file has many years of data then suggestion is to start the account with 
the most amount of transaction to least and start with Bank/CC/Loans types of 
accounts first before going to Investment type of accounts. I recall providing 
good details on my experience of migrating from Quicken 2017 to GNC back in 
2020s so might be worth searching the archive for it. 

For certain things I still fire up Quicken and I did have to learn double-entry 
method as I was not familiar with. Just one quick thing to keep in mind: 
Quicken categories become GNC accounts as mentioned by R Losey. I initially 
exported the account tree in Quicken and imported into GNC as the first thing 
using QIF format which prevented a lot of annoying pop-up asking if you want to 
do this or that in GNC. It took few iteration to get it right before settling 
on the final time. Experimenting and making backup copies in GNC is key to 
fail-fast and recover quick when things do not go the way you expect. Also be 
prepared to potentially looks and review through QIF file in a text editor as 
there are times when GNC expects precise info while exported QIF file may not 
have it or may have it wrong.

-Original Message-
From: R Losey  
Sent: Monday, January 08, 2024 11:18 AM
To: barry milliken 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Moving from Quicken

I, too, left Quicken about 8 years ago and changed to GnuCash. I had a slight 
familiarity with double-entry accounting, and I've seldom had any issues with 
GnuCash.

I thought about importing Quicken data, but then decided against it... I 
reasoned that if I really did need to reference something I had in Quicken, I 
could open those files.  In fact, I think I opened Quicken two or three times 
in the first couple of years, and haven't touched it since. It's just something 
to think about.

I had trouble getting the downloads from financial institutions to work, so I 
do them manually and regularly reconcile. I don't really miss this function, 
but it is possible.

As you will have heard, GnuCash doesn't have "categories"; it has "accounts". 
At the risk of offending a great multitude of GnuCash users, from the practical 
point of view, GnuCash accounts are very much like categories in Quicken. I 
know that they are not really the same thing, but as a former Quicken user, 
they are.

In my experience, the one thing I had trouble with in GnuCash were the reports 
- most of them seem to need some kind of tweaking to get them to do what is 
wanted. Here's another thing to think about: instead of assigning accounts as 
"tax deductible", if you have an account whose transactions are deductible 
(such as charitable giving, you can create a report for just these accounts. 
You just need the discipline to only enter deductible items in such accounts. I 
do know that there is a US tax setup feature, but I haven't made  full use of 
that -- and the report using the accounts I want to know about for tax reasons 
works well enough for my needs.

RL

On Sat, Jan 6, 2024 at 9:50 PM barry 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.
>
> Thanks
>
>
> Barry Milliken
>
> ___
> 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.

Re: [GNC] Ver 5.5 for Windows import issue

[Kalpesh Patel]

For number of the CC issuers, I've observed that that there is subtle changes 
to the description in last few months which differs from what was provided 
previously. I am seeing this when I download it for entire year and try to 
reimport it to validate that all transactions are accounted for. What I have 
seen is that the date (or part their-of) is appended that is way far out on 
right side that might not be visible in the importer screen. Also there is a 
very good chance that the CC issuer re-did the description text as part of 
migration and/or merger which will throw off the confidence for the matcher. 

-Original Message-
From: Gyle McCollam  
Sent: Sunday, December 31, 2023 11:20 AM
To: David Carlson 
Cc: Gnucash Users 
Subject: Re: [GNC] Ver 5.5 for Windows import issue

Sorry it took so long to get back to you, but I've been away.  It is possible 
some of the settings you mentioned have been changed, but I'm not sure.  Do you 
have info for all the default settings, so I can reset?  I know some of them 
are in the tips that pop up and I can change them, but some of the others don't 
say.

As an aside, I see that on my email, outlook.com, all my messages and replies 
appear twice.  Is that happening when you see them and if so, do you know how 
to fix that?


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: David Carlson 
Sent: Saturday, December 30, 2023 3:46 PM
To: Gyle McCollam 
Cc: Gnucash Users 
Subject: Re: [GNC] Ver 5.5 for Windows import issue

Is it possible that any of the settings on the Edit Preferences Import page 
have changed from your previous settings?

On Sat, Dec 30, 2023 at 2:11 PM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
Just tried importing information into my checking account and it exhibits the 
same strange behavior I mentioned with my cc account (different financial 
institutions).  Namely, it wants to add all the transactions as new, but when I 
click on (c)lear it finds the matching transaction.  I don't know what changed 
in the importer, but it was functioning correctly before the upgrade to 5.5.  
However, going back to 5.3 doesn't solve the issue.  It was working fine for 
years and I thought the problem was with Citi Bank, but now that it is 
functioning the same with a different institution, I think it must be GC 
related.  I'll be curious, now that we are at the end of a month, if other 
users are experiencing the same issue.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: David Carlson 
mailto:david.carlson@gmail.com>>
Sent: Saturday, December 23, 2023 4:36 PM
To: Gyle McCollam mailto:gmccol...@live.com>>
Cc: Gnucash Users mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Ver 5.5 for Windows import issue

There is a bit of a learning curve with the process of importing files into 
GnuCash, and a major part of it is learning how GnuCash reacts to the 
particular text that the financial institution uses in the file.  I have found 
that I need to treat files from different banks quite differently.  One FI even 
reverses the signs of purchases vs payments compared to the rest of the world 
(even from other merchants using the same credit card servicer) in their OFX 
files.

OFX/QFX, and QIF files all use the generic importer for the bulk of the import 
process and CSV imports use a different process depending the purpose of the 
import.

If you find that there are any quirks that appear to be wrong or strange come 
back here with specific questions.



On Sat, Dec 23, 2023 at 12:37 PM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
When I reached the end of the import file and continued to the reconciliation 
it eliminated all the duplicates and left only the original transactions.  So, 
I don't know what was going on, but the end result was normal?


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: David Carlson 
mailto:david.carlson@gmail.com>>
Sent: Saturday, December 23, 2023 12:25 PM
To: Gyle McCollam mailto:gmccol...@live.com>>
Cc: Gnucash Users mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Ver 5.5 for Windows import issue

Just for the record, was that a qif import or ofx?



On Sat, Dec 23, 2023, 11:09 AM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
Just downloaded 5.5 for win 11.  Tried to import my cc info and the import 
wanted to add EVERY transaction as new.  When I clicked on (c)lear it found the 
matching transaction, but still was importing as new, which caused it to double 
everything.  I am reinstalling 5.3 until I can find out what is wrong.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com>
  

Re: [GNC] View Transactions After Importing from CSV

[Kalpesh Patel]

During the actual importation process, GNC always shows a confirmation dialogue 
box to take an action on all transaction it found. This is where you get a 
chance to select 'A' to add transaction, 'U+C' to update and clear matched one, 
'C' to clear existing matched one, or select nothing and do nothing with that 
transaction. This is automatic -- ie there is nothing needs to be done, either 
via setting or manually, to trigger it to come up during every import. Note 
that if a transaction is matched incorrectly, you can check either 'U+C' or 'C" 
and then double clicking on it will bring up another dialogue box with a list 
of transactions it believe matches or are similar from which you can select on 
that it should match with. 

-Original Message-
From: Tom Balazs  
Sent: Friday, December 22, 2023 7:02 AM
To: Post to GnuCash User 
Subject: [GNC] View Transactions After Importing from CSV

I'm using Financisto+ on my Android phone. So I am often exporting transactions 
from that, and importing them into GnuCash. Is there an option where I can view 
the transactions I just imported? So they appear on one page, as if I did a 
Find in GnuCash. I think I came across that once, but I can't find it again.

Tom


___
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] Accounting Period Change issue

[Kalpesh Patel]

Thank you, for being flameless. My ears are all yours to listen to the 
explanation...

I actually didn’t tell the whole story ... I did software development for good 
chuck of my early career in the computer field (worked with through 
MIL-STD-2167/A when it was de-facto).

I am concurring that DATA is in a file of "program data" that gets read in when 
the "program" starts and that the "change accounting period" function changes 
this data. I am not sure I concur that to get it to take effect the program has 
to be shut down and start again manually. During the input phase of the change, 
upon confirmation "click" a call to start again just that portion of the 
program is doable, IMHO. It may require implementing a different sub-routine or 
sub-function if the existing one is not sufficient to do so. 

I personally write init routines to take a parameter that has value of "COLD", 
"WORM", "HOT" or nothing (which would default to "COLD") and then branch & 
execute appropriately. If it is in files of "program data" and is not peek-only 
then it is likely to be poked and so that poking at any time should be 
accounted for in "program". I am thinking of examples like say you have to 
install device driver in an OS, have to update routines in Voyager 1 or 2, 
modify systems during Apollo 13 mission, fighter pilot needing to input new 
coordinates, etc. While GNC may not be at the same "critical" level as those 
examples, we shouldn't nonetheless not have sight of it. 
 
I definitely see that you have employed very fail-safe workflow -- for that I 
commend you for it and my hats offs to you...

-----Original Message-
From: Michael or Penny Novack  
Sent: Monday, December 18, 2023 8:54 PM
To: Kalpesh Patel 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Accounting Period Change issue

On 12/18/2023 3:11 PM, Kalpesh Patel wrote:
> Hmmm!
>
> For 1) see the attached jpg. It describes the situation that no one wants to 
> be in (fyi - I am current practitioner in IT/Systems/Engineering/Software 
> world) ... it's a defect; not a bug.
>
> For 2), if I am spending energy to change it deliberately then I want to see 
> updated values; why else would I be making that change? Definitely not to 
> have a self-exploding time bomb for the future. It is a refresh/redraw issue 
> and is not an error in calculation issue, as it does eventually displays 
> correct values.
>
> I get feeling that I am going to get flamed...

No, not flamed, explained.

So you have enough experience in the IT world to understand that this is a 
"refresh" issue. That the DATA (that defines current accounting
period) is going to be in a file of "program data" that gets read in when the 
program starts and that the "change accounting period" function changes this 
data. To get it to take effect the program has to start again.

If you don't want to "leave a time bomb for the future", want to "see it now", 
just do a save, close, (re)open immediately after making the change to 
accounting period. If you don't want to interrupt your work flow (say entering 
a stack of transactions), the change will appear the NEXT TIME you open gnucash 
(not far in the future).  Not having it automatic gives you the choice. 
Personally I like all saves to be explicit, known points in my workflow. I am 
rarely entering transactions "real time" or in date order so want to know 
exactly where I was in the work flow each save.

Michael D Novack

PS -- that "not in real time" means I would be using explicit dates for 
reports, etc. and not things like "current accounting period" which are 
relative to real time.


___
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] Accounting Period Change issue

[Kalpesh Patel]

Haha…

 

Honey Butter Cinnamon Sweet Potato Fries, please … two of them.

 

 

From: G R Hewitt  
Sent: Monday, December 18, 2023 3:32 PM
To: Kalpesh Patel ; GnuCash User List 

Subject: Re: [GNC] Accounting Period Change issue

 

Will you want fries with that?

 

On Mon, 18 Dec 2023 at 20:13, Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

Hmmm!

For 1) see the attached jpg. It describes the situation that no one wants to be 
in (fyi - I am current practitioner in IT/Systems/Engineering/Software world) 
... it's a defect; not a bug.

For 2), if I am spending energy to change it deliberately then I want to see 
updated values; why else would I be making that change? Definitely not to have 
a self-exploding time bomb for the future. It is a refresh/redraw issue and is 
not an error in calculation issue, as it does eventually displays correct 
values. 

I get feeling that I am going to get flamed...

-Original Message-
From: Michael or Penny Novack mailto:stepbystepf...@comcast.net> > 
Sent: Monday, December 18, 2023 8:45 AM
To: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] Accounting Period Change issue

> In trying to track down a Total (Period) issue, I used Edit -> Preferences -> 
> Accounting Period to change the Start Date and End Date fields to Absolute 
> dates.
> After doing Close of that dialog,
> there appeared to be no change
> in the values in the Total (period) column.
> I expected a change, but maybe it is working as designed.
>
> However, after closing and reopening GnuCash, there then were changes in the 
> values.

Did you want an EXPLANATION of this behavior? (why you had to close, then 
reopen the application before the change "took effect")

As a retired senior systems analyst who has designed a lot of software, even 
without examining the code:

1) I am not surprised by this behavior and almost certain about WHY the program 
behaves this way. Definitely not a "bug".

2) If the user desired behavior were to have this action take place upon 
closing the dialog (without doing  a manual save/close/reopen) the change in 
the program to make that happen would be an automated save/close/reopen. That 
could cause its own user confusion. I'd rather KNOW when each "save" was done 
(where was I in the work flow)

Michael D Novack


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

Re: [GNC] Import issue

[Kalpesh Patel]

Thank you for that excellent insight. 

I'll review the code to see if there is anything glaring that I can see before 
going on the code modification/compile/test cycles. If I have query in regards 
to the C++ code, shall I do so here or shall I switch over to the 
gnucash-devel?  

-Original Message-
From: john  
Sent: Monday, December 18, 2023 8:55 PM
To: Kalpesh Patel 
Cc: David Carlson ; Gnucash Users 

Subject: Re: [GNC] Import issue

Somebody commented out all of the DEBUG logging statements in 
import-backend.cpp so you'd need to uncomment them then build GnuCash yourself, 
after which you'd run it from the command line with --log gnc.import=debug to 
get the messages added to the tracefile. Dunno how enlightening that would be. 
FWIW the matching function starts at 
https://github.com/Gnucash/gnucash/blob/bf460b0040f8c9837cca198a9daba83a91c6c35b/gnucash/import-export/import-backend.cpp#L560.

There is one other option besides importing the transaction as a new one: Don't 
import it at all by unchecking all three checkboxes in the match window.

Regards,
John Ralls


> On Dec 18, 2023, at 16:02, Kalpesh Patel  wrot
> 
> I had replied as part of broader response, hence the reason for leaving it 
> out to the group. Anyways, thank you for doing so.
> 
> 
> 
> While behavior you mentioned is also related to matcher engine during import, 
> Gyle’s issue seems not to intersect with yours (function vs. UI).
> 
> 
> 
> Yes, I have seen behavior where GNC does not present the correct, or any 
> existing transaction to match an incoming transaction to during the import as 
> you mentioned but for me it shows up on very rare occasion. I use the same 
> work around, i.e., import it as a new. I had done cursory debugging and I 
> believe I had vaguely narrowed it down to a reason that the transaction that 
> was already present before import had a date that was AFTER the same 
> to-be-matched transaction in the import. I believe I see them for so called 
> “Early Direct Deposit” transaction types. I haven’t paid close attention in 
> the past but now I’ll have to pay close attention to see what the state of 
> transactions are when it happens next time. It makes logical sense that 
> matcher engine would be working with transactions  from the register that is 
> cutoff past “now” for matching.
> 
> 
> 
> I wonder if there is a way to set the matcher engine in a debug mode, similar 
> to F::Q debug facility. I am still on 4.14 version of GNC but I wouldn’t mind 
> a pointer to a documentation showing debugging various major functions. 
> 
> 
> 
> From: David Carlson  <mailto:david.carlson@gmail.com>>
> Sent: Monday, December 18, 2023 5:51 PM
> To: Kalpesh Patel  <mailto:kalpesh.pa...@usa.net>>; Gnucash Users 
> mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Import issue
> 
> 
> 
> You forgot to cc to users.  I did it for you this time.
> 
> 
> 
> My point was that, like the OP, sometimes GnuCash does not present the 
> correct, or any existing transaction to match an incoming transaction to 
> during the import, so the only option left is to import as new.
> 
> There is no option to create a match to an arbitrary existing transaction 
> that GnuCash did not offer.
> 
> 
> 
> This is a sticky wicket anyway, because there is always the possibilty of 
> many very similar existing transactions to choose from in some cases.
> 
> 
> 
> For OFX imports there is the extra possibility that the UUID may have been 
> previously used or re-used inadvertantly,  but I know I see a few cases where 
> that is not the reason that there is no match offered.
> 
> 
> 
> 
> 
> 
> 
> On Mon, Dec 18, 2023, 1:30 PM Kalpesh Patel  <mailto:kalpesh.pa...@usa.net><mailto:kalpesh.pa...@usa.net> > wrote:
> 
> In case you didn’t see the email, for " In those cases I just import the 
> transaction unmatched, but It would be nice to have a way to force those 
> matches." you'll need to set the transaction as either 'U+C' or 'C' and then 
> double-clicking that transaction will bring up 'Select matching existing 
> transaction' window where you can set the correct match.
> 
> -Original Message-
> From: David Carlson  <mailto:david.carlson@gmail.com> 
> <mailto:david.carlson@gmail.com> >
> Sent: Sunday, December 17, 2023 11:01 PM
> To: Gyle McCollam mailto:gmccol...@live.com> 
> <mailto:gmccol...@live.com> >
> Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
> <mailto:gnucash-user@gnucash.org>
> Subject: Re: [GNC] Import issue
> 
> Gyle,
> 
> I have sometimes had GnuCash fail to match transactions with equal amounts 
> and dates.  I do not

Re: [GNC] Import issue

[Kalpesh Patel]

I had replied as part of broader response, hence the reason for leaving it out 
to the group. Anyways, thank you for doing so.

 

While behavior you mentioned is also related to matcher engine during import, 
Gyle’s issue seems not to intersect with yours (function vs. UI).

 

Yes, I have seen behavior where GNC does not present the correct, or any 
existing transaction to match an incoming transaction to during the import as 
you mentioned but for me it shows up on very rare occasion. I use the same work 
around, i.e., import it as a new. I had done cursory debugging and I believe I 
had vaguely narrowed it down to a reason that the transaction that was already 
present before import had a date that was AFTER the same to-be-matched 
transaction in the import. I believe I see them for so called “Early Direct 
Deposit” transaction types. I haven’t paid close attention in the past but now 
I’ll have to pay close attention to see what the state of transactions are when 
it happens next time. It makes logical sense that matcher engine would be 
working with transactions  from the register that is cutoff past “now” for 
matching.

 

I wonder if there is a way to set the matcher engine in a debug mode, similar 
to F::Q debug facility. I am still on 4.14 version of GNC but I wouldn’t mind a 
pointer to a documentation showing debugging various major functions. 

 

From: David Carlson  
Sent: Monday, December 18, 2023 5:51 PM
To: Kalpesh Patel ; Gnucash Users 

Subject: Re: [GNC] Import issue

 

You forgot to cc to users.  I did it for you this time.

 

My point was that, like the OP, sometimes GnuCash does not present the correct, 
or any existing transaction to match an incoming transaction to during the 
import, so the only option left is to import as new.

There is no option to create a match to an arbitrary existing transaction that 
GnuCash did not offer.

 

This is a sticky wicket anyway, because there is always the possibilty of many 
very similar existing transactions to choose from in some cases.

 

For OFX imports there is the extra possibility that the UUID may have been 
previously used or re-used inadvertantly,  but I know I see a few cases where 
that is not the reason that there is no match offered.

 

 

 

On Mon, Dec 18, 2023, 1:30 PM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

In case you didn’t see the email, for " In those cases I just import the 
transaction unmatched, but It would be nice to have a way to force those 
matches." you'll need to set the transaction as either 'U+C' or 'C' and then 
double-clicking that transaction will bring up 'Select matching existing 
transaction' window where you can set the correct match.

-Original Message-
From: David Carlson mailto:david.carlson@gmail.com> > 
Sent: Sunday, December 17, 2023 11:01 PM
To: Gyle McCollam mailto:gmccol...@live.com> >
Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
Subject: Re: [GNC] Import issue

Gyle,

I have sometimes had GnuCash fail to match transactions with equal amounts and 
dates.  I do not know why but I suspect either there is insufficient matching 
text in the description or there is a different reason blocking the match.  In 
those cases I just import the transaction unmatched, but It would be nice to 
have a way to force those matches.



On Tue, Dec 12, 2023 at 5:51 PM Gyle McCollam mailto:gmccol...@live.com> > wrote:

> I'm importing a credit card statement and matching to transactions 
> already entered.  I have a transaction recorded on 11/08/2023 that was 
> processed by the credit card company on 11/12/2023, 4 days later.  It 
> is not matching with the entered transaction even though the amount is 
> identical.  I've looked at the preferences for importing and attached 
> a screenshot.  I don't know what I'm doing wrong.  Is there a way to 
> select the item in the import screen and tell it to match to the 11/08/2023 
> transaction?
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com <mailto:gmccol...@live.com> 
> <mailto:gmccol...@gyleshomes.com <mailto:gmccol...@gyleshomes.com> >  
>  email
> ___
> 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.
>


--
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
-
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 issue

[Kalpesh Patel]

After spending some time looking at downloaded data, I've noticed that, sadly, 
a lot of banks and credit card companies are now appending dates in the far 
right to the description of the actual transactions which makes them very hard 
to zero in as a match when imported. You'll need to play around with the import 
settings via 'Edit' -> 'Preferences' -> 'Import' to adjust so that it matches 
more transactions then not. I also now and then purge out prior learned matches 
for a specific account so the algorithm can relearn again. 

Keep in mind that there is no requirements for financial institutions to 
describe same transaction same way in a bill nor there are any collaborations 
amongst financial institutions to standardize them. Credit card companies are 
notorious for this kinds of shenanigan, perhaps rightfully so as they try to 
"pass-through" that info that third parties provide who are the actual 
executors of the transactions (ex: a customer of Walmart places an online order 
and pays by PayPal account which is backed by a BofA Credit Card who issues the 
bill; those intermediaries can fudge it anyway they like). This is where our 
help comes in to train them ... aka manual match.

Another thing to keep in mind is how the quality of the data and how data is 
formatted for the import. More often than not a space(s) prefixing and/or 
suffixing the numeric value gets to be evaluated as a string, thus 
consequentially failing to match against a numeric value. I haven't looked at 
the GNC code so not sure what tactical GNC takes to normalize but this 
possibility is there so throwing it out there. (This is why in CSV, you don’t 
want to enclose numeric value in a single or double quotes)

While the automatic matches may not be concurred by GNC due to variety of the 
reasons, you always can manually match it, whether transaction is reconciled or 
not. This can only help improve the matcher algorithm. I've always seen 
'Generic import transaction matcher' window pop up just before accepting them 
which gives me an opportunity to manually match it if it failed to match it or 
match is incorrect one. You'll need to set the transaction as either 'U+C' or 
'C' and then double-clicking that transaction will bring up 'Select matching 
existing transaction' window where you can set the correct match.

-Original Message-
From: David Carlson  
Sent: Sunday, December 17, 2023 11:01 PM
To: Gyle McCollam 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Import issue

Gyle,

I have sometimes had GnuCash fail to match transactions with equal amounts and 
dates.  I do not know why but I suspect either there is insufficient matching 
text in the description or there is a different reason blocking the match.  In 
those cases I just import the transaction unmatched, but It would be nice to 
have a way to force those matches.



On Tue, Dec 12, 2023 at 5:51 PM Gyle McCollam  wrote:

> I'm importing a credit card statement and matching to transactions 
> already entered.  I have a transaction recorded on 11/08/2023 that was 
> processed by the credit card company on 11/12/2023, 4 days later.  It 
> is not matching with the entered transaction even though the amount is 
> identical.  I've looked at the preferences for importing and attached 
> a screenshot.  I don't know what I'm doing wrong.  Is there a way to 
> select the item in the import screen and tell it to match to the 11/08/2023 
> transaction?
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
> ___
> 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.
>


--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting Period Change issue

[Kalpesh Patel]

There was an outstanding bug reported for it ... and fixed but somehow it might 
be back again: https://bugs.gnucash.org/show_bug.cgi?id=798709
There was an old bug reported as well: 
https://bugs.gnucash.org/show_bug.cgi?id=745841


-Original Message-
From: Fred Tydeman  
Sent: Sunday, December 17, 2023 5:05 PM
To: Gnucash Users 
Subject: [GNC] Accounting Period Change issue

In trying to track down a Total (Period) issue, I used Edit -> Preferences -> 
Accounting Period to change the Start Date and End Date fields to Absolute 
dates.
After doing Close of that dialog,
there appeared to be no change
in the values in the Total (period) column.
I expected a change, but maybe it is working as designed.

However, after closing and reopening GnuCash, there then were changes in the 
values.


___
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] USAA OFX Direct Connect stopped working

[Kalpesh Patel]

It might be wise to wait until after the weekend is over.

As an IT person I can tell, at least from my experience leading teams, that
disruptive and or large changes/releases tend to get scheduled over the
weekend. If they are updating then by Monday market open they end up being
auto-magically "fixed". Of course if the function is being decommissioned
then it will never work again ... 

-Original Message-
From: john  
Sent: Friday, December 15, 2023 12:24 PM
To: John Haiducek 
Cc: GNU Cash User 
Subject: Re: [GNC] USAA OFX Direct Connect stopped working



> On Dec 14, 2023, at 20:43, John Haiducek  wrote:
> 
> Downloading transactions from USAA accounts stopped working for me today.
> In the past I've been able to restore access by following the 
> instructions at 
> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA 
> and getting an accessid from http://usaa.com/accessid or 
> https://df3cx-services.1fsapi.com/casm/usaa/enroll. However, now both of
those websites redirect to a page that returns the following in JSON:
> 
> {
> "error": "invalid_request",
> "error_description": "Validation error"
> }
> 
> Does anyone know a workaround for this? Is there an updated URL I can use?

I had the same problem yesterday. I worked around it by downloading a CSV of
the transactions from the account and importing that instead.

It's possible that it's just a glitch that will get corrected in a few days.
If not we'll need someone with Quicken and Wireshark to snarf the new secret
handshake.

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Nice to Have?

[Kalpesh Patel]

I think Grace means that when you fire up GNC, it displays scheduled 
transaction window which has all of the transactions configured in that book. 
She (and I) think just displaying what is being added at that firing up should 
display only for the ones that are applicable for that fire up and not any 
other ones that are scheduled further in the future from now. I even go one 
further and say that if there aren't any to be applied then it should not 
display the window at all (perhaps another configuration parameter to add).

-Original Message-
From: Adrien Monteleone  
Sent: Thursday, December 14, 2023 11:50 AM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Nice to Have?

If I'm not mistaken, that is part of the setting for each Scheduled 
Transaction. You set how many days in advance you want it to remind you. 
If you would only want same-day, I'm hazarding a guess that "0" days would 
work. If that doesn't, try "1" day.

I don't think this is configurable for all transactions together. It is a 
case-by-case basis.

Regards,
Adrien

On 12/14/23 10:19 AM, Grace wrote:
> I don't know if this is the correct place to ask for a "Nice to Have".
> 
> My request is that the window that displays scheduled transactions to 
> be posted today, could only display those transactions being posted today.
> At the moment it displays all the scheduled transactions. For me it 
> would be nice if it just showed those being processed today.



___
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] Definition of document root

[Kalpesh Patel]

I set my global as either '/' (root) on *NIX systems or "file://C:\" or 
applicable drive letter where they are located on Windows. There are many way 
to slice-&-dice the path ... this at least forces me to make sure that all 
computers that I make use of have a consistent location for storing data which 
eases and allows teleporting backup and recovery policies across systems.
 
-Original Message-
From: Brook Milligan  
Sent: Sunday, December 10, 2023 10:18 PM
To: Gnucash Users 
Subject: [GNC] Definition of document root

The root path to the set of documents that can be linked to Gnucash 
transactions can be set via the “settings” menu.  However, this seems to be a 
global value; i.e., it applies to all book files.  That is fine if there is a 
single location in the file system for documents for all books, but it seems 
much more logical to store books and documents together in their own 
directories.  

This suggests that the root path for documents should be a book-specific, not a 
global, attribute.  Ideally, it would be possible to have a global value that 
can be replaced by a book-specific value, as that would retain the current 
behavior yet accommodate the more natural (at least to me) organization of all 
book-specific things together.

Does this make sense?  Am I missing the fact that this can already be done?  
Would it be hard to implement this?

Thanks for your thoughts.

Cheers,
Brook



___
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 change date of balance on register?

[Kalpesh Patel]

There is really not a way to specify the date range the way I think you want to 
-- like today to end-of-month or today to infinity -- that is somewhat 
dynamically adjusting per se. As David mentioned, you can select from pre-built 
ones by putting a check mark in the ones that you want to display in the 
Account page. Out of those ones, I'll say 'Present (USD)' is likely to give you 
the closest one as it will normalize all accounts in to common USD basis rather 
than just 'Present' as you will not see the monetary value but amount of shares 
for each issue you have. If you want a bit more "custom" then you can enable 
view by 'Period' or 'Period (USD)' and then you can set the period range in 
'Edit' -> 'Preference' -> 'Accounting Period' sheet.   

-Original Message-
From: David H  
Sent: Sunday, December 10, 2023 5:32 PM
To: Alan Johnson 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] How to change date of balance on register?

If you click on the down arrow in the header line of the accounts tab far right 
you can select lots of dates, see below - try "Present" 

Cheers David H.

[image: image.png]


On Mon, 11 Dec 2023 at 08:12, Alan Johnson via gnucash-user < 
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I'm running GnuCash 5.4.1 flathub.
>
> Is there a way to change the date of balance shown in the account 
> overview?
>
> For example, I have a checking account with 10,000 in it today.  I 
> have a couple transactions that are future dated which decrease the balance.
>  On the Accounts page, it shows the lower balance of the future amount.
> Is there a way to change which date is the reference date for 
> displaying the balance?
>
> Thanks,
> Alan
> ___
> 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] Advise me please: go up to 5.4.2 or stay at 4.13?

[Kalpesh Patel]

I am believer in the maxim 'If it ain't broke, don't fix it' but today’s world 
is quite different then yesteryears. The “on-line” world isn’t that forgiving 
and it is hard to live without it so tread wisely.

 

I still have a fully functional Windows 10 desktop running on Intel Core 2 Quad 
Q6600 that was put together back in 2008… 

 

From: G R Hewitt  
Sent: Tuesday, December 05, 2023 12:45 PM
To: Kalpesh Patel ; GnuCash User List 

Subject: Re: [GNC] Advise me please: go up to 5.4.2 or stay at 4.13?

 

There is always a drive to have the latest iteration of this, that and the 
other - out with the old and in with the new.

My MacPro was bought off my son when his firm upgraded his to the latest (being 
Apple they could afford to) and he was able to buy it from them.

It is a Mid 2010 and I have had it for 8 years and it does everything I need. I 
have a 2017 iMac too, but my main go-to is the MacPro.

 

My point in telling you that is that if your current set up does all you 
require, and you have no need for additional bells and whistles, I'd stick with 
it

and save yourself the hassle of learning a new set of features and their 
attendant bugs. The maxim 'If it ain't broke, don't fix it' comes to mind.

 

But. If you are full of daring-do and to hell with the consequences, by all 
means upgrade, I did and I quite like it and with the pleasing interface 
make-over

provided by a list member whose name regretfully escapes me, I'm very happy 
with it.

 

If you can't make your mind up, toss a coin and if you are not happy with the 
result, do the opposite.  

 

 

On Tue, 5 Dec 2023 at 13:39, Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

I am of the opinion that if you plan to stay on 4 series version then move up 
to its latest version which is 4.14.

-Original Message-
From: Eric Chapman mailto:gnucashl...@etchapman.com> > 
Sent: Monday, December 04, 2023 7:37 PM
To: GNUcash User List mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Advise me please: go up to 5.4.2 or stay at 4.13?

Adrien,

Thank you. That reminds me of what I'd read. I guess it was the auto-completing 
I noticed driving folks crazy at first. I think what I'll do is close the books 
(if I get advice to do so) on the 2022 numbers, and then upgrade to 5.4 and try 
it out for the 2023 data.

Gratefully,
Eric

On 12/4/23 16:26, Adrien Monteleone wrote:
> The 5.x series introduced a new way of auto-completing Descriptions. 
> (you get a drop down list to choose from if you want to)
>
> There are some kinks for a few folks, and the new method takes a 
> little getting used to, but overall I find it to be a vast 
> improvement. Some folks aren't so keen on it though.
>
> Many bugs have been fixed since 4.x. If you want a list, see the 
> release notes for each release. (5.0, 5.1, etc.)
>
> Regards,
> Adrie


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

Re: [GNC] Advise me please: go up to 5.4.2 or stay at 4.13?

[Kalpesh Patel]

I am of the opinion that if you plan to stay on 4 series version then move up 
to its latest version which is 4.14.

-Original Message-
From: Eric Chapman  
Sent: Monday, December 04, 2023 7:37 PM
To: GNUcash User List 
Subject: Re: [GNC] Advise me please: go up to 5.4.2 or stay at 4.13?

Adrien,

Thank you. That reminds me of what I'd read. I guess it was the auto-completing 
I noticed driving folks crazy at first. I think what I'll do is close the books 
(if I get advice to do so) on the 2022 numbers, and then upgrade to 5.4 and try 
it out for the 2023 data.

Gratefully,
Eric

On 12/4/23 16:26, Adrien Monteleone wrote:
> The 5.x series introduced a new way of auto-completing Descriptions. 
> (you get a drop down list to choose from if you want to)
>
> There are some kinks for a few folks, and the new method takes a 
> little getting used to, but overall I find it to be a vast 
> improvement. Some folks aren't so keen on it though.
>
> Many bugs have been fixed since 4.x. If you want a list, see the 
> release notes for each release. (5.0, 5.1, etc.)
>
> Regards,
> Adrie


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

[Kalpesh Patel]

In case anyone has curiosity for the CPAN module configuration settings,
refer to https://metacpan.org/pod/CPAN#Config-Variables link.

-Original Message-
From: Kalpesh Patel  
Sent: Monday, December 04, 2023 1:23 PM
To: 'James Edmunds' 
Cc: 'Geoff' ; gnucash-user@gnucash.org
Subject: Re: [GNC] Finance::Quote upgrade

As a post-install note, the Perl's CPAN module may not be configured sanely
or configuration initialized at all. 

Normally if the CPAN's 'prerequisites_policy' setting (configured with
'follow' option), 'build_requires_install_policy' setting (with 'yes') and
'make' settings (with fully qualified path to a make that is found by search
or compatible one) are properly set then that should have installed all
pre-requisite dependencies automatically. These are the sane defaults that
gets configures with when CPAN module is initialized.

You may want to review for future updates/upgrades.


-Original Message-
From: James Edmunds 
Sent: Monday, December 04, 2023 10:25 AM
To: Geoff ; gnucash-user@gnucash.org
Subject: Re: [GNC] Finance::Quote upgrade

I have fixed the last missing module by "sudo apt-get install
libxml-libxml-perl "

Finance::Quote 1.58  is installed now .
Thank you everybody .

From: gnucash-user 
on behalf of James Edmunds 
Sent: 04 December 2023 12:30
To: Geoff ; gnucash-user@gnucash.org

Subject: Re: [GNC] Finance::Quote upgrade

Geoff
Thank you very much for the " Make"  suggestion , that removed most errors .

Now there is only one error left  -see below "   Module 'XML::LibXML' is not
installed '

I don't know how to fix this .


m@jm-OptiPlex-9020:~$ sudo cpanm Finance::Quote [sudo] password for jm:
--> Working on Finance::Quote
Fetching
http://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.58.tar.gz ...
OK Configuring Finance-Quote-1.58 ... OK ==> Found dependencies: XML::LibXML
--> Working on XML::LibXML
Fetching
http://www.cpan.org/authors/id/S/SH/SHLOMIF/XML-LibXML-2.0209.tar.gz ... OK
==> Found dependencies: Alien::Libxml2
--> Working on Alien::Libxml2
Fetching
http://www.cpan.org/authors/id/P/PL/PLICEASE/Alien-Libxml2-0.19.tar.gz ...
OK Configuring Alien-Libxml2-0.19 ... OK Building and testing
Alien-Libxml2-0.19 ... FAIL ! Installing Alien::Libxml2 failed. See
/root/.cpanm/work/1701691544.81716/build.log for details. Retry with --force
to force install it.
! Installing the dependencies failed: Module 'Alien::Libxml2' is not
installed ! Bailing out the installation for XML-LibXML-2.0209.
! Installing the dependencies failed: Module 'XML::LibXML' is not installed
! Bailing out the installation for Finance-Quote-1.58.
jm@jm-OptiPlex-9020:~$


From: Geoff 
Sent: 04 December 2023 09:04
To: gnucash-user@gnucash.org ; James Edmunds

Cc: Maf. King 
Subject: Re: [GNC] Finance::Quote upgrade

Hi James

You don't need a compiler to install Perl modules like Finance::Quote but
you do need a working "make" utility, which is normally included by default.

Some troubleshooting information here:

https://www.phind.com/search?cache=xbbtjpvwn5ifzh8wmo7htxet

Hope this helps.

Geoff
=

On 4/12/2023 7:48 pm, Maf. King wrote:
> On Monday, 4 December 2023 07:55:05 GMT James Edmunds wrote:
>> I tried to upgrade from Ubuntu 18.04 to Ubuntu 20.04  . There was 
>> some file
>
>> ! Can't configure the distribution. You probably need to have 'make'. 
>> See
>
> I don't know the exact package names for Ubuntu, but it looks to me 
> that you need to install (at least) the "make" package, and quite 
> possibly some other build / compile/ development stuff.
>
> good luck.
> 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] Display of 'Rate' column for Bank accounts type

[Kalpesh Patel]

Auto sizing it keeps it visible (by width of ‘Rate’ text), however, 
grabbing-&-dragging works fine.

 

Thank you for that pointer!

 

From: David H  
Sent: Monday, December 04, 2023 2:36 PM
To: Kalpesh Patel 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Display of 'Rate' column for Bank accounts type

 

Kalpesh,

 

From memory this is the always there, usually hidden, 1 pixel wide Rate column. 
 You have inadvertently made it wider than the default 1 pixel. Try grabbing 
the right hand column header and dragging it back or double click the header to 
auto size it back to 1 pixel when it will disappear from view once again.  
Search the archives for more info - it comes up every couple of years :-)

 

Cheers David H.

 

 

On Tue, 5 Dec 2023 at 04:44, Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

Hi GNC users community -



For some of the accounts that are of type Bank are showing 'Rate' column
after 'Balance' column in the transactions window. Anyone know how I may
have turned on display of that column and how I can turn it off? The ones
that show and the ones that do NOT show the 'Rate' column are under the same
parent sub-account that is also type Bank and it is NOT set to hidden or
placeholder so it seems account specific setting somewhere. This behavior is
seen in version 4.18 running on Windows 11.



Any insight is appreciated.

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

[GNC] Display of 'Rate' column for Bank accounts type

[Kalpesh Patel]

Hi GNC users community -

 

For some of the accounts that are of type Bank are showing 'Rate' column
after 'Balance' column in the transactions window. Anyone know how I may
have turned on display of that column and how I can turn it off? The ones
that show and the ones that do NOT show the 'Rate' column are under the same
parent sub-account that is also type Bank and it is NOT set to hidden or
placeholder so it seems account specific setting somewhere. This behavior is
seen in version 4.18 running on Windows 11.

 

Any insight is 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
-
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 upgrade

[Kalpesh Patel]

As a post-install note, the Perl's CPAN module may not be configured sanely
or configuration initialized at all. 

Normally if the CPAN's 'prerequisites_policy' setting (configured with
'follow' option), 'build_requires_install_policy' setting (with 'yes') and
'make' settings (with fully qualified path to a make that is found by search
or compatible one) are properly set then that should have installed all
pre-requisite dependencies automatically. These are the sane defaults that
gets configures with when CPAN module is initialized.

You may want to review for future updates/upgrades.


-Original Message-
From: James Edmunds  
Sent: Monday, December 04, 2023 10:25 AM
To: Geoff ; gnucash-user@gnucash.org
Subject: Re: [GNC] Finance::Quote upgrade

I have fixed the last missing module by "sudo apt-get install
libxml-libxml-perl "

Finance::Quote 1.58  is installed now .
Thank you everybody .

From: gnucash-user 
on behalf of James Edmunds 
Sent: 04 December 2023 12:30
To: Geoff ; gnucash-user@gnucash.org

Subject: Re: [GNC] Finance::Quote upgrade

Geoff
Thank you very much for the " Make"  suggestion , that removed most errors .

Now there is only one error left  -see below "   Module 'XML::LibXML' is not
installed '

I don't know how to fix this .


m@jm-OptiPlex-9020:~$ sudo cpanm Finance::Quote [sudo] password for jm:
--> Working on Finance::Quote
Fetching
http://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.58.tar.gz ...
OK Configuring Finance-Quote-1.58 ... OK ==> Found dependencies: XML::LibXML
--> Working on XML::LibXML
Fetching
http://www.cpan.org/authors/id/S/SH/SHLOMIF/XML-LibXML-2.0209.tar.gz ... OK
==> Found dependencies: Alien::Libxml2
--> Working on Alien::Libxml2
Fetching
http://www.cpan.org/authors/id/P/PL/PLICEASE/Alien-Libxml2-0.19.tar.gz ...
OK Configuring Alien-Libxml2-0.19 ... OK Building and testing
Alien-Libxml2-0.19 ... FAIL ! Installing Alien::Libxml2 failed. See
/root/.cpanm/work/1701691544.81716/build.log for details. Retry with --force
to force install it.
! Installing the dependencies failed: Module 'Alien::Libxml2' is not
installed ! Bailing out the installation for XML-LibXML-2.0209.
! Installing the dependencies failed: Module 'XML::LibXML' is not installed
! Bailing out the installation for Finance-Quote-1.58.
jm@jm-OptiPlex-9020:~$


From: Geoff 
Sent: 04 December 2023 09:04
To: gnucash-user@gnucash.org ; James Edmunds

Cc: Maf. King 
Subject: Re: [GNC] Finance::Quote upgrade

Hi James

You don't need a compiler to install Perl modules like Finance::Quote but
you do need a working "make" utility, which is normally included by default.

Some troubleshooting information here:

https://www.phind.com/search?cache=xbbtjpvwn5ifzh8wmo7htxet

Hope this helps.

Geoff
=

On 4/12/2023 7:48 pm, Maf. King wrote:
> On Monday, 4 December 2023 07:55:05 GMT James Edmunds wrote:
>> I tried to upgrade from Ubuntu 18.04 to Ubuntu 20.04  . There was 
>> some file
>
>> ! Can't configure the distribution. You probably need to have 'make'. 
>> See
>
> I don't know the exact package names for Ubuntu, but it looks to me 
> that you need to install (at least) the "make" package, and quite 
> possibly some other build / compile/ development stuff.
>
> good luck.
> 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] Reconciliation with a strange opening balance

[Kalpesh Patel]

While "Finding reconciliation discrepancies from previous statements can be
extremely tedious and GnuCash doesn't have any tools to help. There's not
even a way to display historical reconciled balances." is correct, the Banks
(and by their proxy their Information Systems) have stepped up and have
gotten to the point where their online portals (that is if you have signed
up for it) have very good filtering capabilities when it comes to displaying
transactions by date range. In the US the Banks are required to keep 7 years
of statement available, and most banks now do very good job to getting them
to you at a moment's notice. 

Here is what I do that has worked well for me: 
If there were any unintended entries gotten added after reconcile  ('y' or
'c') then they normally appear as unreconciled ('n') which you can filter by
that status in the register (assuming that you normally reconcile accounts
like Bank, Credit Card and/or Investment accounts). This is likely to be
able to flag it down very quickly. If your last reconciled register suddenly
appears out-of-sync with respect to bank statement then review previous
statement(s). Check the beginning and ending balance of previous statements
and if they do not match then go back one more statement and compare. Rinse
and repeat until you get to the statement that actually matches. Your
culprit is likely to be somewhere in the statement following the one that
matches. Use the previous step of transaction status to locate the errant
entry and then correct as necessary. 

-Original Message-
From: john  
Sent: Monday, November 13, 2023 3:55 PM
To: Mahon Finbar 
Cc: Gnucash Users 
Subject: Re: [GNC] Reconciliation with a strange opening balance



> On Nov 13, 2023, at 07:20, Mahon Finbar via gnucash-user
 wrote:
> 
> Hello,
> 
> The recent discussion on reconciliation was helpful in trying to sort out
some anomalies I have.
> 
> When I do the latest reconciliation of one of my accounts the opening
balance is 10,448.43 and gives me an amount of inbalance which is way off.
> 
> Following the advice in the recent posts I tried working backwards to see
if I could find any errors.
> 
> I got close to 0.00 from time to time and was satisfied enough to consider
a balancing entry, but was intrigued on where the 'error' might have been.
> 
> I set off to see where, but, in the course of my search, I tried to find
the number 10,443.43 in the account, as a baseline, but didn't find one.
> 
> If I understand the process of reconciliation the number should be
somewhere in the account, should it not??
> 
> Just tell me I am barking up the wrong tree, if I am making an error.

The reconcile info dialog that comes up when you click the reconcile button
has two balances: Starting balance and Ending balance. The first is the
reconciled balance for the account, that is the sum of all of the splits in
the account marked as reconciled. That's different from the opening balance,
which is the amount in the account when you created it in GnuCash. The
starting balance should match the starting balance on your statement. If it
doesn't then there's a mistake in reconciling a previous statement and you
need to either make a correcting entry in your account to get it to match or
dig through previous statements to try to find the discrepancy. The Ending
balance is what you should enter from your account statement or your bank's
website. It defaults to the balance of the last transaction on the date you
entered in the Reconciliation date entry.

When you finish that dialog the reconcile window opens and in the lower left
it shows the balances from the info window followed by Reconciled balance
and Difference, which update as you tick off transactions in the two panes
of the window; you should tick off the transactions that match your
statement, paying close attention to the amounts: Reconciliation is all
about making sure that there aren't any differences. Fix any differences in
the register and press enter to commit the change and it will be immediately
reflected in the  reconcile window. Once you have marked all of the
transactions the Ending and Reconciled balances should match, Difference
should be 0, and the Finish button in the toolbar should be enabled. 

You might not have a transaction balance matching the reconciled balance if
you have unbalanced transactions previous to the last reconciled one.  The
"R" column between Transfer Account and Debit/Deposit shows each
transaction's reconciled status: y for reconciled, n for unreconciled, c for
cleared, and v for voided. You can use the the Status page of View>Filter
By... to hide transactions by status.

Finding reconciliation discrepancies from previous statements can be
extremely tedious and GnuCash doesn't have any tools to help. There's not
even a way to display historical reconciled balances. 

When it comes to fixing discrepancies remember that banks can make errors
too, but you need documentation and time to get the bank 

Re: [GNC] I need basic help

[Kalpesh Patel]

I reckon that is why this wonderful World accommodates more than 'One size fits 
all' ... hence also there are more than one school in the World! 

I mean I go and ask SME's when I am outside of my expertise. I hope nothing is 
wrong with it. Now on to figuring out which school to go ...

-Original Message-
From: G R Hewitt  
Sent: Wednesday, October 25, 2023 1:59 AM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] I need basic help

Good point, which is probably why schools are the worst place to send your 
child, 'One size fits all'.

On Tue, 24 Oct 2023 at 22:39, Liz  wrote:

> On Sat, 21 Oct 2023 09:12:57 -0700
> "Stan Brown (using GC 4.14)"  wrote:
>
> > It strikes me that you're trying to use GnuCash without first 
> > reading the documentation. That's like trying to run before you can walk.
> > Others have already made the suggestion, but maybe you missed their 
> > messages.
>
> People learn in different ways.
> So Edwin learns by doing and asking when reaching a difficulty.
>
>
> 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
> -
> 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] Bulk invoice printing

[Kalpesh Patel]

I believe they are looking for something similar to mailing label creator or 
mail merge in M$ Word, which could in theory work here  unfortunately I 
have never attempted before as I am not a "business" user of GNC so YMMV.

Export out members (vendors?) as a CSV file from GNC, then create a template in 
word of invoice and then print label/mail merge which should get you to print 
in bulk a lot quicker ... last time I did this I remember that it will create a 
file with all invoices with substitutions in them that you can preview before 
printing it.

-Original Message-
From: Adrien Monteleone  
Sent: Tuesday, October 17, 2023 1:36 AM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Bulk invoice printing

You'd still have to generate the PDFs individually, which is just 'printing to 
a file' and so not really saving any clicks. *Then* you need to send them to 
the printer with more clicks as you describe.

I could be mistaken, but I understood the issue was having to go through the 
steps:

1. Generate an Invoice (lots of clicks and typing, even with the duplicate 
function) 2. Print it (select printer, adjust settings, etc.) 3. Repeat for 
each member

While in this case it is only an annual workflow, having more than a dozen or 
so of these to do all at once is tedious, and having 50+ is crazy repetitive 
and a strain on fingers. (and increases the probability of doing something 
wrong due to the monotony)

If steps #1 and #2 aren't done at the same time. Then you could add:

1a. Do a Find for the invoice(s) or open invoices from AR via the 'jump to 
invoice' on the right click menu 1b. Display the Invoice Report

Optionally the steps can be reversed which runs an Invoice Report, and then you 
have to choose which customer and invoice. (even more clicks)

No matter the workflow chosen, lots and lots of clicks are involved with the 
present state of GnuCash. The Business Features were designed for a small 
consultancy that occasionally generates a few invoices. That doesn't mean you 
can't use it otherwise, but it wasn't optimized for other use cases.

Regards,
Adrien

p.s.—you pressed the right button.

On 10/16/23 11:22 PM, John Walker wrote:
> I am unsure if I have pressed the right buttons in replying to Adrien 
> and Arek and everyone else on the list.  Please let me know.
> 
> If printing is your only issue, I suggest that you make pdfs of your 
> invoices through Gnucash and store them all in the same folder.
> 
> When you go to print, use file explorer, go to the pdf folder where 
> your invoices are stored and select which pdf files you want to print.  
> Then, right click on one of the selected files and left click on 
> *print*.  All selected files should print individually for you on your 
> default printer.



___
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] Help

[Kalpesh Patel]

Just to recap what is being asked ... the basics are as follows (which are 
likely covered somewhere in the fine manual):

1A) On Windows, there are steps that you need to take to install Perl and 
Finance::Quote module:
- Click on the search (the magnifying glass) and type in 'Install Online Price 
Retrieval for GnuCash' and click on it.
- Wait some time (might want to get some refreshment while batch script does 
its magic)

OR

1B) On Linux, there are steps that you need to take to install 
Finance::Quote module:
- Open up your favorite shell console, whether sh, csh, zsh, bash or any choice 
of yours
- Run following command (this assume your CPAN is configured correctly - accept 
defaults when running it for the first time): perl -MCPAN -e 'install 
Finance::Quote'
- Wait some time (might want to get some refreshment while Perl does its magic)

2)  Define the security in GNUCASH: 
- On the main window of GNUCASH, click 'Tools' menu and select 'Security 
Editor' from that dropdown
- Click 'Add' button on the lower right corner on the 'Securities' window
- Type in 'Full Name' field (Example: Bank of New York Mellon Corp) in the 'New 
security' window
- Type in 'Symbol/abbreviation' field (Example: BK) in the 'New security' 
window 
- Type in 'Display symbol' field (Example: BK) in the 'New security' window
- Type in 'Namespace' field (Example: NYSE) in the 'New security' window
- Leave blank in 'ISIN, CUSIP or other code' field in the 'New security' window
- Leave 'Fraction traded 1/' field to read '1' in the 'New security' window

- Put a check mark on the 'Get Online Quotes' box by clicking on the box once 
that is in front of it.

- Under 'Type of quote source', click in front of 'Single' circle to select it. 
On the right side of it (which should read 'Alphavantage, US'), click on the 
arrow, scroll all the way down and select 'Yahoo as JSON'.

- Click 'OK' button in the 'New security' window.
- Click 'Close' button in the 'Securities' window.

3)  Retrieve online quotes:
- On the main window of GNUCASH, click 'Tools' menu and select 'Price Database' 
from that dropdown
- Click the arrow in front of the name space (Example from above: NYSE) and you 
should see your security there (Example from above: BK) in the 'Price Database' 
window
- Click the arrow in front of the security (Example from above: BK) and you 
should see no pricing in this newly created security
- Click 'Get Quotes' on the right side of the 'Price Database' window
- Wait some time (might want to get some refreshment while GNUCASH does its 
magic)
- When you get control back, a new line will be added which will be the price 
that GNUCASH retrieved via Perl's Finance::Quote module
- Celebrate success





-Original Message-
From: R Losey  
Sent: Tuesday, October 10, 2023 3:00 PM
To: Murugan Muruganandam 
Cc: gnucash-user@gnucash.org; James Baxter 
Subject: Re: [GNC] Help

To add to Murugan's advice:

What have you done? Have you set up the quotes to get them online? If you're 
not on Linux, you need to install other parts to get online quotes.

Enlighten the list, and you will receive help.

On Tue, Oct 10, 2023 at 6:47 AM Murugan Muruganandam < 
m.muruganan...@hotmail.com> wrote:

> James
>
> you need to give more details on your request, including version of 
> GNU and online quote, operating system and what ticker you aren ot 
> getting quote for.
>
>
> Saludos Cordiales
> Murugan
>
> 
> From: gnucash-user  hotmail@gnucash.org> on behalf of James Baxter via gnucash-user < 
> gnucash-user@gnucash.org>
> Sent: Monday, October 9, 2023 11:40 AM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Help
>
> This is James Baxter.I am writing email asking for help with the 
> import of stock/tickers from the web to Gnucash.
> I am not getting anything on this,
>
> WhyJames baxterkangaro...@yahoo.com
> ___
>
--
_
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.

Re: [GNC] OFX Import Mappings

[Kalpesh Patel]

Did you delete the parent account mapping as well? Assumption here is that you 
are tracking individual mutual funds along with Money Market fund under the 
parent account. You must also delete the parent account mapping as well as 
individual mutual fund mappings that are in that account in the 'Online" side 
of the 'Import Map Editor'. This has worked fine for me in the past so there 
might be some strange and/or odd interaction here that might be the culprit in 
that case. Read the 'Match String' carefully to find the account you want to 
remove the mapping for. Might be worth to undo the placeholder and unhide to 
see if they show up in the 'Online' side of the 'Import Map Editor'.

Income side of the mapping for the Money Market fund is likely to be in the 
'Bayesian' side of the 'Import Map Editor'. That is where it shows up in mine. 

I am uncertain if the account is disabled or not matters in any way for the 
import.

-Original Message-
From: Rob LaRose  
Sent: Friday, October 06, 2023 1:57 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] OFX Import Mappings

I've already searched all the tabs for any occurence of the disabled 
account...there were none.
I'm pretty sure that I've previously deleted all my Vanguard online mappings to 
get a clean slate, but still ended up with GC importing transactions to the 
placeholder account.
I'll try deleting the online mapping again to make sure that I really have 
tried that approach to see if it will reset,

FYI... GC has behaved this way for quite a while now, but frequently I just 
manually enter if there are just a few transactions.
I only think about it when I do an import (like for an end-of-quarter)

On Sun, Oct 1, 2023 at 8:04 PM Kalpesh Patel  wrote:

> Rob - It is Import Map Editor. What you want to select is the 'Online' 
> at the top where you will see three total choices - Bayesian (selected 
> by default), Non-Bayesian and Online. Unfortunately you can only 
> delete entries here in the Import Map Editor so find the one that is 
> errant as mentioned below and delete it. Next time you import it, GNC 
> will ask you to map the account which is the opportunity you want to 
> take to wire it up correctly.
>
> Hope this helps.
>
> -Original Message-
> From: Rob LaRose 
> Sent: Saturday, September 30, 2023 11:54 AM
> To: gnucash-user@gnucash.org
> Subject: [GNC] OFX Import Mappings
>
> Sometime ago, Vanguard replaced one of their Money Market funds with a 
> new Money Market fund.
> In GC, I created a new fund account to handle the change.
> Once all the transfer transactions for the old fund account were 
> complete,
> I:
> - Renamed the account: to move it to the bottom of any acct list as 
> well as identify it as an inactive account
> - Set the account as a placeholder: to prevent accidentally creating 
> transactions
> - Hid the account: so that I wouldn't have to look at it all the time.
>
> However, now when I import an OFX file from Vanguard, income 
> transactions for the new fund account are entered as being sourced 
> from the renamed, placeholder account instead of the appropriate 
> income account for the new fund.
>
> I figured this had something to do with the Import Map Editor.  I 
> searched for the renamed account that GC was using and found no matches.
> I even deleted all the mappings figuring I would just rebuild the 
> account matches but for some reason, it keeps using the old account.
>
> There must be some other location where GC has stored this association.
> How do I resolve the mapping issue so that transactions get associated 
> to the correct income account?
>
> GnuCash: Flatpak v5.4.1
> OS: Ubuntu 23.04
>
> Thanks
> Rob
>
>
>


___
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] OFX Import Mappings

[Kalpesh Patel]

Rob - It is Import Map Editor. What you want to select is the 'Online' at the 
top where you will see three total choices - Bayesian (selected by default), 
Non-Bayesian and Online. Unfortunately you can only delete entries here in the 
Import Map Editor so find the one that is errant as mentioned below and delete 
it. Next time you import it, GNC will ask you to map the account which is the 
opportunity you want to take to wire it up correctly.

Hope this helps.

-Original Message-
From: Rob LaRose  
Sent: Saturday, September 30, 2023 11:54 AM
To: gnucash-user@gnucash.org
Subject: [GNC] OFX Import Mappings

Sometime ago, Vanguard replaced one of their Money Market funds with a new 
Money Market fund.
In GC, I created a new fund account to handle the change.
Once all the transfer transactions for the old fund account were complete,
I:
- Renamed the account: to move it to the bottom of any acct list as well as 
identify it as an inactive account
- Set the account as a placeholder: to prevent accidentally creating 
transactions
- Hid the account: so that I wouldn't have to look at it all the time.

However, now when I import an OFX file from Vanguard, income transactions for 
the new fund account are entered as being sourced from the renamed, placeholder 
account instead of the appropriate income account for the new fund.

I figured this had something to do with the Import Map Editor.  I searched for 
the renamed account that GC was using and found no matches.
I even deleted all the mappings figuring I would just rebuild the account 
matches but for some reason, it keeps using the old account.

There must be some other location where GC has stored this association.
How do I resolve the mapping issue so that transactions get associated to the 
correct income account?

GnuCash: Flatpak v5.4.1
OS: Ubuntu 23.04

Thanks
Rob


___
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] Importing stock prices from a CSV file

[Kalpesh Patel]

Attached is a file of what it would look like with same security prices for 
different day and with multiple of these examples repeated for other securities 
and/or indexes ...

-Original Message-
From: Kalpesh Patel  
Sent: Sunday, October 01, 2023 7:49 PM
To: 'flywire' ; 'Ove Grunnér' 
Cc: 'Gnucash Users' 
Subject: RE: [GNC] Importing stock prices from a CSV file

Just to remove any confusion, the CSV format of the importing stock prices as 
of GNC v4.18 is as follows (which I don’t believe has changed in later and 5.x 
version)...

"NAME_SPACE","TICKER_SYMBOL",date,"PRICE","QUOTE_CURRENCY"

One line per record each formatted as denoted above.
Double quotes around NAME_SPACE, TICKER_SYMBOL, PRICE and QUOTE_CURRENCY are 
required.
Date format I've utilized and has worked flawlessly has been mm/dd/.
NAME_SPACE corresponds to the top level name given in the 'Security' column in 
the 'Price Database' window and corresponds to 'From Namespace' heading in the 
'Import Preview' window. I normally set this to what Yahoo Finance reports as 
the exchange where the security trades. This also is same thing as 'Namespace" 
in the 'Securities' window.

See code at 
https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/get_historic_quotes.py
 for details if you are knowledged in Python.

https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/README.md has 
additional details...

-Original Message-
From: flywire  
Sent: Saturday, September 30, 2023 6:46 PM
To: Ove Grunnér 
Cc: Gnucash Users 
Subject: Re: [GNC] Importing stock prices from a CSV file

Yes Ove, clearly there is more to it as demonstrated by your example.

I can see the importer is using Commodity, Price Database uses Security, and 
Security Editor uses Namespace and Symbol.

https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help 
much.



gnucash_quotes.csv
Description: MS-Excel spreadsheet
___
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.