← Blog · 📝 Article · 8 November 2026

Cymatic Trader Integration: Excel, Betfair and Lay Signals

Cymatic Trader Integration: Excel, Betfair and Lay Signals

Cymatic Trader integrates with your Betfair account directly and with Microsoft Excel through a two-way connection. Prices flow out to a spreadsheet and commands flow back in, so a UK horse-racing bettor can trigger bets from rules held in a workbook. This guide covers how that connection works, how to set it up, what to check before you automate, and where lay signals fit.

Donkeyradar
Bring Lay Signals Into Your Workflow
DonkeyRadar publishes horse-racing lay signals before races, with Pro API access for trading software such as a Cymatic and Excel setup.
Visit DonkeyRadar

TL;DR

Table of Contents

What Cymatic Trader integration actually means

People use the phrase for three different things:

  1. The Betfair link. Cymatic is a Windows desktop application that connects to Betfair through the official Betfair API. You trade from its grid and ladder views.
  2. The Excel link. The grid hosts a live connection to a workbook. This is the main route to automation.
  3. An external feed. This is any signal source, tipster or model that you pipe into the workbook yourself.

Cymatic’s own FAQ says each subscription works with one Betfair account. The software is tested and certified by Betfair and does not see or log your Betfair username or password.

For a racing bettor, that means one screen can show the market, hold your rules and place the bet. The question is how much of that you let a spreadsheet decide.

How the Excel connection works

The Excel integration is a real-time, two-way connection. Prices, market information, bet summaries and reports go from Cymatic to Excel, while orders go from Excel to Cymatic for automatic submission to Betfair.

According to Cymatic’s manual, that lets you:

For lay bettors, the second item matters most. A spreadsheet can hold a list of selections with a stake or liability for each. It can also check the live price against a limit before it fires.

Setting up the connection step by step

The requirements are simple, but the order matters.

  1. Check your Excel version. Microsoft Excel 2007 or later must be installed on the computer. Any market you want to connect must first be open in a Cymatic grid window.
  2. Let Cymatic open the workbook. Do not open the Cymatic spreadsheet on its own beforehand. Cymatic should open Excel and connect to the workbooks. If the file is already open, it is treated as read-only and causes problems.
  3. Keep the grid window alive. After connecting, you can minimise the grid but you must not close it. It hosts the connection, feeds data to Excel and watches for trigger commands.
  4. Decide on trigger commands. The Enable Trigger Commands option needs care. If a workbook already contains formulae or commands ready to fire, they could instantly send new bets. You can switch trigger commands on or off from the Excel drop-down in the grid after connecting.
  5. Start in training mode. The FAQ says training mode simulates bets without risking real money. Run a full card of simulated races through your workbook before you use real stakes.

A note on Excel 365

Cymatic talks to Excel through COM interoperability, which needs certain DLL files on your machine. If you only use Excel 365 as an online service, those files are not on the computer and the connection fails. The usual fix for missing or unrecognised files is to repair Office. That advice comes from a 2016 forum thread, so check your current Office install before you assume it applies.

What a spreadsheet can trigger

Commands go in the column called Command on the Cymatic worksheet. The Status cell must be empty for a command to trigger. Once Cymatic detects the command, PENDING appears in Status. That stops the order repeating while Betfair responds.

The BACK and LAY commands accept optional parameters:

Parameter What it controls
LAPSE / KEEP / TAKE-SP Persistence type. LAPSE is the default if you set none
OFFSET Tick offset for the order
STOPLOSS Closing the trade to cap a loss
PLACEAT Price at which the order is placed
TRAIL Trailing behaviour
GREEN Greening up after a match
FILLORKILL Cancel what is not matched immediately

The Cymatic Racing Autopilot can select each horse race and move on by itself. The NEXT command tells it to move to the next race. It goes in cell BA7, not on a runner row. When it reaches the last race, the Report column shows that the autopilot has finished.

Stop loss has limits

The built-in stop loss is a global setting that works with Tick-Offset. It applies to bets you enter manually on the grid or ladder, not to automated bets placed by the robot or to greening bets. It is applied when a bet is sent. Unticking it does not switch it off for bets already sent, and ticking it will not apply it to earlier bets.

So if your workbook places lay bets, build the loss limit into the workbook logic or the stake itself. Our guide to a lay betting stop loss that sizes by liability, not stake shows why.

Diagnosing common problems

Most faults show up in the sheet itself.

If your feed is the problem rather than Cymatic, see our piece on the Betfair Streaming API and what to do when no packets arrive.

Risks to check before you automate

Automation multiplies mistakes as quickly as it multiplies good decisions. Check these first.

Order volume. Betfair’s API sets a ceiling of 1,000 order instructions per second. That counts individual instructions, not calls, so one call with 300 bets counts as 300. Cymatic’s developer has said there is no charge for requesting streaming prices. Betfair transaction charges could still apply if you submit or edit more than 1,000 bets per hour. The cleanest defence is not to cancel and re-place an order that could simply be left in place.

Betfair order instruction and hourly charge limits

Robot behaviour. Cymatic warns that in very volatile markets the robot can place and cancel bets so often that it exceeds the hourly order limit, and Betfair may charge for that. Its advice is to use conservative settings and risk only a small percentage of your account on each bet.

Compliance. Cymatic says it adheres to the UK Gambling Commission’s requirements for remote gambling software. The Commission’s security requirements were updated on 4 November 2024. They aim to stop customers being exposed to unnecessary security risks when they gamble remotely.

Cost and caps. One independent review describes a permanent free tier and a Pro tier at roughly £6 a month, with a stake cap on the free tier. Check Cymatic’s own site for current terms before you plan around them.

If you bet at volume, the tax and charge side matters as well. See our explainer on the Betfair expert fee and its £25k threshold.

Bringing lay signals into a Cymatic workflow

A spreadsheet that fires bets is only as good as the selections you give it. Many UK racing bettors who use this kind of setup lay the likeliest loser rather than back a winner. We built DonkeyRadar for that approach.

The route looks like this:

  1. Get the signal before the race. Every DonkeyRadar signal is published before the race starts, so there is nothing to backfill.
  2. Map it to a row. Match the runner and race to the market open in your Cymatic grid.
  3. Size by liability. Decide your maximum loss per lay first, then derive the stake. Our fixed liability staking guide covers the method, and the lay betting calculator does the arithmetic.
  4. Put in the command. A LAY command with a price limit and FILLORKILL stops a stale order sitting in the market.
  5. Check the Report column. Log every result and compare it with our public results history.

Cymatic reads and writes through Excel, so the signal reaches it as spreadsheet data. You build and maintain that bridge yourself. We do not claim a ready-made Cymatic connector. Pro includes API access designed for trading software integration, which is the natural source for a workbook feed. If you use a different desktop tool, we have written up three signal routes into Bet Angel and how Excel runs through Betfair in Geeks Toy. The general guide to connecting tipster signals safely applies to any of them.

Timing matters too. Pre-race lay bets avoid the in-play delay, which we explain in pre-race lay strategies for UK bettors.

Our view on automating lay bets

We get asked about trading software more than almost anything else. Our answer is the same each time: the tool matters less than the discipline around it.

A Cymatic workbook will do exactly what you tell it to, quickly. That is useful when the input is a published, tracked signal with a fixed liability. It is costly when the input is a hunch and the stake is a guess.

This is why we publish every signal before the race and keep every result in a permanent record. Our selection process is data-driven. It uses historical strike rates and live market prices, not opinion. Our overall strike rate is above 85%, and we show the losses too. It happens. Transparency is the whole point.

If you automate, automate the boring parts: the stake calculation, the order placement and the logging. Keep the loss cap fixed, whatever the sheet says. A fixed cap is what keeps a bad run survivable, so you can still be there for the next good one.

Donkey

Get the signals into your setup

DonkeyRadar Free gives you the daily lay signals at no cost. DonkeyRadar Pro is £29 per month after a seven-day trial. It adds real-time alerts by email and Telegram, the full results history and API access for trading software. Staking tier grading and a dashboard with direct Betfair Exchange links help you act on each signal quickly.

Donkeyradar

Start on the free tier and compare the signals with your own workbook rules. Then move up when you want alerts and the API. You can see both plans on DonkeyRadar. For the thinking behind the selections, read our data-driven Betfair lay betting strategy. Profits from betting in the UK are tax-free. You must be over 18 to bet. Only stake what you can afford to lose.

FAQ

Does Cymatic Trader work with Excel?

Yes. It forms a two-way link with Excel 2007 or later. Live prices and bet data go to the workbook, and commands from the workbook go back to Cymatic for submission to Betfair. The market must be open in a grid window, and that window must stay open while you work.

Can Cymatic Trader place bets automatically?

Yes, through Excel trigger commands and the Racing Autopilot. You can set persistence, offsets, stop loss and greening on each order. Start in training mode, use conservative settings and cap your risk on each bet.

Why does my Cymatic command not fire?

The usual causes are a non-empty Status cell, trigger commands being disabled, or the market not being open in a grid. If it fails, look at Status for FAILURE, TIMEOUT or PROCESSED_WITH_ERRORS, then read the detail in the Report column.

Can I connect DonkeyRadar signals to Cymatic Trader?

You can bring our signals into a Cymatic workbook yourself, since Cymatic accepts commands from Excel. Pro includes API access for trading software integration. Use fixed liability on every lay and run the setup in training mode first.

Sources