[GNC] QIF imports for security pricing

[Kalpesh Patel]

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