Excel Add-in for Real-Time Commodity Pricing

About Customer

Our UK-based client is a trusted provider of liquidity solutions in the oil derivatives market. They help market participants trade with confidence by offering effective tools and deep industry expertise.

Making the best use of advanced technology, they ensure smooth operations, consistent performance, and greater efficiency for businesses that rely on accurate and timely decisions.

Challenge

The existing solution was previously built using Add-in Express technology, which led to compatibility issues for Excel versions. Additionally, there were challenges in displaying real-time data within Excel, which required constant manual updates. This was impacting their functionality and overall user experience.

Technology Used

Angular Js

Front-end
DOT NET CORE

Back-end
Git

Version Control
MYSQL

Database

Solution

iFour, a leading Excel Add-in development company, developed a user-friendly Excel add-in that leverages RTD technology for automatic price updates.

Whether you’re tracking live data, retrieving historical prices, or generating settlement reports, the add-in does it all. With features like seamless authentication and easy tenor retrieval, it’s built to streamline your workflows.

Key Features

Authentication: Stay logged in without interruptions. Our system uses Auth0 to refresh tokens automatically, so you never have to worry about being signed out.

Live Prices: Get continuous updates using RTD and WebSocket. No manual refreshes—just real-time data for instant decision-making.

Settlements: Generate settlement reports for specific product-tenor combinations in a few clicks.

Historical Prices: Retrieve daily historical price data for any selected date range.

Insert Function: Automatically update data for a single product-tenor combination.

Tenors: Easily retrieve tenor details based on frequency or type and generate reports.

Refresh Now: Quickly restart RTD if live updates stop, ensuring uninterrupted data flow.

Support Tools: Access help, update logs, and version info effortlessly.

How We Overcome Challenges

1. RTD Integration: Combining RTD with Excel and WebSocket was tricky. By studying similar solutions, we ensured seamless automatic updates.

2. Popup Design: Designing a versatile product-tenor selection popup took careful planning to match various workflows.

3. Deployment: After evaluating options, we chose the MSI Installer for smooth delivery of the RTD-powered add-in.

Impacts Observed

# 60% faster workflows with automated live updates.

# 90% accuracy in reporting by reducing manual errors.

# 40% time saved in generating reports and retrieving data.

# 100% uptime with uninterrupted RTD and WebSocket integration.

# Instant user access through seamless token-based authentication.

Tired of version control headaches? Hire Office Add-in Developer for seamless automation.

Let’s Discuss

Conclusion/Results

This Excel add-in has transformed how live commodity prices are handled, offering the client the ways to make informed, and timely decisions.

It provides real-time updates, makes data retrieval super easy, and offers detailed reporting, which means no more manual work and a big increase in efficiency. With its customized features, users can keep up in fast-moving markets and make important decisions with certainty and accuracy.