In the last post, we looked at taking daily valuations and transactions for a hypothetical investment account and computing daily returns and an index series. In this post, we’ll take that analysis further by computing some drawdown statistics and comparing the fund’s performance against a benchmark. We’ll start this analysis using the index and return…
In this post, I’ll demonstrate how to use Enso to analyse the performance of a hypothetical investment account. Starting from a daily valuation and transaction history, we’ll create a return series and convert it into an index to show monthly returns and statistics. The Input Data For this analysis, we have two input data files:…
One of Enso’s strengths is its ability to easily gather and process data from various sources, particularly web-based APIs. In this post, using Enso, I’ll show how to combine data from FRED and Wikipedia to create a dataset of UK Prime Ministers and the annualised inflation rate during their time in office. My goal is…
It’s been a little while since I last posted, as the team and I at Enso have been hard at work on the new version of the app. We released version 2025.1 a couple of weeks ago with a huge number of new features and improvements. As anyone live in the UK will know, it…
So it’s that time of the year again – it’s even snowing here in London as I write this. That means it’s time for the Advent of Code. For those who haven’t heard of it, this is a fantastic set of 25 puzzles released one by one every day in December until Christmas Day. Each…
In this post, I will use the results from my last post to review how each category has performed against the sales targets the company has set. The completed workflow from that post can be downloaded from GitHub. The sales targets are stored in a JSON file, so they must first be parsed and then…
In this post, I will build on top of my last post and go over how to parse values in the dataset, select down to just the columns we are interested in, and finally aggregate the data. The previous post covered installing Enso and then loading in some data. This post starts from the workflow…
In this post, I will use Enso to read and process a CSV file. Enso is being designed and built to make it easier to process, blend and analyse data. It is a new programming language designed to have a dual representation both as text and as a visual graph. The dataset used in this…
Enso is a functional programming language that lets you quickly and simply load, blend, and analyze your data. We’ve been building out the core capabilities of the product and are rapidly working on the IDE and cloud release to give a straightforward experience for users using it. To show some of the new capabilities, I…
Some members of the team building Enso decided to try and tackle last year’s Advent of Code using the language and see how far we could get. I’ve previously tried solving Advent of Code in Alteryx and was personally interested to know whether it is easier or more challenging with what we are building. For…
It’s the end of the Advent of Code for 2020. The last week was tough – the part 1s were fairly easily doable, but part 2s often were a lot harder. In the end, I managed to solve all of this week but 1 in BaseA Alteryx. For the one I couldn’t, I used BaseA…
So week 1 and week 2 were both possible in BaseA Alteryx, although getting harder as the puzzles progress. Week 3 was the first time I needed to go beyond BaseA to find a solution for a couple of the parts (though in at least one case the community found a BaseA solution). As with…
So week 1 was well suited to Alteryx, let’s see how week 2 unfolded! A nice and gentle Sunday puzzle lulled me into the belief that it was going to be an easy week, followed by the first needed use of an iterative macro, and then something that looked far too much like the dreaded…
So it’s December and time again for the annual Advent of Code. For those not familiar, this is a set of 25 puzzles (each with 2 parts) set by Eric Wastl. They have a Christmas theme and story and are solvable with just a little programming knowledge and some puzzle-solving skills. The puzzles start quite…
In this blog, I look at a few different ways to recreate the Mandelbrot set within Alteryx using just the BaseA tools. Along the way taking a look at pros and cons of each approach and the performance of the new AMP engine.
James Dunkerley's Blog 