I know that you can export the stock prices for each security for an extended time period (eg., five years), but how about exporting the total value of the portfolio for every day for a similar period (Quicken 2006 Personal Plus, Australian version)?
Having searched the archives for this group, and other forums as well, and after trying various things myself, I still haven't been able to find a way to do what I need.
Is it possible, and if so could someone please give me some hints. I don't want to have to open the portfolio for each day and export the value because it will take an eternity to work through more than five years of data.
I've tried what you suggested but it doesn't meet my requirements. As far as I can see it doesn't allow exporting the total portfolio value on a *daily* basis; only monthly, quarterly, etc.
sorry about that. I thought once you got to the report you'd be home free. I do this myself manually, by transcribing portfolio value into a spreadsheet on a nearly-daily basis.
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.
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.
That is what I meant when I said the weeks always end on the same date. No matter what starting or ending date you use, weeks of the report will end on the same dates - to achieve that, the first, and last weeks of the report may be short as many as 6 days). The weekly interval is not measured from your starting date.
If it could have done that, it could have provided results for every day of the week (by running the report 5 times with 5 different start dates), and I would have noted that in my earlier reply.
But also as I said, if you have correct prices for every day that prices were available, it doesn't matter what day of the week the report value's are for, they will represent correct values for a date when prices were available. If a value has a date that falls on Saturday, it will be the correct value for the Friday before.
In the back of my head, I was thinking that Excel might have some macro, or formula, that would change a weekend, or holiday, date to the latest earlier non-weekend/holiday date (Sunday date to the previous Friday date, for example). Or if all the dates are for Saturday, I would think Excel would be able to simply subtract 1 day from each of them making them all Friday dates..
My error; the same is true for US version. Report exports are tab, not comma, delimited.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.