Recording change in price on Excel

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

Recording change in price on Excel

Postby roykeane1694 » Thu Sep 21, 2017 11:11 am

Hi all,

Just wondering if anyone has had any experience in calculating the change in price through the Excel sheet.

e.g. Record price at 1 min before the start of the race, record price 15 seconds before the start of the race and calculate a percentage change figure based on those.

Anyone have any ideas as to how to do this or if it is even possible?
roykeane1694
 
Posts: 2
Joined: Thu Sep 21, 2017 11:08 am

Re: Recording change in price on Excel

Postby Captain Sensible » Thu Sep 21, 2017 9:25 pm

There are plenty of ways to do it with VBA and a few posts across the forum showing sample code but if you prefer to use formulas you can do it that way too. Someone recently posted a link to this thread that shows how to use circlular references with excel to freeze the prices

This formula in AA5 downwards shuld freeze your 1 minute last matched price

=IF(OR($D$2<TIMEVALUE("00:01:00"),ISTEXT($D$2)),IF(AA5="",O5,AA5),"")

and this in AB5 down freeze the 15 second lasr matched price

=IF(OR($D$2<TIMEVALUE("00:00:15"),ISTEXT($D$2)),IF(AB5="",O5,AB5),"")

Then use those to calculate your percentage change. Remember for circular refernces to work you need to go to Files->Options->formulas and enable Iterative calculation in excel.
User avatar
Captain Sensible
 
Posts: 2163
Joined: Sat Nov 19, 2005 2:29 pm

Re: Recording change in price on Excel

Postby Captain Sensible » Thu Sep 21, 2017 9:34 pm

Just tested the formulas on the dogs to check they work and noticed they should be

=IF(OR($D$2<=TIMEVALUE("00:01:00"),ISTEXT($D$2)),IF(AA5="",O5,AA5),"")

and

=IF(OR($D$2<=TIMEVALUE("00:00:15"),ISTEXT($D$2)),IF(AB5="",O5,AB5),"")
User avatar
Captain Sensible
 
Posts: 2163
Joined: Sat Nov 19, 2005 2:29 pm

Re: Recording change in price on Excel

Postby roykeane1694 » Wed Sep 27, 2017 3:07 am

Thanks for that, has been of great assistance
roykeane1694
 
Posts: 2
Joined: Thu Sep 21, 2017 11:08 am


Return to Discussion

Who is online

Users browsing this forum: No registered users and 7 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.

cron