Case in Point: The IFP Excel Add-in
Our client, a large asset manager, found the uploading of numerous OTC trades throughout the day too time-consuming. Their front office had to switch focus from the business they knew to becoming technology experts, which forced them to place heavy demands on their support team. The front office staff were not seeing positions flow into their portfolios in a timely manner, which could leave them exposed and affect trading decisions.
The IFP Excel Add-in now allows the front office to quickly enter OTC trades into Imagine and focus on managing risk while also freeing up our client’s internal resources. Also, having the front office staff manage trade uploads, instead of their IT department, reduced the possibility for error since they are more versed with changing security types and markets—they understand the business.
Flat Learning Curve
Another service we provided for our client was to deliver a set of customized spreadsheets that replicated the tools and applications they have used in the past–tools they know inside and out. Our IFP Excel Add-in customization services dramatically reduced any downtime associated with learning a new application as well as the demand placed on their internal support teams when transitioning from one system to another. Now they had screens that mimicked what their screens have always looked like—which allowed for an almost seamless transition.
With all their Imagine information now viewable in Excel, our client could easily leverage Imagine’s data with Excel functionality for reporting, analyzing, and third-party reconciliation.
Targeted and Focused
We took the robust Imagine system and excised the market data and risk management information that they wanted to see in the form they already recognized. And now they are viewing and working with it in Excel—a powerful program that enables them to easily focus on their expertise, the business of trading.
About the Author
James holds a Masters in Mathematical Finance from Rutgers University. Contact our consultants by email or phone: 212-317-7600
It was a historic moment to be remembered when crude oil plunged into negative price territory on Monday 20th April 2020. Imagine’s Data, Technical, Development and Professional Services teams stood ready to assist users in ensuring they continued to correctly calculate risk metrics across commodity trading books. While negative prices are not a new thing in financial markets, it was the first time for crude oil to exhibit such behaviour. Standard pricing models (Black Scholes) for commodity future options are not designed to handle negative underlying prices. As such, Imagine applied an ‘early roll’ of the front month contract of May crude to the June expiry as the negative settle price was confirmed.