Guys,
as I am not a qualified person in settings of excel formulas, that is why I would like to kindly asko you to help me.
Let's say, I have 3 matches set by Guardian Watching List, connect to Excel and I need to see changes in excel as soon as the matches start.
1.)
I need to get a color signal (green, may be blinking) immediately as the odds goes down after kick off.
E.g. the odds before kick off is 2,20 for home team. 10 mins after kick off, the odds goes down up to 1,9. I would need to get a color signal as the odds is changing in time (5% and more), let's say first 30 mins after kick off.
2.)
Following the first point, I would need to get also a sound signal as soon as the odds is changing of 5% and more (goes down).
I will do appreciate your help and support.
Thanks, Marwin
Watching changes in odds during the match
-
WinLoseWinWin
- Posts: 17
- Joined: Sat Dec 29, 2012 11:41 pm
You would need to capture the odds when the event goes in-play in order to do what you want.
If your Excel skills aren't great, then this might not be so easy for you to do, but I would probably do is create a macro that runs automatically when cell G1 changes to 'In-play' (search google for 'Excel vba on change macro' or similar for details on how to do this) and then you can use conditional formatting within the Excel spreadsheet to colour code the cells based on rules such as last price is < start price (which your macro has copied to cells on the right of the spreadsheet) * 0.90.
You would also need another on_change macro to create the sound alerts.
Richard
If your Excel skills aren't great, then this might not be so easy for you to do, but I would probably do is create a macro that runs automatically when cell G1 changes to 'In-play' (search google for 'Excel vba on change macro' or similar for details on how to do this) and then you can use conditional formatting within the Excel spreadsheet to colour code the cells based on rules such as last price is < start price (which your macro has copied to cells on the right of the spreadsheet) * 0.90.
You would also need another on_change macro to create the sound alerts.
Richard
Marwin - sounds like you are taking a useful approach for inplay. However, my recommendation would be not get ahead of yourself with Excel. I recommend you either track these market positions manually, scrolling through Guardian, or set up simple sound alerts using automation.
If you're only trading three or so markets (which is a good number) this should free you to focus on your big trades.
If you're only trading three or so markets (which is a good number) this should free you to focus on your big trades.