Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 14th August 2009, 09:44 PM
Pauls123 Pauls123 is offline
Member
 
Join Date: Oct 2005
Posts: 245
Default Spreadsheets and formguides

Hi all,

Just a bit of a question here. Does anyone use any online formguide sites that you can copy and paste onto Excel. And from there of course, play around with various formulas to do things with certain aspects of the form.

Just wondering if this can be done, and which sites are the best to use.

Paul
Reply With Quote
  #2  
Old 14th August 2009, 10:20 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

Probably better if you use a Web Query and slap the data straight into your sheet without muckin' around with cuttin' an' pastin'

It can be done, I do it, but I still lose just the same
Reply With Quote
  #3  
Old 15th August 2009, 12:04 AM
Pauls123 Pauls123 is offline
Member
 
Join Date: Oct 2005
Posts: 245
Default

thanks Moeee,

Can you just expand on that a bit more please. How do you do a web query, and which form site would you consider best.

Thanks again,

Paul
Reply With Quote
  #4  
Old 15th August 2009, 08:17 AM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

I wear slippers because I still have problems tying shoelaces.

Only suggestion I can give you is to ask Google.
Thats what I do , and usually it has the answer, or will send you to some page that has.
There are heaps of Tutorials on the Internet.
SEEK and you shall FIND.
I never used to do Web Queries, and still don't, except for the one what gives me the data for the program that I use.
If I need to, I SEEK again to refresh my aging memory.

Web Queries is part of the EXCEL Program, and probably heaps of other Programs, but EXCEL is the one I use.

I play Greyhounds and get my information from the GRV wesite.
I'm sure it won't be long before somebody posts websites suitable for you.
Reply With Quote
  #5  
Old 16th August 2009, 11:18 PM
Neurokahuna Neurokahuna is offline
Member
 
Join Date: Sep 2006
Posts: 18
Default Here ya go

Hi All,

Here is a basic web query that grabs results from S-TAB for Casino today and the prices for a race at Sunshine Coast.

Not sure if I am doing anything contrary to the rules of the websites (here or the TAB's) so will leave it to the mods to determine if the spreadsheet should be deleted.

I use web queries a lot on the weekend and have even attached some buttons to mine to automate the race selection process and the update function, but I don't share these files in case it is a breach.

Hope this helps anyway. It should get you started.
Attached Files
File Type: xls web query basics.xls (155.5 KB, 826 views)
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 12:11 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655