Windows Application: Excel Data Automation to API Integration

Project Overview

The project entailed creating a robust Windows application for real-time stock price data management. The client utilized an Excel sheet that automatically updated stock prices through an addon provided by Bloomberg. The task was to monitor these automatic updates, detect the stock price changes, and push the revised data into a specified database via an API, all in real time.

Project Highlights

Objective

Develop an application to bridge the gap between Excel's automatic stock updates and a designated database by making use of a specified API.

Key Features

  • Real-time Monitoring: The application actively watches the Excel sheet for any stock price updates.
  • Automatic Data Push: Upon detecting a price change, the application immediately pushes the revised data to the database using the provided API.
  • Bespoke Solution: Given the client's unique environment, a tailored approach was necessary, involving extensive troubleshooting and adjustments to ensure compatibility and functionality.

Technologies Used

  • Windows Standalone Application: A dedicated application capable of real-time Excel monitoring and API integration.
  • Excel & Bloomberg Addon: The source of the live stock price updates.
  • API Integration: A conduit for transferring the updated data into the client's database.