Have a stock market data for period of many years. This code or template in EXCEL should create 1. P&L Statement for the any specified year 2. Calculate Capital Gains based on FIFO and other Income tax rules. 3. Show updated inventory as on any date with purchase valuations. 4. Should be able to pull out rates from Google Finance and provide valuation based on current market rates.
Data fields would be 1. Date 2. Stock Code 3. Stock Name 4. Stock Broker 5. Buy/Sell 5. Quantity 6. Market Rate 7. Brokerage 8. STT 9. Stamp Duty 10. Taxes 11. some other fields.