1. Home
  2. Quicken Personal Finance
  3. Stock Split Problems in Q2005

Stock Split Problems in Q2005

PROBLEM # 1: In two of my stocks which recently split two-for-one, it appears that Quicken is splitting them twice for graphing purposes even though I have only one transaction entry for each stock split. For example, ConocoPhillips split two-for-one on 6/1/05. The share price before the split was around $110 and around $55 after the split. These original daily share prices are correctly shown in the "edit price history" listing and they are correctly graphed when the "adjust for split" is NOT checked. However, when the "adjust for split" IS checked the Quicken graphs a value around $26 before the split and and $55 afterward, when it should be graphing around $55 before and after. The same situation happened with Timberland which split two-for-one on

4/27/05. In other cases of stock splits in my portfolio, the graphing is OK, so I cannot understand why only these two should have a problem.

PROBLEM # 2: When a stock splits, the value in the "Day Gain/Loss" column for that stock is always incorrect showing a huge loss. However, the following columns are correct: new number of shares, new share price, day change in stock price, and percent day change in stock price.

I am running Q2005 Deluxe Release R 3.

Any suggestions?

Bill

Reply to
Bill R
Loading thread data ...

-------------------------------------

I have a problem similar to #1 above. PFE (I have that stock in multiple accounts) does not graph properly following the 1999 3:1 split. It appears to be splitting the price twice. The graph shows a price of 30 after the split. The price history properly shows a price of $90 before the split and $30 after (approximate numbers), however the graph shows a price of $10 before the split and $30 after the split (with the box checked to account for splits). I'm currently using Quicken version Rental Property Manager 2010.

I didn't see any answer to Bill's question above. Can anyone help?

Reply to
smirussell

One thing to look for is a Quicken split transaction, for the security in question, with a transaction date different than the actual split date.

Reply to
John Pollard

?Hi, John.

My stocks haven't needed to split in a few years. :>( But when they did in the past, I never did manage to get the split date recorded properly to have Quicken produce a smooth graph of the value. And changing the date by a day or two, forward or back, didn't help. While the numbers in net worth were correct, the graph always showed a sharp "V" shaped dip on or about the date of the split - or a sharp spike. It leveled out immediately, of course, but that one-day plunge or spike always looked weird. I would get either half the shares at the new low price, or double the shares at the old high price. :>(

RC

Reply to
R. C. White

Some of that spikyness may get levelled out if you put a check mark in the "Adjust for Split" option.

This (apparent duplicate splits) happened to me once, quite a while ago. I "solved" it by looking up the split date at Yahoo and changing the Quicken split transaction date to agree with the Yahoo date.

The conclusion I drew at the time was that Quicken keeps its own (internal) split dates, and if your split transaction has the same split date as Quicken, only one split is used. But it seems if the date of the split transaction is different by even one day, Quicken treats it as a separate split.

[Quicken even warns when it thinks a split transaction is missing ... and offers to enter it for you; so it definitely has split information separate from the split transactions in Quicken investment account registers.]
Reply to
John Pollard

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.