General Excel Question Re Betfair SP Data

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
iambic_pentameter
Posts: 443
Joined: Wed May 18, 2016 1:24 pm

I download the Betfair SP data each morning and wondered if it is possible to sort in a certain way?

Currently, I just sort by the selection name and manually check to see which selections have traded lower, but I didn't know if anyone has a method where I can get excel to sort by horses that have a in running low that is 30% lower than their BSP.

Many thanks,

Iambic
User avatar
northbound
Posts: 737
Joined: Mon Mar 20, 2017 11:22 pm

Betfair SP CSV files contain two columns called BSP (column H) and IPMIN (column N).

You can simply use the first empty column (column R) and add a formula to each row. On row 2, the formula would look like:
=N2/H2

Then give a name to column R, call it for example IPRATIO.

Then filter in only rows that have IPRATIO Less Than Or Equal To 0.70.

For example it would filter in horses with a BSP of 100 and IPMIN of 70 or lower (which means IPMIN was at least 30% lower than BSP ... 100-30 = 70).
iambic_pentameter
Posts: 443
Joined: Wed May 18, 2016 1:24 pm

Northbound,

Many thanks for the answer and a crate of a beer of your choice is winging its way to Northbound Towers!

Cheers,

Iambic
User avatar
northbound
Posts: 737
Joined: Mon Mar 20, 2017 11:22 pm

iambic_pentameter wrote:
Fri Sep 07, 2018 10:47 am
Many thanks for the answer and a crate of a beer of your choice is winging its way to Northbound Towers!
:)
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”