Quicken 2008: Sort Investments by Debt/Equity Ratio Incorrect

Posted by David A. Lessnau on September 4, 2007, 11:47 am

Please log in for more thread options

I was going to post this in my "Bugs Not Fixed from Previous Versions"
thread, but after doing a Google search and checking Intuit's site, I can't
see that it's ever been reported. So...

In Quicken Deluxe 2008 as well as my previous Q05 Premier, if I go to an
investment account, load up the Fundamentals screen, and then click on the
"Industry Debt/Equity" header or the company's "Debt/Equity" header, the
list of equities appears to sort. But, the order is incorrect. Not naming
any securities, for "Industry Debt/Equity," my "sorted" list runs as
follows:

1.22
0.26
0.43
1.66
0.26
0.43
0.98
0.51
0.16
1.09
2.66
2.12
2.65

For the company's "Debt/Equity," the "sorted" list is:

0.00
0.00
0.42
0.72
0.00
0.47
0.40
0.64
0.06
1.26
4.62
0.49
0.36

Sorting on any other column (that I tested) works fine.

Dave

Posted by John Pollard on September 4, 2007, 1:50 pm

Please log in for more thread options

David A. Lessnau wrote:

> In Quicken Deluxe 2008 as well as my previous Q05 Premier, if

> I go to

> an investment account, load up the Fundamentals screen, and

> then

> click on the "Industry Debt/Equity" header or the company's

> "Debt/Equity" header, the list of equities appears to sort.

> But, the

> order is incorrect.

> Sorting on any other column (that I tested) works fine.

Did you try "Return (%) YTD"; it's off too.

The problem has existed with that "column" since at least Q2005,
but I can't say that the underlying (reported) cause is the
same.

It has been reported that when the Porfolio is grouped by
Security and sorted by "Return (%) YTD", Quicken adds the Return
percentage of the security once for each account in which the
security is held, then sorts on that total.

While I see that the "Return (%) YTD" percentage does not sort
correctly, it's not clear to me that it is off due to the
reported cause. A quick glance at my data does suggest that
owning the security in multiple accounts may be part of the
problem.

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

Posted by David A. Lessnau on September 4, 2007, 5:53 pm

Please log in for more thread options

John,

Thanks. I have my securities grouped by Security and I do own them in two
different accounts. But, I have identical portfolios in both. So, even if
Quicken somehow weights the values based on ownership, it wouldn't make any
difference in my case.

I know you're on this group and in the official Intuit ones. But, I Googled
the whole web and specifically searched Intuit's and I can't find any
information about this. Where do you find all this? The closest I can up
with is Quicken's inability to sort % Returns based on any holding period
greater than a person owned the stock (IOW, it wants to calculate return
data from a person's holdings and not from an official data base, so unless
a person owned the stock for the required period, there's no data to sort --
that's still the case in Q08).

Dave

> David A. Lessnau wrote:

>> In Quicken Deluxe 2008 as well as my previous Q05 Premier, if

>> I go to

>> an investment account, load up the Fundamentals screen, and

>> then

>> click on the "Industry Debt/Equity" header or the company's

>> "Debt/Equity" header, the list of equities appears to sort.

>> But, the

>> order is incorrect.

>> Sorting on any other column (that I tested) works fine.

> Did you try "Return (%) YTD"; it's off too.

> The problem has existed with that "column" since at least Q2005,

> but I can't say that the underlying (reported) cause is the

> same.

> It has been reported that when the Porfolio is grouped by

> Security and sorted by "Return (%) YTD", Quicken adds the Return

> percentage of the security once for each account in which the

> security is held, then sorts on that total.

> While I see that the "Return (%) YTD" percentage does not sort

> correctly, it's not clear to me that it is off due to the

> reported cause. A quick glance at my data does suggest that

> owning the security in multiple accounts may be part of the

> problem.

> --

> John Pollard

> First initial underscore Last name at mchsi dot com

> Please reply to newsgroup

Posted by John Pollard on September 4, 2007, 8:14 pm

Please log in for more thread options

David A. Lessnau wrote:

> John,

> Thanks. I have my securities grouped by Security and I do own

> them

> in two different accounts. But, I have identical portfolios

> in both.

> So, even if Quicken somehow weights the values based on

> ownership, it

> wouldn't make any difference in my case.

> I know you're on this group and in the official Intuit ones.

> But, I

> Googled the whole web and specifically searched Intuit's and I

> can't

> find any information about this.

> Where do you find all this?

I remembered that there was something about sorting on Return %
YTD in the Intuit Forums, so I searched there for "sort
portfolio return". There were quite a few hits, but one thread
(SORTing by % RETURN YTD) identified the sorting problem. The
op in the thread spelled out the problem, another poster added
the notion that the return percentages were being added together
for each account where the security is held.

I see the same thing mentioned in "SORTing by % RETURN YTD" in
Q2005 and Q2008.

> The

> closest I can up with is Quicken's inability to sort % Returns

> based

> on any holding period greater than a person owned the stock

> (IOW, it

> wants to calculate return data from a person's holdings and

> not from

> an official data base, so unless a person owned the stock for

> the

> required period, there's no data to sort -- that's still the

> case in

> Q08).

> Dave

>> David A. Lessnau wrote:

>>> In Quicken Deluxe 2008 as well as my previous Q05 Premier,

>>> if

>>> I go to

>>> an investment account, load up the Fundamentals screen, and

>>> then

>>> click on the "Industry Debt/Equity" header or the company's

>>> "Debt/Equity" header, the list of equities appears to sort.

>>> But, the

>>> order is incorrect.

>>> Sorting on any other column (that I tested) works fine.

>> Did you try "Return (%) YTD"; it's off too.

>> The problem has existed with that "column" since at least

>> Q2005,

>> but I can't say that the underlying (reported) cause is the

>> same.

>> It has been reported that when the Porfolio is grouped by

>> Security and sorted by "Return (%) YTD", Quicken adds the

>> Return

>> percentage of the security once for each account in which the

>> security is held, then sorts on that total.

>> While I see that the "Return (%) YTD" percentage does not

>> sort

>> correctly, it's not clear to me that it is off due to the

>> reported cause. A quick glance at my data does suggest that

>> owning the security in multiple accounts may be part of the

>> problem.

>> --

>> John Pollard

>> First initial underscore Last name at mchsi dot com

>> Please reply to newsgroup

--

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

Posted by David A. Lessnau on September 4, 2007, 6:25 pm

Please log in for more thread options

John,

Specifically on the Return (%) YTD: with my data (two identically stocked
accounts), my data sorts correctly on that field. But, I'm showing 5 stocks
with N/A for their Return (%) YTD. I mentioned in my other branch of this
thread that Quicken won't calculate returns for periods greater than we've
owned a stock. But, how can it not calculate a YTD value?

I also wonder if, in your case (different stocks in different accounts), it
"pro-rates" the value it's sorting on based on a percentage of the year
owned? Maybe the displayed value is the actual Return (%) YTD but it's
sorted on ((Return (%) YTD) / (% of year owned))?

Dave

> David A. Lessnau wrote:

>> In Quicken Deluxe 2008 as well as my previous Q05 Premier, if

>> I go to

>> an investment account, load up the Fundamentals screen, and

>> then

>> click on the "Industry Debt/Equity" header or the company's

>> "Debt/Equity" header, the list of equities appears to sort.

>> But, the

>> order is incorrect.

>> Sorting on any other column (that I tested) works fine.

> Did you try "Return (%) YTD"; it's off too.

> The problem has existed with that "column" since at least Q2005,

> but I can't say that the underlying (reported) cause is the

> same.

> It has been reported that when the Porfolio is grouped by

> Security and sorted by "Return (%) YTD", Quicken adds the Return

> percentage of the security once for each account in which the

> security is held, then sorts on that total.

> While I see that the "Return (%) YTD" percentage does not sort

> correctly, it's not clear to me that it is off due to the

> reported cause. A quick glance at my data does suggest that

> owning the security in multiple accounts may be part of the

> problem.

> --

> John Pollard

> First initial underscore Last name at mchsi dot com

> Please reply to newsgroup