SSAddin, the SpreadServe Addin is a conventional Excel XLL addin implemented in C#. It has no build or run time dependencies on the SpreadServe server runtime, and can be used independently in a regular desktop Excel installation, or in SpreadServe itself. SSAddin supports quandl, cron style scheduled execution, and web socket live updates. SSAddin is freely available under the Apache License 2.0
You can download ready to install 32 & 64 bit binaries from SpreadServe's download page.
SSAddin gives you access to Google Analytics Reporting v3 API via the s2ganalytics and s2gacache worksheet functions. See the ganalytics_sessions2.xls worksheet for an example.
SSAddin gives you access to the Baremetrics API via the s2baremetrics and s2bcache worksheet functions. See the baremetrics_summary1.xlsx worksheet for an example.
quandl.com already distributes a perfectly good Excel addin, so how is SSAddin different? SSAddin uses no VBA and no GUI. It has no menu cluttering your Excel menu bar, no dialog or message boxes popping up. Everything is achieved via worksheet functions, and all network round trips are handled on a background thread so your Excel UI never blocks waiting for data to download from quandl.com.
Tiingo is an exciting new financial data portal challenging high priced incumbents like Bloomberg and Thomson Reuters. Recently tiingo.com has added API access to historical data, which is now supported by SSAddin.
SSAddin enables the creation of cron style timer jobs in Excel that trigger RTD updates on the schedule you specify. Cron timers can be used to trigger recalculations, or to launch scheduled downloads from quandl.com
SSAddin provides the s2today function. s2today is a non volatile eqivalent of Excel's TODAY. It enables invocation in spreadsheets using RTD without triggering endless calc cycles.
SSAddin supports subscription to live ticking web data via web sockets.
SSAddin builds on several other excellent OSS projects: Excel-DNA, NCrontab, WebSockets4Net and JSON.NET. We use a modified NCrontab that extends Unix style cron schedules to allow more finegrained timing specifications using seconds as well as minutes, hours, days and days of the week.
john dot osullivan at spreadserve dot com