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!
Fully Auto Adjustable Trading Spreadsheet Bot
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.
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.
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
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
see how to make a MACD indicator for excel bot: https://www.youtube.com/watch?v=gG5IQgG_yAw
New version 4 is out! also in trial version: http://bit.ly/1NBK9S6
watch youtube here: https://youtu.be/bxltKnKcyTg
watch youtube here: https://youtu.be/bxltKnKcyTg
-
- Posts: 1110
- Joined: Thu Jan 12, 2012 10:00 am
this is great work,,thank you very much for posting
Marc
Marc
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/
-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/
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
Very clean and fast product!
http://excelbettingbots.com/advanced-data-recorder-bot/
youtube video here: https://www.youtube.com/watch?v=llp4x5yeX9s
the auto trading excel sheet updated to v5.2
and new video here: https://www.youtube.com/watch?v=eYgHmt2d-eo
bugs cleaned!
and new video here: https://www.youtube.com/watch?v=eYgHmt2d-eo
bugs cleaned!
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
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
New Advanced Recording bot v1.5 update available
new video here: https://www.youtube.com/watch?v=TWxf0Ee_xBo
new video here: https://www.youtube.com/watch?v=TWxf0Ee_xBo
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/
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.