Introduction to RaceMate |
Main Features |
System Requirements |
Installing RaceMate |
Registering and Activating RaceMate |
Installing into More Than One Computer |
About Upgrading Windows |
Remarks about Inputting Chinese |
Release Notes |
What is New in RaceMate 11.5 |
What is New in RaceMate 10.5 |
What is New in RaceMate 10.0 |
What is New in RaceMate 9.8 |
What is New in RaceMate 9.5 |
What is New in RaceMate 9.0 |
What is New in RaceMate 8.0 |
What is New in RaceMate 7.0 |
Data Update |
Connecting to the Internet |
Dial-Up Connection |
Downloading Data |
Repeat Last Download |
Firewall Blocking |
Basic UI Techniques |
Using Menus and Toolbars |
Menus and Toolbars |
Moving Toolbars |
Changing Language of Display |
Hyper-Linking Records |
Incremental Search |
Editing Data |
Handling Forms |
Multiple Instances of a Form |
Freezing a Form |
Changing and Restoring Form Size |
Handling Grids |
Changing Column Width |
Changing Row Height |
Freezing Columns |
Changing a Column's Position |
Sorting Grid Columns |
Resetting Grid Layout |
Main Data Forms |
Record Tree Form |
Race Calendar Form |
Race Data Form |
Starter View Page (Race Data Form) |
Trackwork Page (Race Data Form) |
Allocation Page (Race Data Form) |
Flemming Page (Race Data Form) |
Dividends Page (Race Data Form) |
Remark Page (Race Data Form) |
Links Page (Race Data Form) |
Index Page (Race Data Form) |
Print Race Data (Race Data Form) |
Race Search Form |
Jockey Silks |
Horse Form |
Particulars Page (Horse Form) |
Pedigree Page (Horse Form) |
Past Record and Comprehensive Statistics for (Horse Form) |
Overseas Page (Horse Form) |
Wins Page (Horse Form) |
Trackwork (Horse Form) |
Links Page (Horse Form) |
Horse List Page (Horse Form) |
Jockey Form |
Past Record and Comprehensive Statistics (Jockey Form) |
Wins Page (Jockey Form) |
Particulars/Notes Page (Jockey Form) |
Links Page (Jockey Form) |
Jockeys List Page (Jockey Form) |
Stable Form |
Horses in Stable (Stable Form) |
Wins Page (Stable Form) |
Past Record and Comprehensive Statistics (Stable Form) |
Notes Page (Stable Form) |
Links Page (Stable Form) |
Stables List Page (Stable Form) |
Current Odds from Jockey Club |
Daily Track Work and Barrier Trial |
Barrier Trials (Daily Track Work Form) |
Barrier Trial Groups (Daily Track Work Form) |
Track Work (Daily Track Work Form) |
Links Page (Daily Track Work Form) |
Jump by Double-Clicking a Column |
Defining Double-Click Actions |
Forms and Record IDs |
Comprehensive Statistics and Record Query Form |
Views Management |
Type 1: Starter Views |
Defining Starter Views |
Creating Starter Views |
Modifying Existing Views |
View Header |
Example: Creating a Starter View |
Advanced Settings of View Columns |
Filtering Past Records |
Rearranging Position of Views in View List |
Exporting and Importing View Structures |
Copying a Starter View |
Show History in Starters Views |
History Tracks |
Sorting and Grouping |
Sorting in Individual History Groups |
Setting Values & Choosing MCL Variables |
Filtering Records in Starters Views |
Selecting Criteria |
Modifying Criteria and Setting Compound Filters |
Filter Editor |
Type 2: History and Statistics Views |
Types of History and Statistics Views |
Argument of History/Stat View |
Setting Data Range in an Argument |
Cache for View Data |
Conversion Tables |
Managing Conversion Tables |
Using Conversion Tables in Views |
Linking Up Views |
Linked Columns |
Exporting and Importing View Data |
MCL Variables in MCL Functions |
Introduction to MCL Variables |
Setting Values & Choosing MCL Variables |
Using MCL Variables As View Arguments |
MCL Variables to Set Data Range |
Built-in Views |
Built-in Starter Views |
All Distances WQP Stats View |
Jockey Change Statistics |
Excel Spreadsheet Features |
How to Create Complicated Formulae |
MCL Debugging |
Printing and Creating Reports |
Creating a Report for a View |
Report Designer |
Multimedia Resources |
Autolinks |
Managing Your Own Multimedia Resources |
Saving Web Video/Photo into Disk |
Statistics and Data Analysis |
Type 1: Comprehensive Statistics & Record Query |
Defining Structure of Statistics Views and Queries |
Statistical View and Record Filtering Results |
Editing View Particulars |
Editing View Column/Criteria Items |
Query Operators for Requirements |
Creating and Removing OR or AND Criteria Group |
Data Period and Display Mode |
Statistical Items - the [Stat] Column |
Viewing Past Records and Move Columns in Stat View Page |
Type 2: Statistics via Starter Views (Race Data Form) |
Betting Index |
Evaluating Accuracy of Prediction Models |
Example: Draw Position Statistics |
Basic Steps |
Statistical Groups |
Printing or Exporting Statistics |
Type 3: Simplified Statistics Form |
Exporting and Importing Data |
Exporting Simple Race Data |
Exporting Horse Data |
Exporting or Copying Grids Cells |
Exporting View Data |
Data Export via Starter Views |
Format of Exported Excel Files |
Importing View Data From Excel Files |
System Maintenance and Configuration |
Backing Up and Restoring User Data |
RaceMate Notice |
System Configurations and Information |
Options and System Information |
About RaceMate |
Clearing Cache Folder |
Upgrading RaceMate or Installing Add-Ins |
MCL Tutorial |
MCL Reference |
Arguments and Variables of MCL functions |
Optional Arguments |
Data Types of Arguments |
The nBackRaces Argument of an MCL function |
The fCondition Argument (MCL Condition) |
When to use the While keyword |
Quoted MCL Expression Arguments |
The DefaultVal Argument |
The cIncluding Argument |
Null Values |
Characteristics of Null Values |
Absence of Values |
Null Values in Statistics |
Propagation of Null Values |
Errors in MCL Formulas |
Information about a Start |
HrAge( ), JrAge( ), SrAge( ) |
HrAgeMonths( ), JrAgeMonths( ), SrAgeMonths( ) |
HrAllowance( ), JrAllowance( ), SrAllowance( ) |
HrBleedDate( ), JrBleedDate( ), SrBleedDate( ) |
HrBleedDateStr( ), JrBleedDateStr( ), SrBleedDateStr( ) |
HrBlinker( ), JrBlinker( ), SrBlinker( ) |
HrBlinkerAbbr( ), JrBlinkerAbbr( ), SrBlinkerAbbr( ) |
HrBlinkerAbbrNew( ), JrBlinkerAbbrNew( ), SrBlinkerAbbrNew( ) |
HrBlinkerNew( ), JrBlinkerNew( ), SrBlinkerNew( ) |
HrBodyWeight( ), JrBodyWeight( ), SrBodyWeight( ) |
HrClass( ), JrClass( ), SrClass( ) |
HrClassID( ), JrClassID( ), SrClassID( ) |
HrCurRating( ), JrCurRating( ), SrCurRating( ) |
HrDraw( ), JrDraw( ), SrDraw( ) |
HrEntriesWeight( ), JrEntriesWeight( ), SrEntriesWeight( ) |
HrFavorite( ), JrFavorite( ), SrFavorite( ) |
HrFinalOdds( ), JrFinalOdds( ), SrFinalOdds( ) |
HrFP( ), JrFP( ), SrFP( ) |
HrFPX( ), JrFPX( ), SrFPX( ) |
HrHorseNo( ), JrHorseNo( ), SrHorseNo( ) |
HrHorseNoStr( ), JrHorseNoStr( ), SrHorseNoStr( ) |
HrIsRunner( ), JrIsRunner( ), SrIsRunner( ) |
HrLastSectPos( ), JrLastSectPos( ), SrLastSectPos( ) |
HrLoadDiff( ), JrLoadDiff( ), SrLoadDiff( ) |
HrLoadDiffStr( ), JrLoadDiffStr( ), SrLoadDiffStr( ) |
HrMargin( ), JrMargin( ), SrMargin( ) |
HrMarginLen( ), JrMarginLen( ), SrMarginLen( ) |
HrMarginLenX( ), JrMarginLenX( ), SrMarginLenX( ) |
HrNetLoadDiff( ), JrNetLoadDiff( ), SrNetLoadDiff( ) |
HrOdds( ), JrOdds( ), SrOdds( ) |
HrOdds1Day( ), JrOdds1Day( ), SrOdds1Day( ) |
HrOdds5Min( ), JrOdds5Min( ), SrOdds5Min( ) |
HrOverweight( ), JrOverweight( ), SrOverweight( ) |
HrPastIncident( ), JrPastIncident( ), HrPastIncident( ) |
HrPlaceTickets( ), JrPlaceTickets( ), SrPlaceTickets( ) |
HrPositions( ), JrPositions( ), SrPositions( ) |
HrPrivilege( ), JrPrivilege( ), SrPrivilege( ) |
HrPrivilegeID( ), JrPrivilegeID( ), SrPrivilegeID( ) |
HrRunning( ), JrRunning( ), SrRunning( ) |
HrRacingWeight( ), JrRacingWeight( ), SrRacingWeight( ) |
HrRating( ), JrRating( ), SrRating( ) |
HrRatingDiff( ), JrRatingDiff( ), SrRatingDiff( ) |
HrReserved( ), JrReserved( ), SrReserved( ) |
HrSeconds( ), JrSeconds( ), SrSeconds( ) |
HrSectionPos( ), JrSectionPos( ), SrSectionPos( ) |
HrSectMargins( ), JrSectMargins( ), SrSectMargins( ) |
HrSectMargLens( ), JrSectMargLens( ), SrSectMargLens( ) |
HrSectMargLensX( ), JrSectMargLensX( ), SrSectMargLensX( ) |
HrSectPositions( ), JrSectPositions( ), SrSectPositions( ) |
HrSectTime( ), JrSectTime( ), SrSectTime( ) |
HrSectTimew( ), JrSectTimew( ), SrSectTimew( ) |
HrSpecialBit( ), JrSpecialBit( ), SrSpecialBit( ) |
HrSpecialBitAbbr( ), JrSpecialBitAbbr( ), SrSpecialBitAbbr( ) |
HrSpeed( ), JrSpeed( ), SrSpeed( ) |
HrStablePrefence( ), JrStablePrefence( ), SrStablePrefence( ) |
HrStartID( ), JrStartID( ), SrStartID( ) |
HrStartIDOn(), JrStartIDOn(), SrStartIDOn() |
HrStakes( ), JrStakes( ), SrStakes( ) |
HrTime( ), JrTime( ), SrTime( ) |
HrTimew( ), JrTimew( ), SrTimew( ) |
HrUpdown( ), JrUpdown( ), SrUpdown( ) |
HrUpdownID( ), JrUpdownID( ), SrUpdownID( ) |
HrWeight( ), JrWeight( ), SrWeight( ) |
HrWinTickets( ), JrWinTickets( ), SrWinTickets( ) |
HrWQPStat( ), JrWQPStat( ), SrWQPStat( ) |
Static information of Horse, Jockey, and Stable |
HrArrivalYear( ), JrArrivalYear( ), SrArrivalYear( ) |
HrBrandNo( ), JrBrandNo( ), SrBrandNo( ) |
HrBreedNote( ), JrBreedNote( ), SrBreedNote( ) |
HrCHorse( ), JrCHorse( ), SrCHorse( ) |
HrColor( ), JrColor( ), SrColor( ) |
HrCountryID( ), JrCountryID( ), SrCountryID( ) |
HrDam( ), JrDam( ), SrDam( ) |
HrDDam( ), JrDDam( ), SrDDam( ) |
HrDDDam( ), JrDDDam( ), SrDDDam( ) |
HrDDSire( ), JrDDSire( ), SrDDSire( ) |
HrDSDam( ), JrDSDam( ), SrDSDam( ) |
HrDSire( ), JrDSire( ), SrDSire( ) |
HrDSSire( ), HrDSSire( ), SrDSSire( ) |
HrEHorse( ), JrEHorse( ), SrEHorse( ) |
HrFoalDate( ), JrFoalDate( ), SrFoalDate( ) |
HrHorse( ), JrHorse( ), SrHorse( ) |
HrHorseID( ), JrHorseID( ), SrHorseID( ) |
HrHorseMarkNote( ), JrHorseMarkNote( ), SrHorseMarkNote( ) |
HrHorseNote( ), JrHorseNote( ), SrHorseNote( ) |
HrJockey( ), JrJockey( ), SrJockey( ) |
HrJockeyClass( ), JrJockeyClass( ), SrJockeyClass( ) |
HrJockeyEngAbbr( ), JrJockeyEngAbbr( ), SrJockeyEngAbbr( ) |
HrJockeyID( ), JrJockeyID( ), SrJockeyID( ) |
HrJockeyRetired( ), JrJockeyRetired( ), SrJockeyRetired( ) |
HrNoteMark( ), JrNoteMark( ), SrNoteMark( ) |
HrOrigin( ), JrOrigin( ), SrOrigin( ) |
HrOriginCategory( ), JrOriginCategory( ), SrOriginCategory( ) |
HrOwner( ), JrOwner( ), SrOwner( ) |
HrRetired( ), JrRetired( ), SrRetired( ) |
HrSameBlood( ), JrSameBlood( ), SrSameBlood( ) |
HrSDam( ), JrSDam( ), SrSDam( ) |
HrSDDam( ), JrSDDam( ), SrSDDam( ) |
HrSDSire( ), JrSDSire( ), SrSDSire( ) |
HrSex( ), JrSex( ), SrSex( ) |
HrSickHistory( ), JrSickHistory( ), SrSickHistory( ) |
HrSire( ), JrSire( ), SrSire( ) |
HrSSDam( ), JrSSDam( ), SrSSDam( ) |
HrSSire( ), JrSSire( ), SrSSire( ) |
HrSSSire( ), JrSSSire( ), SrSSSire( ) |
HrStable( ), JrStable( ), SrStable( ) |
HrStableAbbr( ), JrStableAbbr( ), SrStableAbbr( ) |
HrStableID( ), JrStableID( ), SrStableID( ) |
HrStableRetired( ), JrStableRetired( ), SrStableRetired( ) |
Track Work Information |
HrABTCount( ), JrABTCount( ), SrABTCount( ) |
HrActivity( ), JrActivity( ), SrActivity( ) |
HrTwResumeDate( ), JrTwResumeDate( ), SrTwResumeDate( ) |
HrBestGallopSect( ), JrBestGallopSect( ), SrBestGallopSect( ) |
HrBTrial( ), JrBTrial( ), SrBTrail( ) |
HrGallop1200Best( ), JrGallop1200Best( ), SrGallop1200Best( ) |
HrGallop1200Stat( ), JrGallop1200Stat( ), SrGallop1200Stat( ) |
HrGallop400Best( ), JrGallop400Best( ), SrGallop400Best( ) |
HrGallop400Stat( ), JrGallop400Stat( ), SrGallop400Stat( ) |
HrGallop800Best( ), JrGallop800Best( ), SrGallop800Best( ) |
HrGallop800Stat( ), JrGallop800Stat( ), SrGallop800Stat( ) |
HrGBTCount( ), JrGBTCount( ), SrGBTCount( ) |
HrRGBTCount( ), JrRGBTCount( ), SrRGBTCount( ) |
HrTwCount( ), JrTwCount( ), SrTwCount( ) |
Race and Meeting Information |
ComingDate( ) |
CurRunHorses( ) |
DateOfRace( ) |
HrAccSectionalTime( ), JrAccSectionalTime( ), SrAccSectionalTime( ) |
HrAccSectionalTimew( ), JrAccSectionalTimew( ), SrAccSectionalTimew( ) |
HrAveRating( ), JrAveRating( ), SrAveRating( ) |
HrClassGroup( ), JrClassGroup( ), SrClassGroup( ) |
HrCourse( ), JrCourse( ), SrCourse( ) |
HrCourseDist( ), JrCourseDist( ), SrCourseDist( ) |
HrCourseID( ), JrCourseID( ), SrCourseID( ) |
HrCupName( ), JrCupName( ), SrCupName( ) |
HrDate( ), JrDate( ), SrDate( ) |
HrDayNight( ), JrDayNight( ), SrDayNight( ) |
HrDayNote( ), JrDayNote( ), SrDayNote( ) |
HrDaysAgo( ), JrDaysAgo( ), SrDaysAgo( ) |
HrDistance( ), JrDistance( ), SrDistance( ) |
HrDistTrack( ), JrDistTrack( ), SrDistTrack( ) |
HrDvd( ), JrDvd( ), SrDvd( ) |
HrDvdPlace( ), JrDvdPlace( ), SrDvdPlace( ) |
HrDvdTrio( ), JrDvdTrio( ), SrDvdTrio( ) |
HrDvdWin( ), JrDvdWin( ), SrDvdWin( ) |
HrGoing( ), JrGoing( ), SrGoing( ) |
HrGoingAbbr( ), JrGoingAbbr( ), SrGroingAbbr( ) |
HrGoingID( ), JrGoingID( ), SrGoingID( ) |
HrIsTurf( ), JrIsTurf( ), SrIsTurf( ) |
HrLastSectionTime( ), JrLastSectionTime( ), SrLastSectionTime( ) |
HrLastSectionTimew( ), JrLastSectionTimew( ), SrLastSectionTimew( ) |
HrMeetingNo( ), JrMeetingNo( ), SrMeetingNo( ) |
HrPenetrometer( ), JrPenetrometer( ), SrPenetrometer( ) |
HrRaceClass( ), JrRaceClass( ), SrRaceClass( ) |
HrRaceID( ), JrRaceID( ), SrRaceID( ) |
HrRaceNoInMeeting( ), JrRaceNoInMeeting( ), SrRaceNoInMeeting( ) |
HrRaceNoInSeason( ), JrRaceNoInSeason( ), SrRaceNoInSeason( ) |
HrRaceNote( ), JrRaceNote( ), SrRaceNote( ) |
HrRacePrize( ), JrRacePrize( ), SrRacePrize( ) |
HrRaceRating( ), JrRaceRating( ), SrRaceRating( ) |
HrRaceRemark( ), JrRaceRemark( ), SrRaceRemark( ) |
HrRacesInMeeting( ), JrRacesInMeeting( ), SrRacesInMeeting( ) |
HrRaceTime( ), JrRaceTime( ), SrRaceTime( ) |
HrRunners( ), JrRunners( ), SrRunners( ) |
HrSeason( ), JrSeason( ), SrSeason( ) |
HrSeason2( ), JrSeason2( ), SrSeason2( ) |
HrSeasonRace( ), JrSeasonRace( ), SrSeasonRace( ) |
HrSectionalTime( ), JrSectionalTime( ), SrSectionalTime( ) |
HrSectionalTimew( ), JrSectionalTimew( ), SrSectionalTimew( ) |
HrSectionTime( ), JrSectionTime( ), SrSectionTime( ) |
HrSectionTimew( ), JrSectionTimew( ), SrSectionTimew( ) |
HrPowerFigure( ), JrPowerFigure( ), SrPowerFigure( ) |
HrPowerComments( ), JrPowerComments( ), SrPowerComments( ) |
HrTrack( ), JrTrack( ), SrTrack( ) |
HrTrackID( ), JrTrackID( ), SrTrackID( ) |
HrTrackPlus( ), JrTrackPlus( ), SrTrackPlus( ) |
HrTrackShift( ), JrTrackShift( ), SrTrackShift( ) |
HrWinner( ), JrWinner( ), SrWinner( ) |
HrWinnerID( ), JrWinnerID( ), SrWinnerID( ) |
HrWinSeconds( ), JrWinSeconds( ), SrWinSeconds( ) |
HrWinTime( ), JrWinTime( ), SrWinTime( ) |
HrWinTimew( ), JrWinTimew( ), SrWinTimew( ) |
IrregularRace( ) |
Data Collection Assistant Functions |
AtStart( ) |
Column( ) |
CurRun( ) |
GetColumn( ) |
HrData( ), JrData( ), SrData( ) |
HrHistoryList( ), JrHistoryList( ), SrHistoryList( ) |
IfAtTop( ) |
IfCurRun( ) |
RaceVar( ) |
StartVar( ) |
Statistics on Past Records |
HrAverage( ), JrAverage( ), SrAverage( ) |
HrAverageBy( ), JrAverageBy( ), SrAverageBy( ) |
HrAverageNZ( ), JrAverageNZ( ), SrAverageNZ( ) |
HrCount( ), JrCount( ), SrCount( ) |
HrCountBy( ), JrCountBy( ), SrCountBy( ) |
HrCountNZ( ), JrCountNZ( ), SrCountNZ( ) |
HrMaximum( ), JrMaximum( ), SrMaxmum( ) |
HrMaxStartID( ), JrMaxStartID( ), SrMaxStartID( ) |
HrMinimum( ), JrMinimum( ), SrMinimum( ) |
HrMinStartID( ), JrMinStartID( ), SrMinStartID( ) |
HrStatList( ), JrStatList( ), SrStatList( ) |
HrSum( ), JrSum( ), SrSum( ) |
HrSumBy( ), JrSumBy( ), SrSumBy( ) |
HrSumCount( ), JrSumCount( ), SrSumCount( ) |
HrXAverage( ), JrXAverage( ), SrXAverage( ) |
HrXMaximum( ), JrXMaximum( ), SrXMaximum( ) |
HrXMaxStartID( ), JrXMaxStartID( ), SrXMaxStartID( ) |
HrXMinimum( ), JrXMinimum( ), SrXMinimum( ) |
HrXMinStartID( ), JrXMinStartID( ), SrXMinStartID( ) |
HrXSum( ), JrXSum( ), SrXSum( ) |
StdTime( ) |
StdTimew( ) |
Statistics in a Race |
RunnersAvg( ) |
RunnersCnt( ) |
RunnersFind( ) |
RunnersList( ) |
RunnersMax( ) |
RunnersMin( ) |
RunnersSum( ) |
Arithmetic Functions |
Average( ) |
AverageNZ( ) |
Int( ) |
Maximum( ) |
Minimum( ) |
Over( ) |
Sum( ) |
String Functions |
At( ) |
Atc( ) |
Left( ) |
Like( ) |
LTrim( ) |
Occurs( ) |
Padr( ) |
Replicate( ) |
Right( ) |
StrExtract( ) |
SubStr( ) |
Trim( ) |
List Functions |
ListAscItem( ) |
ListAscVal( ) |
ListAverage( ) |
ListCol( ) |
ListColVal( ) |
ListCommon( ) |
ListCount( ) |
ListDescItem( ) |
ListDescVal( ) |
ListFilter( ) |
ListItem( ) |
ListSort( ) |
ListSortDesc( ) |
ListsortDescVal( ) |
ListSortVal( ) |
ListStdDev( ) |
ListSum( ) |
ListVal( ) |
RListItem( ) |
RListVal( ) |
Conversion Functions |
Cnv( ) |
Conv( ) |
DateStr( ) |
DToC( ) |
Evl( ) |
GCnv( ) |
GConv( ) |
QStr( ) |
NVL( ) |
SCnv( ) |
SConv( ) |
SToT( ) |
Str( ) |
StrDiff( ) |
TblAddVal( ) |
TblWrite( ) |
Transform( ) |
TToS( ) |
Val( ) |
Multimedia & Internet Functions |
HrBTVideo( ), JrBTVideo( ), SrBTVideo( ) |
HrPostRace( ), JrPostRace( ), SrPostRace( ) |
HrPreRace( ), JrPreRace( ), SrPreRace( ) |
HrPosPhoto( ), JrPosPhoto( ), SrPosPhoto( ) |
HrRaceReplay( ), JrRaceReplay( ), SrRaceReplay( ) |
HrRacingFocus( ), JrRacingFocus( ), SrRacingFocus( ) |
Miscellaneous Functions |
Box( ) |
Compare( ) |
Date( ) |
Edition( ) |
Empty( ) |
Gel( ) |
ICase( ) |
Iif( ) |
InList( ) |
IsNull( ) |
Join( ) |
Lang( ) |
Match( ) |
Month( ) |
Same( ) |
Season( ) |
Year( ) |
VFP Functions & Operators |
VFP Functions |
VFP Operators |
How To |
Find horses of this race met in past starts |
Find horses which win in 60 days after a stable change |
See performance enhanced by a stable change |
Questions & Answers |
Questions You May Asked After Upgrading to 9.0 |
How Can I Display Chinese in English Windows |
Chinese Characters Becomes Garbage |
RaceMate Frozen When Starter View Being Opened |
Technical Reference |
Data Range for Hong Kong Edition |
License Agreement |
© Welkin Systems Limited