[GNC] importing prices from csv

George Riner georgeriner at mycogeo.com
Wed Mar 16 11:36:14 EDT 2022


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



More information about the gnucash-user mailing list