SpreadServe 0.4.2f, data tables and TransFICC

August 28, 2017

SpreadServe 0.4.2f is now available for download. Changes since 0.4.2e include...

  1. Data table acceleration
  2. xldiff: compare the formulae in two spreadsheets
  3. recaide: compare SpreadServe and Excel output
  4. SSAddin.xll: now includes TFWebSock support
  5. TFWebSock: the TransFICC web socket server is now included

SpreadServe and TransFICC

August 11, 2017

Earlier in the summer I did a POC integration of SpreadServe with TransFICC. For those unfamiliar, TransFICC has an ex-LMAX founding team, and is a new entrant in the ECN gateway space. Technically their key differentiators are cloud hosting and high performance engineering techniques. For Transficc clients the only thing running on premises is the API, which puts the same orthogonalised interface on all the usual fixed income ECNs, and connects to the cloud hosted gateway processes.

It's been a while since I built anything non trivial in Java, so I was pleasantly surprised by how improved the Java ecosystem has become. Gradle has transformed dependency and package management. And the single threaded async approach popular in the Python and C++ worlds has finally made it to Java with Netty. You can find the code on GitHub here.

Automated Baremetrics Spreadsheet

June 5, 2017

Back in April I read a great post by Jaakko Piipponen on the SaaS financial model he'd built as an Excel spreadsheet. I'm interested in spreadsheet financial models, so I enjoyed Jaakko's run down on how his model covers PnL report, operating expenses, payroll and revenue. Jaakko describes how you only need to spend 30 mins a month downloading reports from the Baremetrics dashboard and pasting it into Excel to keep it up to date. The post is titled an "SaaS financial model you’ll actually update", because the value of the model is such that 30 mins of manual handle turning a month is more than justified. Now I'm the first to advocate Excel for business agility; it's a great tool that enables sales, marketing and finance people to solve problems for themselves without the bottleneck of a software development team. But the downside of Excel is manual operation like the download and paste Jaakko spells out. Wouldn't it be great if the Baremetrics data in the spreadsheet downloaded and updated automatically? Then the model would always be up to date, and no tedious and error prone download'n'paste operations are necessary.

So I built it by adding Baremetrics functions to SpreadServe's SSAddin. Here's a spreadsheet that strips Jaako's model down to just the revenue parts of the model. It uses SSAddin functions to automatically download the revenue numbers every 10 minutes into the MRR Export sheet via the Show Summary API so the Revenue Model sheet will update every 10 minutes with the latest new customers, subscriptions, cancellations, upgrades and downgrades. All you need to do is download SSAddin 32 or 64 bit .xll binaries from here install the addin in Excel and fire up the spreadsheet. Don't forget to ensure that auto calc is on, and that you've got a copy of SSAddin.xll.config from the download page and put it next to SSAddin.xll on your PC. You'll need to edit the .config to add your Baremetrics license key. You can see flight_bare_model2.xls running online and driven by spreadserve.com data here and here.

The online spreadsheet takes automation to the ultimate level. When you run a spreadsheet model automated with SSAddin on your desktop or laptop you still have to start Excel, load the spreadsheet and hit F9 before auto updates can start. With SpreadServe, you can move the spreadsheet onto a cloud server. All manual operations are eliminated, and everyone can see the same auto updating numbers in their browsers.