So, in an SQL program, having loaded your GnuCash database, you can delete only Finance::Quote prices with:
DELETE FROM prices WHERE source like 'Finance%' Of course, you're messing with your GnuCash data file outside of GnuCash. THIS IS DISCOURAGED STRONGLY BY EVERYONE INVOLVED WITH THIS SOFTWARE. DON'T DO IT. Should you choose to proceed anyway, WORK ON A BACKUP COPY OF YOUR FILE. Also, be aware that the price database doesn't affect your actual financial data such as transactions and holdings--although it does affect valuation of those holdings. Deleting prices for a specific commodity is more complicated, since you need to look up the human readable name in a separate table by a join. I'm not at my machine right now to work out the syntax for that, however. David T. On Dec 7, 2025, 6:57 AM, at 6:57 AM, David Carlson <[email protected]> wrote: >I too would like to know a good and fast way to cherry pick prices to >delete > >David Carlson > >On Sat, Dec 6, 2025, 7:11 PM Fred Tydeman <[email protected]> >wrote: > >> Correct. I can select one price, then press and hold Shift and press >and >> hold Down Arrow >> to select many prices until I unhold Down Arrow. Then click Remove. >So, >> I can do 50 at a >> time for one security. Still, it is taking me hours to clean up my >> history. >> >> On Sun, Dec 7, 2025 at 10:55 AM David Carlson ><[email protected]> >> wrote: >> >>> I think that you can select multiple prices to delete but that could >>> still get tedious when you have many securities. >>> >> >_______________________________________________ >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. _______________________________________________ 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.
