Hey guys, so I'm having an error betting on Basketball markets using excel. For the placement of back bets I have the following code
=IF(AND(COUNTIF(AM7:AM107, "BACK") > 0, O11 = "", G11 > 1.29, H12 >50), "BACK", "")
So if O9 or O11 depending on the 1st or 2nd team, if O11 is empty and all other criteria is met it will place the back bet. (O9/11 being the cell that says Placing, Placed, Failed)
This is supposed to be so it doesnt double bet because if the other criteria changes then it will remove the Back text from cell L9/L11 and can write Back again and again and place more bets
But even with this in place, every blue moon it is placing multiple bets. What I have noticed is when it does place more than one bet, the status in cell O9/11 is always FAILED but it has placed lots of bets
Any ideas of how I can fix this?
Thank you
Error with O9/O11 using excel in guardian
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