For any investor it is very important to keep track of his/her investments on day to day basis. In a volatile market when the market value of ones portfolio changes dramatically everyday, it becomes very difficult to calculate Profit and/or Loss on investments. So I have made a Portfolio Tracker Tool based on Excel.
The Portfolio Tracker can calculate the amount of profit or loss that you are making on individual stocks and also total amount of profit/loss that you are making on your entire portfolio. It can show the profit/loss in percentage terms. Beside that you can also know the percent weightage of each stock in your portfolio. All you have to do is just enter the name of the scrip, quantity of shares, purchase price per share and current market price of each stock. It’s a very valuable tool. I’m using it since 2004.
In order to access the tool click the link given below:
No comments:
Post a Comment