Auto Execute Bets-VBA-NZ TAB-Project
 

Hi Guys

I would like help to create a Macro that looks at an Excel Spreadsheet.

Accomplishes

1/ Logging into NZ TAB using A1 (User name) and A2 (Password)
2/ Looks at Cells B2 (Horse Number) and B2 ($ Bet Amount) and enters Values into appropriate box's on Web Page
3/ Then completes the Submit process

That's it.

I have found Code that fills in Username and Password for

https://www.tab.co.nz/racing/?action=schedule#

Bit clunky but the only one I could find that actually works, message box's disappear after 1 second but sometimes on first call I need to click 1st one, sure there's a better code.

And still can't get it to Actually Login "Click" / "Submit".

Things to look at

A/ Clicking correct Radio Button for selected horse B2 (Horse Number)

B/ Clicking Win or Place

C/ Entering Bet Amount in Bet Amount box B2 ($ Bet Amount)

D/ Clicking Login

E/ Clicking Submit Bet

8/ Clicking the final "OK"

I think that's about it

All that is needed is Tenacity knowledge and Skill : )

I will of course help where I can

One may need a NZ TAB account really, to go through whole process.

Regards

Mike

Mike
You might also post this in the General forum as there are people there who don't visit this forum who have excel knowledge.

Hiya,

Part of the way there with this attachment. Attempts to login (and fails if you're already logged in or the Try Again button is active due to a previously unsuccessful attempt). Specifies a Win bet, clicks the appropriate horse (without handling the error if it were scratched), enters a bet amount and....that's it.

Couldn't figure out how to click the Submit Bet button. They've hidden that one well. Or I'm tired. Pretty sure it might be both. And probably something to do with my lapsed coding skills.

I don't have an NZ TAB account, so my attempt to log in fails and it just fills out everything else anyway. I don't know if the source code would change on a successful log in.

You'll undoubtedly want to add another field to the spreadsheet indicating which race it is you want to bet on. Otherwise it just seems to go to the next race - which there isn't this time of night, in case anyone uses it before they click over until tomorrow.

(Effort somewhat due to SpeedyBen's earlier benevolence - it's a caring, sharing forum... :) )

Hi SpeedyBen

Ok will post in General Forum too will fix B2 to C2 as well Cheers : )


Hi WalkerMac

Tried spreadsheet

As is worked great

Put in real Username and Password, i'm 100% sure it worked first time but then tried again and now comes up with

"Object Doesn't Support This Property Or Method"

Mucked about with it but it didn't help, ha !

But very promising cool

Error checking to see if one is Logged in or not first, is a good idea i think.

Great stuff so far

Mike : )

Hey

Calling WalkerMac : )

Been mucking around with your code all weekend : ) all good learning a bit i suppose but can't get it to do what oi want : (

Any chance you could get the Code to just Fill in

Username
Pw
Win
Selection number
Bet Amount


Then i will click Login and Submit manually

If ya could that would be great my main man i owe ya : )

Respec

Mike : )

Sorry Mr Moderator I didn't Know : (

Hiya,

I've rewritten it properly, and commented liberally - so it should give you a better idea of what's going on (or how to fix it if I've stuffed it up).

Now it logs on if the username/password fields are visible, fills in the bet type and amount, selects the horse (so long as it isn't scratched - tried a couple of things but couldn't get it to work out automatically whether the horse was scratched or not) and then leaves you to click the Submit bet button.

Hi walkermac

Thanks matey

Gave that a Whirl

But : ) When i use my actual Username and Password it Logs in OK but doesn't select Win or Horse number or fill in Bet Amount.

Could you get it to only fill in the page as above and I'll click Login then Submit manually

Filling in the page is the pain : )

Hope that's OK

Know it would be a hassle to suss out whats going on without actually logging in and seeing process

I would be happy with that : )


Appreciate all process descriptions and time

You da man

Great stuff

Mike : )

Heya,

Since it works fine with an invalid username/password pair, I presume that a successful login alters the contents of the betting area (if not the actual layout, then the name/address of items on the page). Unfortunately it won't let me create an account so that I can check whether this is the case.

So, you have 2 options.

1. - Run the code while you're logged out and put a bogus username/password pair in your spreadsheet. This is what I can test and I can see that it works (at least until they change their code). It selects Win bet, it clicks on the horse checkbox (so long as it is running), and fills in the bet amount. When you click on the Submit Bet button manually, it gives you the opportunity to login, etc. Make your bet and click Log out afterwards. Not such a terrible way of doing things as it's probably not a good idea to leave a plaintext copy of your login details of your tab account lying around.

2. - I've commentated my code pretty heavily and explained how I was able to determine the names of items on the screen. Time for you to flap those wings and fly! ;) Log in to the NZ TAB site using the Google Chrome browser (it's easier) then right-click on the items you want to manipulate and select Inspect Element from the resulting pop-up menu. Then update the code to refer to the "name" parameter of these items instead of the existing ones (again, this is presuming that the names change dependent on whether the user is in a logged in or logged out state - if this isn't the case then I don't know how to fix it for you anyway! ;) )


Incidentally, after "horseSelection.click" in the code, add the following to click the Submit Bet button:

i = 0

While i < htmldoc.Links.Length

If htmldoc.Links(i).innerText = "Submit bet" Then
htmldoc.Links(i).Click
i = htmldoc.Links.Length
End If

i = i + 1
Wend

I'm positive I tried the exact same thing before but, with the javascript running it's a dynamic environment. Perhaps I tried it earlier than I should have - or I just made a typo or something.

Anywho, all that should be enough to get you over the line. Good luck! :D


...is what I wrote first.

But I couldn't leave it alone. Try changing all occurences of "htmldoc.forms(0).elements" to "htmldoc.forms(1).elements". It looks like the stuff we want to update is on forms(0) if we have made an unsuccessful login, and on forms(1) if we are yet to log in! Maybe it's the same for a successful login. Just keep incrementing that figure until it complains about it, I guess :)

Hi WM

Thanks for looking at it again

Will give those pointers a go, trial error type thing

Shall report soon be long

Cheers matey

Mike : )

Just curious here Keen2xL.
Are you trying to place bets unattended depending on odds or other variables before jump or just want to place bets via Excel for other reasons?

Hi blackdog1

Q:Are you trying to place bets unattended

Ans: No not unattended just nice to have a Macro fill in Web page for me from my excel sheet, so no errors as i do concentrate on the top 4 favourites which obviously change often and i do wait till the last minute and then i tend to panic in case i miss the jump and have made errors placing bets on the wrong horse Ha hate that, so yer Click Click Click Sweet done, is good.

I don't know why Internet Betting sites don't make these sort of tools readily available apart from Betfair software of course, but i can't figure all that out just want something simple.


: )

Cheers bro

Know what you mean, mucking about and missing to place a bet.
But it's only a small step from where you are to collect the odds and let Excel place the bet for you just in time? in other words running on auto?

Sorry don't ask how to do it, I know next to nothing of Excel I was just interested in what you were doing.

Good luck with it.

Hi Dudes and WM

My wings no work but

Found this Free Windows macro recorder that does the clicking where other macro doesn't.

Some might have it or similar already but below is the Web Address anyways page looks a bit dodgy if ya ask me but I've tried it and it's not blown up my comp (Yet !) Fingers crossed : )

Has YouTube demo on use by some guy he seems alright

http://freelabsonline.com/macro-recorder

Download link is right at the bottom of the page

Makes life easier ya know what i mean

Cheers

May the horse be with you

(OMG did i actually write that corny saying) yep : )

I'm sure it's a great boon to mankind but somehow I have this uneasy feeling?
I wait for more experienced computer users to have an opinion on this before I attempt to use it.

It Worked
 

Hi people

The logging in process and placing the bets worked very well thanks to Walkermac
I had to use a scheduled mouse recorder clicker it has a blue diamond as a emblem to click the popup confirmation box.

But now Internet explorer is obsolete so it doesn't work any more, i never used it alot just proof of concept with an incrementing betting system really, which i did : )

Understand it probably isn't a new concept

Favouite equal to and over $2.40
Target of $10 a win ?
Increase bet (Using specialised calculations in Excel) until Win

Return on investment is good
you can be wiped out but you can also make big bucks before that happens

Lifes a risk : )