OpenAPI for Excel

In this basic tutorial, we copy the features from the FX Exposure Analysis tool and use it to build a dynamic/interactive portfolio overview. This overview provides a breakdown of all portfolio positions of the currently-logged-in client by account, type, currency, and instrument. It then displays some basic data of each position such as the amount (unit), the exposure and the P&L. Bear in mind market data needs to be enabled for this to work, and the data will be delayed by default.