why don't you try adding a % increase to the original odds at G9.
something like =if(G9+10%)(you fill in the rest) then it will dynamically do what you want
Excel odds update query
Yeah but I'm not sure how that achieves what I mean. Even as my odds change with a formula like that, they won't update in betfair unless I remove the STATUS information, as far as I can see, and if I do that it'll place a new bet, meaning I have two lays.MemphisFlash wrote: ↑Mon Apr 02, 2018 10:28 pmwhy don't you try adding a % increase to the original odds at G9.
something like =if(G9+10%)(you fill in the rest) then it will dynamically do what you want
What I am hoping is there is a function which will continually update the price I am offering as the ODDS figure changes on my spreadsheet.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
One thing you could do would be to check the price every x seconds and cancel /place a new bet if the price has changed. You'll need some vba to achieve that. If you move it every time the price changes you might run into transaction charges, you'd certainly risk timing issues like trying to cancel bets before they'd been recognised by BF.
I'm not 100% sure what you plan to do but I may have done something similar just using Guardian.
First it checked the market vol and time since last unsuspend.
If OK it placed an order n ticks away from current.
Every n seconds it checked the price.
If the market had moved away, the order was immediately cancelled and repositioned closer, but keeping its preset distance.
If the price moved towards my order it started a timer and after n seconds would it cancel then repositioned the order.
I needed it to tolerate some stepping towards my order otherwise it rarely got filled but I wanted to maintain a maximum distance.
If the order was taken it would green up after n seconds, do a check point reset, and start all over again.
Extra green up before the off to be safe as std.
It was a crude spike catcher but I found it didn't yield enough to have one of my BF accounts tied up (and a 2nd BA subscription) so it was shelved. It also only worked one side but the newish BA price dependant cancel feature might mean that I'll revisit it and do both sides.....but probably not.
It's surprising what you can do with Guardian signals.
I'm not 100% sure what you plan to do but I may have done something similar just using Guardian.
First it checked the market vol and time since last unsuspend.
If OK it placed an order n ticks away from current.
Every n seconds it checked the price.
If the market had moved away, the order was immediately cancelled and repositioned closer, but keeping its preset distance.
If the price moved towards my order it started a timer and after n seconds would it cancel then repositioned the order.
I needed it to tolerate some stepping towards my order otherwise it rarely got filled but I wanted to maintain a maximum distance.
If the order was taken it would green up after n seconds, do a check point reset, and start all over again.
Extra green up before the off to be safe as std.
It was a crude spike catcher but I found it didn't yield enough to have one of my BF accounts tied up (and a 2nd BA subscription) so it was shelved. It also only worked one side but the newish BA price dependant cancel feature might mean that I'll revisit it and do both sides.....but probably not.
It's surprising what you can do with Guardian signals.
OK, yes, thanks for that.ShaunWhite wrote: ↑Tue Apr 03, 2018 2:26 amOne thing you could do would be to check the price every x seconds and cancel /place a new bet if the price has changed. You'll need some vba to achieve that. If you move it every time the price changes you might run into transaction charges, you'd certainly risk timing issues like trying to cancel bets before they'd been recognised by BF.
I'm not 100% sure what you plan to do but I may have done something similar just using Guardian.
First it checked the market vol and time since last unsuspend.
If OK it placed an order n ticks away from current.
Every n seconds it checked the price.
If the market had moved away, the order was immediately cancelled and repositioned closer, but keeping its preset distance.
If the price moved towards my order it started a timer and after n seconds would it cancel then repositioned the order.
I needed it to tolerate some stepping towards my order otherwise it rarely got filled but I wanted to maintain a maximum distance.
If the order was taken it would green up after n seconds, do a check point reset, and start all over again.
Extra green up before the off to be safe as std.
It was a crude spike catcher but I found it didn't yield enough to have one of my BF accounts tied up (and a 2nd BA subscription) so it was shelved. It also only worked one side but the newish BA price dependant cancel feature might mean that I'll revisit it and do both sides.....but probably not.
It's surprising what you can do with Guardian signals.
I haven't read the manual on the Guardian features as yet, I have to get to that part. I'll continue reading and see if there's options there.
You're right about the multiple / too frequent transactions though, in fact I'd probably only want it to adjust my price offered every 10 seconds or so. In that respect I can write VB code to do it, I was just hoping there was maybe an inbuilt function to do it.
I'll create a sheet to try it out, and see what problems I run into, and in the meantime continue reading about Guardian.
Thanks
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Just watch out for Using Practice Mode Responsibly & Avoid Betfair Restrictions if you're using practice mode to test your stuff.