Mutual Fund Split show incorrect prices pre-split

cwiener
cwiener Member ✭✭✭
edited November 29 in Investing (Mac)

I have a few mutual funds that split effective October 24. For some reason, the prices (but not the quantity) were adjusted for every day back to September 26 (four weeks back).

When I try to rebuild the price history, the prices are incorrectly adjusted for the specific dates of September 5, 12, & 19.

This results in an inaccurate price history - a sawtooth pattern in September followed by a huge drop in value lasting four weeks. Any way to fix this besides manually going in and correcting the prices for those specific days?

Comments

  • John_in_NC
    John_in_NC Quicken Mac Subscription SuperUser, Mac Beta Beta
    edited October 28

    See this thread to explain what is going on. Many of us have seen this with splits, and it isn't a bug, but rather with reporting:

    https://community.quicken.com/discussion/7965070/stock-split-pricing

    Note NotaCPA's response explains what is going on: The Ex-Date is when the stock starts trading at the split price, and the Record date is when you see the actual split in your Quicken file-hence the artificial dip in value.

  • cwiener
    cwiener Member ✭✭✭

    Thanks for that as it is my exact situation and it’s both reassuring and frustrating to see that it’s not uncommon.

    @NotACPA's explanation is a little puzzling to me since the 30-day lookback period is a constant and one would think the ex-date would vary by security. And, in my instance, the funds didn’t start trading at the split price until October 27 while the record date was October 24.

This discussion has been closed.

Categories