Any way to get net worth details BY DAY?

Posted by Gary on October 8, 2007, 11:18 pm

Please log in for more thread options

I have found a huge jump, over 11%, in my net worth between 9/29/2007
and 10/9/2007. In an effort to understand where and when it is coming
from, it would be useful to be able to print account totals and total
net worth for each day between those two dates. This way I could more
easily understand where and when the increases are happening. This
way I could validate whether the increase is a true increase because
of market conditions or a generous error on my part.

In the event a "daily" interval cannot be done (I couldn't figure out
how), can someone suggest a debugging strategy that would make the
where and when of the increase more apparent?

Thanks in advance.

Posted by John Pollard on October 9, 2007, 9:33 am

Please log in for more thread options

Gary wrote:

> I have found a huge jump, over 11%, in my net worth between

> 9/29/2007

> and 10/9/2007. In an effort to understand where and when it

> is coming

> from, it would be useful to be able to print account totals

> and total

> net worth for each day between those two dates. This way I

> could more

> easily understand where and when the increases are happening.

> This

> way I could validate whether the increase is a true increase

> because

> of market conditions or a generous error on my part.

> In the event a "daily" interval cannot be done (I couldn't

> figure out

> how), can someone suggest a debugging strategy that would make

> the

> where and when of the increase more apparent?

There are no Quicken reports that allow a daily interval. You
can create multiple copies of a report, each ending on a
different date (likewise displays, such as the Portfolio tab),
but not a single report with daily intervals.

It seems that you're saying your 9/29 numbers are correct, but
you doubt your 10/9 values.

Unless I'm missing something, the only two factors that can be
involved are number of shares owned, and price/share (ignoring
cash balances).

Why not start by just comparing the security values for the last
good date with the most recent date for which you can get
independent verification ... like your broker's web site.

If you print a Portfolio Value report for a date you think is
wrong in Quicken, and compare it to the values at your broker's
web site for that date, you should be able to determine which
securities have incorrect values.

If the difference is in shares owned, you can print a Quicken
Investment Transaction report for those securities to see where
the problem is.

If the difference is in price/share, you can check your Quicken
price history and correct the wrong prices.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

Posted by John Pollard on October 9, 2007, 9:40 am

Please log in for more thread options

John Pollard wrote:

> Why not start by just comparing the security values for the

> last

> good date with the most recent date for which you can get

> independent verification

I didn't state that correctly. I should have said:

Why not select a date for which you can get verifiably correct
data from your broker and that you believe has incorrect values
in Quicken; and compare the two sets of values for that date.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

Posted by Andrew DeFaria on October 9, 2007, 11:09 am

Please log in for more thread options

This is a multi-part message in MIME format.
--------------090504050504000405050508
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

John Pollard wrote:

> Gary wrote:

>> I have found a huge jump, over 11%, in my net worth between 9/29/2007

>> and 10/9/2007. In an effort to understand where and when it is coming

>> from, it would be useful to be able to print account totals and total

>> net worth for each day between those two dates. This way I could more

>> easily understand where and when the increases are happening. This

>> way I could validate whether the increase is a true increase because

>> of market conditions or a generous error on my part.

>> In the event a "daily" interval cannot be done (I couldn't figure out

>> how), can someone suggest a debugging strategy that would make the

>> where and when of the increase more apparent?

> There are no Quicken reports that allow a daily interval. You can

> create multiple copies of a report, each ending on a different date

> (likewise displays, such as the Portfolio tab), but not a single

> report with daily intervals.

> It seems that you're saying your 9/29 numbers are correct, but you

> doubt your 10/9 values.

> Unless I'm missing something, the only two factors that can be

> involved are number of shares owned, and price/share (ignoring cash

> balances).

> Why not start by just comparing the security values for the last good

> date with the most recent date for which you can get independent

> verification ... like your broker's web site.

> If you print a Portfolio Value report for a date you think is wrong in

> Quicken, and compare it to the values at your broker's web site for

> that date, you should be able to determine which

> securities have incorrect values.

> If the difference is in shares owned, you can print a Quicken

> Investment Transaction report for those securities to see where the

> problem is.

> If the difference is in price/share, you can check your Quicken price

> history and correct the wrong prices.

You're not missing something but you are adding something. You are
making a possibly invalid assumption that net worth == investments. It
does not. Net worth is a combination of all assets and all liabilities.
Granted the OP did state "This way I could validate whether the increase
is a true increase because of market conditions or a generous error on
my part" leading one to think that the error was in the investment
accounts. But the error could as easily been in an incorrect entry to a
liability or other asset account. Indeed it could be merely that one net
worth report is missing a key new account!

The advice about creating multiple net worth reports by day should weed
out what the error really turned out to be.
--
Andrew DeFaria <http://defaria.com>
Old quarterbacks never die, they just fade back and pass

--------------090504050504000405050508
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
John Pollard wrote:
wrote: 
<blockquote type="cite">I have found a huge jump, over 11%, in my net
worth between 9/29/2007 and 10/9/2007. In an effort to understand where
and when it is coming from, it would be useful to be able to print
account totals and total net worth for each day between those two
dates. This way I could more easily understand where and when the
increases are happening. This way I could validate whether the increase
is a true increase because of market conditions or a generous error on
my part. 
 
In the event a "daily" interval cannot be done (I couldn't figure out
how), can someone suggest a debugging strategy that would make the
where and when of the increase more apparent? 
</blockquote>
There are no Quicken reports that allow a daily interval. You
can create multiple copies of a report, each ending on a different date
(likewise displays, such as the Portfolio tab), but not a single report
with daily intervals. 
 
It seems that you're saying your 9/29 numbers are correct, but you
doubt your 10/9 values. 
 
Unless I'm missing something, the only two factors that can be involved
are number of shares owned, and price/share (ignoring cash balances). 
 
Why not start by just comparing the security values for the last good
date with the most recent date for which you can get independent
verification ... like your broker's web site. 
 
If you print a Portfolio Value report for a date you think is wrong in
Quicken, and compare it to the values at your broker's web site for
that date, you should be able to determine which 
securities have incorrect values. 
 
If the difference is in shares owned, you can print a Quicken
Investment Transaction report for those securities to see where the
problem is. 
 
If the difference is in price/share, you can check your Quicken price
history and correct the wrong prices. 
</blockquote>
You're not missing something but you are adding something. You are
making a possibly invalid assumption that net worth == investments. It
does not. Net worth is a combination of all assets and all liabilities.
Granted the OP did state "This way I could validate whether the
increase is a true increase because of market conditions or a generous
error on my part" leading one to think that the error was in the
investment accounts. But the error could as easily been in an incorrect
entry to a liability or other asset account. Indeed it could be merely
that one net worth report is missing a key new account! 
 
The advice about creating multiple net worth reports by day should weed
out what the error really turned out to be. 
<div class="moz-signature">-- 
<a href="http://defaria.com">Andrew DeFaria</a> 
Old quarterbacks never die, they just fade
back and pass
</div>
</body>
</html>

--------------090504050504000405050508--

Posted by John Pollard on October 9, 2007, 11:27 am

Please log in for more thread options

Andrew DeFaria wrote:

> You're not missing something but you are adding something. You

> are

> making a possibly invalid assumption that net worth ==

> investments. It

> does not.

> Net worth is a combination of all assets and all

> liabilities.

Yes, I do know that. And I consciously took into consideration
the possiblity that the differences could occur in
non-investment accounts.

> Granted the OP did state "This way I could validate

> whether the increase is a true increase because of market

> conditions

> or a generous error on my part" leading one to think that the

> error

> was in the investment accounts.

But the statement you quote here was indeed, a strong influence
on my choice of approaches: that and the fact that investment
accounts pose a more difficult "reconciliation" problem, so
perhaps outside advice might provide more benefit in the
investment account realm.

> But the error could as easily been in

> an incorrect entry to a liability or other asset account.

> Indeed it

> could be merely that one net worth report is missing a key new

> account!

I was certainly playing what I thought were the odds; but taking
my approach should not have caused any real problem - it is
after all, just starting with a subset of all possible
accounts - and could have saved some time and paper. If the
difference wasn't found in investment accounts, a subsequent
effort for non-investment accounts would have been easy enough
to do.

> The advice about creating multiple net worth reports by day

> should

> weed out what the error really turned out to be.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup