Attached is a file of what it would look like with same security prices for different day and with multiple of these examples repeated for other securities and/or indexes ...
-----Original Message----- From: Kalpesh Patel <kalpesh.pa...@usa.net> Sent: Sunday, October 01, 2023 7:49 PM To: 'flywire' <flywi...@gmail.com>; 'Ove Grunnér' <write2...@gmail.com> Cc: 'Gnucash Users' <gnucash-user@gnucash.org> Subject: RE: [GNC] Importing stock prices from a CSV file 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_quotes.csv
Description: MS-Excel spreadsheet
_______________________________________________ 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.
