CA Prasenjit Paul
This Excel Sheet calculate your portfolio in real time. Benefits of the sheet is that you have a complete scenario of your portfolio (total Gain/loss at the moment, total brokerage actual gain/loss including brokerage etc.) at a glance with out opening any site, where you need to check the prices of your stock one by one. its also show whether your stock is todays gainer or loser by changing its current price column colour (Green of gainer & red for Loser). This Sheet requires Internet connection & takes automatic updates in every 2 minutes.
Just activate the data connection after opening the sheet. First make your portfolio by finding & coping the stock name of yours from the Gainers or Losers sheet & paste the same in the Stock name column in main sheet, Put your Purchase Price, Qty & the brokerage % applicable to you in the brokerage column for one time.