22nd May 2014, 08:38 AM
|
Member
|
|
Join Date: Oct 2009
Posts: 463
|
|
Just need to add this bit of code in:
Set oddsList = xmldoc.SelectNodes("//WinOdds")
Sheets("sheet1").Range("A1:E50").Select
Selection.ClearContents
Range("A1").Select
For i = 0 To (runnerList.Length - 1)
Then it works like a well oiled machine.
RCP on a side note if you look at SR7 yesterday, see how there is a significant gap on the scatterplot between the runners with the highest odds and all the fancies below that. Is this what your looking for when laying longshots?
Basically was just wondering what the significance of the scatterplot was for you? Obviously don't have to go into huge detail as its something you've clearly researched but just interested.
|