# Connecting Microsoft Excel 2016 to OTCStreaming Using Javascript API for Office

### Release

May 22, 2017

_OTCStreaming Excel web add-in is now available on the Microsoft Office add-ins Store, free of_
_charge. The web add-in provides OTCStreaming’s real time and historical data in Excel 2016’s_
_worksheets._

Introduced in Office 2013, Microsoft web add-ins are web applications running on a browser inside an
Excel worksheet. There is nothing installed on the user’s machine, nothing to download, no update to
manage, no firewall to configure. The user will just have to open a web connection using his
OTCstreaming credentials.

Web add-ins work differently from Excel add-ins or COM add-ins. Most Excel veterans will be
surprised. The web add-in does not provide a new function to be used in the user’s worksheets cells.
The web add-in provides functions in a browser panel interacting with the Excel’s object models like
writing data in a cell or a range. Web add-ins are similar to a VBA macro but they are written in
JavaScript and are connected to the web. Being connected to the web, the add-in can use complex
functions or services on a distant server. OTCStreaming web add-in downloads data from
OTCStreaming’s database and subscribe to real time events available on OTCStreaming’s servers.

The OTCStreaming development team was pleased to just use JavaScript to develop a quick bridge
between OTCStreaming and Microsoft Excel. Easy to implement, the technology works on Windows as well
as on OS X operating systems. The team will keep releasing new features. The user should have the
same UX in a browser or on his personal Office’s tools.