auto select markets every 10 seconds in a loop

[JProut]

Hello there

I'm using an Excel spreadsheet linked to football and greyhound markets.

Is there anyway to do the following?

BA selects first market in Quick Pick list, ignores it if suspended, closed or in-play
Spreadsheet places bet (or not) depending on trigger cell criteria
BA pauses 10 seconds (to regulate 1000 transactions per hour limit)
BA selects next market in Quick Pick list and so on
When BA reaches the end of the Quick Pick list it loops to the start of the Quick Pick and begins again

Please note I'm not that clued up when it comes to Visual Basic. I know of its existence and how to open the VB editor and how to copy and paste but I'm clueless when it comes to understanding the code

Any help on the above would be much appreciated

[Captain Sensible]

Hello there

I'm using an Excel spreadsheet linked to football and greyhound markets.

Is there anyway to do the following?

BA selects first market in Quick Pick list, ignores it if suspended, closed or in-play
Spreadsheet places bet (or not) depending on trigger cell criteria
BA pauses 10 seconds (to regulate 1000 transactions per hour limit)


BA selects next market in Quick Pick list and so on
When BA reaches the end of the Quick Pick list it loops to the start of the Quick Pick and begins again

Please note I'm not that clued up when it comes to Visual Basic. I know of its existence and how to open the VB editor and how to copy and paste but I'm clueless when it comes to understanding the code

Any help on the above would be much appreciated

All the indicators you need are sent to the excel sheet , the market status is sent to BA in cells E2 and F2 so you can see if the markets in play suspended and then use the special triggers in Q2 to navigate around the markets. Can't remember off hand which cell but the number of markets is also sent to excel so you can identify the L last market and then goto the start and begin your loop. THink there's a few examples of looping thru markets on the forum.

At the end of the day you would need to learn some VBA to do exactly what you're looking for as there are quite a few parts and can't imagine many people have the time to code it for free for you, alternatively you could hire a coder like Osknows to do it for you. Have a search thru the forum most of the example code is already there and check out the manual to see what built in functions BA already has to move thru the markets back and forth.

http://www.gruss-software.co.uk/Betting ... e/help.htm

[bolpx001]

For what it is worth, I did something very similar to this some years back and Betfair suspended my account. I think they suspected I might be selling the information or some other type of nonsense. At any rate I managed to convince them to reinstate the account and promised not to do it again. What's the deal with a 1000 transactions per hour limit? I usually have 5 or mote tabs open refreshing at .2 second that would make 18000 transactions per tab per hour or have I got the wrong end of the stick - best regards Paul

[Captain Sensible]

I guess he's talking about the transaction charges for placing over 1000 bets per hour rather than the data charges for refreshes that they did away with when the new API came in.

Transaction Charges
This section only applies to the Betfair Exchange.
In addition to any commission payments, Betfair customers will be charged a transaction fee if they process a large number of transactions on either the main Betting Exchange or on Exchange Games.
NB - Transaction Charges only apply to customers placing or editing more than 1000 bets an hour (although in the case of Exchange Games, the editing of bets is not included). The number of bets placed across the Betting Exchange and Exchange Games are calculated separately for the purposes of calculating any Transaction Charges payable. So, for example, if within the same hour you placed 800 bets on the Betting Exchange and 700 bets on Exchange Games, no Transaction Charges would be payable in respect of any of those bets.
At the end of every day, we add up all the bets you placed or edited (whether matched, cancelled or lapsed). If this number is in excess of 1000 in any hour of the day then:
for customers placing bets through the Application Programmers Interface (API) on the Betting Exchange or for customers placing bets either through the API or on the website on Exchange Games, we will multiply this number by 1p; and
for website customers on the Betting Exchange, we will multiply this number by 2p.
For the purpose of Transaction Charges, bets on financial markets will count as 0.25 of a bet. This will form the basis of the transaction fee, but we will offset this fee against the following amount:
(Commission + Implied Commission) ÷ 2
where
Implied Commission = market losses x 3%
NB: the Exchange Games transaction charge is offset using commission paid instead of commission generated.
Any remaining amount will be charged to your account on a daily basis. Should your (commission + implied commission) ÷ 2 exceed this amount, you will not be charged a transaction fee. Accounts that relate to one person, entity, API subscription or a Master account (Trading version only) with related Sub accounts are treated as one customer for the purposes of transaction charging. Note that no Betfair points will accrue for transaction fees.