How to count BF ticks movement in Excel??

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
tausen
Posts: 22
Joined: Thu Jun 03, 2010 9:08 am
Location: Italy

is there a formula to do this?
sorry for my english!

Daniele
tausen
Posts: 22
Joined: Thu Jun 03, 2010 9:08 am
Location: Italy

is it possible? Nobody can help me?
Hope you understand what i'd like to do.
5,5 to 1,72 how many ticks? in an excel formula

thanks
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

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.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

There are several ways of doing this, you could also use a 'Match' formula.
Tick Movement Count.xls
You do not have the required permissions to view the files attached to this post.
tausen
Posts: 22
Joined: Thu Jun 03, 2010 9:08 am
Location: Italy

thank you guys!
Really helpful!
User avatar
Willygubbins
Posts: 109
Joined: Wed Nov 23, 2016 6:03 pm

nigelk wrote:
Mon Jul 19, 2010 12:08 pm
There are several ways of doing this, you could also use a 'Match' formula.Tick Movement Count.xls
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
2017-06-27_1550.png
You do not have the required permissions to view the files attached to this post.
User avatar
Willygubbins
Posts: 109
Joined: Wed Nov 23, 2016 6:03 pm

Abraquay wrote:
Tue Jun 27, 2017 3:51 pm
Does this help ?
https://exceljet.net/formula/vlookup-without-na-error
Thanks thats perfect.

I used =IFERROR(MATCH(AQ4,BE:BE,0)-MATCH(AR4,BE:BE,0),"-")
2017-06-27_1609.png
You do not have the required permissions to view the files attached to this post.
spreadbetting
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
rostov
Posts: 50
Joined: Mon Jul 02, 2012 3:45 pm

SpreadBetting, that's the dogs' hangers. Nice one.
iangrant230
Posts: 41
Joined: Mon Sep 04, 2017 7:27 pm

nigelk wrote:
Mon Jul 19, 2010 12:08 pm
There are several ways of doing this, you could also use a 'Match' formula.Tick Movement Count.xls

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?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”