Well, it isn't quite that easy. One Ubuntu machine has a very recent flatpak version that knows Sqlite3. I am about to feed it a copy of the backup that has the good price history and save it in Sqlite3 format. . Then I will learn how to implement the rest of your suggestion in Ubuntu Linux. I am still able to crash your nightly builds in Windows so I will need to generate a good tracefile to find out what is going on there.
On Tue, Nov 11, 2025 at 10:23 AM John Ralls <[email protected]> wrote: > The SQL backend has been around for a long time so there shouldn't be any > problem with that. But you might try opening a copy of the backup with your > current GnuCash. > > Regards, > John Ralls > > On Nov 10, 2025, at 21:40, David Carlson <[email protected]> > wrote: > > It turns out that I didn't have to look far for a backup with the full > price histories. They were only lost somehow in my transition to the > release 5 series of GnuCash which started a few months ago. I will try > your suggestion to use sqlite if I can make that work in my old 4.8 version. > > On Mon, Nov 10, 2025 at 3:47 PM John Ralls <[email protected]> wrote: > >> You’re confusing AQBanking, which imports transactions in a variety of >> ways, with Finance::Quote, which retrieves prices/exchange rates. >> >> If you can find a backup with the prices in it that will provide the >> quickest fix. There’s no price export so the simplest way to transfer the >> prices from the backup is to save the backup as a SQLite3 database. Then >> you can use the sqlite3 program to write the prices table out as a CSV that >> you can import into your main book with the CSV price importer. >> >> The straight-up command line version would be >> sqlite3 -csv myfile-db.gnucash “select * from Prices;” > prices.csv >> If you’re using your Windows box for this you’d double-click Sqlite3.exe >> and tell it >> > .mode csv >> > .once “c:/Users/Dave/prices.csv” >> > select * from Prices; >> > .system “c:/Users/Dave/prices.csv: >> >> Full documentation at https://www.sqlite.org/cli.html#export_to_csv. >> >> Failing the backup or if you need to fill in missing dateas I guess the >> most efficient way to get historical quotes is to use something like Yahoo! >> Finance to get the historical quotes and copy them into a spreadsheet then >> save the spreadsheet as a CSV and use File>Import>Import Prices from a CSV >> file. The intro screen to the import assistant has some instructions about >> what columns need to be in the CSV. >> >> Regards, >> John Ralls >> >> >> >> On Nov 10, 2025, at 12:35, David Carlson <[email protected]> >> wrote: >> >> I remember using AQ banking to download prices (not in the last few >> years). It has not even been configured in recent times after the >> AlphaVantage key got flakey. I also had off and on monthly rituals to >> manually add prices to the database for the last day of the month for a >> few securities when the markets were closed on the last calendar day of the >> month. I am sure that I did not intentionally use the tool to remove old >> prices. What I would do is work through the price editor and select >> non-month-end prices to manually remove. Now that I am retired, I don't >> have enough free time to do that. I do need to restore some for reports >> that I want to re-run. >> >> What tools are there to efficiently gather selected historical prices and >> import them? >> >> Could prices disappear through some other mechanism? I know that the >> report was never closed after I last ran it on November 2022 data several >> months ago and it had prices then, as well as for many previous months. It >> is the 11th revision of that report to capture newly added securities from >> time to time. I might be able to find three or even ten year old backups >> if I look hard enough. >> >> On Mon, Nov 10, 2025 at 10:57 AM John Ralls <[email protected]> wrote: >> >>> >>> >>> > On Nov 10, 2025, at 08:34, David Carlson <[email protected]> >>> wrote: >>> > >>> > I am currently using the Windows Nightly Build 5.13 dated November 10, >>> 2025. >>> > When I run a Balance Sheet Report or a custom report based on that >>> report, >>> > Commodities that do not have a price dated on or before the report date >>> > that is visible in the Price Database are not given a value in the >>> report. >>> > I use the Last up through report date price source because I am >>> comparing >>> > the report with my broker's report. >>> > While the Price Database has recent entries generated by purchase and >>> sale >>> > transactions, for some reason sale and purchase prices before November >>> 30, >>> > 2022 for some securities do not exist, even though I have been tracking >>> > those securities in GnuCash for over 10 years. >>> > >>> > I believe that in the past either this price source selection method >>> picked >>> > up prices from transaction history and did not need them to be >>> duplicated >>> > in the Price Database, which may have prices purged accidentally or >>> > intentionally from time to time or perhaps the prices were always >>> > duplicated in the.Price Database and updated if a transaction was >>> edited. >>> > >>> > Do I need to file a bug report? >>> >>> No, you need to put historical prices in your price database. >>> >>> Report pricing is and has always been either price database (nearest in >>> time, nearest in time before, latest) or transaction-based (average cost, >>> weighted average cost). Transaction have written a price into the database >>> since sometime around the v2.6. release. That’s probably what you’re >>> thinking of. >>> >>> I think the only way to delete prices from the price database is to use >>> the RemoveOlld button in the Price Database window. That opens another >>> dialog that provides pretty fine-grained control over what prices to >>> remove, so it would be hard to do it inadvertently. Might you have done >>> that? >>> >>> Regards, >>> John Ralls >>> >>> >> >> -- >> David Carlson >> >> >> > > -- > David Carlson > > > -- David Carlson _______________________________________________ gnucash-user mailing list [email protected] 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.
