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 1st February 2020, 02:52 PM
Stix Stix is offline
Member
 
Join Date: Apr 2005
Posts: 3,026
Default Excel Help/Update with live prices (michaelg)

Hi All

Hoping someone might be able to help with an excel VBA macro or similar that would import the most recent tote or fixed odds prices from https://tab.ubet.com/racing website.

michaelg was able to help me many moons ago with a spreadsheet that downloaded field data from the old tatts bet website, but I don't think he hangs around here anymore.

Thanks in advance, happy to reimburse for your time.

Kind Regards
Stix
__________________
Stix
.......Giddy Up..... !!
Reply With Quote
  #2  
Old 2nd February 2020, 06:02 AM
UselessBettor UselessBettor is offline
Member
 
Join Date: Sep 2011
Posts: 1,596
Default

I would suggest trying some of the excel/vba forums. You will have more luck. its not my expertise working with excel sorry.
Reply With Quote
  #3  
Old 2nd February 2020, 08:01 AM
Shaun Shaun is online now
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,522
Default

Quote:
Originally Posted by Stix
Hi All

Hoping someone might be able to help with an excel VBA macro or similar that would import the most recent tote or fixed odds prices from https://tab.ubet.com/racing website.

michaelg was able to help me many moons ago with a spreadsheet that downloaded field data from the old tatts bet website, but I don't think he hangs around here anymore.

Thanks in advance, happy to reimburse for your time.

Kind Regards
Stix


I am moving away from excel and websites as a lot make it very difficult, but let me see how what i can do.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #4  
Old 2nd February 2020, 09:54 AM
Stix Stix is offline
Member
 
Join Date: Apr 2005
Posts: 3,026
Default

Thanks UB and Shaun

my email is Stix_1771 at outlook dot com

Thanks In Advance
__________________
Stix
.......Giddy Up..... !!
Reply With Quote
  #5  
Old 2nd February 2020, 11:55 AM
Shaun Shaun is online now
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,522
Default

Here is a sheet that will download current and paste races, there is code in there and other formulas that may help you, let me know if you need anything specific, this uses the old Qtab site so no idea how long this code will work.
Attached Files
File Type: xlsm UniTab Live Prices.xlsm (692.6 KB, 204 views)
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________

Last edited by Shaun : 2nd February 2020 at 12:01 PM.
Reply With Quote
  #6  
Old 2nd February 2020, 12:03 PM
Shaun Shaun is online now
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,522
Default

Had a couple errors in last file
Attached Files
File Type: xlsm UniTab Live Prices.xlsm (692.6 KB, 208 views)
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #7  
Old 2nd February 2020, 06:22 PM
Stix Stix is offline
Member
 
Join Date: Apr 2005
Posts: 3,026
Default

Quote:
Originally Posted by Shaun
Here is a sheet that will download current and paste races, there is code in there and other formulas that may help you, let me know if you need anything specific, this uses the old Qtab site so no idea how long this code will work.

Thanks very much Shaun, appreciate it!
__________________
Stix
.......Giddy Up..... !!
Reply With Quote
  #8  
Old 2nd February 2020, 07:00 PM
Shaun Shaun is online now
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,522
Default

Just made a modification and added some auto macro refresh code i found with an on and off button attached to F12
Attached Files
File Type: xlsm UniTab Live Prices Auto Refresh.xlsm (724.3 KB, 201 views)
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #9  
Old 3rd February 2020, 09:43 AM
michaelg michaelg is offline
Member
 
Join Date: Jan 1970
Posts: 2,814
Wink

Hi, Stix. Unfortunately it wasn't me who originally helped you as I know almost nothing about computers.

Good luck with your enquiry.
Reply With Quote
  #10  
Old 3rd February 2020, 01:58 PM
Shaun Shaun is online now
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,522
Default

final update of sheet posted here, will upload to my One Drive so i can make changes easier if needed.

The auto refresh is turned off by default in this version.
Attached Files
File Type: xlsm UniTab Live Prices Auto Refresh.xlsm (731.6 KB, 199 views)
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
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 11:03 AM.


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