SPC’s long short equity market neutral hedge fund, an asset management client was confronting a challenge wherein the fund had equity total return swap with reference fund. The fund acquired data from three varied sources.
To analyze and integrate databases from all three sources and to generate a customized dashboard was a daunting task. The client had a limited budget for software technology as the fund was in advance stage. We at SPC with a pioneering effort from expert analytics and business intelligence team came up with a remarkable solution.
SPC began two-week process to blueprint and elaborate a streamlined database with an assistance of MS access app for SharePoint that reconcile data from three varied databases to form a cloud based database with MS access as a front end but data get stored in SQL Azure.
In the succeeding stage, MS Excel based tools were developed that collect data from varied sources and inserts that into a newly designed centralized database.
After a prolonged discussion with the client, our financial risk management team came up with a live risk monitoring dashboard without manual intervention. This personalized service delivered an impactful outcome to the client.
Microsoft Power BI due its feasibility and advance features in graphics and computations, was preferably adopted by our analytics experts. We utilized R, an open source software, as a computational engine to calculate risk parameters and some statistics which is not available from Bloomberg. R integrates easily with Power BI.
The dashboard subsumes reports as below:
SPC demonstrated its unique approach through technology enabled outcome that allows client organization to gain new business value. Client organization had a great seamless experience by using live portfolio risk monitoring system as it endeavored several benefits like:
Long Short Equity UCITS Hedge Fund