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 <[email protected]> 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 <[email protected]> > Sent: Monday, September 06, 2021 3:56 PM > To: Kalpesh Patel <[email protected]> > Cc: [email protected] > 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 > > [email protected] > > 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 > [email protected] > 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 [email protected] 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.
