Hi. I'm trying to automate a strategy obviously.
I want to back/lay a horse or dog, say 3 seconds before the off and I want my stake to be placed at an amount relative to the best market price.
Eg.
If the back price is 2.75, I want to stake £2.75
If the back price is 3.75, I want to stake £3.75
If the back price is 4.80, I want to stake £4.80
If the back price is 5.00, I want to stake £5.00
etc
OR
If I want to calculate the stake relative to the price say 10%
If the back price is 2.75, I want to stake £0.28
If the back price is 5.00, I want to stake £0.50
If the back price is 3.30, I want to stake £0.33
I can't find the function that allows me to do this in guardian so I'm opting for excel. I've figured that I can enter the formula into stake column(to calculate my stake relative to price as per aove example) in the basic spreadsheet template but how do i get it to trigger at say 3 seconds out from the off, AND AND feckin AND, ONLY TRIGGER ONCE?
Also when preparing guardian is there a quick way to assign my spreadsheet to all markets as if was 'applying rules to all markets'?
Excel blowing my mind
-
- Posts: 1072
- Joined: Fri Nov 20, 2015 9:38 am
you can do it without excel
just set a stored value to back price
and set you stake to the stored value or a % of it..
just set a stored value to back price
and set you stake to the stored value or a % of it..
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
In Excel, it will only fire once per runner because "PLACED" appears in the L column, you just need a macro to delete this cell when each new market loads.
Put your stake calculation inside of an if statement that checks if the time is <= 3 seconds.
For example, in Cell O9:
If(F4<=0.00003472,[Your Calculation],"")
F4 is the countdown cell, if you type 00:00:03 in there and then change the cell from a TIME format to NUMBER, you'll see that's where I got that number from. Adjust accordingly.
Put your stake calculation inside of an if statement that checks if the time is <= 3 seconds.
For example, in Cell O9:
If(F4<=0.00003472,[Your Calculation],"")
F4 is the countdown cell, if you type 00:00:03 in there and then change the cell from a TIME format to NUMBER, you'll see that's where I got that number from. Adjust accordingly.
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
well now i know both. kind of
thanks so much
thanks so much
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
I was so close with my formulaCallumPerry wrote: ↑Tue Apr 06, 2021 10:12 amIn Excel, it will only fire once per runner because "PLACED" appears in the L column, you just need a macro to delete this cell when each new market loads.
Put your stake calculation inside of an if statement that checks if the time is <= 3 seconds.
For example, in Cell O9:
If(F4<=0.00003472,[Your Calculation],"")
F4 is the countdown cell, if you type 00:00:03 in there and then change the cell from a TIME format to NUMBER, you'll see that's where I got that number from. Adjust accordingly.
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
EH, nope, still not getting it.JAMESGLYNN67 wrote: ↑Tue Apr 06, 2021 10:24 amI was so close with my formulaCallumPerry wrote: ↑Tue Apr 06, 2021 10:12 amIn Excel, it will only fire once per runner because "PLACED" appears in the L column, you just need a macro to delete this cell when each new market loads.
Put your stake calculation inside of an if statement that checks if the time is <= 3 seconds.
For example, in Cell O9:
If(F4<=0.00003472,[Your Calculation],"")
F4 is the countdown cell, if you type 00:00:03 in there and then change the cell from a TIME format to NUMBER, you'll see that's where I got that number from. Adjust accordingly.
Cell 09: =If(F4<=0.00003472,[N9=G9/10],"") I know this is not correct. Excel tells me so
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
Thanks Gianni
I'm getting an ERROR message in the global status when i input Cell 09 as per above. I copied and pasted it
I put 'BACK' into L9
what i'm trying to set up is a back bet , 3 seconds out , stakes calculated at the time relative to the odds.
thanks again
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
.....the ERROR message in the GLOBAL STATUS cell is because its out with the timeframe and no action to be taken. Maybe?
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
My bad, somebody pointed it earlier too I saw, just remove the []. Sorry for confusing you. Make sure L9 = BACK and M9 = one of the odds. K9 is the last traded price so M9 = K9 for example and then your stake = If(F4<=0.00003472,N9=G9/10,"").JAMESGLYNN67 wrote: ↑Tue Apr 06, 2021 10:53 amEH, nope, still not getting it.JAMESGLYNN67 wrote: ↑Tue Apr 06, 2021 10:24 amI was so close with my formulaCallumPerry wrote: ↑Tue Apr 06, 2021 10:12 amIn Excel, it will only fire once per runner because "PLACED" appears in the L column, you just need a macro to delete this cell when each new market loads.
Put your stake calculation inside of an if statement that checks if the time is <= 3 seconds.
For example, in Cell O9:
If(F4<=0.00003472,[Your Calculation],"")
F4 is the countdown cell, if you type 00:00:03 in there and then change the cell from a TIME format to NUMBER, you'll see that's where I got that number from. Adjust accordingly.
Cell 09: =If(F4<=0.00003472,[N9=G9/10],"") I know this is not correct. Excel tells me so
I just had to double check my cell references with the template workbook, the stake formula should go into cell N9, not O9. O9 is where the status message appears from Bet Angel once a bet has been confirmed.
Global commands runs separate so if you're getting an error there, you have a problem elsewhere. As long as cell L9 = Back, M9 = odds, N9 = formula, you should be fine.
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
So i think Ive progressed here.
If i use the multi-sheet template will I have to copy and paste the above formula to all the sheets or will they populate from the first one?
Can I delete all the extra sheets and then duplicate the first one as many times as i want?
AND, if I use the switesh multi sheet template will all the data collection magic still work as set up?
If i use the multi-sheet template will I have to copy and paste the above formula to all the sheets or will they populate from the first one?
Can I delete all the extra sheets and then duplicate the first one as many times as i want?
AND, if I use the switesh multi sheet template will all the data collection magic still work as set up?
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
I dont really have any idea what the magic is but betting itll look cool on my laptopJAMESGLYNN67 wrote: ↑Wed Apr 07, 2021 5:42 pmSo i think Ive progressed here.
If i use the multi-sheet template will I have to copy and paste the above formula to all the sheets or will they populate from the first one?
Can I delete all the extra sheets and then duplicate the first one as many times as i want?
AND, if I use the switesh multi sheet template will all the data collection magic still work as set up?
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
Not looked at the swiftest multi sheet for ages so couldn't tell you but yes, create a master sheet with all of your formulae in first and then once you copy the sheet, it should copy all of the contents also for you to use on multiple markets.JAMESGLYNN67 wrote: ↑Wed Apr 07, 2021 5:42 pmSo i think Ive progressed here.
If i use the multi-sheet template will I have to copy and paste the above formula to all the sheets or will they populate from the first one?
Can I delete all the extra sheets and then duplicate the first one as many times as i want?
AND, if I use the switesh multi sheet template will all the data collection magic still work as set up?