Excel blowing my mind

A place to discuss anything.
JAMESGLYNN67
Posts: 25
Joined: Wed Aug 22, 2018 6:40 pm

I cant get guardian to auto-bind to any more than 6 sheets
rik
Posts: 1583
Joined: Sat Jan 25, 2014 5:16 am
Location: London

Whats the logic behind staking higher for higher odds, wouldnt you want to even out your payout/winnings?
Most people would stake higher the lower the odds
JAMESGLYNN67
Posts: 25
Joined: Wed Aug 22, 2018 6:40 pm

I would love to say I've been data mining but I think I've been copying and pasting loads. Last week I downloaded a months worth of dog placed markets by mistake and put my formula into the spreadsheet and my account emptied rapidly (practice mode), and steadily, almost in a perfect sequence, so reversed the formla to BACK on place markets, I had the 2 columns side by side, highlighted them and then pressed a button on excel that looked like it might draw a graph. I reckon i need £1k to start as cant the small stake to agree with betfair.

Not sure this will help help anyone understand anything as I'm struggling myself. I remember being proud of a mail merge i did 20 years ago. my laptop is mainly for youtube netflix etc
JAMESGLYNN67
Posts: 25
Joined: Wed Aug 22, 2018 6:40 pm

rik wrote:
Wed Apr 07, 2021 11:57 pm
Whats the logic behind staking higher for higher odds, wouldnt you want to even out your payout/winnings?
Most people would stake higher the lower the odds
just remembered a time when manual betting on BA bookmaking page, wheni wonderd if the staking could be reversed?
JAMESGLYNN67
Posts: 25
Joined: Wed Aug 22, 2018 6:40 pm

sionascaig wrote:
Mon Apr 05, 2021 4:50 pm
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..
Hi sionascaig

I'm now trying to get my head around the stored values and admit freely that I'm clueless.

Can you help me out. I want BA to place a BACK bet at the best market price, 3 seconds before start. The stake has to be the 10% of the price
sionascaig
Posts: 1055
Joined: Fri Nov 20, 2015 9:38 am

JAMESGLYNN67 wrote:
Thu Apr 08, 2021 7:31 pm
sionascaig wrote:
Mon Apr 05, 2021 4:50 pm
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..
Hi sionascaig

I'm now trying to get my head around the stored values and admit freely that I'm clueless.

Can you help me out. I want BA to place a BACK bet at the best market price, 3 seconds before start. The stake has to be the 10% of the price
Hi James, I sent you a PM... If its unclear then just let me know & I'll post some pics in this thread..
sionascaig
Posts: 1055
Joined: Fri Nov 20, 2015 9:38 am

Example baf attached...

1st rule collects Back Price data & puts in a SV
2nd rule uses SV & places a Back Bet of 10% Back Price @ Back Price

Note: the SV rule is set to "always armed", runs every refresh & prints to log - you dont need this (and will swamp your log with data but left in so you can test)...
You do not have the required permissions to view the files attached to this post.
JAMESGLYNN67
Posts: 25
Joined: Wed Aug 22, 2018 6:40 pm

Thanks Jim

Thanks a lot

Practice mode here I come

James
JAMESGLYNN67
Posts: 25
Joined: Wed Aug 22, 2018 6:40 pm

sionascaig wrote:
Fri Apr 09, 2021 6:25 pm
Example baf attached...

1st rule collects Back Price data & puts in a SV
2nd rule uses SV & places a Back Bet of 10% Back Price @ Back Price

Note: the SV rule is set to "always armed", runs every refresh & prints to log - you dont need this (and will swamp your log with data but left in so you can test)...

See what you mean about the log data. 17 pages, 300 lines a page. Is that the refresh rate in action I'm seeing? I only really need value just before off so thats just amending from ALWAYS ARMED, to a time closer to the off but outwith my BACK time yeah?
sionascaig
Posts: 1055
Joined: Fri Nov 20, 2015 9:38 am

JAMESGLYNN67 wrote:
Fri Apr 09, 2021 7:13 pm
sionascaig wrote:
Fri Apr 09, 2021 6:25 pm
Example baf attached...

1st rule collects Back Price data & puts in a SV
2nd rule uses SV & places a Back Bet of 10% Back Price @ Back Price

Note: the SV rule is set to "always armed", runs every refresh & prints to log - you dont need this (and will swamp your log with data but left in so you can test)...

See what you mean about the log data. 17 pages, 300 lines a page. Is that the refresh rate in action I'm seeing? I only really need value just before off so thats just amending from ALWAYS ARMED, to a time closer to the off but outwith my BACK time yeah?
yup - and untick the box that writes the SV to the log...
JAMESGLYNN67
Posts: 25
Joined: Wed Aug 22, 2018 6:40 pm

wiil do.

will it still log the matched bets?
final stored vales be the bsp? just a thought
Post Reply

Return to “General discussion”