Saxo Bank releases Version 1.1.1 of OpenAPI for Excel
The latest version of Saxo’s OpenAPI for Excel offers an improved authentication flow, reverse-populating Formula Builder window, updates to trading functionality and improved data handling.
Multi-asset trading and fintech services provider Saxo Bank has released a new version of its OpenAPI for Excel.
Major updates have been pushed into version 1.1.1 to increase the capabilities and user-friendliness of Saxo’s Excel solution. With an improved authentication flow, reverse-populating Formula Builder window, updates to trading functionality, improved data handling, and a long list of bugs resolved, this update marks a milestone with regards to the evolution of the solution.
The latest version of the API makes 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.
In addition, the Formula Builder can now 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.
Also, the User-Defined Functions (UDFs) that are included in the add-in now have proper built-in documentation with correct naming and help URLs sending users straight to the Function Documentation section on this website.
On top of that, trading functionality has been upgraded to the orders/v2/ endpoints. As with all UFDs, the trading functionality now follows intelligible naming conventions and references within Excel.
The add-in now correctly handles complex data formats in JSON (JavaScript Object Notation) structures. For nested elements such as lists and dictionaries, the add-in will automatically create new rows of data to cover all possible data formats and correctly convert them to the 2D arrays which can be handled in Excel and VBA.
The first full version of Saxo’s OpenAPI for Excel was released in August 2018 offering numerous enhancements to usability, especially for the Formula Builder, and ironing out a couple of inconsistencies that affected earlier versions such as uninformative error messages. The version was re-released version in December 2018 when it was signed with a fresh certificate (valid until November 30, 2020) to prevent errors from the Microsoft Excel Trust Center.
