Following on from Peters spreadsheet shown here:
http://www.youtube.com/user/betangeltv# ... JoZjwpf7sQ
I've created something similar.
I've loaded several markets into Guardian, and they are all listed on the summary sheet along with the sheet name, market name, LTP, Green up P&L and profit/loss for that market.
As you can see from the sample, there are several LTP prices of 1,000. Assuming you don't want to see all of these, you can narrow the field down to show markets that are still tradable by pressing the "Hide if LTP=1000" button. Doing this shows that the correct score market is now 1-3, 2-3, 3-3 and any unquoted.
The "green up p&l" figure and the profit in the next column are explained in the video.
If you click on the "Green Up?" cell, the appropriate market will green_all. Note: If you p&l is zero, you'll get a message saying that it wasn't greened up. This stops the error message appearing on the market sheet .
If the green up is successful, the cell will change from "Green Up?" to "Greened Up"
In D21 you can see I made a profit of £10.00 and Bet Angel(2) is showing "GREEN_ALL"
You can test it out by entering a profit figure in col D ( the formulas will re-set themselves when you press "Populate").
When you press the "populate" button, everything is re-set and the GREEN_ALLs are cleared from each sheet.
All existing Bet Angel sheets will be shown on the summary whether they are from today or 1 week ago, so please make sure any existing info shown is cleared before use.