Bit of a long shot and thanks in advance for anyone who can help. Im looking to capture data from the betangel spreadsheet for both players in a tennis match. All i want to capture is the current back price as soon as the the market turns in-play signalled in cell G1. Im struggling to capture the data as the spreadsheet keeps refreshing meaning any code iv made up keeps running meaning the cell value keeps changing. If anyone has any ideas I would be enternally greatful and would save me a massive headache.
Regards
Simple I think but struggling!
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Generally the way to stop the data updating is to use VBA and just include another condition to your capture statement so it only fires if your cell, where the data is being sent to, is empty.
Iv pm'd you if that is ok spreadbettingspreadbetting wrote: ↑Thu Aug 31, 2017 1:07 pmGenerally the way to stop the data updating is to use VBA and just include another condition to your capture statement so it only fires if your cell, where the data is being sent to, is empty.