[GNC] importing prices from csv

D. sunfish62 at yahoo.com
Wed Mar 16 17:59:31 EDT 2022


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 <georgeriner at mycogeo.com>
Sent: Wed Mar 16 11:36:14 EDT 2022
To: gnucash-user at 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 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.


More information about the gnucash-user mailing list