Excel blowing my mind

A place to discuss anything.
sionascaig
Posts: 1053
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: 1053
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: 1053
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”