Applications that we use for data sourcing - Blogs - Racehorse TALK harm-plan

Racehorse TALK



Applications that we use for data sourcing - Blogs - Racehorse TALK

Author Topic: Applications that we use for data sourcing  (Read 1275 times)

0 Members and 1 Guest are viewing this topic.

Offline Skybeau

  • Group 2
  • User 41
  • Posts: 1718
O.P. « 2016-May-15, 10:46 AM »
Seeing as though I can't find Stormy's thread, thought it might be an idea to have a thread that we can use to share some of our methods for data sourcing.

Excel / Access is my wheelhouse, but would love to see any other methods/languages used to source data.

Offline MagiC~*

  • Admin
  • Group 1
  • User 2
  • *****
  • Posts: 14274
« 2016-May-15, 10:48 AM Reply #1 »
Stormy may have been a bit worried he was going to get into trouble for how he was sourcing his stuff   emthup

Offline Skybeau

  • Group 2
  • User 41
  • Posts: 1718
« 2016-May-15, 10:53 AM Reply #2 »
** Can't upload the file

This file is what I use to grab data re greyhounds in my database.

Firstly I paste the dog names in Column A.  I then use the FindFormURL() routine to return a URL from which I later grab sex, sire and dam information using the ReturnFormURL() routine.

In case there are multiple names listed for a dog over a period of time, I paste the dog name in Column A of the MultiTabs page and use the MultipleChromeTabs() routine to open the URL in Chrome.
« Last Edit: 2016-May-15, 11:08 AM by Skybeau »

Offline Skybeau

  • Group 2
  • User 41
  • Posts: 1718
« 2016-May-15, 10:54 AM Reply #3 »
Magic - Any chance you can add .xlsx / .xlsm to the allowable files to be uploaded?

Offline MagiC~*

  • Admin
  • Group 1
  • User 2
  • *****
  • Posts: 14274
« 2016-May-15, 11:06 AM Reply #4 »
try that mate

Offline Skybeau

  • Group 2
  • User 41
  • Posts: 1718
« 2016-May-15, 11:08 AM Reply #5 »

Offline PoisonPen7

  • Group 1
  • User 55
  • Posts: 20293
« 2016-May-15, 11:17 AM Reply #6 »
Well if this is illegal then Open Office and Excel are illegal by association. This is a punting forum. What do they expect us to talk about? Transgenderism?

Using Open Office

1. On a fresh worksheet, select Insert/Link To External Data



2. In the dialog box, enter the URL for the race you want - here it is the Sunny Caost R1 today



Hit enter and you may be prompted for "Import Options" - select Automatic. Then select the HTML_all

3. Your ratings are in the spreadsheet.

To get rid of all the formatting, select all data (Ctl-A) then right click and select default formatting



Offline Skybeau

  • Group 2
  • User 41
  • Posts: 1718
« 2016-May-15, 11:18 AM Reply #7 »
This is what I use to scrape data for Victorian greyhound meetings.




Offline PoisonPen7

  • Group 1
  • User 55
  • Posts: 20293
« 2016-May-15, 11:27 AM Reply #8 »
This is what I use to scrape data for Victorian greyhound meetings.

  emthup

Offline el zoro

  • Group 1
  • User 367
  • Posts: 9310
« 2016-May-16, 03:10 PM Reply #9 »
Is there any way of downloading data from the Tattsbet site into an Excel  spreadsheet?
After all my computer probs last year,  now up & going again but with Windows 10. (prev Windows 7) Have had a few problems but am used to it now.

 Tried the above post by PP7 but there are different tabs, & I  can't work it out .   
« Last Edit: 2016-May-16, 03:12 PM by el zoro »

Offline el zoro

  • Group 1
  • User 367
  • Posts: 9310
« 2016-May-16, 03:23 PM Reply #10 »
Currently I pay to download CSV files from Everyrace(Wizard). It's very good & easy to drop into a Spreadsheet but wondering if there is an easy cheap way to get form. Cheap meaning Free, ha ha. 

Offline Skybeau

  • Group 2
  • User 41
  • Posts: 1718
« 2016-May-16, 03:55 PM Reply #11 »
Can't see why not, might take some manipulation in Excel once the table is linked from the website.  Flick me a link EZ and I'll take a look.


BACK TO ALL TOPICS
Sitemap