PDA

View Full Version : Method_260 help needed


Toil
18th March 2012, 11:17 AM
I have been running this program for about a week now checking it out but yesterday it decided to stop working :S

But when i run it for the next day it works but it has a problem when you run it for the next day in that the 3LSV 2LSV LSV columns are blank or only show figures for 1 or 2 runners and this has always been the case, its no good running it for the next day as those 3 columns are vital to the ratings.

I have Provided an attachment of the original Method_260 Auto excel program

When i run it for today's date it immediately comes up with Run-time error '9': Subscript out of range.

And shows this:

Races 01 02 03 04 05 06 07 08 09 10 11 12
QR SUNSHINE COAST (QR) Fields 12:30 13:05 13:40 14:15 14:50 15:26 16:05 16:44
NR NOWRA (NR) Fields Abnd Abnd Abnd Abnd Abnd Abnd Abnd
VR CRANBOURNE (VR) Fields 54m 12:35 13:10 13:45 14:20 14:58 15:38 16:14
AR PT LINCOLN (AR) Fields 59m 12:40 13:15 13:50 14:25 15:04 15:42 16:18
CR TAREE (CR) Fields 12:20 12:55 13:30 14:05 14:40 15:16 15:54
PR MT BARKER (PR) Fields 14:54 15:34 16:10 16:48 17:25 18:05 18:45 19:25
ER WANGARATTA (ER) Fields 12:15 12:50 13:25 14:00 14:35 15:12 15:50 16:26
ZR HORSHAM (ZR) Fields 40m 12:22 13:00 13:31 14:08 14:42 15:19
SS KRANJI (SS) Fields 14:50 15:20 15:50 16:20 16:50 17:20 17:50 18:20 18:55 19:25 20:00 8:30
OS SHA TIN (OS) Fields 15:00 15:30 16:00 16:30 17:00 17:30 18:00 18:35 19:15 19:50
ZS ASCOT PARK (ZS) Fields 7,3,1 6,9,10 6,1,7 11m 47m 12:30 13:07 13:44
Trots 1 2 3 4 5 6 7 8 9 10 11 12
ORANGE (NT) Fields 12:44 1:21 1:58 2:34 3:14 3:44 4:12 4:45
BOORT (VT) Fields 12:24 12:59 1:34 2:09 2:44 3:20 3:58 4:38
MOTUKARARA (OT) Fields 18,5,9 7,11,8 16,10,4 13,6,9 0m 37m 12:16 12:53 1:30 2:07 2:42
MANAWATU (ZT) Fields 8,5,10 6,2,8 8,7,3 Interim 24m 12:07 12:44 1:21 1:58
LAUNCESTON (TT) Fields 4:51 5:20 5:47 6:12 6:35 7:00 7:20 7:42 8:05 8:25
Greyhounds 1 2 3 4 5 6 7 8 9 10 11 12
ALBION PARK (BG) Fields 5:06 F4 5:29 F4 5:44 F4 6:02 F4 6:22 F4 6:41 F4 6:57 F4 7:16 F4 7:39 F4 7:57 F4
SANDOWN PARK (MG) Fields 1:04 1:28 1:49 2:12 2:32 2:54 3:11 3:29 3:49 4:07 4:25
NOWRA (NG) Fields 5:01 5:16 5:39 5:57 6:17 6:32 6:53 7:11 7:34 7:53
SALE (VG) Fields 4:56 5:11 5:34 5:53 6:09 6:27 6:49 7:06 7:29 7:48
GAWLER (AG) Fields 4:43 F4 5:04 F4 5:27 F4 5:46 F4 6:08 F4 6:26 F4 6:48 F4 7:08 F4 7:31 F4 7:47 F4
CANBERRA (CG) Fields 4:37 4:55 5:14 5:36 5:55 6:16 6:40 6:59 7:19 7:38 7:55
HEALESVILLE (EG) Fields 12:27 12:49 1:13 1:35 1:56 2:19 2:39 3:04 3:24 3:41 3:57 4:17
CAMBRIDGE (ZG) Fields 32m 54m 12:23 12:39 1:00 1:16 1:37 1:53 2:14 2:29 2:48 3:07
MT GAMBIER (DG) Fields 29m F4 44m F4 12:13 F4 12:36 F4 12:57 F4 1:19 F4 1:41 F4 2:03 F4 2:24 F4 2:47 F4

Shaun
18th March 2012, 12:15 PM
This sheet is what i based my sheet on but i made a lot of changes because i didn't understand a lot of the coding.

Would it have to do with the races already have resulted or this has been fine in the past.

Toil
18th March 2012, 07:14 PM
This sheet is what i based my sheet on but i made a lot of changes because i didn't understand a lot of the coding.

Would it have to do with the races already have resulted or this has been fine in the past.

It automatically leaves out resulted races or does not rate them so yer has never been a problem.

I'm guessing tatts.com has made a change to the site for the days racing?

Toil
18th March 2012, 08:00 PM
It automatically leaves out resulted races or does not rate them so yer has never been a problem.

I'm guessing tatts.com has made a change to the site for the days racing?

Shaun any idea how Method_260 calculates the points for 3LSV 2LSV LSV columns?

Shaun
18th March 2012, 09:39 PM
If you go to the main sheet you can unhide all the columns to see how they do it all the figures are there.

This method has been around for about 5 to 10 years and was created well before they changed the site but was not automated back then Kennedy 20654 or what every his name was on here automated it but can't remember if that was before or after the site change.

I know he changed the form to The Tote because unitab restricted access to members only.

At one point i was going to re-create the ratings system using my methods of race extraction, i know the macros are not that advanced just things i haven't used before, if i get time i might try and understand it as i have learned a bit between this and now.

It may have been the number of races that put the system out maybe this needs to be changed, it may need this increased.

Toil
19th March 2012, 10:39 AM
Shaun, its running fine today, so you think it could't handle the number of races on the last few days?

Shaun
19th March 2012, 11:50 AM
That's my guess, so you need to find where it decides about races and change it, might be something set at 8 i would say as a guess.

Shaun
19th March 2012, 01:56 PM
I will have to have a look at the ratings they use, i compared some of todays races with what mine produced and mine were more accurate, that's a good sign for me.

That last race in Hamilton they had.


BICKLEIGH VALE 4.93
LARCH 4.96
FLYING HUSSLER 5.55

I had
3 Larch 2.53
7 Flying Hussler 2.53
10 Via Dubai 5.85


This was close but the prices were way off, there have been other races worse than this.

Armidale 4 lowest price is 6.01 same selection order as mine but i have it rated 2.84

Toil
19th March 2012, 02:15 PM
That's my guess, so you need to find where it decides about races and change it, might be something set at 8 i would say as a guess.

That's weird because it rated the 10 races at Bunbury on thursday, well it left race 1 blank as it already went.

Maybe its the total number of races for the whole day it struggles with?

I'll have a look.

Toil
19th March 2012, 02:30 PM
I changed Global Races(1 To 100) As String to 200 so hopefully that will fix it because there was like 104 races on friday and like 176 both saturday and sunday lol.

Shaun
19th March 2012, 02:55 PM
Maybe it skipped a few races Friday.

Shaun
28th March 2012, 04:26 PM
From what i have heard with the sale of the Tote to Tatts that the form this program uses is no longer available.

Have not tested it only heard it mentioned on another forum.

Toil
28th March 2012, 05:02 PM
Yer very dissapointing :/

Which forum was that Shaun?

Was making some use from this program too :S

Maybe you can get it back up and running shaun? using some other data? might take a while though :S

Or maybe you could incorporate some of the features into your Consensus Worksheet? Only things I'm using from Method_260 atm is the 3LSV 2LSV LSV and LSD + / - columns.

Today alot of columns got nothing and other columns the same thing.

This is from today

Age Bar Wt / Min 3LSV 2LSV LSV Days Ago L/S B/M $$$$ u/d/s LSD + / - W/100? P100? RATING VALUE
0 12 5 40 0 s 1550 n n 3 $34.50
0 1 5 40 0 s 1550 n n 10 $10.42
0 7 4 40 0 s 1550 n n 8 $13.16
0 10 4 40 0 s 1550 n n 6 $17.87
0 3 3.5 40 0 s 1550 n n 11 $8.93
0 9 3.5 40 0 s 1550 n n 7 $13.70
0 6 2.5 40 0 s 1550 n n 11 $8.93
0 8 1 40 0 s 1550 n n 13 $7.76
0 2 1 40 0 s 1550 n n 17 $5.92
0 4 1 40 0 s 1550 n n 16 $6.41
0 5 0 40 0 s 1550 n n 17 $5.92

Shaun
28th March 2012, 09:30 PM
Betfair forum.

Not to hard to duplicate the ratings i think, i will have a look when i get some time.

yes a pity they did that i was thinking of converting my ratings sheet to that form as it downloaded nicely, never mind.

Toil
29th March 2012, 04:43 PM
sweet