[GNC] QIF imports for security pricing

Tue Sep 7 14:41:41 EDT 2021

I've used csv imports for commodity prices many times. Because of problems with retrieving prices through Finance::Quote that started when Yahoo! deactivated its servers, I set up a process that worked pretty well to get weekly price updates into gnucash. 

I built a spreadsheet in Google Sheets in which I pasted the output of the Advanced Portfolio report on one sheet. I then pulled tickers from this pasted info, and then used Google's finance functions to get current quotes. This all was in a sheet with stock symbol, date, and price, that I could then cut and paste into a new csv file, which I then imported into gnucash using a saved csv profile. 

Although it sounds complex, it actually only took a couple of minutes to perform the routine, once I had it worked through. 

David T. 

-------- Original Message --------
From: David Carlson <david.carlson.417 at gmail.com>
Sent: Tue Sep 07 10:32:21 EDT 2021
To: Kalpesh Patel <kalpesh.patel at usa.net>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] QIF imports for security pricing

Kalpesh,

Have you tried to put together a way to get prices in a CSV file and import
that?  I will admit that I haven't tried that myself, so if any others
could elaborate on a way to do that?

On Tue, Sep 7, 2021 at 8:56 AM Kalpesh Patel <kalpesh.patel at usa.net> wrote:

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

-- 
David Carlson
_______________________________________________
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.