Shaun, I am partially lost at this point,(THE BASICS PART 3) but impressed at the speed of the imports to say the least using the XML thing.

The way I do my "refresh" is race by race on the race start time order list.
By "refresh" I mean a Loop in starting at the top using the
Do until
-----------------------
So it's ( your code )



and the rest of your code at this point.
----------------
FOR TESTING,
I have used a counter method, so when it reaches "5", it simply gets the next race on the list. This will be deleted later on.


How is the code written to get RaceDisplayStatus to appear in Sheet 1 Cell J2 please?
And the results if possible for that race.
Thanks.


Puntz

So what you want it to do on the unitab site is select a race then keep refreshing then when the race is over you want it to move to the next race?

That is for the new site correct.

Yes, that is for the tatts site cos that is the one I am working on now, but later I'll move on to the other sites.

For now,

the Do Until requires the status, whatever it is, if it's,
a "Time", "PAYING","INTERIM","CLOSED", "ABANDONED" "PHOTO" "PROTEST" etc etc
and/or whatever else the scenario may be.
Eventually it will get to "PAYING", which will be the official RESULTS.

The actual RESULTS payout figures may be best go to Sheet2.

During some testings I don't wait around for PAYING, and choose INTERIM then move on to the next race.

The time limit is important to.

If lets say a race has a advertised start time of 3:00pm and it's Looping, there has to be a limit or it will Loop forever, so therefore I implement a Variable factor of let's say 20 minutes after advertised race start time LIMIT.

So if at 3:20pm there is no status or they are still negotiating a PROTEST, then 20 minutes past 3:00pm ( Variable), Next Race...,

Puntz

What do you use to get the race times in order and where do you get them?

I was having a look at your last sheet the screen updating is doing twice the work, have it set like this


Application.ScreenUpdating = False

Rest of macro here

Application.ScreenUpdating = True

What that does is stops the screen updating so it just looks like the info appears and you don't see the macro working, if you do the same for the clean up macro will look smother.all the

Ok, I did not include the entire macro, only the section.

-----------------------------

It's in another workbook
using the old html code


Cell A1 is: 2012/02/06/raceday
This brings up the entire race card
----------------------------------


Yes, I am still tweaking as I go along.

I'll post the new day's race list tomorrow at around just past 9.AM.

I need the RESULTS though or the project/workbook cannot be completed, and won't be able to get past BASIC 3.

Thanks

Puntz

Today's Race list
There are 3 sheets
1: with only horse and trots
2: horse-trots-greys
3: all races on card
the all races on card sheet, the overseas racetimes may show past midnight so effectively it is not in true time order.

The code I use to delete a race row goes something like:
add a sheet and call it: DAYSRACELIST
USE THE ONE POSTED HERE AS A BACK-UP, COPY AND PASTE FROM BACKUP TO DAYSRACELIST, THEN YOU NEVER LOSE THE ORIGINAL.



Puntz

Attached Files

DAILY RACE LIST-20120207.xlsx (25.5 KB, 388 views)

Shaun,

On the Workbook you have here where it gets the prices using xml how is it coded to gather other information ?
For example
Length,Distance etc etc

This xml makes no sense, it's not like the code when Record Macro is written where it understandable-linear-->

xml looks like "2-way speak"

Set runnerNumber = runner.Attributes.getNamedItem("RunnerNo")
If Not runnerNumber Is Nothing Then
Sheet1.Cells(i + 5, 1) = runnerNumber.Text


Ya know?

It's not like,
"put race length in Cell B1"
Give this some thought, since when does a punter need to learn to program a PC to win a race when the punter already knows more than the programmer about racing and betting ?


But if your answer is something like, "well what goes round comes round, it is the age of the programmers"
I say ****, Pitsburgh Phil never used a computer!

http://en.wikipedia.org/wiki/George_E._Smith_(gambler)

xml is different from what i have been doing in this short course, xml is the website designers way of providing all the information that a person needs to put that in excel.

The VBA that i have posted is excels way of gathering information from the website that is why not all information is able to be separated in to individual bits before download.

This is why some times you can download individual tables and other times you have to get the whole page and take what you need.

I am not good with xml i can only understand some from there example so i am not the best person to ask about this.

As for your comments about computers helping punters win, well to be honest i think it is the punter helping the computer win.

Computers are no smarter than what information they are given, they can calculate things and display other things in a layout that is easier to understand.

The speed they can accomplish these things can be very fast.

comment are just my way of breaking monotony, I have a soft spot for programmers, I surely do.
I went to TAFE actually to enter a 6 year IT course and failed the intro.,
( I did not tell them my "secret" that I wanted to make my own horse race program) they said I need to go back to school and learn Trigonometry. I said OK.
So I went back the TAB and looked for a horse with a similar sounding name.
When I asked the woman at the counter after placing a bet,
"Do you know Trigonometry?"
She pointed to her wedding ring!

Anyway,



Yes, that's what I been doing using another web query with html at the end,
and yeah, like you say, "take what you need"


Thanks