Integration into Excel

[Vortech]

Does anyone know or can direct me to some content in regards to how one can integrate some of the neurals / don scott ratings from R&S into Excel.

The customised form guide doesn't list the CP ratings

Regards

[Shaun]

Here is a short course i did a few months back in getting webpages in to excel.

It will work with R&S on some of there pages but not all and they have a couple methods for displaying the page.

http://forums.ozmium.com.au/showthread.php?t=23333&page=1&pp=10

[Vortech]

Thanks Shaun.

I've done a little research into the results regarding the different neurals with comparison to unitab / don scott and can't find much information.

This is either one of two things
- the results aren't that great
- it hasn't been tested in much detail

The best free information on the net

[Shaun]

I have a few sheets based on the R&S website that i have created in the past for others that were after this type of info.

[Vortech]

Can I send you an email with my rules?

Regards

[Vortech]

Ok Found some information.

The Top CP on racing and sports is quoted to have a loss on turnover of 9%.

[Vortech]

My Selections today based on the theories of

a. DLS
b. Don Scott ratings
c. Weightings of Neurals
d. Careers Starts
e. Barriers

No Heavy tracks

AR7 - h5
PR2 - h1
PR5 - h2

[Toil]

Gud luck Vortech.

[Toil]

Thanx for sharing once again Shaun

[Vortech]

AR7 - h5
PR2 - h1
PR5 - h2[/QUOTE]
Average start today with one win and 2 placings

Trying my luck overseas

Durben 3 - 11
Lingfield 2 - 5
York 1 - 11
York 4 - 3
York 6 - 11

Due to the forum being as exciting as a nun going to a brothel these are my last tips and the rest will go out to my twitters followers.

[Toil]

Whats your Twitter name? is it Vortech?

[Vortech]

Toil I'm happy to send you the rules via email if you prefer?

[Toil]

Shaun, with that Racingfiles version 4, can you get tomorrows Data?

[Toil]

Thanks Vortech, my email is allanwilson at iinet dot net

[Shaun]

in earlier version i had it set to get those files but the issue was that Skyform were particular when and what they would list, so i removed it.

I may have another look at re adding it.

[Toil]

Yer I think Sky is a little more consistent now so might be worth putting it back in if you could please :)

[Shaun]

Ok done, it should work now.

[Toil]

Vortech did you try send me an attachment with that email? because the attachment failed, i ended up with a ATT00001.dat file 345 bytes in size.

I'm not sure if that email address accepts attachments as its just an email I still use from iinet when i was with them years ago you get to keep it for $25 a year.

I'm gonna set up new email now with the new isp i just joined.

[Toil]

Ok done, it should work now.

Sweet Shaun but it's not getting tomorrows Unitab ratings?

[Shaun]

i will look in to it.

[Shaun]

Where it should have the unitab rating just change the first part of formula to $AF$3 not $AG$3 then copy down.

[Vortech]

[QUOTE=Vortech]

Trying my luck overseas

Durben 3 - 11 - SCR
Lingfield 2 - 5 - SCR
York 1 - 11 - 1st 8.00
York 4 - 3 - 1st 1.20
York 6 - 11 - Unplaced

[Pete the punter]

Vortech

I have a excel file i use to consolidate data from R&S, then i paste it into a microsoft Access Database- you copy the data from R&S site then i have a macro button that pastes the data into the excel sheet. if you have anything in particular that you are after, i may be able to assist with what i have and modify to what you are after.
I currently get the Nuerals, Worksheet(DS ODDS) and Ratings pages

Pete

[Vortech]

Thanks Pete

Basically I have a log in to R&S and have a customised form guide which allows me to filter my 6 variables.

From there I have to manually load each meeting and check which horse gets all the ticks.

The filters include the CP rating out of Neurals, Don Scott FR, DLS, Career Starts, Barrier and track condition.

I would like to have a Macro dump all the data from all the meetings into a Excel sheet. I don't think its possible to list the selections based on my criteria.

Also I assume the DS FR and neurals change after scratchings?

[AngryPixie]

Due to the forum being as exciting as a nun going to a brothel these are my last tips and the rest will go out to my twitters followers.

It's the quiet ones you've got to look out for Vortech. I like your Twitter idea.

[Vortech]

Selections today

QR 1 h3
QR 6 h7
PR 4 h1
NR 7 h4
AR 7 h2

[Toil]

Where it should have the unitab rating just change the first part of formula to $AF$3 not $AG$3 then copy down.

Awesome Shaun, thanks.

[The Ocho]

Ok Found some information.

The Top CP on racing and sports is quoted to have a loss on turnover of 9%.
I don't suppose anyone has any stats for the other neural categories like CF, TIM, JA, TA, JT, CRS, etc?

[UselessBettor]

These are based on tatts prices. Results since August 2011 as per most of my data.

Disregard slightly wrong SQL.

Some of these races have more then 1 as the top, for example JA, JT, TA. You might get 3 or more horses with the same figure.

[The Ocho]

No worries UB.

[UselessBettor]

JA = loss OF 16.9%
CP= loss of 14.5%
CF= loss of 17.1%
Tim = Loss of 16.9%
JT = Loss of 16.9%

[The Ocho]

Ok thanks UB. Not so good now. :(

[Vortech]

Ok thanks UB. Not so good now. :(

Combined two for a break even.

[The Ocho]

Combined two for a break even.
What do you mean Vortech?

[Pete the punter]

I can understand that if you run data against one criteria you would most likely come out with a loss, but if you start mixing different criterias together you can turn things around and make a profit, I have been using some of the criterias below with others since mid April, currently I have had 32 selections, strike rate is running at 38% and the P.O.T is at 92% . The below post has each criteria as indiviual methods running at a loss, so the figures don't justify what Vortech may be using.

Pete

[Vortech]

Thats correct Pete,

Uselessbettor - at what time to you record the results for the top selection in each category; the night before or after scratchings?

Also does your testing include NZ and other international meetings?

Cheers

[UselessBettor]

Thats correct Pete,

Uselessbettor - at what time to you record the results for the top selection in each category; the night before or after scratchings?

Also does your testing include NZ and other international meetings?

CheersNight before.

No international markets, just Australian Markets.

The figures were also based on tatts figures so you can do a lot better using betfair/best tote.

[Vortech]

Selections today from Ipswich

Race 1 h4
Race 4 h6

[Toil]

I have a few sheets based on the R&S website that i have created in the past for others that were after this type of info.

Hi Shaun, do you have a sheet for getting the R&S Neurals?

[Vortech]

[QUOTE=Vortech]Selections today from Ipswich

Race 1 h4 1st - 3.60 unitab
Race 4 h6 4th

[Pete the punter]

Vortech,

I will have a look at the data extration this weekend, i assume based on your previous post that if the data is extracted, you may be able to filter some of the data in excel, if you want to, you can send me a sample of what your after to peter underscore is at tpg dot com dot au i will see if i can write some formulas to filter the data in excel

Pete

[Vortech]

Thanks Pete.

I have my rules (filters) just need a easier way to generate my selections. I'll send you through some data.
Regards