If you run sqlite3 from a terminal session and put Geoff's query into a file
you can say
sqlite3 -csv path/to/file.gnucash < query-file > prices.csv
and the results will be in prices.csv ready to open in your spreadsheet program.
Regards,
John Ralls
> On Oct 16, 2022, at 7:36 AM, Elmar
Thank you! It worked! I got DB Browser for SQLite running on Linux
Mint, exported the GC file to sqlite3, opened in the program, and ran
the code. I couldn't figure out how to export the resulting table into
csv, but simply highlighted the thing, and copy/pasted it into
LibreOffice Calc.