Excel Spreadsheets

We were all new to Bet Angel once. Ask any question you like here and fellow forum members promise not to laugh. Betfair trading made simple.
Post Reply
Mav33
Posts: 1
Joined: Tue Jan 17, 2012 6:39 pm

Would someone be able to tell me how you work out what a particular Bet Angel fields Excel cell reference is for when I'm writtening my Excel "IF" statements, for instance "H1" or "G9"

Thanks Mav33
User avatar
Shamrock
Posts: 205
Joined: Thu Sep 30, 2010 11:41 am

Hi Mav33,
I’m not sure what you are asking so I hope this is right.
In excel all the columns have a letter assigned to them across the top. The sixth column across is column G.
Each or the rows from top to bottom have a number attached on the left, the ninth row down is 9.
Where the column and row intersect is the reference, sixth column across (column G) and the ninth row down (row 9) is G9. G9 is the current back price of the top selection.
H11 would be the lay price of the second selection.
I hope this is what you’re looking for.
Post Reply

Return to “Bet Angel for newbies / Getting started”