In microsoft.public.money, Ouroboros wrote:

- quote -

A split must be entered as a ratio of integers, each of which can be
1...65535. A 2 for 3 split is as close as you can get for the result
you specify above.

Money is not going to display the shares to seven decimal places.

I assume the special dividend is a cash dividend. That sounds
straight forward enough.

- quote -

I suspect you have more than one split entered. Look thru the list
for more, and delete the unwanted one(s).



- quote -

- quote -

I've tried to enter the fractions (2 for 3) and see the result and then
delete if price history if wrong. The problem is that until I see how the
calculation is working it's not as easy as say goal seeking in excel.

492.394841 became 328.2632273 shares (and I recieved a special dividend).
It's a sharebuilser account and the holdings are ina shared nominee account
so these were the real before and after values. whether I enter 2 for 3 or
328263 for 492394 it comes up with the same wrong answer in total (275.851).
I'm afraid it's changing the prices to get this circa 56% ratio adding up
rather than 66.6r%.

I'm thinking I may have to do a pretend sell and rebuy to accomodate this or
one of the actions recommended by MS before Money sould track splits. But
then I'm afraid I'll lose the total gain tracking of a share that went
through two corporate actions in my holding history.

In microsoft.public.money, Ouroboros wrote:

- quote -

True. If you enter a split that was not the right thing, delete the
split and enter the correct one. Deleting your current value might
be useful to answer the question below. Also note that entering a
split for the same date will replace the existing split after a
warning.

- quote -

What is the official split ratio, how many shares did you have
before, and how many shares do you actually have afterward? I doubt
that your statement actually says you hold 390.789166 shares.


- quote -

Cal,

Many thanks - I see MS money also records the splits in the price history.
I'm having problems making this X for Y matching real world values though.
For instance in one action I lost one in every three shares:

492.394841 became 328.2632273 shares (and I recieved a special dividend)
So I enter the split

2 shares for every 3 and I get 275.851 in total after it applies this split!
Am I missing how the calculation is applied - I'm not sure if it plays with
the price to make this work, but I can;t allow this becuase this share has to
keep this number for a future spin off calculation to work.





"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Ouroboros wrote:

- quote -

Go to the details for the investment. Find RecordASplit in the left
column. Enter a 11905 for 10000 split or 2381 shares for every 2000
shares.

Usually, for a stock, the broker provides "cash in lieu" for
fractional shares. Money will ask if you should maintain the
fractional shares in the account or to sell.

Hi,

In a Stock Investment account register (Investement Transactions) I have
390.789166 shares of a stock. They implemented an action where existing
ordinary shares were subdivided and consolidated so that I recieved 1.1905
new ordinary shares for every existing ordinary share.

Now with the actions in the 'Activity' drop down I don;t see anything about
splits/spin offs etc - but I'm sure I've seen this somewhere in the
application - how would I account for the above?

Cheers,