[GNC] QIF imports for security pricing

[Kalpesh Patel]

The issue in GNC 4.5 and above stems from the updated inclusion of libofx.
The updated libofx does not consider cash deposits and withdrawals as
security transactions and as a result of that change those transactions are
skipped in the import process for Investment account types. I reached out to
the author of libofx and waiting to hear back.

I may go the route of cherry-pick the QIF import feature back to 4.4 or
figure out how to import prices issuing CSV.


-----Original Message-----
From: Dong Lin <c54e-gnucash at yahoo.com> 
Sent: Thursday, September 09, 2021 12:00 PM
To: Kalpesh Patel <kalpesh.patel at usa.net>
Cc: gnucash-user at gnucash.org
Subject: RE: [GNC] QIF imports for security pricing

Your best course of action is to resolve your issue with the latest
GNC/libofx.  Not sure what exactly it is. but wide impact issues should be
resolved shortly. I import both qfx and qif imports for investment accounts,
have not experienced any issue.

If you really want to stick with 4.4 and if you are willing to mess with
scripts and code,  an alternative is to cherry-pick the QIF import feature
back to 4.4.  The patch should apply without conflict. All you need to do is
rebuild GNC.

> I am at version 4.4 (2020-12-28) and had to roll back to version 4.4 
> because it appears that the changes in the later versions of libofx 
> included in the subsequent version of GnuCash is severely impacting 
> OFX imports for investment accounts.
>
> Securities themselves exist under "FUND" section of security editor 
> and were created as part of the investment transactions import.
>
> Looks like I will have to make a choice ... loose certain 
> functionality of OFX and upgrade, or live without QIF security pricing 
> import and stay behind. A dreaded conundrum ...
>
> -----Original Message-----
> From: Dong Lin <c54e-gnucash at yahoo.com>
> Sent: Monday, September 06, 2021 3:56 PM
> To: Kalpesh Patel <kalpesh.patel at usa.net>
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] QIF imports for security pricing
>
>
> Which GNC version are you using? Price database update from QIF 
> imports is added in version 4.5.
>
> In order to propagate the price db through import, you need to ensure 
> the security account type is mutual_fund or stock and the 
> corresponding security exists in the security editor.
>
>
>> Hello GnuCash Dev and user community -
>>
>>
>>
>> Looking for answer to few questions related to GnuCash use, so I am 
>> hoping community can provide guidance.
>>
>>
>>
>> -          Recently I tried to import a QIF file containing mutual fund
>> transactions and pricing info into an investment account. The 
>> securities transactions in it imported fine but it appears that the 
>> importer skipped security prices that were also defined in that file.
>> I tried same file with Quicken 2017 to make sure there were no errors 
>> in the file and it imported all data without any problem, and with a 
>> brand new clean GnuCash file and importing it. Price database do not 
>> show any pricing information either.
>> Is
>> this the intended behavior of the importer?
>>
>>
>>
>> -          After importing transactions, I noticed that Present (USD),
>> Cleared (USD), Reconciled (USD), and total (USD) columns in the 
>> account list displays zero for the value of the account or the 
>> individual security sub-account. Since these are non-public mutual 
>> funds, I am unable to get them downloaded via any of the financial 
>> sources nor do symbol exist for them. Is this the intended behavior?
>> How should symbol for each mutual fund be specified? Is there a way 
>> to tell it to use the last provided price for the mutual fund to 
>> calculate total for that account and show in at least one of those 
>> columns?
>>
>>
>>
>> -          Where can I find what is expected in the format of import
>> prices
>> from csv mechanism? Specifically I am getting tripped up with "From 
>> Namespace" column. I RTFM but I couldn't make sense out of this 
>> specific field.  If there is any guidance on simply importing pricing 
>> via CSV that has three columns - date, mutual fund name, and price 
>> for that day - it would be appreciated.
>>
>>
>>
>> Look forward to replies.
>>
>>
>>
>> Thanks.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>