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
  #11  
Old 7th March 2020, 06:48 PM
gsdanger gsdanger is offline
Member
 
Join Date: Jan 1970
Posts: 37
Smile Live Prices Auto Refresh for NSW TAB

Hi Shaun,
I have been using your excellent recent Unitab Live Price Auto Refresh spreadsheet as a basis for setting up my batch betting method into the QLD TAB.
I have not been able to find out from the QLD TAB if they have a batch betting option (have emailed them a couple of weeks ago, however, at this stage, nil response).
I have recently moved to QLD from NSW and as such, am using the QLD TAB instead of the NSW TAB ( had a NSW account, however, I closed it when I moved).
Can you set up a spreadsheet for the NSW Live Prices and Auto Refresh, just as you have for the unitab?
I have a feeling that the QLD TAB does not cater for batch betting, and if this is the case, I will have to open a new NSW TAB account and use their batch betting services.
I am not up to speed with the web importing aspect into excel, hence I seek your valued services to assist me in this endeavour.

Shaun, Thanks - In advance

Regards......gsdanger.
__________________
Garry D.
Reply With Quote
  #12  
Old 7th March 2020, 09:15 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,523
Default

Unfortunately this is the only site this type of VBA that i use can access, i do plan on working on a python script to access the NSW/Vic sites but haven't got around to it.

Depending on how you use the prices to determine your bets for NSW i can create a macro for this sheet that would generate a file that contained your bet strings for batch betting, it would require some setup at the beginning of the day and also loading the file to the site for each race, let me know your thoughts.
__________________
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
  #13  
Old 8th March 2020, 09:34 AM
gsdanger gsdanger is offline
Member
 
Join Date: Jan 1970
Posts: 37
Smile Live Prices Auto Refresh for NSW TAB

Hi Shaun,
Thanks for your prompt reply.
I have added to your Uni live prices spreadsheet so that it creates the betting strings for each, plus the amount to be wagered on each horse to return a profit (Dutch book), (when a certain criteria is met).

Some years ago, (5 or 6) when I had my NSW TAB account, I built a spreadsheet that did the above in the NSW TAB area. It worked very well.
I didn't have many bets per day (good thing), but I was managing to turn a profit 2 out of 3 days, and recovering any losses over time. However, the NSW TAB decided to update their web page and I lost all the web addresses associated to live prices, and price updates. With me being a numpty in regard to web stuff, I was rendered "Dead In The Punting Water" trying to use my spreadsheet.

The response I am waiting for from the QLD TAB in regards to the batch betting option availability will determine whether I pursue the batch betting option with the QLD TAB.

You say that you are looking at using the Python language in the future.
I have embarked on the same pathway, however, I am finding it quite confusing for this numpty, however I will persevere with the education with a hope of the penny dropping (in my mind) as to how to use it correctly.

Anyway Shaun, Thanks for the response.
Oh BTW, I am interested in sorting the unitab race info into race times format (earliest first etc...for Aus races, with an option for international races. Not easy, however, I will continue to fiddle with this option, hoping I will crack it eventually.
I can then use this list in the Uni Live Prices Auto Refresh spreadsheet instead of the drop down Venues and the additional race selection cell.
I can only dream...lol.

Thanks Shaun....Have a good day.

regards....gsdanger
__________________
Garry D.
Reply With Quote
  #14  
Old 8th March 2020, 12:30 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,523
Default

I know what you are saying for the website, NSW used to have a small program that could monitor a folder so when you added a file it would send it to there site, for some reason they only want this type of betting available to high turn over punters.

If you look at the One Drive in my signature you will find a file for python, it contains a starting point and might give you some ideas.
__________________
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
  #15  
Old 9th March 2020, 08:35 AM
gsdanger gsdanger is offline
Member
 
Join Date: Jan 1970
Posts: 37
Smile Live Prices Auto Refresh for NSW TAB

Thanks Shaun,
will do...
Are you still living in WA, or did you complete your move to QLD?
I remember some years ago you were contemplating the move.
Anyway Shaun, Thanks for your comments and direction.
If I manage to come up with some way of sorting the race time into earliest to latest, I will let this forum know.

Have a great day...
Regards
gsdanger
__________________
Garry D.
Reply With Quote
  #16  
Old 9th March 2020, 08:48 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,523
Default

Been in Queensland about about 7 years, even got married for the first time,lol.

I will also have a look at the race times when i get a chance.
__________________
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
  #17  
Old 9th March 2020, 09:08 AM
gsdanger gsdanger is offline
Member
 
Join Date: Jan 1970
Posts: 37
Smile Live Prices Auto Refresh for NSW TAB

Wow!
Time flies...Could've sworn your comments about moving to QLD was only a few years ago. I moved up here last June...Mom wants to be near the grand kids (son in Air Force).
Hey Shaun, how do I access your one drive in your signature block?
I remember I asked you this question in the past...Got to remember, I'm a bit of a numpty when it comes to probably obvious things like this...lol

regards...gsdanger
__________________
Garry D.
Reply With Quote
  #18  
Old 9th March 2020, 11:37 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,523
Default

Just click where it says "One Drive" under this post, should open up
__________________
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
  #19  
Old 9th March 2020, 01:58 PM
gsdanger gsdanger is offline
Member
 
Join Date: Jan 1970
Posts: 37
Smile Live Prices Auto Refresh for NSW TAB

Hi Shaun,
Numpty here again...
I cannot see the "One Drive" option anywhere under this post.
What am I doing wrong?....I'm sure it's a simple thing that I have not seen.
Please advise..

Kind Regards....gsdanger
__________________
Garry D.
Reply With Quote
  #20  
Old 9th March 2020, 04:38 PM
Surround Surround is offline
Member
 
Join Date: Sep 2005
Posts: 70
Default

It's right under Shaun's comments.....One Drive in blue for me anyway
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 08:08 PM.


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