csv import formatting

How to Import Betting Selections into Bet Angel

Bet Angel lets you bypass Excel completely and drop data—your picks, prices, model outputs, even external stats—straight into its automation engine.

From version 1.57 onward you can do this with a simple “Set stored values using a file” rule that reads a CSV on every market refresh, turns each row into a stored value, and makes that information instantly available to any rule, servant or custom column inside the software.

Here’s a step-by-step guide that pulls together the essentials.


Why use a CSV instead of Excel?

  • Speed & stability – no DCOM time-outs or VBA crashes; Bet Angel just parses a text file.
  • Platform freedom – generate the file with R, Python, a third-party API, or a simple web-scraper.
  • Full automation – the file can update on a schedule while Bet Angel is already running Guardian rules.

1. Check your Bet Angel version

The feature arrived in v1.57. Earlier builds can only push data in via Excel. Upgrade if necessary (free for existing licence holders).


2. Understand the CSV structure

Each row contains four filter columns and two action columns:

ColumnPurposeExampleWildcard
Market NameFull Betfair market nameNewcastle 19:30 6f Hcap*
Market TimeISO or Bet Angel date/time2025-07-04 19:30*
Selection NameRunner/team nameThunderous*
Selection RowRow number in Guardian1*
SV NameName of the stored valuetarget_odds
SV ValueThe value to set4.2

Any filter you don’t need can be replaced by an asterisk to act as a wildcard. Bet Angel will process the first matching row for the current market/selection. A fully worked template called storedValueFromFile.csv lives in:

C:\Program Files (x86)\Bet Angel Limited\Bet Angel - Professional\templates
bet angel csv files

Use it as a starting point and keep the file in a writable folder so your external script can overwrite it.


3. Build the automation rule

  1. Guardian ▶ Automation ▶ Create a new rules file
  2. Click Add Rule and choose “Set Stored Value using a File” from the Rule Type list.
  3. General tab – decide when the rule fires (e.g. every 1 sec while event is In-Play).
  4. Parameters tab – browse to your CSV and press Check File for Errors. Bet Angel will validate the format instantly and list any problems.
  5. Save the rules file and apply it to any markets in Guardian.
set stored values
data file selection

4. Use your imported data

Now that target_odds (or whatever you named it) is a stored value you can:

  • Trigger bets – e.g. back the horse when its LTP ≤ target_odds.
  • Display on-screen – add a Custom Column or Marker to show the value on the ladder.
  • Share across markets – tick Shared when you create subsequent rules so other automation files can read the same value, ideal for cross-market football strategies.

5. Advanced ideas

  • Real-time stats – scrape xG or serve-speed data, append it to the CSV, and let Bet Angel act when a threshold is hit.
  • Full model output – write multiple rows per selection (one stored value per metric) and let Guardian evaluate complex conditions locally.
  • Pre-race short-listing – generate the CSV the night before and Guardian will ignore every runner not on the list.
  • Bulk green-up – combine CSV-driven entry with a second rule that greens up all selections where a stored entry_time ≥ 60 sec ago.

The Bet Angel forum has ready-made files and walk-throughs for football, tennis and racing. A popular example pulls a dozen statistics per match from a free football-stats site and uses them live in-play.


6. Troubleshooting checklist

SymptomLikely causeFix
“File locked or not found” in the logExternal program still writingClose the file handle or write to a temp name then rename atomically.
Rule fires but SVs stay blankFilters too specificReplace unnecessary columns with * wildcards.
Trigger counts explodeRule re-arms too quicklyAdd a “Number of times rule can trigger” condition or increase re-arm time.
Incorrect selectionsNames don’t exactly match BetfairUse Selection Row instead of Selection Name, or pre-process names (title-case, remove accents).

7. Next steps

  • Experiment in Practice Mode first.
  • When you’re happy, move the CSV creation into your normal workflow (Python script, Trading View alert, Google Sheets export, etc.).
  • Keep Guardian’s refresh rate sensible; there’s no need to read a 1 Hz file if your data only updates every minute.

That’s it—your model now talks directly to Bet Angel with nothing more exotic than a text file. If you run into quirks, the “Set Stored Value using a File” section of the User Guide and the community forum threads cover almost every edge-case.

Happy trading!