connect via excel - auto bet my selections
Got it working!! Thanks so much!!jimibt wrote: ↑Fri May 10, 2019 4:51 pmyou can add it as a sub in the same namespace as the bet Angel worksheet_change event... just paste it below, then, call if from the worksheet_change event when the market changes to another market. Below is how i track this change in that event:liero1 wrote: ↑Fri May 10, 2019 4:45 pmah thanks, perfect. So i just add it as a module? Testing now.. This is really a headache, what's the point in automating when you need to manually delete the status cells... But this might work well,let's see.
Otherwise maybe just look for the 'inplay' status in G1 and empty those status cells...
so, module level variable:then, in the worksheet_change event:Code: Select all
Private m_LastEventName As String
<--- cut<---cutCode: Select all
Const RACE_NAME_COL = 1 Const STATUS_ROW = 1 Set wsSource = ThisWorkbook.Sheets("Bet Angel") Set wsCalc = ThisWorkbook.Sheets("Calculations") Set runnerRange = wsSource.Range("B1:K50") Set mainCells = wsSource.Range("B1:G6") If Not Application.Intersect(runnerRange, wsSource.Range(Target.Address)) Is Nothing Then ' change event info on cell contents being updated If (m_LastEventName <> mainCells.Cells(STATUS_ROW, RACE_NAME_COL)) Then m_LastEventName = mainCells.Cells(STATUS_ROW, RACE_NAME_COL) ClearBetStatuses end if end if
Hi
Your solution works perfectly and I have been placing bets fully automated the last two days. A beauty!
Just one thing hope you don’t mind - as the code blanks the global command as well I can’t use the take SP command at the moment. Any way we can amend the code so it doesn’t clear the global command cell?!
Thanks!
Your solution works perfectly and I have been placing bets fully automated the last two days. A beauty!
Just one thing hope you don’t mind - as the code blanks the global command as well I can’t use the take SP command at the moment. Any way we can amend the code so it doesn’t clear the global command cell?!
Thanks!
morning... ok, you are obviously using the setup in a slightly different way to me. i my scenario, that function (ClearBetStatuses) only gets called when a NEW event is focussed on -i.e. when Bet Angel changes markets. This is determined by your *Automatically Switch Bet Angel Market* flag and time. However, as i don't know how you are using it, then maybe the best option is to not reset the glogal status cells in side the function. In that case, simply comment out this line:liero1 wrote: ↑Sun May 12, 2019 8:33 amHi
Your solution works perfectly and I have been placing bets fully automated the last two days. A beauty!
Just one thing hope you don’t mind - as the code blanks the global command as well I can’t use the take SP command at the moment. Any way we can amend the code so it doesn’t clear the global command cell?!
Thanks!
Code: Select all
'wsSource.Range("L6:O6") = ""