Steps on how to add/remove capital to a running Weekendinvesting portfolio..

How to add capital to your exisiting portfolio
1. So you are say having some allocated of xx lacs and a running portfolio of y no of stocks.
2. Now you want to add /remove some capital to this
3. Go to the utility on the master-sheet and add the proposed capital amount on the top right orange box
4. You will now have the additional quantities that you need to purchase ( including liquid bees) with your additional capital (or the qty to be removed for reduced capital)
5. Once purchased (sold), for each stock, now you have to manually (or on excel) calculate your now total qty and average price and replace in the appropriate columns (in your sheet).
6. Replace PFstart (P2) with your original + (or minus) the proposed capital
7. This should be it. If errors try to see if can fix it else go to File>version history> and restore the version before changes and do all over again.

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.