Perl Price History Script

David T. sunfish62 at
Mon Oct 31 11:03:48 EDT 2016

> On Oct 31, 2016, at 7:06 PM, John Ralls <jralls at> wrote:
> BIG WARNING NUMBER 0: This script writes directly to the GnuCash database without using the GnuCash API. It might corrupt your database and render it unusable. Make a copy and work with the copy, testing thoroughly after importing the prices.

Yes, sorry. I meant to include that as well.

> BIG WARNING NUMBER 2: If something goes wrong and you ask the GnuCash developers for help, we'll just tell you to toss the database and use your backup. MAKE SURE YOU HAVE A GOOD BACKUP!

Yes, this too. In fact, it is why I set up the script to work on a copy of the datafile—so that your original GnuCash data file remains intact.

> The prices table is stand-alone and no core data depends on it, so the worst that will happen (aside from GnuCash crashing on startup) is that all of the values in the Accounts  page, the summary bar, and reports will be wrong for everything that you retrieve prices for. 

Of course, running Get Quotes would restore the values in those locations; it *won’t* however, restore the price histories you previously had.

> Regards,
> John Ralls


More information about the gnucash-user mailing list