i want regarding this code

[Former Member]

Name of the Report Transaction in Equity Market during the Month-Anx 8A

Field Name Source

Company TPM13: SECURITY_ID

Investment As at 01/0x/200x* TPM12:BOOKVALUE_POSITION_Crcy.

Date TPM13: TRL DATE

Quantity TPM13: UNITS

Price TPM13:IT_TXNPRICE-BUPRC

Investment TPM12:BOOKVALUE_POSITION_Crcy

Cost of Sales WAC*Quantity

WAC= AVERAGE RATEACQU_VAL

Quantity= UNITS

Investments (as at 30/xx/xxxx) Opening Balance *+-Cost of Sales

(Addition of individual investments)

Special Notes: Sort by counter party, subtotals of counter party wise.

this type out put i want

Sheet1

A B C D E F G H I J

1

2

3 Id Number Company investment/ 01.03.2005 Date Quantity Price(Rs.) Investment(Rs.) Cost of Sales Investment/ 31.03.2005

4

5 50005 Comm Pref.share 124,242,235.82 02.03.2005 2,000,000.00 10 0 20,715,670.83

6

7 31.03.2005 5,000,000.00 13 65,796,275.00 0 169,322,839.99

8 50030 AHOT 25,306,250.00 01.03.2005 500,000.00 50 0

9

10 02.03.2005 500,000.00 55 27,836,875.00 0

11

12 05.03.2005 100,000.00 60 0 5,314,312.50 47,828,812.50

13

14 50035 Tkoy 0 01.03.2005 500,000.00 50 25,306,300.00 0

15

16 02.03.2005 500,000.00 55 27,836,925.00 0

17

18 05.03.2005 100,000.00 60 0 5,314,322.50 47,828,902.50

19

20 Total 124,242,235.82 9,200,000.00 353 172,082,625.00 31,344,305.83 214,368,004.99

[Former Member]

that output is exel sheet like

psle

just send me coding i will check taht