I have purchased 12 shares of a company @ Rs 85/- on 01-04-12. I sold 4 shares @ Rs 92/- on 15-06-12. I purchased 2 shares of same co. @ Rs 116/- on 27-07-12. Then I again purchased 7 shares of same co on 30-09-12. I sold 8 shares @ Rs 210/- on 13-05-13. How to calculate realized profit/ Unrealized Profit/Loss earned with reference to money I invested at different time and what is Profit/Loss if share price is Rs 110 today. Also say I had invested the same money in fixed deposit in a bank with interest rate of say 9% per annum what would be Profit/Loss w.r.t.same money at same time in a bank? This is an example. I want standard Excel Worksheet to solve my day to day problem please.