Latest version of Saxo Bank’s OpenAPI for Excel offers substantial speed improvements
In particular, clients using the app in Asia are set to notice significant improvements in performance.
Multi-asset trading and fintech services provider Saxo Bank has rolled out a new version of its OpenAPI for Excel.
The latest version of the solution (1.2.1) includes an important update to OpenAPI for Excel’s request/response performance that significantly increases the pace at which the add-in communicates to the OpenAPI. Saxo says that speed improvements of 50-75% can be achieved using this new version. In particular, clients using the app in Asia are set to notice significant improvements in performance.
The preceding version of Saxo’s OpenAPI for Excel, released less than a month ago, was enhanced with some useful features that were requested by Saxo API’s users. Updates include refresh options (to either refresh all OpenAPI formulas in the workbook, or just for the single sheet), fixes made to the trading functions in preparation of upcoming requirements, and a fix to properly handle data from OpenAPI endpoints that follow a non-standard data model (such as the AutoTrade endpoint).
Version 1.1.1 of the API, which was rolled out in April 2019, offered improved authentication flow, reverse-populating Formula Builder window, updates to trading functionality, improved data handling, and a long list of bugs resolved, that update marked a milestone with regards to the evolution of the solution.
Version 1.1.1 of the API made logging in easier. Instead of opening a side bar and resizing the Excel window, the login prompt now appears as pop-up. In addition, it runs a few quick checks before handing control back to the user to ensure a smooth transition into the app without hiccups.
Also, that version enabled the Formula Builder to be used in reverse, which means it has become extremely easy to adjust a formula quickly and pull out updates. Users have to select any part of the array that is returned on the sheet and click the Formula Builder button.
Finally, the User-Defined Functions (UDFs) that are included in the add-in got proper built-in documentation with correct naming and help URLs sending users straight to the Function Documentation section on this website.