I am able to import prices from csv with a four column source: Ticker, Namespace, Price, Date
Namespace is the entry from Gnucash. -------- Original Message -------- From: George Riner <[email protected]> Sent: Wed Mar 16 11:36:14 EDT 2022 To: [email protected] 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 [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.
