Placing 2 bets using excel

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
parbynat
Posts: 65
Joined: Thu May 10, 2018 5:25 pm

How would I do this?
I'm trying to place 2 back bets, 1 at 5 ticks above best market price which happens to be odds of 3.0 and the other bet a further 20 ticks higher at the other crossover price of 4.0.
Both bets to be placed with a stake of £5.
Hopefully all this can be written without using the odds and stake cells.
Thanks
Parbynat
parbynat
Posts: 65
Joined: Thu May 10, 2018 5:25 pm

Probably should have posted in the newbies section or a section named still a plonker after 6 months.
I got it now. :oops:
Anbell
Posts: 2007
Joined: Fri Apr 05, 2019 2:31 am

Hi - did you solve this? I'm also looking to do this.
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

probably better to do this using standard automation but if you want to do it with excel:

first you need yourself an index of prices, ie
1.01
1.02
.
.
5.1
.
.
5.2
.
.
1000

so that you can index/match to your desired price.
then it's a matter of if statements in your formulae. for example, if (unmatched volume + matched volume) is less than desired total amount, then if (unmatched + matched) < 5 then place at x ticks higher, else if (unmatched + matched) < 10 then place at x + y ticks higher. I think that would more or less suit what you're after with some additions etc. Good luck.
Anbell
Posts: 2007
Joined: Fri Apr 05, 2019 2:31 am

Appreciate it. Thanks
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”