Simple I think but struggling!

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
HRacing
Posts: 278
Joined: Tue May 14, 2013 11:25 am

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
spreadbetting
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.
User avatar
HRacing
Posts: 278
Joined: Tue May 14, 2013 11:25 am

spreadbetting wrote:
Thu Aug 31, 2017 1:07 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 spreadbetting
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”