Enron email

Algorithmic Indexing

2 Oct 2001, 18:02 UTC

RE: Index curves

From
Francis S. Lim s..lim@enron.com
To
Jason Wolfe
Date
Tue, 2 Oct 2001 11:02:31 -0700 (PDT)
I'm confused. The gas daily prices is ok.
Question on index curves. What index curves do you need?

	a. the curves from egs_curves that are inserted into the
	   database everyday because the prices are different everyday.
	   risk type code = 'I' and curve_type_cd = 'PR'.

	b. the curves from the pub posting that are inserted into
	    the database once a month. These are the settle price curves.
	    risk type code = 'D' and curve_type_cd = 'SP'
Quoted or forwarded from earlier messages
-----Original Message-----
From: 	Wolfe, Jason  
Sent:	Monday, October 01, 2001 12:45 PM
To:	Lim, Francis S.
Subject:	RE: Index curves

That's fine. The Index curves we are most concerned with (the current month), will be set in the next day
or so and will not change for the duration of the month. Next month's index curves can be loaded whenever.

Jason

 -----Original Message-----
From: 	Lim, Francis S.  
Sent:	Monday, October 01, 2001 12:41 PM
To:	Wolfe, Jason
Subject:	FW: Index curves

I am still waiting for your reply.

 -----Original Message-----
From: 	Lim, Francis S.  
Sent:	Wednesday, September 26, 2001 11:39 AM
To:	Wolfe, Jason
Subject:	Index curves

Jason,

	The Gas Daily Curves are loaded into the system everyday at 6AM
	or something when they have problems, the curves are loaded at
	around 11AM. I can get these curves as soon as they get it.
	However, Index curves are loaded by GGREENA, CFRANK2, and CRABON
	at around 3PM or 4PM. I will not be able to get these curves.
	I can get Yesterdays Index curves.


select effective_dt,curve_cd, book_type_cd, curve_type_cd, ref_period_dt, curve_amt
 from egs_curves
where effective_dt = trunc(sysdate)
and curve_cd like 'GD%'
and book_type_cd = 'D'
and curve_type_cd = 'SP'

select effective_dt,curve_cd, book_type_cd, curve_type_cd, ref_period_dt, curve_amt
 from egs_curves
select * from egs_curve_def
where effective_dt = trunc(sysdate-1)
and book_type_cd = 'I'
and curve_type_cd = 'PR'
and curve_cd in (
'NGI-PGE/CG',
'NGI-SOCAL',
'IF-ELPO/SJ',
'IF-ELPO/PERMIAN',
'IF-WAHA-TX',
'NGI-MALIN',
'NGI-PGE/TOPOCK',
'NGI-SOBDR-SOCAL',
'NGI-SOBDR-PG&E',
'IF-NWPL_ROCKY_M',
'IF-NTHWST/CANBR'
)