 | 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 |
| Changing Language of Display |
| Hyper-Linking Records |
| Incremental Search |
| Editing Data |
| Handling Forms |
| Handling Grids |
| 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 |
| 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 |
| 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 |
| Linking Up Views |
| 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 |
| Excel Spreadsheet Features |
| Printing and Creating Reports |
| Multimedia Resources |
| 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) |
| 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 |
| 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 |
| Arithmetic Functions |
| 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 |
| 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 |
| License Agreement |