To use this software, minimum requirements are
Microsoft Windows PC with
          Microsoft Excel 2000 or later,
          java run time environment, JRE.  If not installed get it from here..http://www.java.com/en/download/manual.jsp       


Unzip all the fies in attached(XLCapitalGains.zip) zip file to your PC.
After unzipping XLCapitalGains directory will be created like for ex: c:\XLCapitalGains\

Click on XLCapitalGains.Exe in the installed directory.

Input file required for the application should be an excel file. SOpen  attached TestTransaction.xls for reference.
    The first sheet named as transaction contains all transactions in the below format.
    The second sheet contains the current market price for each stock.
(Refer to TestTransaction.xls in the attached zip file)


The transaction sheet should contain entries in the below format.
Stock 	TransactionDate 	Transaction Type 	Quantity 	Avg Purchase Price
TANLASOLU 	22/09/2008 00:24 	BUY 	10.00 	184.12
CROMPTON 	22/09/2008 03:17 	BUY 	50.00 	258.95
CROMPTON 	22/09/2008 03:27 	SELL 	50.00 	260.05
TANLASOLU 	22/09/2008 03:50 	 SELL 	2.00 	185.60
BHARTI 	22/09/2008 02:36 	 SELL 	10.00 	808.50
TANLASOLU 	22/09/2008 03:18 	 SELL 	8.00 	178.25
CROMPTON 	22/09/2008 04:15 	 SELL 	150.00 	256.00
RIL 	22/09/2008 01:04 	 BUY 	3.00 	2040.00
MARUTIUD 	22/09/2008 01:00 	 BUY 	10.00 	730.00
ICICIBANK 	22/09/2008 12:59 	 SELL 	10.00 	630.00
RIL 	22/09/2008 11:58 	 BUY 	3.00 	2062.00

(Make sure that stock names are left aligned in the cell, should not contain white spaces in the left & remaining cells are right aligned as in the attached xls document.)

The currentmarketprice sheet  should contain entries in the below format.
Stock 	Avg Purchase Price
BHARTI 	828.37
BHEL 	2263.36
BRIGADE 	275.52
CROMPTON 	290
HDFC 	2232.79

Save the excel file.

Using Application:

   1. Launch the ExcelCapitalGains application by double clicking on it from where you have installed.
   2. Load input transaction file using Browse button.
   3. Click on Comput Button.
   4. The computed result sheet will be opened.


The demo version of the software work with particular stocks only like ICICIBANK,HDFC, RIL,CROMPTON, BHARTI  and PowerGrid.
When you purchase the software does not have limitations on the stocks & report size.
In the full version,

    *  application works for all Stocks & MF
    * dividend income addition as a part of realised gain.
    * one more sheet to enter check inward/outward to compute the final earnings.


If you experience any problem in installing feel free to contact me.


 Thank you for trying  XLCapitalGains. 