Is it possible to access the following pieces of information in Excel:
1. Total amount laid and average price for each option (matched)
2. Total outstanding laid amount and odds (unmatched)
The spreadsheet only seems to show to most recent outstanding order.
Cheers!
Accessing Variables in Excel?
The only information you can access in Excel is on the 'Bet Angel' worksheet in the workbook.
So if what you want is in there then you can access, manipulate and work with it.
So, total volume matched is available by runner. But this is a total of back and lay.
Total amount outstanding or waiting to be matched is not available entirely; you can see the money available waiting to be matched on the first three prices either side of the book.
So if what you want is in there then you can access, manipulate and work with it.
So, total volume matched is available by runner. But this is a total of back and lay.
Total amount outstanding or waiting to be matched is not available entirely; you can see the money available waiting to be matched on the first three prices either side of the book.
-
DefTouch85
- Posts: 8
- Joined: Thu Apr 29, 2010 11:13 pm
How could things like totat outstanding lays not be available? That would render the sheet essentially useless for programming
-
DefTouch85
- Posts: 8
- Joined: Thu Apr 29, 2010 11:13 pm
Only from the most recent lay. What if you have multiple lays on a single option?