I'm Sorry Francis for continuing to call.  I didn't see your e-mail.

 -----Original Message-----
From: 	Lim, Francis S.  
Sent:	Tuesday, November 06, 2001 2:25 PM
To:	McLaughlin Jr., Errol
Subject:	FW: URGENT REQUEST

We are working on your urgent request.

 -----Original Message-----
From: 	Lim, Francis S.  
Sent:	Tuesday, November 06, 2001 2:25 PM
To:	Gupta, Sanjeev
Subject:	URGENT REQUEST

Contact: Errol McLaughlin
tel:5-8274
list of all deals done in the last 30 days
and their duration (Start date and end date).
Do a quick and dirty sql in toad
and paste it in excel then mail it to Errol

select * from egs_price_basis
where quote_deal_status_cd != 'K'
and portfolio_type_cd = 'P'
and book_cd = 'G'
and deal_dt >= trunc(sysdate)-30
filter out
	no book to book deals
	no desk to desk deals
	no internal deals

Duration of the trade for the price book over the last 30 days
Excel
deal num
commodities
start date
end date
qty....etc..relevant information about the deal