OTCStreaming Excel Add-In 2.0: What’s New?

Back in May 2017, OTCStreaming had used a, then, pioneering piece of technology, Office JavaScript, to launch an Excel Add-In that connects Microsoft Excel to OTCStreaming database.

The OTCStreaming development team are delighted to release a new version of the Add-In to allow users for an enhanced experience, and a more reliable use of their spreadsheets. Benefiting from an updated Office JavaScript Excel API from 1.4 to 1.9, the objective of the release was to grant users with a modernized interface while improving the overall performance and experience.

The entire add-in was rewritten in TypeScript to leverage static type checking analysis leading to faster and safer developments. Overall performance of the add-in and the error handling process were greatly enhanced as well. The bundle size was reduced from 2Mo to 870Ko.

A cleaner login menu displayed in a separate window allows the user to come into the add-in environment where he can choose the required data from a tab menu: “Ticker”, “SDR”, or “Histo” as shown below.

To get real time data for one ticker or from a range of tickers, the simple two-step process was maintained. First step: select the range, second step: click the “Insert table” button. And the below table will appear on the spreadsheet for the range of tickers selected.

An Insert Worksheet button have been added to get the Realtime Swap Data Repository information.

The possibility to pause real time contributions in all spreadsheets was also introduced as new feature by clicking on the plug icon (green or red) for each relevant range or spreadsheet.

More improvements are less visible but very useful nonetheless. For instance, handling worksheet rename: previously renaming a sheet would break real time feed, now the feed is maintained, and the name of worksheet is updated in the interface. Also using SignalR instead of using http requests for real time also allows the server to directly push updates as soon as they are ready instead of having clients to fetch new data every few seconds.

With this release, further updates will be safer and faster to deliver. OTCStreaming is committed to keep delivering curated data in a unique and simple format to make credit derivative market data readable and relevant.