You Have Questions? We’ve Got Answers
A Q&A with Eric Pearl
Eric Pearl is the Director of Platform Marketplace and Consulting at Imagine. We sat down to ask him a few questions about the Excel Add-in.
Hey Eric, first, can you give some background on what Imagine Apps are?
So is the Excel Add-in an App?
Can you give us an example of how it works?
Sure! Our add-in provides an Excel UDF (User Defined Functions) named IMAGINE() which can be used like other Excel functions like AVERAGE() or SUM(). Below is a screenshot showing how to use IMAGINE() in a formula to invoke an Imagine App named myApp. (We also demonstrate this in our demo located here).
The IMAGINE() formula passes the user’s input (the contents of A1 and B1) to the function with the exported name getVolSurface in the Imagine App myApp. Naturally, inputs and outputs can include Excel cell ranges as well.
In addition to the IMAGINE() UDF, we also provide IMAGINE.VBA(), which is easier when you are writing macros or VBA. See our demo for an example of how this works.
Where can I get the App? What if I want to write my own App?
Want to write your own App? Great, more details on the process are included for you here. Rather have Imagine Consulting write the App for you? The Imagine Consulting team can do that—contact us at firstname.lastname@example.org.
About the Author
Eric Pearl has been developing risk and portfolio systems for over twenty years. In 2000, he helped launch the industry’s first and leading SaaS solution and in 2012, he launched Imagine’s Platform Marketplace.
Contact our consultants by email or phone: 212-317-7600
In times of stress in the markets, not only does volatility increase for individual assets, cross-asset correlations can increase dramatically as well. This results in a “double whammy” for a typical portfolio because the portfolio’s volatility increases due to both effects.
Those responsible for maintaining a margin system often feel that they are drowning in data management issues. In part two of this series we discuss ways to make margin calculations far more efficient and meet the firm’s need for answers in real-time.