[GNC] QIF imports for security pricing

Dong Lin c54e-gnucash at yahoo.com
Mon Sep 6 15:56:04 EDT 2021


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




More information about the gnucash-user mailing list