Home Page link  

1-month gain/loss report problem

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
1-month gain/loss report problem Nathan Gutman 12-06-2007
Posted by Nathan Gutman on December 6, 2007, 8:29 pm
Please log in for more thread options
 I have re-posted this thread from three days ago hoping that someone
will come up with an answer before the subject dies.
Nathan
Fred Smith wrote:
> I suspect your downloading schedule is causing the problem. If, as
far as Quicken is concerned, there is no change in price in the last
month, then the 1-month gain loss is 0%, which is what Quicken is reporting.
>
> Pick a security that Quicken is reporting zero for, and check the
price history. If there's no price in the last month, enter one, and see
if that solves your problem.
>
> For an example, I was hoping to see something like: For Security A, I
had 1000 shares at 10.00 last month, and they were worth 10.46
yesterday. That's a 4.6% increase, but Quicken is reporting 0%. All
we're trying to do is get the same information you have so we can track
down the problem.
>
>
> Regards,
> Fred
>
>
>> Fred Smith wrote:
>>> Have you owned the security for more than a month?
>>> Do you have a previous month-end price on file?
>>>
>>> Give us an example of what Quicken is calculating and what you
think the right answer is.
>>>
>> Yes I have owned them for years.
>> I update/download prices once a month but not exactly on the same date.
>>
>> Don't know what Quicken is calculating because it shows zeros for
most and non-zero values for some. Can't figure out why. What examples
do you need?
>>
>> --
>> Nathan Gutman
>
>
Looking at price history...
Security A 11/2 $20.05 12/3 $19.75 Quicken reports 0 Gain/Loss (Wrong)
Security B 11/2 $13.90 12/3 $13.65 Quicken reports correctly the 1-month
loss by multiplying the price difference by the number of shares.
This what baffles me.
--
Nathan Gutman

Posted by Fred Smith on December 6, 2007, 11:33 pm
Please log in for more thread options
 Part of the reason you are getting so few responses is you make it difficult for
us to try to help you. In any newsgroup, you're going to get responses
commensurate with the amount of information you give. At least now you've given
us an example of what's going wrong. You could have saved at least a week
turnaround time by posting those right from the beginning.

Also, you are better off keeping your response in the same thread. Most posters
always look at threads they've posted to. They may be less likely to look at
other threads depending on the time they have.

To the issue at hand, the questions are:
Are there any transactions (like a dividend) posted between 11/2 and 12/3 for
Security A?
What valuation date are you displaying (12/3, 12/4, or something else)?

--
Regards,
Fred


>I have re-posted this thread from three days ago hoping that someone will come
>up with an answer before the subject dies.
> Nathan
> Fred Smith wrote:
> > I suspect your downloading schedule is causing the problem. If, as
> far as Quicken is concerned, there is no change in price in the last month,
> then the 1-month gain loss is 0%, which is what Quicken is reporting.
> >
> > Pick a security that Quicken is reporting zero for, and check the
> price history. If there's no price in the last month, enter one, and see if
> that solves your problem.
> >
> > For an example, I was hoping to see something like: For Security A, I
> had 1000 shares at 10.00 last month, and they were worth 10.46 yesterday.
> That's a 4.6% increase, but Quicken is reporting 0%. All we're trying to do is
> get the same information you have so we can track down the problem.
> >
> >
> > Regards,
> > Fred
> >
> >
> >> Fred Smith wrote:
> >>> Have you owned the security for more than a month?
> >>> Do you have a previous month-end price on file?
> >>>
> >>> Give us an example of what Quicken is calculating and what you
> think the right answer is.
> >>>
> >> Yes I have owned them for years.
> >> I update/download prices once a month but not exactly on the same date.
> >>
> >> Don't know what Quicken is calculating because it shows zeros for
> most and non-zero values for some. Can't figure out why. What examples do you
> need?
> >>
> >> --
> >> Nathan Gutman
> >
> >
> Looking at price history...
> Security A 11/2 $20.05 12/3 $19.75 Quicken reports 0 Gain/Loss (Wrong)
> Security B 11/2 $13.90 12/3 $13.65 Quicken reports correctly the 1-month loss
> by multiplying the price difference by the number of shares.
> This what baffles me.
> --
> Nathan Gutman



Posted by Nathan Gutman on December 7, 2007, 10:01 am
Please log in for more thread options
Fred Smith wrote:
> Part of the reason you are getting so few responses is you make it difficult
for
> us to try to help you. In any newsgroup, you're going to get responses
> commensurate with the amount of information you give. At least now you've
given
> us an example of what's going wrong. You could have saved at least a week
> turnaround time by posting those right from the beginning.
>
> Also, you are better off keeping your response in the same thread. Most
posters
> always look at threads they've posted to. They may be less likely to look at
> other threads depending on the time they have.
>
> To the issue at hand, the questions are:
> Are there any transactions (like a dividend) posted between 11/2 and 12/3 for
> Security A?
> What valuation date are you displaying (12/3, 12/4, or something else)?
>
Thank you for trying to help. I will provide all information needed but
I don't know what is needed.

The last transaction for security A was reinvested dividends on 9/30/07.
I set the valuation date at 12/3/07 but trying different valuation dates
made no difference. Please consider that the zero 1-month gain/loss
appears for 27 out of 30 securities.

--
Nathan Gutman

Posted by wbertram on December 7, 2007, 1:22 pm
Please log in for more thread options
I believe if you want to see reliable monthly gain/loss you need to have
stock prices entered on a routine monthly or more frequent basis,
ideally, you would have a priced entered for at least the last day of
each month. How else could you compute a meaningful monthly gain/loss?

Nathan Gutman wrote:
> Fred Smith wrote:
>> Part of the reason you are getting so few responses is you make it
>> difficult for us to try to help you. In any newsgroup, you're going to
>> get responses commensurate with the amount of information you give. At
>> least now you've given us an example of what's going wrong. You could
>> have saved at least a week turnaround time by posting those right from
>> the beginning.
>>
>> Also, you are better off keeping your response in the same thread.
>> Most posters always look at threads they've posted to. They may be
>> less likely to look at other threads depending on the time they have.
>>
>> To the issue at hand, the questions are:
>> Are there any transactions (like a dividend) posted between 11/2 and
>> 12/3 for Security A?
>> What valuation date are you displaying (12/3, 12/4, or something else)?
>>
> Thank you for trying to help. I will provide all information needed but
> I don't know what is needed.
>
> The last transaction for security A was reinvested dividends on 9/30/07.
> I set the valuation date at 12/3/07 but trying different valuation dates
> made no difference. Please consider that the zero 1-month gain/loss
> appears for 27 out of 30 securities.
>

Posted by Fred Smith on December 8, 2007, 10:58 am
Please log in for more thread options
OK. Keep the valuation date at 12/3. I agree with others that I think your
problem is your price history has prices for less than one month periods. What
happens if you enter a price for, say, 11/25 or 11/30? Does that get you a
1-month return?

Another obvious question, although it's none of our business, is that 1-month
returns seem very important to you, but not important enough to download prices
more than once per month. Why the disconnect?

--
Regards,
Fred


> Fred Smith wrote:
>> Part of the reason you are getting so few responses is you make it difficult
>> for us to try to help you. In any newsgroup, you're going to get responses
>> commensurate with the amount of information you give. At least now you've
>> given us an example of what's going wrong. You could have saved at least a
>> week turnaround time by posting those right from the beginning.
>>
>> Also, you are better off keeping your response in the same thread. Most
>> posters always look at threads they've posted to. They may be less likely to
>> look at other threads depending on the time they have.
>>
>> To the issue at hand, the questions are:
>> Are there any transactions (like a dividend) posted between 11/2 and 12/3 for
>> Security A?
>> What valuation date are you displaying (12/3, 12/4, or something else)?
>>
> Thank you for trying to help. I will provide all information needed but I
> don't know what is needed.
>
> The last transaction for security A was reinvested dividends on 9/30/07.
> I set the valuation date at 12/3/07 but trying different valuation dates made
> no difference. Please consider that the zero 1-month gain/loss appears for 27
> out of 30 securities.
>
> --
> Nathan Gutman



Similar ThreadsPosted
Re: C/G Report Problem May 9, 2006, 5:52 pm
C/G Report Problem May 8, 2006, 10:13 pm
Categories Report Problem and Split Transactions December 6, 2007, 3:40 am
Problem wiht Portfolio Value by Asset Class Graph/Report October 24, 2007, 9:53 pm
Report Wont Ask to Create Reconcile Report March 15, 2008, 7:42 pm
Cannot Create New Report From Existing Report December 30, 2007, 3:53 pm
Report Transfers September 4, 2006, 12:15 pm
Reconciliation Report November 2, 2006, 8:50 pm
Tax Summary Report January 5, 2007, 1:51 am
Tax Report Wrong January 13, 2007, 8:50 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap