This is a simple spreadsheet that allows you to pull stock quotes in from Yahoo Finance, for a range named 'Stock Symbol'. If you change the symbol, the company names and stock prices will change as well. This spreadsheet just makes it easier to track a portfolio using Excel.
For NSE use 9 or less Character NSE Code and suffix with .NS(i.e NSE Code for Infosys is INFOSYSTCH so in Stock Symbol type INFOSYSTC.NS)
For BSE use BSE Code and suffix with .BO (i.e BSE Code for Infosys is 500209 so in Stock Symbol Type 500209.BO)
Step1: Add your stock in Stock List Sheet,Get Yahoo Quote for the same.
Step2: Then Add your Stock in your Portfolio Sheet.
Virtually all-financial quotes tell you the amount that a stock has changed since the prior close. One benefit of this spreadsheet approach is that by recording your observation, you can review the change since the last time you looked at your portfolio, whether that was an hour or a week ago.
This is written in visual basic for excel, and we have left the source code open.