Customizable Fully Auto Trading Spreadsheet Bot Available

Find a developer for your Excel triggered betting needs and advertise your development service here.

Moderator: 2020vision

Re: Customizable Fully Auto Trading Spreadsheet Bot Availabl

Postby probro » Fri Oct 27, 2017 3:32 am

xraymitch wrote:It would be great if you could post a video of the spreadsheet in action with real money using one of your strategies. Seeing it in action would save you thousands of words of explananation...lol

Using the free trial I am at a loss to understand what strategy is being used (might it be RSI...?)

Thanks again. 8)



Yes, the example strategy using only RSI with some other conditions(odds, countdown...).

Here is video with real money:
https://youtu.be/P7Hi_JGItEQ
probro
 
Posts: 12
Joined: Fri Jul 25, 2014 1:35 am

Re: Customizable Fully Auto Trading Spreadsheet Bot Availabl

Postby mandarin » Fri Oct 27, 2017 10:41 am

xraymitch wrote:Hi,

I am still trying to get my head around the trial sheet - shame that you cannot use the ladder.

Did you place the backs and lays as per RSI trigger already setup ? Or did you create your own trigger ?

As to
can you automatically clear the database at the end of a race prior to going onto the next race?


I would expect it to be cleared but hopefully you will get an answer shortly.

8)

Yes I did use the RSI strat just to test if it was backing and laying correctly. I had to manually clear the data from previous race as it gave an erroneous signal using the old data. Seemed to work fine although on one occasion it fired in the same back bet twice. Not sure why. Perhaps I will get into it more next week as this week was pretty hectic with family.
mandarin
 
Posts: 3
Joined: Tue Oct 21, 2014 3:25 pm

Re: Customizable Fully Auto Trading Spreadsheet Bot Availabl

Postby xraymitch » Tue Nov 07, 2017 8:28 am

I ran the trial version with real money staking £20 as fixed liability in Cell CV6. Not clear how the stakes are calculated though.

Odds Me Actual
5.90 £4.08 £4.00
6.00 £4.00 £3.80
6.20 £3.85 £3.70
6.40 £3.70 £3.80
6.80 £3.45 £3.60
7.60 £3.03 £3.10

You will see in the screenshot that bets were placed by the bot which I stopped running 3 minutes before the off as the price on Lady Of The Lamp was drifting big time so I cancelled the lays with the intention of getting out in running. Can someone explain the thinking behind RSI (Relative Strength Index) as so far I have no idea.
Attachments
Betting Assistant_2017-11-03_17-42-01.png
Betting Assistant_2017-11-03_17-42-01.png (142.04 KiB) Viewed 158 times
xraymitch
 
Posts: 335
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Customizable Fully Auto Trading Spreadsheet Bot Availabl

Postby xraymitch » Tue Nov 07, 2017 8:32 am

You can see in the screenshot below that I got lucky and Lady Of The Lamp stormed home.
Attachments
Betting Assistant_2017-11-03_17-46-53.png
Betting Assistant_2017-11-03_17-46-53.png (133.07 KiB) Viewed 158 times
xraymitch
 
Posts: 335
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Customizable Fully Auto Trading Spreadsheet Bot Availabl

Postby xraymitch » Tue Nov 07, 2017 8:56 am

If I wanted to use the same RSI strategy on the first 2 runners it seems to me I have to insert extra columns containing the formulas for calculating the LTP R2 runner.

Am I wrong in thinking that if you want to create triggers for more than one selection irrespective of the strategy in use you will always have to insert columns for each selection?
Attachments
EXCEL_2017-11-07_06-55-16.png
EXCEL_2017-11-07_06-55-16.png (131.83 KiB) Viewed 158 times
xraymitch
 
Posts: 335
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Re: Customizable Fully Auto Trading Spreadsheet Bot Availabl

Postby probro » Tue Nov 07, 2017 11:43 am

xraymitch wrote:I ran the trial version with real money staking £20 as fixed liability in Cell CV6. Not clear how the stakes are calculated though.

Odds Me Actual
5.90 £4.08 £4.00
6.00 £4.00 £3.80
6.20 £3.85 £3.70
6.40 £3.70 £3.80
6.80 £3.45 £3.60
7.60 £3.03 £3.10

You will see in the screenshot that bets were placed by the bot which I stopped running 3 minutes before the off as the price on Lady Of The Lamp was drifting big time so I cancelled the lays with the intention of getting out in running. Can someone explain the thinking behind RSI (Relative Strength Index) as so far I have no idea.


The stakes are calculated as liability: your stake/(odds-1) according to the actual back or lay odds. RSI is a relative strength index, It helps you decide if the market is overbought or oversold. But it is just a simple example strategy. You can build any strategy there, just need some excel skills.
probro
 
Posts: 12
Joined: Fri Jul 25, 2014 1:35 am

Re: Customizable Fully Auto Trading Spreadsheet Bot Availabl

Postby probro » Tue Nov 07, 2017 11:47 am

xraymitch wrote:If I wanted to use the same RSI strategy on the first 2 runners it seems to me I have to insert extra columns containing the formulas for calculating the LTP R2 runner.

Am I wrong in thinking that if you want to create triggers for more than one selection irrespective of the strategy in use you will always have to insert columns for each selection?


Yes, you need to build up new columns for make it work on additional runners. Here are some basic tutorials how you can do it:
http://excelbettingbots.com/tutorials/

But free trial only works on one runner and it doesn't clear itself when jumps to the next market, only the full version do it! Full version can trigger bets for the first 6 runners.
probro
 
Posts: 12
Joined: Fri Jul 25, 2014 1:35 am

Previous

Return to Find an Excel developer

Who is online

Users browsing this forum: No registered users and 1 guest

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.