My Portfoilo- A Excel Utility for maintaining your Share Market portfolio in Realtime
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 %
Great utility tool……..
not working even if i enable macros. error massage comes “No macors found named ‘my-portfolio.xlsx!macros1’. pl.resolve
Macro will not work from the downloaded file… you need to change the worksheets from worksheet tab. however Other main functions of the Utility tool are working….
Hi Prasenjit,
I have downloaded the utility but not able to use the same as I am not able to see the drop down option to add a scrip to my folio.
I have also written an e mail to you regarding this and given some more suggestions.
Please see and reply.
Regards
Yes Received the mail… will get back to you soon..
I have the same macro problem. Could you please share me the macro to my mail? Thanks