I'm fairly new to BA and using excel to automate trades so apologies if this is a dumb question but haven't been able to find the answer anywhere.
My question relates to horse racing but someone may have done something similar with other events.
I am doing my own analysis to determine different positions on a number of horse with various back and lay positions in a race. Using the BA excel spreadsheet I have created a formula in input whether its a back bet or a lay bet in report field (Column L) but sometimes I will have both a back and lay position on the same horse. I thought the offset command would work but this places the same stake on both the back and lay sides where as I want to place different stake amounts for the back and lay options.
The only way I can think of doing it involves writing a macro (which I am not very good at) that if the selection has a back and lay position then once the back bet has been matched then it deletes "Placed" from the status field (column O) and then writes LAY in the report field (Column L) to place the LAY bet.
Is this the only way to do this or are there other commands I could try?
Assume for argument sake assume that I am taking the BSP price for both back and lay.
Bet Angel - Spreadsheet / Excel chat : placing back and lay bets on same runner but with different stake amounts
Discussion regarding the spreadsheet functionality of Bet Angel.
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest