How to calculate Last traded amount in Excel ?

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
YESWAY
Posts: 17
Joined: Wed Jun 22, 2016 10:35 am

Does anyone know how to calculate Last traded amount in Excel for each individual selection and price ?
User avatar
BetScalper
Posts: 1139
Joined: Sun Jul 02, 2017 10:47 pm

YESWAY wrote:
Mon Jul 03, 2017 8:46 pm
Does anyone know how to calculate Last traded amount in Excel for each individual selection and price ?
Don't think you will find the answer to that on here.

Not sure BA supports it in its current version. Although I believe you can get it via the API.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 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!

Code: Select all

MsgBox RunnerName & vbCrLf & "Traded: £" & TradedDiff & vbCrLf & "at " & LTP
change to suit the column where the result is shown, currently showing in AF, (column number 32)

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.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”