Click the read on link below to view two videos that show you how to automate your betting using the Gruss Betting Assistant software.
Related posts:
Gruss Betting Assistant Videos
<< Spread Betting GreyHorse Bot >>
Previous post: Ten Tips for In Play Trading Part 2
Next post: Minimum Stakes
{ 2 comments… read them below or add one }
Hi. I’ve written a macro that is supposed to trade automatically. When the timer is on 00:00:00 the program is supposed to load the next race in the quickpick-list. The macro-code is in sheet1 under the Worksheet and Calculate. The piece of code that should tell the program to move on to the next race is:
If sheet1.Cells(2, 4) = “00:00:00″ Then
sheet1.Cells(2, 17) = “-1″
End If
where the sheet1.Cells(2, 4) is the timer-cell and the sheet1.Cells(2, 17) is the special trigger cell.
This doesn’t work, and I’m suspecting that the macro is not being run at all. I read somewhere that if I want the macro to run automatically every time the Excel spreadsheet is being loaded i should put the code under the ThisWorkbook, but that didn’t work. Where should I put the code, so it can be activated? Is the sheet1.Cells(x,x)-way of referencing correct?
And does the “00:00:00″-way of reading the timer-cell work. I would be thankful for some info on this beginner-stuff.
Hi Gustav
a few things that might be the problem
I have never been able to reference the timer value in the format described and have instead had to use an integer, usually I use the current time compared to the off time and if you take one from the pther you will get current time to off.
You may be able to use it the way you have by using =0
Also how is your macro triggered, do you use On-Calculate?
Depending on how your security is set up in Excel your macros may need to be activated each time you open the workbook.
The easist thing to do would be to write a simple macro taht said something like, on calculate sheet1.cells(1,1)=999 and then just do a calculation IE in any cell enter =a3+5 or something that causes the sheet to calculate
Then if the macro is being triggered A1 will be changed to 999
Hope that helps
Darren