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
Placing 2 bets using excel
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.
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.