Hi,
could someone please help?
I have a macro that works fine when I open excel that basicaly clears the bet status. If I manualy write "placed" in the status cell the macro clears it, but if I put the sheet in guardian it simply won't work.
this is the code I'm using:
already tried it with calculate and with change. it works both ways manualy but not when betangel fires the bet..
Can you help?
Thanks,
Miguel
Private Sub Worksheet_Change(ByVal Target As Range)
Dim bSuccess As Boolean
On Error Resume Next
bSuccess = Range("ai4").GoalSeek(0.6, Range("Ag2"))
On Error GoTo 0
If Not bSuccess Then
MsgBox "Goal Seek Failed for Cell ""ag2""!"
End If
Dim i As Integer
For i = 9 To 67 Step 2
If Range("O" & i).Value = "placed" Then _
Range("O" & i).ClearContents
Next i
If Range("H1").Value = "Suspended" Then
For i = 9 To 67 Step 2
If Range("O" & i).Value = "placed" Then _
Range("O" & i).ClearContents
Next i
End If
End Sub
Macro works in excel but not with guardian
Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
2 posts
• Page 1 of 1
Post Reply
2 posts
• 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