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