Every stock has a Namespace in Gnucash. "NYSE" "NASDAQ" are examples.
I have an online spreadsheet into which I can paste my Advanced Portfolio data, and then a second worksheet in the file compiles the prices for the result set, which can be cut and pasted locally for import. -------- Original Message -------- From: George Riner <georgeri...@mycogeo.com> Sent: Wed Mar 16 19:47:26 EDT 2022 To: Gnucash Users <gnucash-user@gnucash.org> Subject: Re: [GNC] importing prices from csv Thanks. One question... I don't know what is "the entry from Gnucash" ? err... what entry from Gnucash? :George On 3/16/2022 2:59 PM, D. wrote: > I am able to import prices from csv with a four column source: > > Ticker, Namespace, Price, Date > > Namespace is the entry from Gnucash. > ------------------------------------------------------------------------ > *From:* George Riner > *Sent:* Wed Mar 16 11:36:14 EDT 2022 > *To:* gnucash-user@gnucash.org > *Subject:* [GNC] importing prices from csv > > My specs: > > Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM) > Gnucash: 4.9+(2021-12-18) Enaaglish > Finance Quote: 1.51a > I live and work in California, USA. > > I've been trying to use the "Import Prices from a CSV file..." tool. > I've got a CSV with symbols ('ticker symbols'?) and prices, and it > includes the name of the fund that the ticker symbol is for. > It has a 'date' column for the date of the fund price. > It has a column for 'Amount' that is the price of that fund. The prices > are in USD. > > I set "Currency To" to "USD (US Dollar)" in the drop down above the > panel where it shows the rows of the CSV > > But I'm stumped what "Commodity From" is supposed to be. The CSV has > prices (in USD) for various different funds - are funds commodities? If > I pick "USD (US Dollar)" for Commodity From, the error is "Commodity > From can not be the same as 'Currency To'". Looking through the list > offered in the 'Commodity From' drop down, I see all sorts of currencies > and securities I've entered through the Security Editor. What am I > supposed to pick? > > :George > California, USA > > ------------------------------------------------------------------------ > > 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 > seehttps://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. _______________________________________________ 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.