Adjusting for Bonus/splits…

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

guest
0 Comments
Inline Feedbacks
View all comments
Nishitha K
Nishitha K
5 years ago

Do you expect with any of portfolio Same.

Can we know the name of Same.

R

Nishith

>

Suresh Kumar
Suresh Kumar
5 years ago

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

Related posts

November 22, 2019 by Weekend Investing
September 26, 2016 by Weekend Investing

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…