Adjusting for Bonus/splits…

January 23, 2018 1 min read

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

0 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” >

Leave a Reply

Your email address will not be published. Required fields are marked *

Related posts

Practical insights for wealth creation

Join the thousands of regular readers of our weekly newsletter and other updates delivered to your inbox and never miss on our articles.

Thank you. You will hear from us soon.

Mail Sent Failed !

    vector

    Adjusting for Bonus/splits…