Price Histories

Posted by DGD on August 16, 2009, 12:42 pm

Please log in for more thread options

For some reason, I have lost the price histories associated with some
of my mutual funds, but not all in Quicken 2009 HAB (Cdn version). I
have to re-enter the price histories, one date at a time. I can find
no quick way to find out the prices for each of the funds and their
associated date, apart from reviewing each individual transaction for
each fund, which is very time consuming. Quicken appears to be able
to import price histories for identified funds in ASCII or CSV (not
sure) format. Where can I download from the internet price histories
for the funds affected by this? I am looking for price histories in
the 1996 to 2004 time frame.

Thanks.

Doug

Posted by John Pollard on August 16, 2009, 1:59 pm

Please log in for more thread options

DGD wrote:

> For some reason, I have lost the price histories associated with some

> of my mutual funds, but not all in Quicken 2009 HAB (Cdn version). I

> have to re-enter the price histories, one date at a time. I can find

> no quick way to find out the prices for each of the funds and their

> associated date, apart from reviewing each individual transaction for

> each fund, which is very time consuming. Quicken appears to be able

> to import price histories for identified funds in ASCII or CSV (not

> sure) format. Where can I download from the internet price histories

> for the funds affected by this? I am looking for price histories in

> the 1996 to 2004 time frame.

If it were for U.S. securities, I'd say Yahoo; but I don't know if Yahoo
has price histories for Canadian securities. Also possibly MSN Money.

I don't know much about the Canadian version of Quicken: is your price
history kept in a separate Windows file, as it is in the US version? Look
for QDATA.QPH (where QDATA is the name of your Quicken data), and the QPH
file contains your Quicken price history (and nothing but your price
history).

If you have a separate price history file, I think there's a good chance
you can recover some, or all, of your "missing" prices.

In the US versions of Quicken, the format of the QPH file has not changed
since it was first introduced back around Q2001, or so. That means we can
replace any QPH file with any other QPH file (obviously, some limitations
exist for securities present in one QPH file but not another).

Better yet: if you have a separate QPH file (and assuming the Canadian
versions have the same format as the US versions), there is a free program
that can list the data in that file; and can extract some (you select), or
all, (uncorrupted) prices from that file into a comma delimited file that
can be imported into Quicken. Google can find the "QPH File Processor".

--

John Pollard

Posted by DGD on August 16, 2009, 4:39 pm

Please log in for more thread options

> DGD wrote:

> > For some reason, I have lost the price histories associated with some

> > of my mutual funds, but not all in Quicken 2009 HAB (Cdn version). =A0I

> > have to re-enter the price histories, one date at a time. =A0I can find

> > no quick way to find out the prices for each of the funds and their

> > associated date, apart from reviewing each individual transaction for

> > each fund, which is very time consuming. =A0Quicken appears to be able

> > to import price histories for identified funds in ASCII or CSV (not

> > sure) format. =A0Where can I download from the internet price histories

> > for the funds affected by this? =A0I am looking for price histories in

> > the 1996 to 2004 time frame.

> If it were for U.S. securities, I'd say Yahoo; but I don't know if Yahoo

> has price histories for Canadian securities. =A0Also possibly MSN Money.

> I don't know much about the Canadian version of Quicken: is your price

> history kept in a separate Windows file, as it is in the US version? =A0L=

ook

> for QDATA.QPH (where QDATA is the name of your Quicken data), and the QPH

> file contains your Quicken price history (and nothing but your price

> history).

> If you have a separate price history file, I think there's a good chance

> you can recover some, or all, of your "missing" prices.

> In the US versions of Quicken, the format of the QPH file has not changed

> since it was first introduced back around Q2001, or so. =A0That means we =

can

> replace any QPH file with any other QPH file (obviously, some limitations

> exist for securities present in one QPH file but not another).

> Better yet: if you have a separate QPH file (and assuming the Canadian

> versions have the same format as the US versions), there is a free progra=

> that can list the data in that file; and can extract some (you select), o=

> all, (uncorrupted) prices from that file into a comma delimited file that

> can be imported into Quicken. =A0Google can find the "QPH File Processor"=

> --

> John Pollard

John,

Thanks for the reply. I found your response to similar question and
downloaded QPH processor. I created a file for a particular security
from a back-up QPH file and all the data for the security seemed to
come out ok in an excel spreadsheet. I have used the security code,
in this case AIM1511 for the AIM Trimark Fund. For some reason, I
cannot get Quicken to import the file. After I put in the path for
the file name, all I get is "path is not found or file is
unreadable". The file is a csv file so it is what is asked for in the
Quicken help file, so I don't understand why it can't import the
file. In the Cdn version, the file import dialogue is not very
helpful - there is no browse button to find the file, one has to type
in the entire path and file name. Is it necessary to add the file
extension to the file name (.csv, for example)? Have tried it with
and without the extension with no change.

Thanks.

Doug

Posted by DGD on August 16, 2009, 5:32 pm

Please log in for more thread options

> > DGD wrote:

> > > For some reason, I have lost the price histories associated with some

> > > of my mutual funds, but not all in Quicken 2009 HAB (Cdn version). =

=A0I

> > > have to re-enter the price histories, one date at a time. =A0I can fi=

> > > no quick way to find out the prices for each of the funds and their

> > > associated date, apart from reviewing each individual transaction for

> > > each fund, which is very time consuming. =A0Quicken appears to be abl=

> > > to import price histories for identified funds in ASCII or CSV (not

> > > sure) format. =A0Where can I download from the internet price histori=

> > > for the funds affected by this? =A0I am looking for price histories i=

> > > the 1996 to 2004 time frame.

> > If it were for U.S. securities, I'd say Yahoo; but I don't know if Yaho=

> > has price histories for Canadian securities. =A0Also possibly MSN Money=

> > I don't know much about the Canadian version of Quicken: is your price

> > history kept in a separate Windows file, as it is in the US version? =

=A0Look

> > for QDATA.QPH (where QDATA is the name of your Quicken data), and the Q=

> > file contains your Quicken price history (and nothing but your price

> > history).

> > If you have a separate price history file, I think there's a good chanc=

> > you can recover some, or all, of your "missing" prices.

> > In the US versions of Quicken, the format of the QPH file has not chang=

> > since it was first introduced back around Q2001, or so. =A0That means w=

e can

> > replace any QPH file with any other QPH file (obviously, some limitatio=

> > exist for securities present in one QPH file but not another).

> > Better yet: if you have a separate QPH file (and assuming the Canadian

> > versions have the same format as the US versions), there is a free prog=

ram

> > that can list the data in that file; and can extract some (you select),=

> > all, (uncorrupted) prices from that file into a comma delimited file th=

> > can be imported into Quicken. =A0Google can find the "QPH File Processo=

r".

> > --

> > John Pollard

> John,

> Thanks for the reply. =A0I found your response to similar question and

> downloaded QPH processor. =A0I created a file for a particular security

> from a back-up QPH file and all the data for the security seemed to

> come out ok in an excel spreadsheet. =A0I have used the security code,

> in this case AIM1511 for the AIM Trimark Fund. =A0 For some reason, I

> cannot get Quicken to import the file. =A0After I put in the path for

> the file name, all I get is "path is not found or file is

> unreadable". =A0The file is a csv file so it is what is asked for in the

> Quicken help file, so I don't understand why it can't import the

> file. =A0In the Cdn version, the file import dialogue is not very

> helpful - there is no browse button to find the file, one has to type

> in the entire path and file name. =A0Is it necessary to add the file

> extension to the file name (.csv, for example)? =A0Have tried it with

> and without the extension with no change.

> Thanks.

> Doug

OK, tried it again. The Quicken web site asks for the csv file in
fund, date, price format while the QPH processor generates a fund,
price, date format. Re-arranging the data allowed Quicken to import
the file correctly. Be careful with the directions provided on the
Canadian Web site however. If you are using the standard Canadian
date format of dd/mm/yy, ignore what the Quicken instructions say. If
you use the US date format (mm/dd/yy), some of your data will be lost
(I had 665 entries, of which only 235 came through and they were wrong
because of the date format). Also ignore the instructions regarding
configuring your computer to US standard. The instructions on the
Quicken Canadian site are simply a copy of the US instructions. Have
fed this back to Quicken.

Thanks for the pointer to the QPH file processor.

Doug

Doug

Posted by John Pollard on August 16, 2009, 8:22 pm

Please log in for more thread options

DGD wrote:

>>> DGD wrote:

>>>> For some reason, I have lost the price histories associated with

>>>> some of my mutual funds, but not all in Quicken 2009 HAB (Cdn

>>>> version). I have to re-enter the price histories, one date at a

>>>> time. I can find no quick way to find out the prices for each of

>>>> the funds and their associated date, apart from reviewing each

>>>> individual transaction for each fund, which is very time

>>>> consuming. Quicken appears to be able to import price histories

>>>> for identified funds in ASCII or CSV (not sure) format. Where can

>>>> I download from the internet price histories for the funds

>>>> affected by this? I am looking for price histories in the 1996 to

>>>> 2004 time frame.

>>> If it were for U.S. securities, I'd say Yahoo; but I don't know if

>>> Yahoo has price histories for Canadian securities. Also possibly

>>> MSN Money.

>>> I don't know much about the Canadian version of Quicken: is your

>>> price history kept in a separate Windows file, as it is in the US

>>> version? Look for QDATA.QPH (where QDATA is the name of your

>>> Quicken data), and the QPH file contains your Quicken price history

>>> (and nothing but your price history).

>>> If you have a separate price history file, I think there's a good

>>> chance you can recover some, or all, of your "missing" prices.

>>> In the US versions of Quicken, the format of the QPH file has not

>>> changed since it was first introduced back around Q2001, or so.

>>> That means we can replace any QPH file with any other QPH file

>>> (obviously, some limitations exist for securities present in one

>>> QPH file but not another).

>>> Better yet: if you have a separate QPH file (and assuming the

>>> Canadian versions have the same format as the US versions), there

>>> is a free program that can list the data in that file; and can

>>> extract some (you select), or all, (uncorrupted) prices from that

>>> file into a comma delimited file that can be imported into Quicken.

>>> Google can find the "QPH File Processor".

>> Thanks for the reply. I found your response to similar question and

>> downloaded QPH processor. I created a file for a particular security

>> from a back-up QPH file and all the data for the security seemed to

>> come out ok in an excel spreadsheet. I have used the security code,

>> in this case AIM1511 for the AIM Trimark Fund. For some reason, I

>> cannot get Quicken to import the file. After I put in the path for

>> the file name, all I get is "path is not found or file is

>> unreadable". The file is a csv file so it is what is asked for in the

>> Quicken help file, so I don't understand why it can't import the

>> file. In the Cdn version, the file import dialogue is not very

>> helpful - there is no browse button to find the file, one has to type

>> in the entire path and file name. Is it necessary to add the file

>> extension to the file name (.csv, for example)? Have tried it with

>> and without the extension with no change.

> OK, tried it again. The Quicken web site asks for the csv file in

> fund, date, price format while the QPH processor generates a fund,

> price, date format. Re-arranging the data allowed Quicken to import

> the file correctly. Be careful with the directions provided on the

> Canadian Web site however. If you are using the standard Canadian

> date format of dd/mm/yy, ignore what the Quicken instructions say. If

> you use the US date format (mm/dd/yy), some of your data will be lost

> (I had 665 entries, of which only 235 came through and they were wrong

> because of the date format). Also ignore the instructions regarding

> configuring your computer to US standard. The instructions on the

> Quicken Canadian site are simply a copy of the US instructions. Have

> fed this back to Quicken.

> Thanks for the pointer to the QPH file processor.

Thanks for the feedback.

I have successfully imported the delimited file output from the QPH File
Processor directly into the US version of Quicken.

Glad to get your results with the Canadian version of Quicken.

[Interestingly: I believe the creator of the QPH File Processor is a user
of the Australian version of Quicken.]

--

John Pollard