HRBT Logo

HR Best Times - Horse Racing Data Analytics

πŸ“Œ Looking for more details or to purchase? Visit the HR Best Times product page.

πŸ“Œ Table of contents

βš™οΈ How HRBT works

Welcome to HR Best Times!

HR Best Times (HRBT) is a comprehensive horse racing data software designed to help you compare runners quickly, understand suitability to conditions, and identify potential value angles using a consistent and structured scoring framework.

Each daily HRBT spreadsheet contains a full dataset of over 175 columns, covering race context, runner profiles, suitability metrics, performance scores, market indicators, and proprietary HRBT ratings in a single spreadsheet view.

See a real HRBT Excel file
If you are discovering HR Best Times for the first time, you can download a real example of a daily Excel file generated by HRBT. This allows you to immediately see the structure, columns, and depth of data produced by the software.

πŸ“₯ Download a sample HRBT Excel file
This file is provided as an example for demonstration purposes and reflects a typical HRBT daily output.

HRBT includes its own integrated Excel reader, which eliminates the need for an Excel license.

  1. ❢ When launched, HRBT opens the Excel file of the day if races have already been imported.
  2. ❷ You can manually import races by clicking on the Races button and selecting either UK or IRE races, or both. The data for these races is generally available between 8 a.m. and 9 a.m. UK time. Moreover, races are automatically downloaded every day according to the last race types you selected, which can either be UK/IRE, UK, or IRE. However, to activate this feature, you need to have imported races manually at least once using the new version.
  3. ❸ The HR Best Times columns tabs (in the ribbon) allows you to select which columns you want to display or hide.
  4. ❹ Results are updated automatically by the system. You can also update manually using the Results button.
  5. ❺ The fractional odds (WIN SP) come from the bookmaker. The Betfair SP odds and volumes are only available the next day. To update the Excel spreadsheet, you simply need to read the previous day's Excel file and click on the Betfair SP button.
  6. ❻ If you have made changes to the Excel table (or if the file was generated by an older version), you can regenerate the file using the Rebuild feature.
  7. ❼ HRBT saves the spreadsheet automatically with the name HR_BestTimes_YYYYMMDD.xlsx in a dedicated folder (openable from the folder icon).
  8. ❽ Click the Excel button to open the spreadsheet in your default spreadsheet software.
Important:
HRBT focuses on professional UK/IRE races. Point-to-Point (P2P) races may appear in public form strings, but they are not used for HRBT calculations. If a runner has only P2P form, HRBT leaves performance-based fields blank.

⬆ Back to contents

🧩 Understanding the HRBT layout

The spreadsheet is organised into logical blocks: race context, runner details, market and tip signals, recent race indicators, suitability ratings, and finally the HRBT scores (Performance, Suitability, Speed, Intent, Market).

Display rule used across HRBT:
When a value is not applicable (for example OR in non-handicaps), the cell is usually left empty to keep the sheet clean. When a value is unknown but normally expected, HRBT may leave it empty as well. This keeps filters and sorting usable without filling the sheet with repeated N/A.

⬆ Back to contents

πŸ“Š Excel Spreadsheet Description

** Weather conditions are retrieved daily early morning. **

Column reference notation
Column letters shown in [brackets] (for example [A], [B], [AA]) refer to the Excel column position in the generated spreadsheet. This helps you locate each field quickly.
HRBT proprietary data

Throughout this spreadsheet description, magenta / purple-highlighted blocks are used to identify proprietary HR Best Times calculations.
These sections describe ratings, scores, and indicators that are designed and computed internally by HRBT, using HRBT-specific logic and data processing, and are not sourced directly from bookmakers, exchanges, or third-party providers.

This visual distinction helps separate raw or reference data from HRBT analytical intelligence throughout the document.

⬆ Back to contents

🧭 How to use the generated Excel file

HRBT generates the data automatically, but the real power starts once the daily Excel file is created. The software is deliberately flexible: there is no single fixed strategy, and the edge comes from how you combine and filter the information.

While HRBT includes its own integrated Excel reader, to analyse and filter the data efficiently, it is recommended to open the generated file in Excel or a compatible free spreadsheet application such as LibreOffice Calc or WPS Spreadsheet.

HRBT automatically saves the daily Excel file in a dedicated folder. To access this folder quickly, click the blue folder icon directly from the HRBT interface.

HRBT Excel folder access

This will open the directory containing all generated HRBT Excel files, allowing you to open, filter, and analyse them using your preferred spreadsheet software.

πŸ’‘ HRBT is designed to let you build your own logic progressively, rather than forcing a predefined system.

Filtering and searching across columns

Once the Excel file is open, enable filters in Excel using Ctrl + Shift + L. You can then filter any column using:

For better readability of column names, we strongly recommend selecting the first row (column headers) and enabling Wrap Text from the Home tab of your spreadsheet software. This ensures long column names are displayed fully instead of being visually cut.

– Numeric conditions (for example: HRBT Rtg β‰₯ 7.5, Suit. Score β‰₯ 7, Data Qual. β‰₯ 6).
– Rank-based logic (for example: HRBT Rank ≀ 3, Track Rank = 1).
– Binary flags (for example: CD? blank, G? blank, Challenge Flag not marked).

This allows you to recreate very precise searches across many columns at once, without manually scanning races.

A simple starting approach

A common and sensible way to begin is:

– Remove races with low Data Qual.
– Focus on horses ranked near the top by HRBT Rtg or HRBT SR.
– Refine further using suitability (Track, Distance, Going) and intent signals.

This approach gives far more flexibility than a rigid rule and allows you to experiment safely.

Back testing in HRBT

HRBT includes a Back Test module, which is accessed via Custom Systems. The workflow is:

– You describe the logic you want to use (filters, ratings, ranks, exclusions, etc.).
– Our team builds this logic directly inside HRBT as a Custom HRBT System.
– The system appears in your Custom System tab.

From there, you can generate selections automatically, run back tests on previous days using the same logic, and export selections into a Malbot-compatible text file.

The cost is Β£49.79 per Custom HRBT System. Once created, the system is yours, permanently available in HRBT, and reusable every day without manual filtering.

Manual back testing without a Custom System

Without a Custom System, back testing is done manually by opening previous daily Excel files and applying the same filters and rules to observe how the logic behaved across multiple days.

Sending selections to Malbot

Once selections are identified:

– From Excel: filter the horses, copy the Horse name column, paste it into a simple text file (using Notepad or Notepad++), and save it with a .txt extension for Malbot.
– From an Official or Custom System: HRBT can export selections automatically into a Malbot-ready text file.

Many users operate this way: HRBT for analysis and selection logic, Malbot for execution.

How to begin

For new users:

– Start with one simple idea.
– Apply it manually in Excel.
– Check how it behaved on recent days.
– Focus on understanding the data rather than optimising too early.

The user manual is continuously being improved, and step-by-step video guides will be released to visually walk through filtering, searches, Custom Systems, back testing, and Malbot integration.

⬆ Back to contents