Hi Gavin
Sorry if this has already been mentioned but I couldn't find it in the Excel forum or Suggestions pages.
Can you put the Green Up value that is at the top of the selections on the Cymatic Main Dashboard Page into the Excel Spreadsheet at the top of the Green To column.
(Please see attached images for clarification - Please Note they're not from the same race they're just to clarify the Green Up value and Excel column location).
In the Dashboard image, the value I'm looking for is the £1.53 Green Up value at the top of the selections list.
I've found that simply summing the Green To values for each selection in Excel appears to be the same when only a single bet has been made on each selection.
But once multiple bets have been made across the selections in the Market the simple summation doesn't work.
The Dashboard image indicates this. Simply summing each selection's green up value (£-0.06 + £0.08) isn't close to the £1.53 at the top of the column
which I'm guessing is based on previous completed trades.
The image also indicates that I've found the sign of the Green All value to be the same eg in this case +ve but the magnitude of the value is way out:
£1.53 versus £0.02.
I'd like to use the Green Up value to drive Greening in the Spreadsheet, so that if it is beyond a threshold (+ve or -ve)
the Market can be Greened (or "Redded").
Hope this makes sense.
Cheers
!! WARNING !!
I've found that simply summing the individual Green's is DOWNRIGHT DANGEROUS and can cause a thumping loss.
e.g.
If the other selections are Lay Bets, towards the end of the race the sum of the greens on the losers add up to a large green.
However if you Green Up, all the stakes on the losing bets are removed from the profit of the Winner causing a big loss.
Images
=========================================================================================