Countdown Timer

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
wellfkmepink
Posts: 2
Joined: Fri Nov 12, 2010 1:55 pm

I am using the Betdaq version of BetAngel and am attempting to write a macro for myself.

I cannot find the countdown timer incorporated in the excel sheet. Is it there or is there a handy piece of code that I can use to incorporate it into my spreadsheet.

Basically I don't want to enter the market until 30 minutes before the off and want to exit just before the scheduled off.
User avatar
TheTub
Posts: 267
Joined: Thu Mar 26, 2009 7:53 pm
Location: Nottinghamshire

I did this by stripping out the time from the event name then formatting the result as 'time'. Then subtract the current time from this and you get the value you are after.
wellfkmepink
Posts: 2
Joined: Fri Nov 12, 2010 1:55 pm

Cheers,

That's what I ended up doing alright.

If anyone knows of, or has an idea of, another way that would take into account when races are delayed I would appreciate a nudge or some suggestions.(Probably a step too far!)

Thanks for the reply.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”