Import stock price history from QIF?

prl prl at ozemail.com.au
Fri Sep 9 21:51:58 EDT 2011


On 4/09/11 16:56, prl wrote:
> The QIF export of my accounts from Quicken for Mac 2005 contains stock 
> prices, in tables like this:
>
> !Type:Prices
> "CBA",9.350,"9/11/93",,,0
> "CBA",9.500,"7/12/93",,,0
> "CBA",12.510,"27/3/97",,,0
> "CBA",14.550,"30/9/97",,,0
> "CBA",18.060,"27/3/98",,,0
> "CBA",18.790,"30/9/98",,,0
> "CBA",24.500,"26/3/99",,,0
> ...
> ^

For information, the QIF Type:Prices fields are:
     Stock Exchange code for stock (above is the ASX code for 
Commonwealth Bank of Australia, CBA)
     Closing price
     Date
     Day's high price (empty in above example)
     Day's low price (empty in above example)
     Volume

I'm planning on writing a Perl script to translate QIF closing prices 
into GnuCash "last" prices for a fixed time of day, probably 23:59:59 in 
the system (or a user-specified) time zone. There doesn't seem to be any 
useful translation of the daily high and low prices in QIF to GnuCash.

Peter


More information about the gnucash-user mailing list