i want regarding this code

Former Member — Mon, 16 Apr 2007 08:57:59 GMT

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

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

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

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

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

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

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

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

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

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

Re: i want regarding this code

Former Member — Mon, 16 Apr 2007 09:00:54 GMT

that output is exel sheet like

psle

just send me coding i will check taht