Hi Chaitanya,
The Excel sheet posted by Uma contains all the required formulas inside. You don't need to program anything. Therefore you can use that sheet itself and replace the existing values with your data. But remember not to do anything in the columns J, K, L, M and N. That is the columns with heading "P/L per share", "Total P/L", "P/L %", "Stoploss Reached?" and "Target Reached?" should not be changed. Don't delete anything in these columns even if they are empty. The Data in these columns will be calculated automatically when you put your data in the other columns. You can change the first two rows which contain the title to suit your needs. Column A to I contain your data.
The sheet at present holds 54 stocks. If you need to add more rows just go to last empty row copy the contents of the cells in column J to N from the row above into the corresponding cells of the last row. This you can repeat for any number of rows as you need.
This is all there for the worksheet. Not at all a difficult job.
-Anant
The Excel sheet posted by Uma contains all the required formulas inside. You don't need to program anything. Therefore you can use that sheet itself and replace the existing values with your data. But remember not to do anything in the columns J, K, L, M and N. That is the columns with heading "P/L per share", "Total P/L", "P/L %", "Stoploss Reached?" and "Target Reached?" should not be changed. Don't delete anything in these columns even if they are empty. The Data in these columns will be calculated automatically when you put your data in the other columns. You can change the first two rows which contain the title to suit your needs. Column A to I contain your data.
The sheet at present holds 54 stocks. If you need to add more rows just go to last empty row copy the contents of the cells in column J to N from the row above into the corresponding cells of the last row. This you can repeat for any number of rows as you need.
This is all there for the worksheet. Not at all a difficult job.
-Anant
can you send excel sheet on balram_r(at) hotmail dot com
Regards
Balram