Fully Auto Adjustable Trading Spreadsheet Bot

Example spreadsheets and comments on example spreadsheets.
Post Reply
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

Greeting everyone,

I've seen many users on this forum who had trouble with VBA programming so I decided to create an easy to use fully auto excel bot. It’s mainly designed for trade on horse racing or greyhound markets. The spreadsheet is listing the data from the actual market and makes it simple for you to create any auto trading algorithm, based on the current historical data. You only need basic excel skills now to add your advanced trading algorithm/strategy. No need any VBA programming skill!


-Pre Market and/or In-play auto trading all day long. Bet Angel uses “Guardian” to auto attaching excel sheets to the markets all day long. When a market is finished it jumps to the next one. The spreadsheet only can focus on one market at the time! However you can ask for more sheets as a custom bot here!
-Runner 1 (favourite) Visual Ladder display
-Runner 1-3 Traded Volume Dispersion Display for each odds.
-Built-in Race type filtering system (adjustable filter texts): Hcap/Not Hcap; Beg, Claim, Cond, Grp1, Grp2, Grp3, Grd1, Grd2, Grd3, Hunt, Listed, Mdn, Nov, Nursery, Sell; Chs, Hrd, INHF, NHF, Stks; (video here)
-Estimated in-running time (sec) indicator: can be useful for in-play strategies
-Built-in book % calculation
-Auto Result listing and analysing system: adjustable data listing places. It helps you to analyse your trading success or fine tune your strategy
-Can be use it on Horse/Greyhound Racing markets (or probably football,tennis too).
-Refresh rate = 1 row data, how fast you can make is depending on your computer speed and software setup. Usually 500-1000ms / row is easily achievable!
-No VBA programming skill needed from you, the spreadsheet does all the work for you!
-Easy to create your advanced trading strategy/algorithm! You can trigger Back bets, Lay bets, Green all commands, Cancel all commands with algorithm signals (excel formulas). e.g. MACD, RSI, MFI, Candlesticks, Moving Averages, ADX, other custom conditions or strategies, unlimited possibilities;
-Built-in Odds to Tick converter: can be essential for specific strategies (tick is an integer number 1-350, each number represents an odds value)
-Fully adjustable bet properties: offset; green offset; stop loss; place stop; fill kill delay; stake with built-in liability stake calculator, above-below X tick.
-Adjustable 31 Data listing places are more than enough to create any algorithm
-3 phase time based pre market green all system built in for extra safe trade closing
-Auto Stop Green/Red function if Market Profit/Loss <= or >= X (Auto Stop Win/Loss)
-Previous race result indicator: you can change stakes or strategy based on the last race result
-Working example strategy provided (not for profit) to help you understand how to create your own strategy.
-You can create advanced live excel charts to help your manual trade as well
-Provided with cell comments and notes (you can hide the comments)
-Bug support via email

Here is an example setup on Bet Angel for all day work:

1. Set Bet Angel refresh rate to 1 sec or lower (according to your needs)
2. Load up all the horse racing markets into Guardian: first tab “Markets” and click “Add”
3. Set Guardian to auto switch to the next market at 300 sec (you can change this according to your needs). First tab “Markets”.
4. Set Guardian to Auto-Bind Bet Angel Sheets. Second tab: “Excel”.
5. Set Guardian to Auto-Clear Bindings. Second tab: “Excel”.
6. Set Guardian to Restrict Refresh Rate: 590 sec (up) and 30 sec (down) (you can change this according to your needs). “Advanced Settings” tab
7. Go to Guardian’s “Excel” tab and browse your excel file and click open workbook and tick ‘connect’

Use Bet Angel in practice mode at first until you know exactly what you do!

Many videos here: https://www.youtube.com/channel/UCmLaWh ... 4OA/videos

You can download and try a free trial version with limited abilities. And if you like it you can get the full version by supporting my work:

Website: http://excelbettingbots.com/

On this website you can find a stable Advanced Data Recorder Bot which can record the last 10-15 minutes of every race in a day fully automatically. And a free Football Visualisation spreadsheet.

Thank you and enjoy!
Last edited by probro on Fri Jun 16, 2017 1:35 pm, edited 24 times in total.
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

The bot has been updated to v2, it can work on in-running markets now, I tested with 350ms data per excel row so it is quite fast.

also a new youtube video available: https://www.youtube.com/watch?v=UIvnTd_hCJI

It show how RSI strategy triggers LAY bets by excel signals.
8ball030
Posts: 5
Joined: Wed Nov 18, 2015 7:27 am

Hi Probro,

Thanks for this, its absolutely perfect for my needs.

Its appreciated that you shared :)

8Ball
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

Hi 8ball030!
Thanks!

New v3 version available!

+ 2 Runner data added
Queue 1 Lay and Back data available on the first 2 runner (can be useful for scalpers)
You can turn OFF the unnecessary runners (faster excel sheet)
Result option: simply you can see all your results at the end of the day
minor bugs fixed

video about how result listing works: https://youtu.be/RdL1ceT_b6c
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

see how to make a MACD indicator for excel bot: https://www.youtube.com/watch?v=gG5IQgG_yAw
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

New version 4 is out! also in trial version: http://bit.ly/1NBK9S6

watch youtube here: https://youtu.be/bxltKnKcyTg
convoysur-2
Posts: 1110
Joined: Thu Jan 12, 2012 10:00 am

this is great work,,thank you very much for posting
Marc
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

Excel Bot updated to v5: http://excelbettingbots.com/

-Improved result listing system: help you to analyse your all day trade algorithm’s results more deeply
- Improved race type indicator. Now you can filter your trades easily with the main type of races: Beg, Claim, Cond, Grp1, Grp2, Grp3, Hunt, Listed, Mdn, NHF, INHF, Nov, Nursery, Sell
- minor bugs fixed and improved:(result system, green system, fixed tick conversion formula etc.)

New video, How to trigger bets using Candlestick Patterns in excel for betfair trade. And how to change candlestick interval properly: https://www.youtube.com/watch?v=eiEa2O8o_mU

Now you can easily trigger bets for specific candlestick patterns and/or combine it with other strategies, the possibilities are unlimited!

Also check out and download the free example indicators: http://excelbettingbots.com/download-ex ... ndicators/
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

New advanced Data Recorder Bot available!

Very clean and fast product!

http://excelbettingbots.com/advanced-data-recorder-bot/

youtube video here: https://www.youtube.com/watch?v=llp4x5yeX9s
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

the auto trading excel sheet updated to v5.2

and new video here: https://www.youtube.com/watch?v=eYgHmt2d-eo

bugs cleaned!
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

New Betting Bot v6 available!

with New: built-in Race type filtering system


video: https://www.youtube.com/watch?v=um8nRjjnaKE

Picture about the system here:
http://excelbettingbots.com/wp-content/ ... g-bot1.png
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

New Advanced Recording bot v1.5 update available

new video here: https://www.youtube.com/watch?v=TWxf0Ee_xBo
PeterLe
Posts: 3715
Joined: Wed Apr 15, 2009 3:19 pm

I just checked out the YouTube video.
I can see that the spreadsheet tracks/records the market vol. Is it possible to select an individual selection and track its volume in isolation?
Thanks
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

Hi,

Of course, 1-6 runners has Runner Volume data next to their Last Traded Price. You can make a simple formula in the sheet so you can get the exact traded amount for every traded price individually. Here is a photo about the data: http://excelbettingbots.com/wp-content/ ... 3-pic4.png

Here you can download a volume by price indicator, which you can build it into anything which has a Runner Volume and LTP data: http://excelbettingbots.com/download-ex ... ndicators/
Last edited by probro on Tue Jan 12, 2016 11:36 pm, edited 1 time in total.
PeterLe
Posts: 3715
Joined: Wed Apr 15, 2009 3:19 pm

Of Course Yes - Thanks for the reply
Looks good!
Post Reply

Return to “Bet Angel - Example spreadsheets”