1-month gain/loss report problem

Dec 07, 2007 4 Replies
N

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 >
>
>>> 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.

Vote
Twitter Facebook LinkedIn
F

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)?

Vote
Twitter Facebook LinkedIn
N

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.

Vote
Twitter Facebook LinkedIn
F

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?

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required