[GNC] QIF imports for security pricing

[Dong Lin]

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