As far as xml, yes no real working model but tones of web query sheets, as i post a lot of what i have done and it is similar to xml, i guess the difference is that they provide the xml feed where as with queries i just take what i want and have to alter code when webpages change.

It is good to provide the tools but is better to teach people how to do it because we all want something different.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Give me an idea of what you would like to display on the page and if i get some time i will work on it.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Mate, anything that moves, Dogs, Harness & Racing. Let's go global and look at the overseas stuff covered by them. No, Name, Tote Win, Fixed Price Win,Winner, Placegetters.

That's the wish list......Good man...

At least that'll allow anyone to build a reliable database to analyse, even if only for price. I downloaded the most recent Betfair historical file the other day. I set the filter to <$1.20 win price Pre Event. The results threw up anything with a SP up to $5. A complete waste of time for a historical data site.

The smarties with programming knowledge can build a bot to record accurate prices, which leaves a lot of forumites disadvantaged. I know forumites who still use a ruled school excercise book to record prices. Imagine how empowered they could be with a simple recording program.

It's a legacy, you won't be forgotten for Shaun....

So you want the Unitab site in excel with the ability to record past results with some type of filter system.

Sounds simple enough, well if anything it will give me xml knowledge that i don't correct possess so that's a plus.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

I'll add some snippets of code that helps when Excel slows down.

This one here, deletes Excel's Active Workbook Connections somewhere in the process of a continual web query.

My first count was over 200 connections at the same time. Excel became really sluggish.
I think it meant 200 web queries.
Imagine clicking your mouse 400 or 600 times at the Ribbon to delete these "connections" manually.
These "connections" were weeks old, well after the races had run.

I run this code before after each web query within a Do Until Loop.

So basically, you may consider running the code between the last race and the new race so the memory starts with a clean slate.


-----------
To explain this part of the code is basically a counter showing the total times it Loops, ( meaningless/important statistical stuff).



Mine is curently up to 5208.
This means the Excel race worksheet has connected 5208 times in that particular Workbook.

Running the code eliminated the task of clicking the mouse 5208 multiplied by about 3
5208 * 3 would have been lots of mouse clicks, lots of races missed, POT down.


Or do it manually on Excel 2010, click on Data then click on Connections, there you will see it under Workbook Connections.

Run the above code and it goes away, freeing up Excel.

Forget PE, you want to delete all IP and PE.
Then it's accurate.

__________________
RaceCensus - powerful system testing software.
Now with over 402,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/05/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Beg to differ CP. Take the latest file 28 April to 4 May. If you filter out IP In Play and PE Pre Event, that only leaves NI ?? Not sure what that means, but doesn't matter, take a typical race at random Wyong R1 1/05/14.
If you filter PE and IP OUT, leaves you with NO horses! That's because NI was only applicable for TO BE PLACED on that event.


Another example: 28/4/14 Bathurst R1 Pace runner Amelia Regal Last Taken actually three prices at 3:39..... 50 60 100. How do you know which figure relates to what price classification. This is a simplistic example but the favourite in the race would have lot's of differing numbers displayed.
The prices, that Betfair paid on, were Back 50, SP 81.83 & Lay 110.

That's really accurate, hey? Build a database, don't think so?

Then what are the prices published representing, they're not WAP, SP, Back or Lay. A punter needs some reference to what he has available to him on screen and them providing last price taken is of no consequence. Let's say I wanted to query the file to find the largest price never to had a win. Well I can tell you the figures provided are so far off and bear no resemblance to actual SP.

Morning Josh, the only hiccup with this one is that if the field size was greater on the previous race shown (Yesterday SR4) than todays VR1 then it still displays the overrun of horses from the previous race. See the jpg, horses 9 ~ 16 were from SR4 yesterday.

Nearly there mate.....

Attached Images

Josh for PM2.JPG (54.5 KB, 362 views)

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.