[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