Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
.gitignore
README.md

README.md

Legacy SQL

-- Update the date

DECLARE @Deadline DATETIME DECLARE @NewDeadline DATETIME DECLARE @templatename as varchar(30)

/*Set new values */

SET @NewDeadline = '2012-07-11 02:45' --SET @NewDeadline = getdate() --SET @templatename = 'F-ISOCY' SET @templatename = 'E-MTCL' --SET @templatename = 'F-TOLD' --SET @templatename = 'GLOBAL_P_3' --SET @templatename = 'NSEA_3'

--SET @NewDeadline = '2012-05-31 11:35' --SET @templatename = 'WCR_3'

update r set rp_deadlinedate = @NewDeadline from template tp inner join report r on r.rp_templateid = tp.tp_templateid where tp.tp_templatename = @templatename and r.rp_deadlinedate = (select max(rp_deadlinedate) from report r_in where r_in.rp_templateid = r.rp_templateid)

XQuery

Clean DB

xdmp:collection-delete("Regions"); 
xdmp:collection-delete("Audit"); 
xdmp:collection-delete("images"); 
xdmp:collection-delete("ProductData"); 
xdmp:collection-delete("SubEdit_Audit"); 
xdmp:collection-delete("Preferences"); 
xdmp:collection-delete("Thresholds"); 
xdmp:collection-delete("ProductTemplates"); 
xdmp:document-delete("/mldeploy/latest.xml");

Activate Crude

xdmp:node-replace(doc("/icis.dnr.template/W-CR3-WAFR.xml")/ProductTemplate/Status, );

Node Replace

xdmp:node-replace(doc("/icis.dnr.template/W-CR3-GLOBAL.xml")/ProductTemplate/Status ,

) ;

Collection Delete

xdmp:collection-delete("Regions")

Nail the DB

let $numberOfTemplatesToCreate := 25
let $regions := ("Africa","Americas","China","Asia","CIS","Middle East","World","Europe")
for $id in (1 to $numberOfTemplatesToCreate)
let $index := xdmp:random(7)+1
let $region := $regions[$index]
let $hour := xdmp:random(23) cast as xs:string

let $hourFull := if (string-length($hour) = 1) then 
concat("0",$hour)
else $hour

let $templateXml := 
  TEST{$id}
  TEST{$id}
  TEST{$id}
  WorldCrudeReport
  1
  {$region}
  
  
    Daily
    Daily
    {$hour}
    45
    1,2,3,4,5,6,7
  
  
    
      Period
      
  
      
        
          DerivedDate
          
        
          Empty
          
          text
        
          
        
        
          DerivedDate
          
        
          Empty
          
          text
        
          
        
        
          DerivedDate
          
        
          Empty
          
          text
        
          
        
      
    
    
      BFOE
      
        
          Spot
          
        
          Dated
          Dated
          text
        
          
        
        
          ForwardTradingSpot
          
        
          Month
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Month
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Month
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Month
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
      
    
    
      Brent Dubai
      
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
      
    
    
      Dubai
      
        
          ForwardTradingSpot
          
        
          Month
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Month
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Month
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
      
    
    
      WTI-Brent
      
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
        
          ForwardTradingSpread
          
        
          MonthRange
          input
        
          
        
      
    
    
      WTI
      
        
          ForwardTradingSpot
          
        
          Month
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Month
          input
        
          
        
      
    
      
    
    
      Singapore Close
      
    
      
        
          DerivedDate
          
        
          DateText
          calculate
        
          
        
        
          DerivedDate
          
        
          WeekDayText
          derivetext
        
          
        
        
          DerivedDate
          
        
          TimeText
          input
        
          
        
      
    
    
      BFOE
      
        
          Spot
          
        
          ?
          ?
          text
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      BRENT-DUBAI
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      DUBAI
      
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      WTI-BRENT
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
      
    
    
      London Midday
      
    
      
        
          DerivedDate
          
        
          DateText
          derivetext
        
          
        
        
          DerivedDate
          
        
          WeekDayText
          derivetext
        
          
        
        
          DerivedDate
          
        
          TimeText
          12:30pm
          text
        
          
        
      
    
    
      BFOE
      
        
          Spot
          
        
          ?
          ?
          text
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      BRENT-DUBAI
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      DUBAI
      
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      WTI-BRENT
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
      
    
    
      London Afternoon
      
    
      
        
          DerivedDate
          
        
          DateText
          derivetext
        
          
        
        
          DerivedDate
          
        
          WeekDayText
          derivetext
        
          
        
        
          DerivedDate
          
        
          TimeText
          2:30pm
          text
        
          
        
      
    
    
      BFOE
      
        
          Spot
          
        
          ?
          ?
          text
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      BRENT-DUBAI
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      DUBAI
      
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      WTI-BRENT
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
      
    
    
      London Snapshot
      
    
      
        
          DerivedDate
          
        
          DateText
          derivetext
        
          
        
        
          DerivedDate
          
        
          WeekDayText
          derivetext
        
          
        
        
          DerivedDate
          
        
          TimeText
          4:30pm
          text
        
          
        
      
    
    
      BFOE
      
        
          Spot
          
        
          Mid-Point
          Mid-Point
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      BRENT-DUBAI
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      DUBAI
      
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      WTI-BRENT
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
      
    
    
      Exchange Close
      
    
      
        
          DerivedDate
          
        
          DateText
          derivetext
        
          
        
        
          DerivedDate
          
        
          WeekDayText
          derivetext
        
          
        
        
          DerivedDate
          
        
          CommentaryTime
          input
        
          
        
      
    
    
      BFOE
      
        
          Spot
          
        
          ?
          ?
          text
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      BRENT-DUBAI
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      DUBAI
      
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpot
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      WTI-BRENT
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
    
      WTI
      
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
        
          ForwardTradingSpread
          
        
          Low
          Low
          input
        
        
          High
          High
          input
        
          
        
      
    
      
    
  
  {

let $numberOfBackIssues := xdmp:random(200) 
for $x in (1 to $numberOfBackIssues)
let $issueIdDay := (xdmp:random(27)+1) cast as xs:string
let $issueIdMonth := (xdmp:random(11)+1) cast as xs:string
let $issueIdYear := xdmp:random(11) cast as xs:string

let $issueIdDayFull := if (string-length($issueIdDay) = 1) then 
concat("0",$issueIdDay)
else $issueIdDay

let $issueIdMonthFull := if (string-length($issueIdMonth) = 1) then 
concat("0",$issueIdMonth)
else $issueIdMonth

let $issueIdYearFull :=if (string-length($issueIdYear) = 1) then 
concat("0",$issueIdYear)
else $issueIdYear

let $guid := concat(xdmp:random(999),"-",xdmp:random(999),"-", xdmp:random(999),"-",xdmp:random(999))
let $idFull := concat($id, $guid, "_20", $issueIdYearFull, $issueIdMonthFull, $issueIdDayFull, $hourFull, "45")

let $issueXml := 
  TEST{$idFull}
  TEST{$id}
  20{$issueIdYearFull}-{$issueIdMonthFull}-{$issueIdDayFull}T{$hourFull}:45:00
  
    
      Period
      
    
      
        
          
        
          Empty
          text
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          Empty
          text
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          Empty
          text
          
          false
          
        
          
          DerivedDate
          Monthly
        
      
    
    
      BFOE
      
        
          
        
          Dated
          Dated
          text
          
          false
          
        
          
          Spot
          Monthly
        
        
          
        
          Month
          input
          
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Month
          input
          
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Month
          input
          
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Month
          input
          
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      Brent Dubai
      
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      Dubai
      
        
          
        
          Month
          input
          
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Month
          input
          
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Month
          input
          
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      WTI-Brent
      
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          MonthRange
          input
          
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      WTI
      
        
          
        
          Month
          input
          
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Month
          input
          
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
      
    
      
    
    
      Singapore Close
      
    
      
        
          
        
          DateText
          21/06/2012
          calculate
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          WeekDayText
          Thu
          derivetext
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          TimeText
          input
          
          false
          
        
          
          DerivedDate
          Monthly
        
      
    
    
      BFOE
      
        
          
        
          ?
          ?
          text
          
          false
          
        
          
          Spot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      BRENT-DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      WTI-BRENT
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
      
    
    
      London Midday
      
    
      
        
          
        
          DateText
          21/06/2012
          derivetext
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          WeekDayText
          Thu
          derivetext
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          TimeText
          12:30pm
          text
          
          false
          
        
          
          DerivedDate
          Monthly
        
      
    
    
      BFOE
      
        
          
        
          ?
          ?
          text
          
          false
          
        
          
          Spot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      BRENT-DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      WTI-BRENT
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
      
    
    
      London Afternoon
      
    
      
        
          
        
          DateText
          21/06/2012
          derivetext
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          WeekDayText
          Thu
          derivetext
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          TimeText
          2:30pm
          text
          
          false
          
        
          
          DerivedDate
          Monthly
        
      
    
    
      BFOE
      
        
          
        
          ?
          ?
          text
          
          false
          
        
          
          Spot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      BRENT-DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      WTI-BRENT
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
      
    
    
      London Snapshot
      
    
      
        
          
        
          DateText
          21/06/2012
          derivetext
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          WeekDayText
          Thu
          derivetext
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          TimeText
          4:30pm
          text
          
          false
          
        
          
          DerivedDate
          Monthly
        
      
    
    
      BFOE
      
        
          
        
          Mid-Point
          5
          input
          Mid-Point
          false
          
        
          
          Spot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      BRENT-DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      WTI-BRENT
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
      
    
    
      Exchange Close
      
    
      
        
          
        
          DateText
          21/06/2012
          derivetext
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          WeekDayText
          Thu
          derivetext
          
          false
          
        
          
          DerivedDate
          Monthly
        
        
          
        
          CommentaryTime
          input
          
          false
          
        
          
          DerivedDate
          Monthly
        
      
    
    
      BFOE
      
        
          
        
          ?
          ?
          text
          
          false
          
        
          
          Spot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      BRENT-DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      DUBAI
      
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpot
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
        
          
        
          Low
          5
          input
          Low
          false
          
        
        
          High
          5
          input
          High
          false
          
        
          
          ForwardTradingSpread
          Monthly
        
      
    
    
      WTI-BRENT
      
        
          
        
          
Something went wrong with that request. Please try again.