Focus Ratings is a Uk and Irish Horse Racing ratings service designed to aid you and help you narrow the field so that you can concentrate on the real contenders. Our completely computerised analysis system selects the top three rated horses from each race and sends out the ratings every day at 10:00 a.m. Wonderful results and an excellent strike rate. Use Focus Ratings to win more money and make more profits from British and Irish Horse Racing. The only horse racing system you'll ever need.

Home

A disappointing day – 03-03-2013

Posted by Keith Eckstein on Mar 3, 2013 in News | 0 comments

Not such a great day for Focus Ratings today with only 1 winner in 17 races from the top rated horse.

However, the 9 winners from 18 races for the 2nd and 3rd rated horses wasn't too bad and 6 of those horses did come in at starting prices better than 4/1 (with two at 10/1!)

So, moving briskly on....

March Statistics

I have some statistics for March that you may be interested in.

And whilst you're busy perusing them I'll just wish you a good evening and hope for better results tomorrow.

// Winners from Top Rated...
$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=1 AND result!='NR'") or die(mysql_error());
$races = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=1 AND result=1") or die(mysql_error());
$wins = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT avg(price) as average_isp FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=1 AND result=1") or die(mysql_error());

while($row = mysql_fetch_array($rankresult))
{
$avg_isp = $row['average_isp'];
}

$avg_isp=round($avg_isp,2);

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=1 AND result>0 AND result $places = mysql_num_rows($rankresult);

$percentage=($wins/$races)*100;
$percentage=round($percentage,2);

$place_percentage=($places/$races)*100;
$place_percentage=round($place_percentage,2);

$a_races=$races;
$a_wins=$wins;
$a_places=$places;

echo "

Performance of the top rated horse...

echo "

"; echo ""; echo "";
echo "Wins";
echo "Win %";
echo "Places";
echo "Place %";
echo "Avg win ISP";
echo "";echo "
"; echo "";
echo "" . $wins . "";
echo "" . $percentage . "%";
echo "" . $places . "";
echo "" . $place_percentage . "%";
echo "" . $avg_isp . "";
echo "";echo "

Races

" . $races . "

// Winners from Second Rated...
$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=2 AND result!='NR'") or die(mysql_error());
$races = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=2 AND result=1") or die(mysql_error());
$wins = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT avg(price) as average_isp FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=2 AND result=1") or die(mysql_error());

while($row = mysql_fetch_array($rankresult))
{
$avg_isp = $row['average_isp'];
}

$avg_isp=round($avg_isp,2);

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=2 AND result>0 AND result $places = mysql_num_rows($rankresult);

$percentage=($wins/$races)*100;
$percentage=round($percentage,2);

$place_percentage=($places/$races)*100;
$place_percentage=round($place_percentage,2);

$b_races=$races;
$b_wins=$wins;
$b_places=$places;

echo "

Performance of the second rated horse...

echo "

Races

" . $races . "

// Winners from Third Rated...
$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=3 AND result!='NR'") or die(mysql_error());
$races = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=3 AND result=1") or die(mysql_error());
$wins = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT avg(price) as average_isp FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=3 AND result=1") or die(mysql_error());

while($row = mysql_fetch_array($rankresult))
{
$avg_isp = $row['average_isp'];
}

$avg_isp=round($avg_isp,2);

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=3 AND result>0 AND result $places = mysql_num_rows($rankresult);

$percentage=($wins/$races)*100;
$percentage=round($percentage,2);

$place_percentage=($places/$races)*100;
$place_percentage=round($place_percentage,2);

$c_races=$races;
$c_wins=$wins;
$c_places=$places;

echo "

Performance of the third rated horse...

echo "

Races

" . $races . "

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=1") or die(mysql_error());
$races = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND result=1 AND R4_status!=3") or die(mysql_error());
$wins = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT avg(price) as average_isp FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status!=3 AND result=1") or die(mysql_error());

while($row = mysql_fetch_array($rankresult))
{
$avg_isp = $row['average_isp'];
$avg_bsp = $row['average_bsp'];
}

$avg_isp=round($avg_isp,2);

$places=($a_places+$b_places);

$percentage=($wins/$races)*100;
$percentage=round($percentage,2);

$place_percentage=($places/$races)*100;
$place_percentage=round($place_percentage,2);

echo "

Performance of the top two rated horses...

echo "

Races

" . $races . "

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=1") or die(mysql_error());
$races = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT * FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND result=1") or die(mysql_error());
$wins = mysql_num_rows($rankresult);

$rankresult=mysql_query("SELECT avg(price) as average_isp FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND result=1") or die(mysql_error());

while($row = mysql_fetch_array($rankresult))
{
$avg_isp = $row['average_isp'];
}

$avg_isp=round($avg_isp,2);

$places=($a_places+$b_places+$c_places);

$percentage=($wins/$races)*100;
$percentage=round($percentage,2);

$place_percentage=($places/$races)*100;
$place_percentage=round($place_percentage,2);

echo "

Performance of the top three rated horses...

echo "

Races

" . $races . "

$rankresult=mysql_query("SELECT rp_race_number FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=1 AND result=1") or die(mysql_error());

$csf=0;

while($rank_row = mysql_fetch_array($rankresult))
{
$rp_race_number=$rank_row['rp_race_number'];
$csfresult=mysql_query("SELECT result FROM tbl_race_results WHERE rp_race_number='$rp_race_number' AND R4_status=2") or die(mysql_error());
while($csf_row = mysql_fetch_array($csfresult))
{
$race_result=$csf_row['result'];
if($race_result==2)
{
$csf=$csf+1;
}
}
}

echo "CSF = " . $csf . "
";

$rankresult=mysql_query("SELECT rp_race_number FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=1 AND result=2") or die(mysql_error());

$rcsf=0;

while($rank_row = mysql_fetch_array($rankresult))
{
$rp_race_number=$rank_row['rp_race_number'];
$csfresult=mysql_query("SELECT result FROM tbl_race_results WHERE rp_race_number='$rp_race_number' AND R4_status=1") or die(mysql_error());
while($csf_row = mysql_fetch_array($csfresult))
{
$race_result=$csf_row['result'];
if($race_result==2)
{
$rcsf=$rcsf+1;
}
}
}

$rcsf=$rcsf+$csf;

echo "Reverse CSF = " . $rcsf . "
";

$rankresult=mysql_query("SELECT rp_race_number FROM tbl_race_results WHERE MONTH(date)=3 AND YEAR(date)=2013 AND R4_status=1 AND result=1") or die(mysql_error());

$tri=0;

while($tri_row = mysql_fetch_array($triresult))
{
$race_result=$tri_row['result'];
if($race_result==3)

$tri=$tri+1;
}
}
}
}

echo "Tricast = " . $tri . "
";
?>

A disappointing day – 03-03-2013