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.

My Feedback

Engaging with Jitendra and his team proved to be an enriching experience. While the project had its challenges, especially with the unique nuances of the client's Windows environment, collaboration and effective communication paved the way for a successful outcome. Jitendra displayed commendable patience and organizational prowess throughout. I eagerly anticipate future collaborations with such a dedicated client. Highly recommended!