Adjusting for Bonus/splits…

Mi Users,

If your stock goes in for a Bonus/Split adjustment, update your sheets like this :

Say you hold 1000 shares of XYZ at 50 rs per share

Now say you get a Bonus 1 shares for every 2 held

Go to your sheet and update your qty to 1000*(2+1)/2 = 1500

and your purchase price to Total amount of original purchase divided by total shares: 1500

Your sheet will work perfectly with the Current market price hereon

3 thoughts on “Adjusting for Bonus/splits…

  1. Any stock which has declared bonus or split in Mi25 portfolio?

    On Tue, Jan 23, 2018 at 9:57 AM, WeekendInvesting.com wrote:

    > WeekendInvesting.com posted: “Mi Users, If your stock goes in for a > Bonus/Split adjustment, update your sheets like this : Say you hold 1000 > shares of XYZ at 50 rs per share Now say you get a Bonus 2 shares for every > 1 held Go to your sheet and update your qty to 1000*(2+1) = 3000” >

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.