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: 2883
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: 2883
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

Re: Recording change in price on Excel

Postby CharlieGB74 » Tue Feb 16, 2021 6:36 pm

Captain Sensible wrote: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),"")


Hello Captain!

I tried using this formula, but it doesn´t freeze the odds, it displays them after the minute and keeps changing them as time passes.

How could I freeze the price display for example at 5 minutes, 3 minutes, 1 minute, etc??

Thank you for all your help!

Charlie.
CharlieGB74
 
Posts: 2
Joined: Sun Oct 29, 2017 3:34 pm

Re: Recording change in price on Excel

Postby CharlieGB74 » Tue Feb 16, 2021 6:47 pm

Got it to work!

I wasn´t using the same AA5 Cell.

This will help me a lot!!!

Thanks again!
CharlieGB74
 
Posts: 2
Joined: Sun Oct 29, 2017 3:34 pm

Re: Recording change in price on Excel

Postby red_corfe » Sat Mar 13, 2021 12:30 pm

Hi,

Can someone help, I have allocated this to AA5, but am not getting the "last price" recorded. I've checked and checked but what am doing wrong !


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


Cheers
red_corfe
 
Posts: 2
Joined: Sat Mar 13, 2021 12:14 pm

Re: Recording change in price on Excel

Postby Deestar » Sat Mar 13, 2021 12:57 pm

Have you enabled Iterative calculation in excel?
Deestar
 
Posts: 262
Joined: Sun Apr 26, 2015 8:17 am

Re: Recording change in price on Excel

Postby red_corfe » Sat Mar 13, 2021 2:02 pm

Errrrrrrrrrrr No :oops:

Many thanks Deestar
red_corfe
 
Posts: 2
Joined: Sat Mar 13, 2021 12:14 pm


Return to Discussion

Who is online

Users browsing this forum: No registered users and 12 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.