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 %
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…
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.
I am unable to insert rows to put my holding which is more then 30 rows also some of script are not there how to insert?
this does not speak about other cost (other than brokerage)
Sir,
The Sheet is Protected and asking for Passord in Excel 2013, i tried enabling Macros but its not working,
Dear Sir,
For any problem in the sheet mail me at paul_prasenjit@yahoo.co.in
Hi Sir,
Now its working…. there was some micro enable issue yesterdsy…
Thanks it is a good sheet…
Regards,
CA. Vishal Gupta
Sir,
it is difficult the download the software
prakash jhaveri
Hi Sir,
Security prices are not getting change according to market price….
Regards,
CA. Vishal Gupta