Cell N2

[excelhasey]

Within your Excel spreadsheet cell N2 gives the number of requests made in the last hour, so is this a rolling hour ??

I have my Throttling set at 16 but I notice my N2 figure is 889 (gulp) as you are charged extra by Betair when you reach a 1,000

So what can I do to keep my spreadsheet functioning and avoid paying the extra charges

What effect will dropping my throttling to 1 have ??

In BA options preferences display columns if I switch off (untick) WOM, Back 2, Back 3, Lay 2, Lay 3, Show Silks etc will this reduce my number of requests made, as I assume it is gathering this information every second bouncing back and too from the betfair site receiving this information ??

Any other good suggestions ??

Thanks

[Drunkenight]

Hi Excelhasey,

Cell N2 records the number of transactions you have placed in the last hour. A transaction is placing a bet or changing the status of a bet, like changing the odds. This shouldn't have anything to do with the throttling.

The figure is reset on the hour to zero. If you place more than 1000 transactions in an hour you are likely to start incurring charges from Betfair.

A suggestion would be to have transaction trigger that stops any transactions being placed once you have reached 1000. Then once you reach the next hour the number of transactions will be reset to zero and then your excel program can start placing transactions again.

Hope this helps.

[excelhasey]

Yes I already had a trigger that says N2 has to be lower than 1,000 but I don't want it to be at 1,000 and I miss the crucial bet !!!!

Whilst N2 might reset on the hour its not a true rolling hour figure then ??

If I started betting at 16:40 and got upto 1,000 transactions then N2 resets to zero at 17:00 and I throw in another 500 transactions by 17:20 then that means I have had 1,500 transactions within a rolling hour (well 40 mins) so do Betfair charge me for the 500 transactions above the allowable 1,000 transactions ??

So really without stopping my spreadsheet placing the bets I was wondering if I can chop some fat off this figure somehow ??

[Drunkenight]

No it is not a rolling hour. It starts on the hour for a one hour period. For example from 14:00 to 15:00. You can place 1000 tranasctions during this period. At 15:00 the counter is set back to zero and the next period is 15:00 to 16:00.

In the example you give, you would not be charged. During the period 16:00 - 17:00 you place 1000 transactions. Then during the period 17:00 - 18:00 you place 500 transactions.

Hope this helps.