Saxo Bank rolls out new version of OpenAPI for Excel
Version 1.0.2 tackles a number of issues reported by API users and includes fixes for bugs and minor improvements, primarily concerning subscription functionality.
Multi-asset trading and fintech services provider Saxo Bank has released a new version of its API for Excel.
Version 1.0.2 tackles a number of issues reported by users and includes fixes for bugs and minor improvements under the hood, primarily concerning subscription functionality.
- Enhancements
Log file link added to About box – The debugging experience is enhanced as the log file can now be opened straight from Excel by opening the About box.
System requirements check – If .Net Framework is not installed on one’s machine, the add-in will show a warning message.
- Bug fixes & improvements
Stability of streaming functionality is improved. This should prevent streaming data from being interrupted.
Streaming functions restart properly when re-opening a spreadsheet that contains subscription functions.
Updates to logs to improve relevance and consistency.
Version 1.0.2 was released several days after the rollout of version 1.0.1 of the API. It included an UI update, along with a new functionality in the form of an About button, with helpful links to the developer portal and the version number of the add-in.
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.
The list of upcoming changes includes upgraded login flow. In the current setup, OpenAPI for Excel authenticates with Saxo Bank through a web page that is loaded on a side panel in Excel, which in turn uses Internet Explorer 9 to render the login page functionality. This requires a recent version of Internet Explorer (9 or higher). In order to eliminate this requirement altogether, version 1.1 will incorporate a completely independent authorization flow, which is sent through the user’s default browser. Security benefits and user experience are improved through this process, as the login is no longer dependent on (old) Internet Explorer software.
Saxo’s Developer Portal provides more information about Saxo Bank’s APIs.
