importing historical quotes into gnucash

David Hampton hampton-gnucash at rainbolthampton.net
Wed Feb 1 18:07:57 EST 2006


On Wed, 2006-02-01 at 13:34 -0800, Steve Kelem wrote:
> Steve Kelem said the following on 2/1/2006 10:16 AM:
> 
> > It looks like there are two steps that I need help in:
> >
> > 1. How to download prices for stocks on a certain date. Finance::Quote 
> > seems to work on only the current prices. There must be a way
> > to get historical prices for stocks & bonds.
> 
> I found Finance::QuoteHist.  This module will download historical 
> quotes, splits, and dividends.
> 
> I still need to know how to do the following.  Can anyone point me to 
> some documentation?
> 
> Thanks,
> Steve
> 
> > 2. Once I get the prices, how to import them into gnucash. There are 
> > too many to input one at a time. It looks like I could hack the .xac 
> > file,
> > but this seems like something that many people would like to do, so a 
> > more general solution would be a good thing.
> > What are the available mechanisms?  Do I have to learn postgresql? 
> > Write a Perl script? Learn guile?

You can either convert the quotes into XML and add them to your data
file, or you could extend gnucash to support retrieving historical
quotes as well as current quotes.  This could all be done with C, glade,
and Perl.  No need to learn guile.  (The current quote support does use
guile code, but I hope to rewrite it into C after the 2.0 release.)

David





More information about the gnucash-user mailing list