Connect to Spark via multiple methods

To save you time and effort, we’ve built multiple options for you to integrate our data into your systems.

Excel Add-in Excel Add-in

Retrieve Spark prices directly from within your Excel sheet.

More details
Spark API Spark API

Integrate with your systems directly via our API.
Automatically update forward curves, get additional prices for marking positions, bolster risk management systems and use the Spark prices to support analysis. No more manual downloads required and designed for the future.

More details
Spark Webhooks Spark Webhooks

Get the latest price information as they are released automatically via our Webhooks API.
Benefits include getting the latest prices as they are released and receiving an updated price when there’s a price correction.

More details
3rd-Party Connectors

Retrieve our prices via our 3rd-party connectors.
Available to Spark Premium subscribers. 3rd Party Connectors may apply additional costs.

ZEMA™ ZEMA™
Morningstar Morningstar
Enverus Enverus

Frequently Asked Questions

Firstly, you need an account with us. Any existing Spark accounts within your organisation can be used or you can also create a new account set up as a developer (which doesn't count towards number of nominated Spark Premium accounts).
For Premium plan users:
Navigate to “Contract” > “Data integrations” > “Spark API” on the sidebar menu and follow the steps in this page to access our API.

For Basic plan users: Download button Click on the download button and select “Download with our API”. Follow the steps in this page to access our API.

All Spark users have basic access which means that you can access the SparkS price for free but with a limited dataset.

To access the SparkF, SparkFo, historical data and wider data sets, users must have premium access which applies on an organisation level. Please get in touch if you'd like more detailed information.

As our API evolves, we will ensure that the older versions of the endpoints remain available to limit any changes on your side. We'll make sure you have enough time to move to the latest version.
The data available via the API is linked to your organisation. This is to ensure that people changes are easier to manage in the future. Additional users can be added to ensure the right teams and people have access to the information and each organisation has a secure, unique token.
The information available via the API is linked to your permission status. Unlimited access to historical data and full forward curves is only available to those with Premium access. Get in touch to find out more.
Yes, your data is secure. Spark uses a HTTPS over TLS (HyperText Transfer Protocol Secure) as a secured, bidirectional tunnel for communication and OAuth2 as authorization framework.

Rate limiting of the API is primarily on per-customer basis — or more accurately described, per user access token. Following limits are currently the default setting:

  • Throttling (requests per second): 50 req/sec
  • Burst (bucket size): 200
  • Quota (requests per day): 1000 req/day

You can request an increase of these limits. Please contact us directly via contact@sparkcommodities.com and describe your scenario.

Either analysts with previous API experience or your IT teams should be comfortable with this. We've designed our API to make it as quick and easy as possible. We are also always available to help if needed.

Excel Add-in


This guide is intended to get you set up with our Excel Add-in as fast as possible. Any feedback or suggestions are always welcome.

The Spark Excel add-in is supported for the following Excel versions: - Microsoft Excel 2013, Microsoft Excel 2016 Microsoft Excel 2019, Excel 365 MSO 64 bits and Excel 365 MSO. Unfortunately Excel on Mac OS is not supported currently.

Installation steps

  1. Download the Excel Add-In file here and save the add-in file in a suitable location. The latest version of the add-in is v1.2 from 10 Aug 2021.

  2. Choose File > Options within Excel
    Step 1
    Step 2

  3. From Options, choose Add-ins, Manage ‘Excel Add-ins’ -> Go.
    Step 3

  4. Within the Add-ins window, choose ‘Browse’ and browse to the location of the add-in file. Make sure to check the “Spark Excel Addon” to enable it.
    Step 4

To ensure the Spark Add-in remains in your Excel Ribbon take the following steps:

  1. Open the Trusted Locations menu. File > Options > Trust Center > Trust Center Settings.
    Step 5

  2. Go to Trusted Locations and press the ‘Add new location…’ button.
    Step 6

  3. Click the ‘Browse…’ button. Navigate to the folder that contains your add-in files and press OK. If your add-ins are organized in subfolders then click the “Subfolders of this location are also trusted” checkbox.
    Step 7

  4. Press OK, then press OK again on the Trust Center Window. Close and re-open Excel.

  5. ‘Unblock’ the Excel Add-in by right clicking it in the folder you saved it in and choose ‘Properties’ and check ‘Unblock’.
    Step 8
    Step 9


Using the Excel Add-in

This article helps you get logged in to the Spark Excel Add-in and quickly download Spark data.

  1. Once the add-in is successfully installed, click the Login button on the Spark ribbon and login via the authentication pop-up using your existing Spark platform email username and password.
    Step 1

  2. Once logged in, you will be able to click the ‘Get Pricing Data’ button on the Spark ribbon and request the required data from the pop-up wizard.
    Step 2


Data availability

Data availability depends on your permission rights.

The following details the range of fields and descriptions are available to Spark Premium users:

  • Contract groups: Spark25, Spark30
  • Contracts: Spark25S, Spark25F, Spark25Fo, Spark30S, Spark30F, Spark30Fo
  • Price units: USD/day, USD/MMBtu

In addition to the above, the data is returned with the following fields:

  • Release date: data of assessment
  • Contract type: spot, front-month or forward
  • Calendar month: delivery month
  • Period start: first day of delivery window
  • Period end: last day of delivery window
  • Prices: Spark price, Spark min, Spark max, Portfolio Player price, Portfolio Player min, Portfolio Player max, You.