[GNC] Remove Finance::Quote prices from database

[sunfish62 at yahoo.com]

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 <david.carlson.417 at gmail.com> 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 <tydeman.fred at gmail.com>
>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
><david.carlson.417 at gmail.com>
>> 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
>gnucash-user at 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.