Gruss Forum • View topic

by **milfor** » Fri Jun 19, 2009 12:17 am

Some weeks ago I saw in this forum an Excel spreadsheet that downloaded (from Racing Post ?) all horses and the ranks they acchieved for the whole day. I used the forum search but can't find this spreadsheet anymore.

Does anyone have this spreadsheet or remember in which thread it was posted?

by **dgs2001** » Fri Jun 19, 2009 9:16 am

milfor

Are you thinking about the sample tissue price capture workbook by Gary? If so its in the sample triggered betting excel files thread.

If not you may be thinking about a workbook which I suspect was accidently put up by alrodopial, it was being hosted in the same place as another but seems to have been removed now.

Duncan

by **milfor** » Fri Jun 19, 2009 10:14 am

Thank you for your help.

It was definitely not from Gary.

I have searched for alrodopial and found a spreadsheet but I am afraid that is another one. The spreadsheet I remember was very simple - only 1 page with all the horse names of the day and the result ranking beside them.

by **alrodopial** » Fri Jun 19, 2009 10:30 pm

What do you mean by "result ranking" ?
The sheet was downloading and update the results at the end of day?

by **milfor** » Fri Jun 19, 2009 11:38 pm

Exactly!

by **dgs2001** » Sat Jun 20, 2009 12:10 am

Dices,
I hope you don't mind me bringing you into this thread

Duncan

by **alrodopial** » Sat Jun 20, 2009 12:19 am

Here's a fast link from RP for today's results:
http://www.racingpost.com/horses/result ... 2009-06-20

The sheet must download today's runners (BA or RP) and at the end of day must download the results and assign the correct result to the correct horse.
Any ideas?

by **alrodopial** » Sat Jun 20, 2009 6:48 am

If you are looking for just a list of runners and their position in the race the above link is a very good way to get them.
What are you looking for?

by **milfor** » Sat Jun 20, 2009 9:23 am

The problem is: How do I get the information of the page into Excel cells?

by **Roger** » Sat Jun 20, 2009 10:35 am

You can cut and paste the information into an Excel worksheet, then do another cut and paste to get the righthand group of data under the lefthand group.

by **milfor** » Sat Jun 20, 2009 1:22 pm

Cut and paste doesn't work. Excel puts everything in the same cell.

The spreadsheet that I found in this forum downloaded everything automatically into seperate cells. If I only could remember in which thread it was.

by **alrodopial** » Sat Jun 20, 2009 1:28 pm

milfor wrote:The problem is: How do I get the information of the page into Excel cells?

You can do it using web query from excel.Google it
Also take a look here:

Excel help site :
http://www.cpearson.com/excel/topic.aspx

Excel help forum:
http://www.mrexcel.com/forum/index.php

Come back after a couple of days if you need more help.
Exploring excel and VB is a wonderful trip.

by **Roger** » Sat Jun 20, 2009 1:58 pm

Milfor, I've done it!

Does anyone remember this spreadsheet?

Does anyone remember this spreadsheet?

Who is online

Sports betting software from Gruss Software