Tag Archive for: query tool

Two New Features in Query Tool

We've added a couple of new features in Query Tool - woohoo!

The first is 'Course Characteristics', which covers the direction of the track, its profile (flat, undulating or very undulating), its general configuration (galloping, sharp or very sharp), and any specific configuration elements (sharp bends, uphill finish).

And the second, which might be more general fun, is DSLR, or 'Days Since Last Run'. This has a few nuances, which I'll quickly explain. Selecting a 'from' of 0 on DSLR (i.e. no days since last run) will bring back data even though it is impossible for a horse to run multiple times in one day.

What's actually happening is that we're using zero to mean 'horse is making its first start in UK or Ireland'. That in turn can mean one of two things: an unraced horse making its debut, or a horse with overseas form making its UK/Ire debut. Our dataset does not extend to overseas form so if, for instance, a French trainer brings a horse to UK for the first time, that runner will show up in the zero DSLR cohort.

Although we don't have point to point form in our database, we do normally have the number of days since the most recent point run, so horses with experience between the flags will generally not show up in the zero DSLR cohort.

I told you it was a bit nuanced!

Anyway, it's a really interesting way of looking at things like trainer performance, especially at this time of year when juveniles are making their debuts and horses are returning from their extended winter breaks.

This short video explains more about the new features and includes a couple of quick examples.

 

 

Good luck!

Matt

QT Updates Coming Today

A short post, with some video content if you'd like it, to let you know that we'll be updating Query Tool today. We're adding some new input variables as well as a new output column.

Details of those can be found in this recent post. Or in the videos below (first one is a general overview including the new variables; second one outlines a couple of important changes to the way QT Angles works).

IMPORTANT: QT may be unavailable for a period this morning (Tuesday 2nd December) while we make the upgrades.

These changes are also reflected in the latest version of the User Guide, which you can view here.

 

VIDEO #1: Query Tool Overview

 

VIDEO #2: QT Angles Enhancements

 

Matt

Geegeez Autumn Update

It's getting darker earlier, and there's a distinct chill in the air this week. The turf flat season is a fading memory and close at hand now is the National Hunt season proper as well as a serious programme of all-weather racing. Both make for excellent punting!

While it might seem like we've been quiet on the development front this year, we've actually added some big (and small) features in 2025.

The TRENDS tab was introduced in January, and has become part of my 'go to' considerations for a race.

In April, we rolled out Betfair data (Betfair SP, Place SP, in running high and low prices) across the site.

And in September we added 'AvOR', the average official rating of each race, to help you compare today's race quality with runners' recent outings.

You'll also have noticed this year that parts of the site have had a 'facelift' - updating them to be easier on the eye as well as instructive to your wagering.

And we're not done yet!

We're currently working on some further Query Tool updates, as well as more costmetic upgrades. Allow me to show you a few things from the development site.

Query Tool

We'd originally decided on a small number of new variables in QT to release as soon as possible... but once we started digging we found a few technical elements that ideally needed improving. That has delayed release unfortunately, but I'm still able to show you a couple of bits here.

New Variables

We've added some new variables for you to interrogate. These are:

Season

You'll soon be able to search by season, across flat, all-weather, and National Hunt seasons in both UK and Ireland. This is great for analysing, for example, trainers' and jockeys' progression (or regression!) and - especially for the non-flat seasons, where things are not aligned to calendar year - looking at overall stats more generally.

Below for example I've selected the trainer Anthony Honeyball, whose yard geegeez.co.uk sponsors and with whom we syndicate a number of horses, and 'grouped by' season (having only selected UK and NH race types - Anthony has also had flat winners and winners in Ireland during this time).

 

Anthony Honeyball stats by season

Anthony Honeyball stats by season

 

Owner

You'll also be able to drill down by owner before long. And, because some ownership entities have, literally, hundreds of ownership names, we've added a 'select all' button within the search facility. Here's an example using the geegeez.co.uk ownership entities. You'll be able to dig in the weeds of J P McManus, the Ballydoyle cartel, and/or anyone else you fancy.

 

 

Racing Post Rating and RPR Rank / Topspeed and TS Rank

And we've added Racing Post Rating and Topspeed, as well as RPR/TS Rank within a race (e.g. RPR rank 1 means the top rated horse on Racing Post Ratings). This image shows the top two ranked Topspeed horses' collective performance over the past two years in UK handicap hurdle/chase races. This is bound to include some big-priced winners skewing the data, but it's not a bad starting point for further analysis by any means!

 

 

PRB

The eagle-eyed may have noticed that we've added a new column on the right hand side of the results output in Query Tool for PRB (Percentage of Rivals Beaten). This is a very useful metric, especially for smaller sample sizes, where a number from around 0.55 (55% of rivals beaten) is a positive, and anything below (0.45) is somewhat of a negative. It's definitely a number to keep an eye out for when creating your QT Angles.

*

A New Look for the Reports

As well as QT upgrades, we're also working on our report suite and, specifically, on making it a little more modern in look (the data remains the same excellent content you're already familiar with). They'll look like this:

 

 

Timeline for Implementation

I've already got this wrong once, which is annoying/embarrassing, and so I'm loth to make the same mistake again. However, I'd be very hopeful they'll appear on your screens - the report changes at least - by the end of the month.

Query Tool upgrades should be an early Christmas present, expect them online in the first half of December with a following wind.

And... in January, we'll be kicking off the New Year in style. More on that another day.

 

Thanks as ever for being a geegeez subscriber, it means a huge amount to me - to all of us - and it enables us to continue to invest in your racing site. Thanks again!

Matt

A Major New Site Update

It's the changing of the seasons, a time for spring cleaning and refreshing the house. And, this year, that extends to chez geegeez, too. You may have noticed a few changes already, including on this page, in terms of the look and feel of things. There's much more of that in the pipeline for the coming days and weeks.

But today I want to share an update that is more than just cosmetic. Indeed, it feels like building an extension on the side of the house - after a fashion, at least. Yes, finally, we have added Betfair data to our racecards, form tools and reports. The video below illustrates what we've added, where you'll find it, and how to use it. I very much recommend you have a gander.

 

 

Betfair data is visible to all paid plan users, whether Lite or Gold. To see what else we have, and to upgrade your account, click here.

There is also an updated User Guide, which you can review here.

I really hope you enjoy the new data as much as I have been.

Matt

p.s. As is often the case with new releases, there are a few odds and ends to sweep up afterwards. We're aware that the 'tomorrow' report content is not yet on site - it will be later this afternoon.

p.p.s. In the video, I've referred to 2% commission on Betfair. In order to ensure you're paying this minimum level, log in to your Betfair account and go to this page. Choose the 'Basic' plan (probably the panel on the right of the page). That's it, you'll now pay 2% only on net winning exchange bets.

What to expect in 2024

The new year is well upon us now and, on this fourth day of January, a few resolutions may remain intact. Chocolate, biscuits, cakes (and especially chocolate biscuit cakes) and beer are largely off the agenda for a bit here - yes, life is currently very dull - but, on a much more interesting note, below are some words around what is on the 2024 agenda for geegeez.co.uk...

 

Racecard Small Changes

We'll start with a 'not very rock n'roll' update: a collection of small changes to the racecards. Although small, most of them are things many users repeat countless times while navigating the software in search of interesting horses.

22nd January Update

These changes are now live and you can see them in action in the video below - there's a timeline below the video:

00:00 Intro
00:31 Save Racecard Filters (desktop & mobile)
02:45 Actual Race Distance in form blocks
04:16 Full Form UK/Ire filter
05:25 'By Time' Racecard view now has time order dropdown
06:40 Asterisked notes
09:10 Run Style added to Full Result
11:00 Removed 'abandoned' meeting non-runners from Tracker
11:35 Outro

 

Editorial Explainer

First up is a racecard menu filters 'memory' - currently, a user must select parameters from the racecard menu filters section each time they close and open the cards menu page. If you use the same filters all the time, you have to reinstate them each time. Faff. We'll sort that.

[Incidentally, if you sometimes see there are no races displaying on the menu page, just hit the 'reset' button top right]

 

Next, an asterisk on the form row when you have a note saved for any/all of meeting, race or runner - to notify you that it's there.

 

Also, we'll be displaying the specific race distance and any distance amendments when you hover over the 'Race Conditions' on any form row:

 

And, if you choose to view the racecard menu page 'by time' you can view the race dropdown ordered by time.

 

If run style is of interest to you, we're adding each horse's early pace position to the full results:

 

We'll get those small, but perfectly formed, changes live later this month.

 

Betfair Data

One of the projects for later in the year is to incorporate Betfair data - Betfair Starting Price (BSP) as well as in-running high and low prices. We actually have these data in our system but adding them appropriately to results and into the tools will take a while. But it's on our to do list.

For a lot of readers who have been restricted, some of the BSP results are likely to make eye-opening reading, certainly when compared to SP.

 

Ratings Model

This is one of those dreaded rabbit holes into which I vowed we'd never delve. Well, we have already sunk a good few hours into the project and we've made some promising progress; but there is  much still to do. I'm at the point now where, for the first time, I do believe we can produce a set of ratings that a) finds a lot of winners and b) highlights some value.

The process involves creating separate models for separate groups of races, and if/when we get as far as publication, we'll do it piecemeal. That is, once we're happy with, for instance, our all-weather sprint handicap model, we'll publish numbers for all-weather sprint handicaps. And so on.

There are loads of ratings out there, many of which are very good at finding winners - but due to the fact they're published so widely they are significantly loss-making. Our Peter May ratings get close to break even at Betfair SP with their top rated picks every year, sometimes turning a small profit and sometimes a small loss. And we might not be able to fare better than that.

My main point is that, unless we find something of utility, as opposed to the somewhat ornamental numbers produced by the fashionable houses, we'll not publish.

 

Query Tool

QT is a powerful means of analysing large chunks of racing data and, once that's done, of saving specific 'QT Angles' to your own account and being notified of qualifiers each day. It's been unchanged for a few years now, and we've aborted a few attempts at an upgrade; but I have so many things I want to add to QT - a majority of them from your feedback and suggestions - and, once we've re-engineered a QT 2.0 engine, it will be relatively straightforward to deploy that extra functionality.

This WILL happen in 2024, it's been too long.

 

*

As you can see, apart from the small changes due for release this month, we've got a couple of pretty big 'how long is a piece of string' projects for later in the year. The Betfair element shouldn't be too onerous but I'd like to put some developer time into the modelling next. Very, very loose timeline would be aiming to get some flat rating models on stream for the start of the turf season; then perhaps pivoting to the Betfair and QT projects before reverting to the remaining race code ratings models.

There is a lot of scope for timelines to change, but these are the 2024 resolutions for geegeez. Let's hope they last longer than my personal attempts at self-improvement!

Matt

p.s. away from the bright lights of geegeez, there are a couple of other interesting projects on the go. One, a tote ticket builder, should hopefully be available very soon (I've been using it for a year!), and the other, TennisProfits.com, is a site for tennis traders that we're hoping to make more accessible for bettors, too. I'll share snippets on these from time to time as the year progresses. The tote ticket project especially is one that I think will be of great interest to many geegeez readers/racing punters.

Spring Mile / Lincoln Video Preview

To mark the return of flat turf racing to Britain, I've recorded some thoughts on the two big field mile handicaps being run at Doncaster tomorrow. The Spring Mile and the Lincoln are both Class 2 straight mile handicaps and both have 22 runners as I write. The ground is currently soft, heavy in places, with the sky taps still turned on - so heavy might be what we get.

With all that in mind, I share my thoughts in the video below. In it, I share:

- Common features between the races
- Draw / run style biases
- Instant Expert overviews
- Some picks!

[*As ever, if I speak too slowly for you, use the little cog icon bottom right on the video to choose a faster playback speed]

Good luck!

Matt

 

Gold Nuggets: Negative Draw Bias

In this week's episode, we look at the value of identifying horses that have run well from a poor draw; and how to spot these horses and add them to your Geegeez Tracker.

The video was inspired by an article published this week on site, which can be viewed here.

00:00 Intro
04:20 Looking at historical races
13:15 How to research negative draw bias using QT
15:00 Example 1
18:00 Adding to Tracker
22:20 Example 2
24:45 Example 3
27:45 Video Recap

Gold Nuggets #4: Using QT to Find Race Trends

In this week's Gold Nuggets, I show you how to use our awesome Query Tool to drill down into a race's history in search of profiles, patterns and, heck let's say it, trends! I've used the example of the Thyestes Chase, a high class extended three-mile handicap which often throws up a Grade 1 performer of the future. See what you think...

Gold Nuggets #3: Px Form & Jackpot Joy

In this week's third instalment of Gold Nuggets, I show you how to:

- get a head start with your big race ante-post betting

- use Query Tool to get specific with draw and pace insights

- get an instant feel for how well a horse has performed in its recent races

- have fun with low stakes, optimised jackpot betting

 

It's all in the video below. Two points before you press play:

  1. The video has 'chapters' so if you're interested (or not) in certain parts, click the chapter title to view all available chapters

  2. To make me speak faster, click the cog icon and choose the speed you want

 

 

 

Exotic Betting Two-Parter

Multi-race Bet Builder

Winter Webinar #4: The Tools One

In this fourth and final Winter Gold series web broadcast, we look at the tools available to Gold subscribers. Specifically:

- The joy of a (good) Tracker, and how to use one properly
- Draw and Pace blue sky thinking
- Know thyself (and thy bets)
- Query Tool: where the really good stuff happens

If you like to arm yourself with nuggets of profit-pulling intel that other people don't have, watch this video and then set to work!

Matt

p.s. if you'd prefer to watch/listen slightly more quickly,  use the ⚙ icon in the bottom right of the video screen and change the 'Playback Speed'.

p.p.s. If you missed the previous sessions, you can watch them here (#1), here (#2) and here (#3).

Horse Racing Betting Angles: Part 3b, Bonus Module

In this bonus module, Part 3b, you'll learn about something I call 'mark up' angles. These are snippets of information which are not necessarily worthy of a bet in their own right, but will help me to form a view on a horse in the context of a race.

Again, if you've not seen the previous episodes, I urge you to start here.

In this bonus recording, we'll look at mark up angles for:

- Sires

- Wind surgery runners

And we'll also look at horse profiling within Query Tool. Adding a few of these to your Tracker for the upcoming flat season will be a VERY good use of an hour or two during this downtime!

Here's the video - I hope you like it.

Matt

p.s. If anybody has any questions, I will be happy to record a QT Q&A session to help you get you out of the blocks as quickly as possible.

Horse Racing Betting Angles: Part 2, Query Tool Intro

In Part 1 of this three-part series looking at horse racing betting angles, I talked about research principles: about knowing what works for you, about the importance of logic and a lot more besides. It's a foundation piece for the next two parts and, if you've not read it yet, I'd strongly encourage you to do that first. Here's the link: Horse Racing Betting Angles Part 1

Parts two and three are video-based for now, though I will endeavour to get transcripts at some point. The middle piece, then, is below, and it provides an introduction to Query Tool, Geegeez Gold's main research module. It can be used to drill down on courses, horses, trainers, jockeys, sires, damsires, and plenty of other things besides.

In this video, you'll discover what Query Tool (QT) is, where it lives, and how it works. You'll see how to visualise your analysis, display qualifiers and, best of all, save your research so that it is recalled when relevant, i.e. when there are qualifiers in the day's racing. Click the play button to watch Part 2.

In Part 3, which you can look at here, we'll look at some examples of angle research, produced with Query Tool. Each example is one element of a group of entities which can be researched. As such, there is ample opportunity for curious readers/listeners to try things out for themselves. Look out for that in the next couple of days.

Matt

Using Query Tool to find Heavy Ground Angles

It's been raining. Rather a lot. Those courses which have dodged the abandonment bullet are largely racing on heavy ground just now, and that presents a challenge for us punters because most horses have little or no form on such a testing surface.

So how do we mitigate for this? Plan A for most is to guess. Not ideal.

Plan A for Gold subscribers should be to do a little digging; and in this shortish video I'll show you a couple of ways - via Instant Expert and the Query Tool - to home in on those sires whose progeny might be worth marking up when the mud is flying.

 

Hope that's useful.

Matt

p.s. It's Royal Ascot next week - whoop! - and if you haven't yet secured your Gold subscription, you can take a £1 trial here (new users only, please). Alternatively you can access a short-term seven-day sub for just £12 by clicking here. Good luck!

COMING SOON: Query Tool

In this post, I want to share a new feature which is going to be available very soon. I also want to politely remind you that today (Friday 27th January) is the last chance to secure your discounted (for life) Annual Gold subscription.

Let's cover that off first.

Geegeez Gold is continuing to invest in innovation. After this week's latest 'bell and whistle' enhancements - Pace Predictions on the pace tab, and Proximity Form on Full Form Filter - we have a much bigger enhancement in early stage testing. More on that below.

Unlike some publishers, we don't increase our prices for existing subscribers. Instead, we prefer to reward commitment and early adoption, by offering our best subscription rates to our most loyal community members, and by guaranteeing that the price at which you sign up is the price you pay for the lifetime of your subscription.

This means that, regardless of what new features we introduce or how much a subscription might cost in the future, you get the lot for the price now. That's only fair, after all, because without your investment in Geegeez Gold, we are unable to re-invest in you.

So, no big fanfare, but just to say that today is the last day you can lock in your subscription for 68p a day (£249 annually). From tomorrow, the annual price rises to £297 (81p a day), which still offers two months free against the annualised monthly subscription of £360 (99p a day). That's the very best value you can get, so if Gold is something you currently enjoy, and/or if the new feature highlighted in the video below excites you, then now is the time to upgrade.

 

YOU CAN UPGRADE HERE (make sure you're logged in first!)

 

Oh, and if you're currently a free subscriber, you can use that same link to upgrade directly to Gold Annual. One fee, swallowed (!) now, gives you full 'access all areas' for the entire year of 2017 - both flat and jumps, UK and Irish - and into January 2018. Nothing more to pay.

Enough already, because I think you probably already know if this is something you want to do... If you're still unsure, here's a sneaky peek at a 'COMING SOON' feature...

 

 

.

What do you think? Anything in particular you'd like to see included? Leave a comment and let me know.

Matt

p.s. here's the upgrade button one last time. Best value racing form for 2017 lives here