Racing Schedule

[good 4th]

Hi, Im wondering if anyone can help me with copying the racing Schedule in nswtab.com.au to excel,im after just the races (all codes ) not all the other stuff, otherwise i have to input all the days racing. dogs, trots, horses and it takes so long....
Cheers

[Shaun]

Hi...just wondering do you import this stuff to excel i have tried but it won't link to the page....and explain the information you need i may be able to help

[stebbo]

On 2003-10-20 08:41, good 4th wrote:
Hi, Im wondering if anyone can help me with copying the racing Schedule in nswtab.com.au to excel,im after just the races (all codes ) not all the other stuff

Hi Good4th....

it's actually an incredibly difficult process.... :wink:

1) go to the page you want,
2) click onto the page near the info you want
3) press Ctrl-A or click-and-drag to select all the info you want
4) press Ctrl-C or right-click and select copy
5) go to excel
6) press Ctrl-V or Click Edit.. Paste.

viola!

If you're just after the gallops, then might I suggest you go to the skychannel website, and click on on Todays Racing... Rundown, then select the gallops and press go. To get this into Excel you'll need to left-click and drag across the info you want to select it, then copy and paste.

Cheers,
Chris.

<font size=-1>[ This Message was edited by: stebbo on 2003-10-20 21:00 ]</font>

[Shaun]

When i say import i mean that i will have the prices on my excel page and when they update from the tab they update on my page as well...i have only found one tab site that i can do this from

[good 4th]

Thanks for the info. I dont think you understand as i know how to cut, copy, paste.When you paste the page to excel(do it yourself)i only want the tab code location & the race advertised & the how do u format the thing to fit......
Any help would be helpful

[Shaun]

try copying it to word....then take what you want from there....that works for me when i only need a portion of the information

[Every Topic]

good 4th, do you mean you want the race schedule which is obtained by clicking on todays racing at the top left corner and then schedule at the top left of the page that appears???

and you mean you just want that without the T and G races??

if so, right click your mouse - oh, and you have to be using that idiot MS browser - explorer or whatever the stupid thin gis called.

click "export to excel" and that solves that part of the equation.

then you just need to filter out the non R meetings by using the filter that you find under DATA on the tool bar.

if however you want the prices etc for each race in the lead up to the race then you need to import this data using the "import new data - web query" mechanism under DATA and there you can select the info you want downloaded for each race and can leave out the stuff you dont want.


hope that helps.

see ya
Every Topic

[good 4th]

Thanks every topic.Yes im after the total racing schedule in running order for the whole day, night racing.Have tried exporting but i must be not doing it correctly, will keep trying..
cheers
good 4th