[GNC] Importing stock prices from a CSV file

flywire flywire0 at gmail.com
Sun Oct 1 21:43:51 EDT 2023


Can we focus this back on improving the clarity of the Price Import
Assistant? The first page is essentially the full documentation of the
process.

https://github.com/Gnucash/gnucash/blob/5.4/gnucash/gtkbuilder/assistant-csv-price-import.glade#L55
uses the column labels: Date, Amount, From Namespace, From Symbol and
Currency To, irrespective of the labels used elsewhere for this data.

A csv file can use any column order, a header is optional, and the Import
Assistant doesn't use the header names. Various options exist for
specifying the delimiter as well as a fixed width option. Double quotes are
not required as shown in other examples.

I am confused by seemingly different labels being used within GnuCash for
the same data and I highlighted Commodity, Security, Namespace and Symbol.
How exactly is "CURRENCY" used in that example? Does it refer to the
default for the security or user/file?

It also seems From Symbol for
https://www.vanguard.com.au/personal/invest-with-us/etf?portId=8205 could
be VAS, VAS.ASX, or VAS.AX (ie custom Yahoo exchange code). I understand
>From Namespace is any convenient label the user chooses for the group of
Securities [??], not necessarily the Stock Exchange which could form part
of the From Symbol.


More information about the gnucash-user mailing list