Docs Help

The GoogleTournament function returns live data for games occurring during the Men’s and Women’s NCAA Division I Basketball Championship. You can use this function to create your own brackets, then see your predictions evaluated in real time, as results from the games are returned.

• Year – the year of the tournament (2009 for this year). Note that this is different from the year the season starts.
• League – type “men” or “women,” depending on the version of the NCAA Division I Basketball Championship you're tracking.
• Round – the round of the tournament. Enter the number corresponding to each round. Use 65 for the play-in game, 64 for the Round of 64, 32 for the Round of 32, 16 for the Sweet 16, up to 2 for the Final.
• Slot – the slot within each round as it appears on the bracket, counting down beginning at the top of the left column and going down, then continuing at the top of the right column. For instance, in the Round of 64:
  • 1 is the game at the top left
  • 16 is the game at the lower left
  • 17 is the game at the top right
  • 32 is the game at the bottom right
• Statistic - enter any of the following strings to display the associated value:
  • Identifying the team:
    • "school" - the name of the school. For example, "Notre Dame."
    • "name" - the team name. For example, "Fighting Irish."
    • "shortname" - an abbreviation for the school. For example, "ND."
  • "seed" - the team's original seed within their region, which will be a number ranging from 1-16.
  • "record" - the team's record during the regular season
  • "score" - the final score for a single team
  • "date" - the day and time of the game
  • "location" - the city and state the game will be played in
• Team - In order to get a value for all of the statistic strings other than "date" and "location," you also need to specify the team. Just enter either of these options:
  • 1 or 2, indicating the top or bottom team as they appear on the bracket.
  • "W" or "L," indicating the winning or losing team.

For instance, if you'd like to display the name of the men's team appearing at the top of the 4th slot in the Round of 64, you'd use the following formula:

=GoogleTournament(2009, "men", 64, 4, "name", 1)

Check the GoogleTournament template we've added to our templates gallery.