is there a formula to do this?
sorry for my english!
Daniele
How to count BF ticks movement in Excel??
There are 351 odds increments in Betfair from 1.01 to 1000. Create a list of these odds on a spreadsheet then label them 1-351. Do a vlookup on the value of the odds and cross reference it to it's place in the tick list. Should be a five minute job.
- Willygubbins
- Posts: 109
- Joined: Wed Nov 23, 2016 6:03 pm
Nigel, that is great one question.......and it is more for my OCD.
Is there a way to get rid of the #N/A when there is no value in there?
Thanks
You do not have the required permissions to view the files attached to this post.
Does this help ?
https://exceljet.net/formula/vlookup-without-na-error
https://exceljet.net/formula/vlookup-without-na-error
- Willygubbins
- Posts: 109
- Joined: Wed Nov 23, 2016 6:03 pm
Thanks thats perfect.Abraquay wrote: ↑Tue Jun 27, 2017 3:51 pmDoes this help ?
https://exceljet.net/formula/vlookup-without-na-error
I used =IFERROR(MATCH(AQ4,BE:BE,0)-MATCH(AR4,BE:BE,0),"-")
You do not have the required permissions to view the files attached to this post.
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
If you're ok with VBA there's a few functions in this thread to set and find your odds using ticks
http://www.betangel.com/forum/viewtopic ... 19&t=13770
http://www.betangel.com/forum/viewtopic ... 19&t=13770
-
- Posts: 41
- Joined: Mon Sep 04, 2017 7:27 pm
Thats great thanks for putting that up.
Do you know or have a formula so you could put in say a £10 stake and then it tell you the profit you could of made between the sp and the in play low going off the tick reduction?