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....@gmail.com> Sent: Tue Sep 07 10:32:21 EDT 2021 To: Kalpesh Patel <kalpesh.pa...@usa.net> Cc: Gnucash Users <gnucash-user@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.pa...@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-gnuc...@yahoo.com> > Sent: Monday, September 06, 2021 3:56 PM > To: Kalpesh Patel <kalpesh.pa...@usa.net> > Cc: gnucash-user@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@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@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@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@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.
