In this session, we move towards completing the first part of the heatmaps task.  We do this by creating heatmaps for each of the 20 teams in the Premier League.  This is reasonably straightforward - the hard work really is creating the mechanism, which we've already done!  It's just a case of changing the loop parameters.  Note how easy it is to 'scale up' a loop once the basic mechanism is in place.

We also look at how to get 'unique values' from a set of data.  Excel's UNIQUE formula, a relatively new offering that 'spills' into the rows below, really helps us here.  As always, however, there are multiple options for getting this done, including the traditional 'remove duplicates' facility, available in the Data tab on all versions of Excel.  This helps us to get a list of all teams in the league.

To complete the task, we 'tidy up' the formatting, discuss the importance of the conditional formatting rules manager, and switch off screen updating in the VBA editor to dramatically improve the speed of code execution.

So, have you managed to create your own heat maps?  Don't stop here!  You now have the tools to get the bespoke analysis you need to support your trading activities.  We will return to heat maps in the future to create even more powerful analyses.

Tools And Techniques:

- UNIQUE
- Remove Duplicates Facility
- Scale Up A Loop
- .Cells Referencing Technique
- Conditional Formatting Rules Manager
- Application.ScreenUpdating