How to calculate Last traded amount in Excel ?
- BetScalper
- Posts: 1139
- Joined: Sun Jul 02, 2017 10:47 pm
Press the button everytime you load a new market (necessary to get correct number of runners and assign range).
Monitors the £ amount under each LTP and returns the amount traded in col AF.
Change the £ and you'll get a message box pop up with the details. This is only so you can check the details are correct. Remove before trying for real!
change to suit the column where the result is shown, currently showing in AF, (column number 32)
Monitors the £ amount under each LTP and returns the amount traded in col AF.
Change the £ and you'll get a message box pop up with the details. This is only so you can check the details are correct. Remove before trying for real!
Code: Select all
MsgBox RunnerName & vbCrLf & "Traded: £" & TradedDiff & vbCrLf & "at " & LTP
Code: Select all
Sheets("Bet Angel").Cells(AddrRow, 32) = TradedDiff
You do not have the required permissions to view the files attached to this post.