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