In Bet Angel excel, is it possible to retrieve a particular bet reference number's status?. i.e. Is it matched, partially matched, unmatched or cancelled? I know you can work it out from the information already present in the Bet Angel sheet columns T to AE with the matched and unmatched bets column but I would be interested to know if you can get the bet reference information directly in a formula or procedure. I never saw anything in the documentation to say that you could do it. I asked ChatGPT the same question I posted, It said:
"To check the current status of an order in a Betfair betting market, you can use the following Excel formula:
=BA_XSP("bet_id")
Replace "bet_id" with the unique identifier of the bet you want to check the status of. This will return the current status of the bet, which could be one of the following:
"U" - Unmatched
"M" - Matched
"MU" - Matched and Unmatched
"C" - Cancelled
"E" - Expired
"S" - Settled
You can also use other Bet Angel functions such as BA_BF_PandL() and BA_BF_PLACED() to retrieve information about your bets' profit and loss and whether they have been placed successfully or not."
I presume this information is not correct or is there a way to do this?
Finding out the status of a Bet Reference
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