|
Posted by Marjohn on August 7, 2006, 8:21 am
Please log in for more thread options John,
Thanks for your idea of using the Net Worth report.
I've now tried it and it works quite well, although there are some
drawbacks. I didn't experience what you said about the weeks always
ending on the same date, but I did find that they always seem to end on
the same day of the week. This isn't too bad, but unfortunately I
couldn't find a way to change the starting or ending day of the week
for reporting.
No matter what day/date combination I chose in the custom dates
dropdown, the report always used the data for Saturday and fitted in
100 different data points to match the starting/ending parameters that
I provided.
I was hoping that if I selected, for example, Monday start date and
Monday end date or Friday start date and Friday end date, it would
"oblige" by providing data for Mondays or Fridays respectively, but it
doesn't. It gives the data for the first Monday and last Monday, as an
example, but persists in reporting all the intermediate data for
Saturdays. I was unable to find any means of changing this default
behaviour.
BTW, my Australian version of Quicken Personal Plus 2006 only exports
from the Net Worth report in tab delimited format, and not csv format,
but of course this is still easily imported into Excel.
Whatever, as you pointed out it is better than nothing, and for a
relatively small amount of effort.
Regards,
MarJohn
Marjohn wrote:
> John,
>
> Thanks for providing this extra information.
>
> When time permits I'll give it a try in my Australian version and see
> how it goes. Here's hoping. :-)
>
> Regards,
>
> MarJohn
>
> John Pollard wrote:
> >
> > > John and Paul,
> > >
> > > Thanks to both of you for taking the time to reply to my
> > > query.
> > >
> > > Disappointing news from John, but I guess I'm stuck with what
> > > there is
> > > (and isn't) available in Quicken.
> > >
> > > I was intending to do what you do Paul, and enter the daily
> > > portfolio
> > > values into Excel. Not so sure now, though. It will be a
> > > rather
> > > daunting task with 5+ years of data that I'm interested in
> > > using.
> > >
> > > Not only that, but manually transcribing can easily lead to
> > > errors.
> >
> > Well maybe Quicken can't do it all, but you might get Quicken to
> > help (at least the US version might).
> >
> > Quicken can report on weekly intervals, so 1/7 of the job can be
> > as accurate as your Quicken data for a relatively small amount
> > of effort. (Quicken's "weeks" are somewhat indiscriminate for
> > investment values in that they always end on the same *date*,
> > without regard to day of the week ... but if you have prices for
> > every day prices were available, a Saturday or Sunday value
> > would be the same as the preceding Friday value.)
> >
> > The Net Worth report can be used to report on your Investment
> > accounts at weekly intervals, including total value. (You can
> > even get values at the security level in the Net Worth report).
> > You would need to run the Quicken report about 3 times to get 5
> > years worth of weekly intervals.
> >
> > Quicken reports can be exported to .csv files and opened in
> > Excel, or copied to the Windows clipboard and pasted into Excel.
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap