Just to remove any confusion, the CSV format of the importing stock prices as of GNC v4.18 is as follows (which I don’t believe has changed in later and 5.x version)...
"NAME_SPACE","TICKER_SYMBOL",date,"PRICE","QUOTE_CURRENCY" One line per record each formatted as denoted above. Double quotes around NAME_SPACE, TICKER_SYMBOL, PRICE and QUOTE_CURRENCY are required. Date format I've utilized and has worked flawlessly has been mm/dd/YYYY. NAME_SPACE corresponds to the top level name given in the 'Security' column in the 'Price Database' window and corresponds to 'From Namespace' heading in the 'Import Preview' window. I normally set this to what Yahoo Finance reports as the exchange where the security trades. This also is same thing as 'Namespace" in the 'Securities' window. See code at https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/get_historic_quotes.py for details if you are knowledged in Python. https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/README.md has additional details... -----Original Message----- From: flywire <flywi...@gmail.com> Sent: Saturday, September 30, 2023 6:46 PM To: Ove Grunnér <write2...@gmail.com> Cc: Gnucash Users <gnucash-user@gnucash.org> Subject: Re: [GNC] Importing stock prices from a CSV file Yes Ove, clearly there is more to it as demonstrated by your example. I can see the importer is using Commodity, Price Database uses Security, and Security Editor uses Namespace and Symbol. https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help much. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
