Skip to content
  • Join Us
  • Insights
  • Events
  • Contact
  • Join Us
  • Insights
  • Events
  • Contact
Sinara_Pos_DIGITAL
  • Sectors
    • Start Ups
    • Exchanges
    • Brokers
  • SinaraTLC
    • TLC Exchange
    • TLC Broker
  • Managed Services & Support
  • Consulting
  • Why Sinara?
    • Our Story
    • Meet the Team
    • Specialist Areas
    • Our Approach
    • Press Releases
  • Sectors
    • Start Ups
    • Exchanges
    • Brokers
  • SinaraTLC
    • TLC Exchange
    • TLC Broker
  • Managed Services & Support
  • Consulting
  • Why Sinara?
    • Our Story
    • Meet the Team
    • Specialist Areas
    • Our Approach
    • Press Releases
USE CASE

Fund Manager Performance Spreadsheets

Home » Use Cases » Fund Manager Performance Spreadsheets

Automating and visualising data for a leading financial news provider.

A leading financial news provider regularly published Excel spreadsheets that allowed investors to review the performance of fund managers over a certain period. These spreadsheets not only included performance ratings for the managers, but charts visualising the data, as well as the providers’ branding and other complex formatting.

The provider wanted to automate the increasingly time-consuming process of creating these spreadsheets, which was mostly done manually. Sinara was brought in to develop a tool that the client’s operations staff could use to generate larger numbers of spreadsheets on a daily basis for all of the fund mangers they tracked. The tool’s requirement was to read the performance data from the providers’ existing databases and output Excel spreadsheets that would be ready to distribute to the providers’ customers.

Sinara built the tool in C# and used the Microsoft Office OpenXML SDK for .NET to generate Excel files based on a template spreadsheet provided by the client. This choice was made since the tool would be running on a server machine, where there would be no installed copy of Excel that the tool could call on programmatically to generate the spreadsheets. It was therefore necessary to directly build the Excel XLSX files (Office OpenXML) and ensure they could be opened by Excel on a desktop machine.

The tool was structured in a such a way that the template could be changed with minimal impact on the rest of the code. Sinara also developed various extensions to the OpenXML SDK to allow for more rapid development. As the client intended to continue development in-house, Sinara performed a handover of the source code, with extensive documentation, once the project was completed.

Related Use Cases

Transforming Non-Exchange Traded Metals with Cutting-Edge Trading Solutions

Digital warehouse receipt listing, management & trading A new international exchange wanted to introduce a modern B2B trading platform for non-exchange traded metals, enabling seamless

Read Use Case »

Automated Electronic Auctions for Commodities Exchange

Fully automated price auction management for platinum and palladium

Read Use Case »

Market Data Distribution for Commodities Exchange

Real time prices and quotes disseminated to exchange clients’ systems

Read Use Case »
Load More

Why the markets choose Sinara

  • 35 years’ experience across the trading lifecycle
  • Pre-built trading modules accelerate speed to market
  • Software expertise to customise complex integrations 
  • Everything is 100% supportable and sustainable

We are the trade engineering people.

Find out why

Ready for the next step?

Whether you have detailed requirements for your new business IT solution or wish to discuss your initial thoughts and ideas, contact us to see how Sinara can help.

Get Started
Linkedin
Sectors
  • Exchanges
  • Brokers
  • Start Ups
  • Exchanges
  • Brokers
  • Start Ups
Solutions
  • SinaraTLC
  • SinaraMDP
  • SinaraTLC
  • SinaraMDP
Resources
  • Insights
  • Use Cases
  • Specialist Areas
  • Insights
  • Use Cases
  • Specialist Areas
Culture
  • Why Sinara?
  • Meet the Team
  • Our Approach
  • Careers
  • Why Sinara?
  • Meet the Team
  • Our Approach
  • Careers

Privacy Policy © All Rights Reserved

© Sinara Consultants Ltd © 2025