Contact: +44 1842 829000  support@sarus.com

home header

 

 monitor plusWebNewJSON 4

The Sarus Monitor+ API offers easy and secure access to your market data direct from our web servers.  The service includes a free premium commodity futures and FX historical database. Monitor+ can  be used to populate internal market data databases, web pages, inhouse solutions and reports making it suitable for front, mid and back office needs1.

We manage the market data - applying all corrections and updates - giving you 24/7 access to all current and historical prices and symbol metadata.   The market data is delivered to you in JSON format via HTTPS (secure HTTP) making in-house databases, web content and analytic solutions a straight forward proposition. 

 

CloudBase12med

 

Our Monitor+ API also calculates changes, mean and averages  (day to year plus custom averages). We return the query results together with any corrections issued during the date range requested.  Our API lets you immediately access all prices and corrections for any number of symbols and for any date range available to you* - back to the 1970’s where data is available.

You can access day prices (with changes) letting you create 'quote' style pages with high, low, mean , volume, change and even spark lines. You can use the API extract prices, symbol information and corrected prices for any series and any date range.2

Sarus Monitor+ is the ideal solution for your business continuity plan. It enables you to ring-fence this important business requirement  and, as we store your data on cloud servers, gives you the ability to recreate your own database of market data should the need arise without the need to purchase more historical data.

When used in conjunction with our Sarus XLerate Excel add-in, your users you can create  both day and historical reports, forward curve and in-depth seasonal analysis for any commodity - with just a few clicks of the mouse and basic Excel skills.  You can  access your market data and reports from anywhere 24/7 - making Sarus a valuable core business resource.

Package includes: Full  API specification and sample Excel VBA and Java/Javascript code where needed.  It is also compatible with the Platts Market Data FTP service and so can be used to significantly reduce cost as pricing sections of published reports can be recreated in Excel at no extra cost.   
 
If you would like more information about our MarketData+ service then please contact Don Gray on This email address is being protected from spambots. You need JavaScript enabled to view it.   

 

Note:

1. Subject to your Sarus licence type.

2. The amount of data accessible depends on your subscription with the data vendor.

Sarus XLerate is a powerful Excel add-in designed to help you to get the most out of your data. It is flexible and cost effective, perfect for front, mid and back office use. It gives instant access to all your historical price data. It becomes an integrated part of Excel giving you a flexible reporting tool that can handle historical reports, day reports and charts with ease.

ExcelToolbarFig 1. The Sarus XL Excel toolbar

 

Historical reports are column based worksheets than can contain a virtually unlimited number of time series with prices going back to the 1970’s2. The series can be displayed in any average, mid-point or chosen date range. The prices in the reports  update making them an ideal data source for both in-house and 3rd party software solutions.  See Fig 3 below.

 Dayreports are custom day reports that display market data in a format similar to financial market quote pages and give a concise overview of the products and markets covered. They show a daily snapshop of the market and display market prices, mid points, change and spark lines for any date, with all corrected prices marked and shown.2 See Figs 2 and 5 below.

You can create multiple reports that can be updated, printed, shared and published making them the perfect choice for your office market data requirements.1

Correction and sparkFig 2. Journal sample showing correction and spark lines (using simulated data)

 

Corrected prices are highlighted in all reports and full information about the original price, date published and date added are displayed in a popup hint.

 

 


Historical Reports

Sarus XLerate gives you instant access to all your historical data. Historical reports are workbooks that can containing a virtually unlimited number of time series that are selected from your favourite series list or day report. They can calculate all your averages and mid points allowing you to fill forward series so posted (or series quoted in different time frames) can be normalized for analysis and comparison. All reports can be easily updated, copied and edited and shared. 1  See Fig 4 below.

Two types of charts are included with historical reports:

  1. Line charts - useful for showing price movement of series over time.
  2. Bar charts that show the day to day difference in the series. Bar chart are ‘live’ and update as you scroll through the sheet.

Historical reports have automatic conversion factors for US$ per Barrel, US$ per Metric ton and USc/Gallon. They can access over 40 years of historical data2 and have built in analysis features such as crack spreads, correlation, mean of means and contract pricing - plus many other analysis reports and studies. You can choose to display a date range or rolling number of days. You can also edit series descriptions and conversion factors giving full control of how the data is dispayed.

 

HistoryRep1Fig 3 . Sarus XL sample Historical report (using simulated data).

All Sarus XLerate reports are saved as Excel workbooks and can be shared, edited and refreshed so making them perfect to use as a virtual data source allowing further analysis in your in-house or 3rd party software.1

 

Load Data Series

Fig 4. Sarus XL – Editing a Historical report.

  

Day reports

Day or journal reports are quote page styled worksheets that can be created to cover any number of products, creating the perfect a snapshot of the market on any date.2   They provide added value to the historical data you’ve collected by allowing you to display a corrected cross market view of high, low, mid-point, mid change and spark line charts - for any number of price series.

Create and save as many Journal reports as you require and because they are Excel worksheets, they can be customized, published and shared with colleagues. 1  You can create them in your own style to show the series that you need or they can be designed as more traditional market reports.

Journal reports can contain hundreds of market symbols and are an easy way to instantly create historical reports. Simply select the series and click on a button to get instant access to the historical information required for immediate analysis. See Fig 6 below.

ViewHistoryFig 6. Generating a Historical report from a Journal (simulated data)

 

Compared to traditiional published reports, Journal reports have some significant advantages:

  • Instantly recreate a view of the market for any number of products - for any date in time.2
  • Journal reports show corrected prices - ensuring the prices you see are the correct ones.
  • Spark-lines (mini charts) give instant insight into recent market trends.
  • Select series from a Journal report and instantly create a historical report and chart.

 

 Charts

Fig 7, Sarus XL – Sample charts from Historical data  (using simulated data).

 

Sarus XL has an intuitive interface and works with Excel 2007 upwards. It offers improved productivity and a significant cost reduction both in terms of price and man hours saved.  

Our Cloudbase JSON API allows access to your market data and analytics is perfect for inhouse system development and for secure environments where software installations are not possible. Both systems offer business continuity solutions and 24/7 access from virtually anywhere.

 

If you would like to have a trial of our Sarus XLerate software, an online demonstration or just have some have any questions,  please send an email to This email address is being protected from spambots. You need JavaScript enabled to view it. or get in touch via our “Contact us” link at the top of the page. You will be amazed at what Sarus XL can do for your business.

 

Averages

Sarus XL supports the following averages:

Average Custom
Week Yes
Half-Month Yes
Month Yes
3 Month -
6 Month -
Year -

 

 

1. Subject to permission from the data vendor.

2. Subject to data being available from the data vendor.

3. Forthe first user. Discounts apply to subsequent users when bought from Sarus directly.

 

Notes:

  • Spark lines are mini charts of the last 10 prices giving a quick indication of recent price trend.
  • To create day reports requires a familiarity with Excel. We’ll be glad to assist you.
  • We provide you the day report creator not actual report templates.
  • We store your database so you should never need to purchase your historical data again.

 

 

 

EuropeEurope

Sarus Systems Ltd
The Old Rectory
Feltwell
Norfolk
England
IP26 4DN

Tel:  00 44 1842 829 000

This email address is being protected from spambots. You need JavaScript enabled to view it.

 

AustralasiaAustralasia/Asia

Sarus Systems Ltd
55 Park St
Ashburton
Mid Canterbury
New Zealand

Tel: 00 643 307 0386

This email address is being protected from spambots. You need JavaScript enabled to view it.
 

Get in touch

Your questions and comments are important to us.  If you have a technical/pre-sales question or just want to know more about our software, please fill in the form below and we'll be in touch.  Alternatively you can email us using one of the email addresses on the left.

Thanks for contacting us.

 

XLerate 3D 1

Sarus XLerate is a powerful Excel add-in designed to be the ideal solution for your end of day market data analysis and reports.  It is powerful, flexible, cost effective and perfect for front, mid and back office use.    It comes with a free comprehensive historical database of premium FX and futures contracts and gives instant access to all your historical price data via the cloud. You  can also have access to thousands of other data series from EEX,  BP , CFTC.  Also,  if you have market data available from other data vendors or exchanges, we can help manage this data for you and give your users secure access via Sarus XLerate or our Monitor+ analytic JSON API.

Sarus XLerate becomes a part of Excel, giving you a flexible reporting solution that can handle historical reports, day reports and provides multi axis charts  in Excel with pan and zoom functionality.  All reports and charts update and can calculate all your averages and mid points, allowing you to fill any series for easy analysis and comparison.  Historical reports have built in historical average calculations including custom week, half month and month giving you comprehensive reporting capabilities.  Price corrections (where published) are highlighted in all reports 

Sarus XLerate has many built in 'quick functions' that allow you to instantly apply spreads, averages and technical analysis to any worksheet series. It also has a comprehensive report library allowing you to create detailed reports including: Time series analysis, Seasonal analysis, Forward Curves, Mean of Means, Correlation Analysis, Custom Crack spreads, MACD, RSI and currency FX (using any of 150+ currencies as the base currency) and many more.

Please click here for more information.

monitor plusWebNewJSON 4

Monitor+ is a secure JSON API that gives full access to your market data from our secure servers. It uses industry standard JSON/REST technology allowing access to all prices, averages and metadata to your in house systems. Perfect for in-house databases and solutions.

Please click here for more information.

 

 

 

  • SarusFeatures2

 

 

Key Features

 

OneStop 48 One stop solution is designed for front office, back office,  fund managers, traders, analysts and developers. Sarus provides the market data you need instantly in Excel or via our analytic JSON API.
cloud 48 Cloud -  Instant access to all your latest and historical price data and corrections. Our Cloudbase servers have prices from the 1970’s and all prices, history and corrections are always available instantly.
Team2 48 Market Data - All Sarus subscribers have free and unrestricted access to our Commodity Futures and FX prices.   User Sarus XLerate to create snapshot day or historical analysis reports.  
support 484 Support - We offer direct telephone support, e-mail and remote access support.  We pride ourselves on the dedication of our support team who have instant access to our developers so can solve most problems in the shortest possible time.
footprint 2 Zero database footprint - Our databases are all stored in the cloud and can be setup and working in minutes. Our Excel add-in works in conjunction with our web servers and it too provides market day reports, historical data and analysis.
BusinessCont 48 Business Continuity - Have your market data available 24/7. Our servers are replicated globally ensuring continual access to your market data. Our powerful web software allows you and your team to work from anywhere,at any time and on any device.
developer 48 Database and systems developers - Use our JSON/REST feed to power your in-house database and systems. As well as prices and corrections, the API allows calculated averages (notifiying you of relevant corrections) making in-house software solutions faster to develop. With the API, all the history and metadata that you subscribe to are available for immediate access.

We pride ourselves on our client support and client driven development. We will be adding other 3rd party data as requested. We can now add your own data  to our API giving you a new channel to market. If you'd like to find out more about what Sarus can do for your business, please email Don Gray at This email address is being protected from spambots. You need JavaScript enabled to view it. or use the 'Contact Us' menu above. Thanks.

 

Stay with Sarus.

We really appreciate that you wish to continue to use Sarus as the software to manage your Platts Market Data service.  We are committed to providing you with cutting edge software while significantly reducing your costs.  We will be glad to discuss our software features and pricing so you can see how staying with Sarus can save you money.

We can often offer trials and online demonstrations of our software so you can see how we can help maximize the befefit from your market data.  Please get in touch using the form below and lets get started.