ComboCurve: Differentials

ComboCurve: Differentials

Differentials Options

1st, 2nd, and 3rd differentials can be used to model increases or reductions in realized product pricing relative to basis (NYMEX).  These can be basin deducts, quality adjustments, use, access and marketing fees and other offsets.


  1. Negative values indicate subtraction from price, positive a bonus to price.
  2. You can copy/paste columns of data from Excel by clicking in a pricing cell and Ctrl-V.
  3. Cap is value which the Escalation model will not let pricing exceed.
  4. Note that escalations occur on each entered time-series value and ONLY begin once the current value is in effect.  Values are not escalated from As of or the start of the escalation model but rather are only applied at the current escalation in effect during the period the values are being used. 
  5.  Note that the order of input on 1st, 2nd, 3rd differential governs calculation order rather than any notion of PEMDAS.  If both a dollar and a percent delta are both being used, the order of input can change the result.  For example, a $100 oil price with a -$5 1st and 90% 2nd differential will yield (100 - 5) * 0.9 = $85.50.  Flipping the order would be (100 * 0.9) - 5 = $85.00.
  6. Begin Dates can be:
    1. Flat: From As Of Date to ECL
    2. As Of: From As Of Date and continuing for specified # months
    3.  Dates: From entered date.  Unless intended, be careful not to start after As Of Date
    4. Tip: For months and dates, Econ Limit auto-entered in final segment so put a zero at end if needed.
  7. 1st Diff, 2nd Diff, 3rd Diff
    1. Oil Differentials entered as:
      1.   $/BBL
      2. % of Base Price Remaining, i.e. 70% of $100 oil = $70 realized price. The % is applied to price continually as it changes per pricing model
    2.  Gas Differentials entered as:
      1. $/MMBTU, Ensure BTU content defined in Stream Properties.
      2. $/MCF
      3. % of Base Price Remaining, i.e. 70% of $5 gas = $3.50 realized price. The % applied to price continually as it changes per the pricing model
    3. NGL Differentials can be entered as:
      1. $/BBL
      2. $/GAL, Since NGL Yield is set in Stream Properties at BBL/MMCF, 42 gal/BBL conversion factor applied in all calculations
      3. % of Base Price Remaining, i.e. 70% of $50 NGL price = $35 realized price. The % applied to price continually as it changes per pricing model
        1. Be careful not to double-dip if you have already applied reduction in oil price tab
    4. Drip Cond Differentials entered as:
      1. $/BBL
      2. % of Base Price Remaining, i.e. 70% of $50 Drip Cond = $35 realized price. The % is applied to price continually as it changes per pricing model
        1. Be careful not to double-dip if already applied reduction in oil price tab

Price Decks

Price decks pull the current or historical futures basin differentials for oil.  The same warning for price deck first date applies here also.  Gas differentials are no longer traded or reported by CME and thus are not available via auto-pull.

  1. WTI-Brent Financial Futures
  2.  Argus LLS vs. WTI (Argus)
  3. WTS (Argus) vs. WTI
  4. WTI Midland (Argus) vs. WTI
  5. WTI Houston (Argus) vs. WTI
  6. WTS (Argus vs. WTI) ==> Deprecated, no longer traded or reported by CME
  7. WRI Midland (Argus vs. WTI) ==> Deprecated, no longer traded or reported by CME
  8. Clearbrook Bakken Sweet (NE2) ==> Deprecated, no longer traded or reported by CME
  9. Edmonton Light Sweet (NE2) ==> Deprecated, no longer traded or reported by CME

Import/ Export Differentials 

Similarly to the pricing econ model, you can import unique Differentials. To do so, you can use the following workflow:
  1. Create a dummy differential model and apply it to your wells
    1. In the dummy model, include all the differentials that you'll modeling. For example, if you know that some wells will have oil and gas differentials, add those in the dummy model 
    2. This would prevent adding additional lines in the csv export. If some wells don't have gas but only oil, you can always set the gas differential value to 0
  2. Click on the 3 dots next to the Differentials column header and select csv export
  3. In the export locate the differential  $ value column
    1. If you're modeling 3 differentials, you'll have 3 rows for each well
  4. Modify the differential values accordingly
    1. You can use the chosen ID value in the export to lookup on from an external spreadsheet
  5. Save the file and move back to ComboCurve
  6. Go back on the 3 dots menu and select csv import
  7. Check "Create Unique Assumptions"
    1. If you want to import this set of unique differentials to a new qualifier, check the "New Qualifier". If not, ComboCurve will overwrite the current differential model applied
  8. Click on "CHOOSE FILE" to select the export csv
  9. Click on "START IMPORT"

Custom Stream Differentials

  1. Similarly to custom stream price decks, users can define price differentials for any custom streams that have been created from the project or company level as a $/Unit or a % of price remaining
  2. From the 'Differentials' assumption's Advanced View, all created custom streams will be displayed under the 'Key' dropdown
    1. Custom stream variable expenses cannot be defined from standard view.
  3. After selecting a custom stream in the 'Key' cell, make sure to indicate:
    1. The stream type (Company/Project Custom Stream) in the 'Category' column
    2. The criteria (flat, time series, or relative time from your effective date)
  4. All differentials will be based on $/Unit measurements, with 'Unit' being defined in the production streams settings
  5. Users can have an unlimited number of differentials applied to a custom stream, and they will be read top to bottom for priority order
    1. This is necessary to calculate the differential if both $/unit and % of price remaining are being used concurrently





    • Related Articles

    • ComboCurve: PHDWin Scenario Export - Assumptions Guide

      ComboCurve provides the option to export certain assumptions from a scenario to PHDWin. This document is provided to help users understand what can be exported from a ComboCurve scenario and discuss certain changes made during the export process to ...
    • ComboCurve: Mass Export/Import Assumptions

      ComboCurve: Mass Export/Import Assumptions In this article we will discuss mass importing and exporting from the scenario main page. Model management, analysis and preservation is done through the EXPORTS and IMPORTS buttons at the top of the ...
    • ComboCurve: Pricing

      ComboCurve: Pricing In this article we will take a dive into the pricing header within the scenario module in ComboCurve. Price Model Price Model (Copy/paste columns of data from Excel by clicking in a pricing cell and Ctrl-V). Cap is maximum pricing ...
    • ComboCurve: Compositional Economics

      ComboCurve v35 - Compositional Economics Feature Description: ComboCurve now supports the ability to break out the inlet gas stream into components for economic analysis & reporting. Where: Setup is managed in Stream Properties and Pricing Econ ...
    • ComboCurve: Pricing, Differentials, and Stream Properties Advanced View

      In this video, we look at the new advanced view functionality for the pricing, differentials, and stream properties assumptions in the scenario module. The advanced view has already been released for expenses and CAPEX, and in the future, we hope to ...