×

iFour Logo

Quick Summary

Onyx Capital Group struggled to efficiently manage live oil trading data, track market prices, and organize trading workflows inside Excel. Manual processes and limited system flexibility slowed down operations and affected productivity.

To solve these challenges, iFour developed a smart Excel Add-in for financial data management.

It helped users access live oil market prices, create custom watchlists, refresh real-time data instantly, and improve trading efficiency directly inside Microsoft Excel.

Impacts Observed:


 

100%

Live Data Access

80%

Less Manual Efforts

75%

Improved Trading

70%

Faster Decision

90%

Better Management

About Customer

The Onyx Capital Group operates in the financial domain, focusing on digital liquidity and oil futures trading.

Industry: Finance / Trading

Geography: UK

Why They Came to Us:

Onyx Capital Group needed a custom Excel Add-In development solution that could:

  • Simplify live oil market data tracking
  • Make trading operations faster and easier
  • Improve flexibility & real-time monitoring
  • Save time from manual efforts
  • Manage large volumes of market data inside Excel
  • Offer data security & scalability
Client overview
call to action

Looking to modernize legacy software into scalable business applications? Explore our Custom Software Development Services.

Client Success Stories

See how we've transformed businesses with custom software solutions

Challenges

Before using the real-time market data Excel Add-in, Onyx Capital Group faced several challenges in managing live oil trading data and market updates. The major issues included:

1

Difficulty tracking real-time oil market prices

2

Manual data tracking consumed too much time and effort

3

Managing multiple datasets inside Excel was difficult

4

Lack of secure user authentication created data security concerns

5

Refreshing and updating live market data was slow and inefficient

Our Solution

iFour Technolab, an experienced Microsoft Excel Add-in development company, redeveloped the existing solution into a
scalable and user-friendly Excel Add-in for oil trading and financial data management.
The solution works smoothly across Microsoft Office versions and enables users to effectively manage
live oil market data directly inside Excel.

Excel Add-in for Oil Market Data 10

Explore the Key Features Included:


  • Safe user authentication
    The Add-in has OAuth login functionality for safe and reliable user authentication.
  • Live Price Tracking
    We provided fields for users to select product groups, product types, products, and tenors, and after these selections, we generated live price data directly in the sheet.
  • Settlement Management
    View settlement data for different dates and settlement types directly inside Excel.
  • Refresh Sheet Functionality
    Refresh sheets instantly to update live market prices and trading information.
  • Custom Watchlists
    Users can create multiple watchlists as separate worksheets for better tracking and organization.
  • Custom Function Support
    Generate and print separate custom functions for selected stock groups and market data.
Excel Add-in for Oil Market Data 11

User-Friendly Task Pane

  • Simplified account management and easy navigation through interactive task panes and popups.
Outcome
  • The solution improved how users manage and track oil market trading data inside Excel. Teams could access live prices faster, organize watchlists more efficiently, and reduce manual effort in managing financial data.
  • With the smart Excel Add-in, Onyx Capital Group improved operational efficiency, simplified live data tracking, and created a smoother trading experience for users.
call to action

Build secure and high-performance business applications with our Node.js Development Services

Security, Compliance & Governance

  1. Secure OAuth-based user authentication
  2. Controlled and secure access to trading data
  3. Reliable handling of live market and settlement data
  4. Secure storage and management of user watchlists
  5. Scalable architecture for growing trading operations
  6. Safe and stable integration within Microsoft Excel
  7. Improved data visibility with controlled user access
How We Built It

(Technology Stack & Architecture)

Frontend: AngularJS
Backend: Node.js
Database: SQL
Type: Excel Add-in
Version Control: Git, Excel Add-In

Impact That Mattered

The smart Excel Add-in helped Onyx Capital Group improve live market tracking,
simplify financial data management, and create a better trading experience for users.

  • Faster access to real-time oil market prices
  • Reduced manual effort in managing trading data
  • Improved visibility into live market movements
  • Simplified watchlist creation and data organization
  • Better user experience with smooth Excel integration
  • Faster data refresh and settlement tracking
  • Secure and scalable authentication for users
  • Improved productivity and operational efficiency across trading workflows
Key outcomes
“Managing live oil market data manually was time-consuming for our teams. With iFour's custom Excel Add-in solution,
we can now track market prices faster, manage data easily, and make quicker trading decisions with confidence.” — Trading Operations Team, Onyx Capital Group

iFour Technolab developed a smart and scalable Excel Add-in for financial data management that helped Onyx Capital Group simplify real-time oil market tracking and improve trading operations.

With live price tracking, secure authentication, custom watchlists, and faster data updates, the solution improved productivity, reduced manual effort, and created a smoother trading experience directly inside Excel.

  • Smooth deployment with minimal disruption to trading workflows
  • Easy Excel Add-in installation across Microsoft Office versions
  • User onboarding and technical assistance for faster adoption
  • Continuous monitoring, maintenance, and performance improvements
  • Scalable support for future feature enhancements and integrations

Boost your business workflows and improve operational efficiency with our custom Microsoft 365 Development Services .

Talk To Our Experts
contact team
talk with team

Get In Touch With Us

We encourage you to contact us with any questions or comments you may have.

image

Our Portfolio

Take a look at our latest projects, where digital transformation comes to life.

Safeguarding Work with Multi Location File Storage Add in

Safeguarding Work with Multi Location File Storage Add in

We built this add-in for file management. It organizes data, improves access, and reduces clutter.

Impacts Achieved

95%
Improve Storage
98%
Working efficiency
99%
Data Recovery
  View Case Study  
Streamlining Document Creation with a Law Practice Management Add-in

Streamlining Document Creation with a Law Practice Management Add-in

This solution helps law firms manage operations. It tracks cases, manages tasks, and improves workflow visibility.

Impacts Achieved

80%
Faster Drafting
60%
Less Manual Work
100%
Data Security
  View Case Study  
Driving Translation Accuracy with Custom Word Add-in Development

Driving Translation Accuracy with Custom Word Add-in Development

This platform helps manage translation workflows. It assigns tasks, improves coordination, and supports multilingual work.

Impacts Achieved

90%
Better Translation
85%
Improved Efficiency
4X
Faster Data Access
  View Case Study  
Simplifying Structured Documentation with Custom Word Add-in

Simplifying Structured Documentation with Custom Word Add-in

This solution focuses on document automation. It reduces manual work, ensures consistency, and saves time.

Impacts Achieved

70%
Faster Creation
3x
Improved Efficacy
100%
Compliance
  View Case Study  
How iFour’s Add-in Made Reporting 60% Faster and Audit-Ready

How iFour’s Add-in Made Reporting 60% Faster and Audit-Ready

This solution helps manage Excel versions. It tracks changes, avoids conflicts, and improves control.

Impacts Achieved

90%
fewer errors
60%
faster reports
80%
audit-ready
  View Case Study  
AI-Powered Add-in for Presentation Consultants: A Time Saving Solution

AI-Powered Add-in for Presentation Consultants: A Time Saving Solution

We created this add-in to enhance presentations. It improves content creation, saves time, and boosts productivity.

Impacts Achieved

90%
faster creation
70%
more engagement
90%
design consistency
  View Case Study  
Custom Excel Add-in Slashes 70% of Manual Data Tasks for U.S. Firm

Custom Excel Add-in Slashes 70% of Manual Data Tasks for U.S. Firm

This solution helps manage Excel versions. It tracks changes, avoids conflicts, and improves control.

Impacts Achieved

70%
Less Work
100%
Faster Reports
3X
Productivity
  View Case Study  
AI + Excel: The Automation Development for Commodity Intelligence

AI + Excel: The Automation Development for Commodity Intelligence

We built this tool for commodity analysis. It provides insights, improves forecasting, and supports decisions.

Impacts Achieved

Zero
Manual Work
95%
Fewer Errors
4+
Hrs. Saved Weekly
  View Case Study  
PTiQ PowerPoint Add-in for Productive Presentation Workflows

PTiQ PowerPoint Add-in for Productive Presentation Workflows

This PowerPoint add-in centralizes templates, improves collaboration, ensures brand consistency, and reduces manual presentation formatting efforts.

Impacts Achieved

80%
Faster Management
85%
Less Manual Efforts
90%
Better Collaboration
  View Case Study  
Onyx Microsoft Excel Add-in for Oil Market Data Tracking

Onyx Microsoft Excel Add-in for Oil Market Data Tracking

This Excel add-in enables live oil price tracking, secure authentication, and streamlined workflows for trading and analysis.

Impacts Achieved

100%
Live Data Access
75%
Improved Trading
70%
Faster Decision
  View Case Study  
TamLabs Excel Office Add-in for Market Data Analysis

TamLabs Excel Office Add-in for Market Data Analysis

This Excel add-in automates TAM/ASP reporting, improves real-time insights, and simplifies market intelligence workflows for Orca Labs.

Impacts Achieved

85%
Faster Accessibility
75%
Better Collab
70%
Faster Insights
  View Case Study  
Slide Breeze PowerPoint Add-in for Smart Presentation Automation

Slide Breeze PowerPoint Add-in for Smart Presentation Automation

This PowerPoint add-in automates slide formatting, transitions, and animations, improving workflow efficiency and presentation consistency.

Impacts Achieved

80%
Less Manual Effort
70%
Faster Editing
90%
Better Consistency
  View Case Study  
PWC Contract Management Word Add-in for Legal Workflow Automation

PWC Contract Management Word Add-in for Legal Workflow Automation

This Word add-in automates legal contract customization, reduces errors, and improves accuracy for streamlined document preparation.

Impacts Achieved

80%
Faster Processes
70%
Bost Efficiency
85%
Better Visibility
  View Case Study  
Team8rix Outlook Add-in for Leadership Insights

Team8rix Outlook Add-in for Leadership Insights

This Outlook add-in delivers real-time collaboration insights, strengths analysis, and leadership recommendations during emails and meetings.

Impacts Achieved

80%
Faster Access
70%
Boost Synergy
90%
Improve UX
  View Case Study  
Sophia Excel Add-in for Risk Management

Sophia Excel Add-in for Risk Management

This Excel add-in automates risk reporting, dashboards, and improves visibility, reducing manual effort for risk analysts.

Impacts Achieved

80%
Report Accuracy
70%
Boost Workflow
90%
Better Visibility
  View Case Study  
My Ticket Solution Outlook Add-in for Smart Ticket Management

My Ticket Solution Outlook Add-in for Smart Ticket Management

This Outlook add-in simplifies ticket creation, reduces repeated logins, and improves helpdesk workflow efficiency for support teams.

Impacts Achieved

85%
Faster Ticketing
80%
Fewer Logins
75%
Boost Workflow
  View Case Study  
HDH Excel Add-in Development for Automated Data Operations

HDH Excel Add-in Development for Automated Data Operations

This Excel add-in automates financial workflows, validates formulas, and synchronizes reports, improving accuracy and efficiency.

Impacts Achieved

80%
Faster Data Entry
75%
Faster Navigation
90%
Better UX
  View Case Study  
 
Blog Our insights
Why AI Agents Fail Without Context (And How Fabric Ontology Fixes It)

05 October 2026

Kapil Panchal

Why AI Agents Fail Without Context (And How Fabric Ontology Fixes It)

Quick Summary: AI agents don't fail because they lack intelligence. They fail because they lack business context. Enterprise data often contains information but not meaning. Fabric...

AI in Legal Practice: Powerful Use Cases Every Lawyer Should Know

10 September 2026

Kapil Panchal

AI in Legal Practice: Powerful Use Cases Every Lawyer Should Know

Quick Summary Lawyers use AI to research faster, draft/review contracts, review large documents, track compliance, and automate legal workflows. However, they must verify...

How to Use Power BI for Sales Forecasting (Guide for CTOs)

06 August 2026

Kapil Panchal

How to Use Power BI for Sales Forecasting (Guide for CTOs)

Sales Forecasting isn't optional anymore. Whether you are a startup or a mid-level enterprise, every decision you make today depends on how well you predict the future. Instead...

Full Project Display
1 / 4