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:
| Column | Purpose | Example | Wildcard |
|---|---|---|---|
| Market Name | Full Betfair market name | Newcastle 19:30 6f Hcap | * |
| Market Time | ISO or Bet Angel date/time | 2025-07-04 19:30 | * |
| Selection Name | Runner/team name | Thunderous | * |
| Selection Row | Row number in Guardian | 1 | * |
| SV Name | Name of the stored value | target_odds | – |
| SV Value | The value to set | 4.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
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
- Guardian ▶ Automation ▶ Create a new rules file
- Click Add Rule and choose “Set Stored Value using a File” from the Rule Type list.
- General tab – decide when the rule fires (e.g. every 1 sec while event is In-Play).
- Parameters tab – browse to your CSV and press Check File for Errors. Bet Angel will validate the format instantly and list any problems.
- Save the rules file and apply it to any markets in Guardian.
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
| Symptom | Likely cause | Fix |
|---|---|---|
| “File locked or not found” in the log | External program still writing | Close the file handle or write to a temp name then rename atomically. |
| Rule fires but SVs stay blank | Filters too specific | Replace unnecessary columns with * wildcards. |
| Trigger counts explode | Rule re-arms too quickly | Add a “Number of times rule can trigger” condition or increase re-arm time. |
| Incorrect selections | Names don’t exactly match Betfair | Use 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!