CA Prasenjit Paul
A simple Excel Utility that manages your Share market portfolio in real time. Its basic features are:
  • This sheet gets updated automatically in every 2 minutes to give realtime position
  • If your stock is todays gainer Current price will automatically become green otherwise red
  • Set target to sell or watch, Cell become green & fonts bold & red when it reaches
  • t will calculate your shares profit/ loss & your portfolios. Even its shows netoff brokerage Profit or Loss if you put brokerage % applicable to you.
  • It shows you your Investment as on date, your just needed to fill Ledger column in your sheet
  • Its calculate BEP of any share purchased when you put brokerage % applicable to you.
  • Its also calculate every shares monthly return %

Download Excel Utility

More Under Finance

9 Comments

  1. SALMAN PASHA RAASHID says:

    not able to add stocks which are not listed in your sheet, like Edelweiss Financials, please let me know how to add this

    excel sheet is good… simple…

  2. Rohan says:

    Please tell me how to get data for Current Price for other companies. I am not able to get the current stock price as other Company names are not working. Please help.

Leave a Comment

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

Search Posts by Date

October 2020
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031