Excel blowing my mind
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
I cant get guardian to auto-bind to any more than 6 sheets
-
- 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
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
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
just remembered a time when manual betting on BA bookmaking page, wheni wonderd if the staking could be reversed?
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
Hi sionascaigsionascaig wrote: ↑Mon Apr 05, 2021 4:50 pmyou 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..
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
-
- Posts: 1055
- Joined: Fri Nov 20, 2015 9:38 am
Hi James, I sent you a PM... If its unclear then just let me know & I'll post some pics in this thread..JAMESGLYNN67 wrote: ↑Thu Apr 08, 2021 7:31 pmHi sionascaigsionascaig wrote: ↑Mon Apr 05, 2021 4:50 pmyou 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..
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
-
- 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)...
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.
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
Thanks Jim
Thanks a lot
Practice mode here I come
James
Thanks a lot
Practice mode here I come
James
-
- Posts: 25
- Joined: Wed Aug 22, 2018 6:40 pm
sionascaig wrote: ↑Fri Apr 09, 2021 6:25 pmExample 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?
-
- Posts: 1055
- Joined: Fri Nov 20, 2015 9:38 am
yup - and untick the box that writes the SV to the log...JAMESGLYNN67 wrote: ↑Fri Apr 09, 2021 7:13 pmsionascaig wrote: ↑Fri Apr 09, 2021 6:25 pmExample 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?
-
- 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
will it still log the matched bets?
final stored vales be the bsp? just a thought