This spreadsheet bot collects data from betfair markets into the excel sheet automatically all day. It’s mainly designed for horse racing and greyhound markets. Very clean development! Use it to build up huge personal databases for farther analysis, backtest your trading ideas and save time! You can analyse statistics to create your profitable strategies! It’s essential for serious traders! You need to have Cymatic subscription and Excel (min. 2010) to use this bot!
Why use excel? Because excel is highly user friendly and customizable. Most people already know their way around the software. Huge amount of information available online about improving excel skills. Excel is the easiest and most effective way to create complex strategies for betfair trading or analyse big data.
- Extremely easy to use and professionally made!
- It will record every data from the First 18 Runners (betfair sort): Actual Back/Lay Odds, Last Traded Price as Odds and Tick, 6 Queue position data, Runner Volume.
- It has 40 custom data places, so you can record your personal calculations or BSP, Projected SP, more horses or anything extra you need.
- You can also rearrange all runner’s data if you don’t like the default arrangement.
- It also records the Event Name, Total Matched, Countdown, Date and Time, Market Status(In-play or Pre-Market).
- It can record the last 5-15 minutes of every pre market race in a day fully automatically with proper setup.
- Bet Angel version has 2 sheets (xlsm file), thanks to guardian when 2 markets are too close to each other, guardian can use the second sheet to record the data, so it can record from 2 markets simultaneously, resulting more collected data per day! However you can buy the 50 sheets version here too!
- Betting Assistant and Cymatic versions has only 1 sheet (xlsm file), so they can only focus on one market, but they can still record a lot of data per day.
- Both can record about 1 million rows per sheet, when it’s full you can open a new empty excel file and start recording again.
- It can record Pre Market and/or In-play data as well.
- It can record data when the market in negative time (when after the official start time but not in-running yet, the countdown will show 0 value)
- Mainly designed for horse racing / greyhound markets, but It can be used for football/soccer or tennis markets too
- Very fast and clean development, no faltering!
- Adjustable recording time frequency: from 1 sec to unlimited
- Adjustable conditions for recording: total matched money, number of runners, countdown interval, market status (in-play, pre market or both)
- Built-in converted Last Traded Price Tick data, it can be essential for backtesting. (Tick is an integer number 1-350, each number represents an odds value)
- Delete faulty rows button (clean up your database from bad rows: zero data rows, empty rows)
- Potential free updates.
- Bug support via email.
- Sheets are macro protected (you can ask for unprotected version for additional costs).
- One time payment, unlimited usage.
Cymatic version (1 sheet):
Max. 24 hours delivery via email, please be patient! If question: firstname.lastname@example.org
Clean up database:
Make your custom backtest analysis with the collected data (backtest system not included with the bot, it’s just a custom made example):