Problem with Stock Split

[nittany85]

I have owned a stock since 1997 and in 2003 there was a 2 for 1 stock split. Now it appears that the Split information is no longer working. The number of shares after the split are the same as before the split. I have been using Fund Manager for many years and I think that this issue has appeared after a recent upgrade to version 10.9.

Anyone else having problems with old splits?

[Mark]

Hello nittany85,

If you look in the Data Register under the data type of "Splits", do you see your split transaction recorded? Where are you looking at the share balance? Can you give me some specific numbers on what you have recorded for purchases, splits, and what you see your balance to be?

[nittany85]

A 2 for 1 stock split was registered on 12/16/2003 and is shown in my Data Register.

I made a purchase on 10/02/1997 for $1,000.00 at a price of $48.59/share which resulted in 20.58 shares. But, with the View\Split Adjusted off (no check mark next to Split Adjusted) the Data Register now shows the 10/2/1997 purchase price as $97.19/share and 10.289 shares purchased. When I turn on the Split Adjusted view (with check mark next to Split Adjusted) the purchase information in the Data Register matches the actual purchase.

When I look in the Investment Transactions report for this stock and toggle Split Adjusted view ON and OFF the Share Balance before the stock split changes, but the values are only half of what they should be. The number of shares after the stock split are half of what they should be and do not change when I toggle the Split Adjusted view.

This is data that was entered many years ago and I have not made any changes to those investments. I continue to purchase this stock today as part of a regular investment plan and I am confident that this is a new problem as I monitor this share balance on a regular basis. I upgraded recently to v10.9 (in the past month?) and I suspect that is when this problem happened.

I should mention that I have another stock that also had a 2 for 1 split and that information is still correct.

[Mark]

Hi nittany85,

Thanks for the nice detail. You are the 2nd person I've seen with this issue, so it does sound like there may be a bug we don't know about. What version of Fund Manager were you using before you upgraded to 10.9? Did you recently do anything in this investment, like record some transaction? If you can think of anything else that can help us reproduce this problem that would be helpful.

To fix it, you can go in and edit your $1000 purchase. Whenever you edit a transaction, the transaction should show in the dialog with the information as it happened on that transaction date.

[nittany85]

I keep up to date with the updated versions. My update to v10.9 was from v10.8.

I still invest in this stock so the data file that has the split is active with regular purchases every month and and daily price updates.

The only thing different with this stock is that it is part of my company's 401k and as a result the price per share is slightly different than the daily close in the market. Therefore, when I download price updates from the internet I manually adjust it to match the actual price of the stock in our retirement plan. I have been doing this for several years though so I do not know why it would have caused the problem now.

I have the Split Adjustment View OFF. When I go to edit the purchase it shows the price as 2X what it was on that date and the number of shares purchased is 1/2 of the shares I purchased.

[Mark]

Hi nittany85,

Would you mind emailing me this investment file? I would like to take a look. I've spent some time looking into this, and haven't been successful in reproducing it, or finding a bug. Were your closing prices affected by this problem, or is it only the transactions?

Since it sounds like you have many purchases, you may want to restore this one investment only from a backup (*.FMB). If you don't have your own backups, Fund Manager creates automatic ones, that you can restore from. When restoring, choose to only restore that one investment.

[nittany85]

I restored the stock file from a backup made in the middle of January and the problem looks like it is fixed. I am going to send you both the file that has the problem as well as the restored file that is correct.

[nittany85]

Where should I send the files for your review?

[Mark]

Hi nittany85,

Thanks for the plans to send those files. I've just sent you an email, so you can reply to that with the 2 *.dat files attached.

[nittany85]

Mark,

I made a change to the file that caused the problem to happen again.

As I mentioned in an earlier post I manually make changes to the price of the fund after downloading it from the internet. In the past I have done this by opening the Data Register and then the Edit button. The pop up screen shows the Closing, Open, High, and Low prices and the Volume. In the past I have just changed (typically multiply the closing price by .95) the Closing price but not the others. When I did it today it caused the problem to reoccur.

I restored the file which had the correct prices for the split again and then downloaded today's price. I manually changed the Closing price in the same manner but this time I deleted the other values for Open/High/Low and Volume. No problem when I did it this way.

[Mark]

Hi nittany85,

This is promising that you are able to somehow reproduce it. I opened the good investment file you sent me previously, and tried to retrieve, but the file you sent me had an empty name and symbol? It of course didn't retrieve a price since the symbol was empty. I just tried editing the last price as you described, but couldn't reproduce the problem. A few questions:

1) Is your name/symbol empty too, like in the file you sent me?

2) Can you reproduce the problem again if you repeat the same steps?

3) Did you notice when exactly the problem happened? Was it after the retrieving of prices, or was it right after you edited the price? Did you save, and re-open before you noticed it, or was it just right after you edited the price?

4) Are you editing the price from within the Data Register and the "Prices" data type?

5) What quote server are you retrieving from?

Thanks for your help.

[elliots]

Mark,

I'm now seeing a problem which appears related to this. I ran a Performance report (and an Investment report) on a client's portfolio for quarter to date and saw a substantial error in the IRR for a specific stock. I had bought 200 shares in 2009, and the stock split 3:1 on December 21 2010. The original purchase and the split appear to be correctly entered in the Data Register. When looking at the position in portfolio editor I see 600 shares of the stock. Looking at the stock price in the editor, I find that the post split prices don't appear until 1/21/11. The dollar value on the reports is using the pre-split price (from 12/31/10) and 600 shares to calculate the beginning value, and the post-split price and 600 shares to calculate the ending value.

I have this same position and same problem for a second client.

Prices have been imported from Scottrade data files; I entered the split manually -- I think this was the split that your import module missed and I reported to you before (and you fixed the import).

Elliot

[Mark]

Hi Elliot,

This does not sound like it is from this bug. You would have an incorrect number of shares and your initial purchase would not show correctly if this same bug were happening. It sounds like somehow the prices from 12/31/10 - 1/20/11 were somehow incorrect. If you go look in one of your Scottrade price files within this date range, does it have the correct pricing?

Scottrade price files end in *.SE1. You can edit one with a text editor, like Notepad. The price is in columns 200 - 299.

[elliots]

Mark,

Sorry for the trouble; the split actually happened on 1/21/11 not 12/21/10. All is OK again.

Elliot

[rm_organ]

Mark,

Was there ever a resolution to this? I am running 10.9 too and have now uncovered this issue with several investments. I might not have noticed it quickly enough to go back to the auto backups, but am wondering if the problem has been resolved. I have been manually fixing - slow process, but its the best I can do.