Can anyone point me in the right direction on this topic. I have a programming background but I don't know VBA though I could probably understand the code/pick it up.
I have a trading method which goes like this:
The evening before racing I generate a list of horses to be traded, one per race in 80-90% of the races scheduled for the following day (UK/IRE), so there are quite a number especially in summer.
In Betangel, I have a column set up to place back bets with one-click by asking for the best lay price -1 tick. That enables me to place all the bets fairly quickly into the markets.
Now comes the laborious bit: next morning I have to cycle through the unmatched bets and adjust the asking price on each one so that it is still best lay price -1 tick, until all bets are matched. This is very time consuming, also it means where a price has dropped rapidly I have missed out on getting the best price available.
I have been trying to figure out how to use automation to do this matching process but so far it has defeated me. The logic is, if there is an unmatched amount, cancel the existing bet and place a new back bet for the unmatched amount into the market at the current best lay price -1 tick. How hard can that be?
After all bets are matched I place an SP lay bet to offset the back bet (in case my computer/virginmedia/Betfair goes down), then I have an in-play greenup rule that fires right after the off. This all works really well apart from the bet matching bit.
Cheers
Steve
Automating bet matching process
Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
1 post
• Page 1 of 1
Post Reply
1 post
• Page 1 of 1
Return to “Bet Angel - Spreadsheet / Excel chat”
Jump to
- Bet Angel Professional - Betfair trading software
- ↳ Bet Angel - Release & version history
- ↳ Announcements
- ↳ Bet Angel - FAQ's
- ↳ Bet Angel for newbies / Getting started
- ↳ Bet Angel - Tips and tricks
- ↳ Bet Angel - Spreadsheet / Excel chat
- ↳ Bet Angel - Example spreadsheets
- ↳ Horse racing
- ↳ Trade analysis & record keeping
- ↳ Tips and tricks
- ↳ Excel Power Query
- ↳ Bet Angel - Automation
- ↳ Bet Angel - Total Performance Data - FAQ's
- ↳ Bet Angel Automation - Shared files
- ↳ Bet Angel Automation - Football
- ↳ Bet Angel Automation - Tennis
- ↳ Bet Angel Automation - Horse racing - In-running
- ↳ Bet Angel Automation - Horse racing - Pre off
- ↳ Bet Angel Automation - General
- ↳ Bet Angel - API
- ↳ Bet Angel Automation - Betfair trading alerts
- ↳ Tennis trading alerts
- ↳ Bet Angel - Servants
- ↳ Bet Angel - Servants - Shared files
- ↳ Bet Angel - Customisation, settings, filters and coupons.
- ↳ Market selection filters
- ↳ Market coupons
- ↳ One Click trading interface
- ↳ Ladder trading interface
- ↳ Advanced charting
- ↳ In-play trader tool
- ↳ Guardian market list layouts
- ↳ TPD / Total Performance Data
- ↳ Suggestions
- ↳ Betfair trading videos - For current videos visit www.betangel.tv
- ↳ Support
- Betfair trading & Sports Betting strategies
- ↳ General discussion
- ↳ Australian
- ↳ Deutsche
- ↳ Español
- ↳ Italiano
- ↳ русский
- ↳ Trading Horse racing
- ↳ Football trading
- ↳ Trading Financial markets
- ↳ Cryptocurrency
- ↳ Tennis Trading
- ↳ Trading Psychology
- ↳ Other Betfair Sports Trading markets
- ↳ Trading Golf
- ↳ Rugby
- ↳ Boxing
- ↳ Non Sports trading Markets
- ↳ Political betting & arguing
- ↳ Technology
- ↳ Betfair Cricket trading
- ↳ Betfair trading strategies
- ↳ Sports betting strategies
- ↳ Loss recovery systems and methods
- ↳ Trading Greyhound racing
- Betting exchange & Bookmakers reviews and advice
- ↳ Chill Out Area
- ↳ Betfair exchange
- ↳ Betfair Data
- ↳ Betfair Exchange API
- ↳ Betdaq exchange
- ↳ Alternative betting exchanges, Smarkets, Matchbook etc.
- ↳ Bookmaker & Sportsbooks
-
- Bet Angel Quicklinks