How to download nba references as csv file

Worksheet is invalid syntax. However, using ActiveSheet can have many traps, although in a few select cases it's absolutely necessary. This is not one of them. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 4 years ago. Active 4 years ago. Viewed 1k times. My code I've attempted with is giving the error Run-time error '': Object Required I'm guessing it's because it's not in a.

Worksheet Debug. Print PrimaryWB. Name Debug. Print DataWS. Name End Sub My active window is the. Improve this question. Community Bot 1 1 1 silver badge. The TeamID of the team assocated with this outcome where applicable. The PlayerID of the player assocated with this outcome where applicable. GlobalTeamID from The GlobalTeamID of the team assocated with this outcome where applicable.

SportsbookUrl from BettingResultTypeID from BettingResultType from The string identifier of the BettingResultType of this outcome e. BetValue from ActualValue from BettingMarketTypeId from BettingBetTypeId from BettingPeriodTypeId from BettingMarketSplitID from Name of Betting Outcome Type e. Home, Away, Under, Over. BetPercentage from MoneyPercentage from LastSeen from The details of the quarters associated with this box score. The name of the operator who is running contests for this slate.

The name of the slate assigned by the operator. Whether this slate uses games that take place on different days. The game type of the slate.

The positions that need to be filled for this particular slate. The salary cap for the current slate is null for slates with no salary cap such a Tiers gametypes. The player's eligible positions for the contest assigned by the operator. The player's salary for the contest assigned by the operator.

The player's eligible positions to be played in the contest assigned by the operator. Indicates the game's status. The timestamp of when the record was last updated US Eastern Time. The current quarter in the game. PointSpread from The oddsmaker Point Spread at game start from the perspective of the HomeTeam negative numbers indicate the HomeTeam is favored, positive numbers indicate the AwayTeam is favored. OverUnder from AwayTeamMoneyLine from Money line from the perspective of the away team.

HomeTeamMoneyLine from Money line from the perspective of the home team. A globally unique ID for this game. A globally unique ID for the away team. A globally unique ID for the home team. The money line payout odds when betting on the away team with the point spread. The money line payout odds when betting on the home team with the point spread.

Indicates whether the game is over and the final score has been verified and closed out. The details of the quarters including overtime periods for this game. NeutralVenue from OverPayout from UnderPayout from CrewChiefID from UmpireID from RefereeID from AlternateID from DateTimeUTC from SeasonType from Season Type e. Preseason, Regular Season, Postseason. Day from BettingMarketSplits from The Betting Markets included in this game that have splits.

The calendar year of the season during which this game occurs. Score of the home team updated after game ends to allow for resolving bets. Score of the away team updated after game ends to allow for resolving bets. Total scored points in the game updated after game ends to allow for resolving bets. List of Alternate Market GameOdds from different sportsbooks such as 1st-half, 1st-qtr, etc.

The sportsbook's point spread payout for the home team. The sportsbook's point spread payout for the away team. The sportsbook's total points scored over under for the game. The market type of the odd ex: live, pregame, 1st-half, 2nd-quarter. The player's preferred hosted headshot URL.

The last updated date of the player's preferred hosted headshot. The last updated date of the player's hosted headshot. The player's transparent background hosted headshot URL. The last updated date of the player's transparent background hosted headshot. Team from FirstName from LastName from Position from Starting from Indicates whether this player is in the starting lineup or on the bench. Confirmed from Indicates whether Starting status has been confirmed for this player.

UpcomingGame from TeamTrends from TeamMatchupTrends from OpponentMatchupTrends from PreviousGames from The brief title of the news typically less than characters. The terms of use with using this news item, credit must be given to the originator of the story when specified in the terms of use.

Comma delimited meta tags describing the categories of this content. OriginalSource from The original source who broke this news before it was picked up by the publisher of this blurb.

OriginalSourceUrl from Indicates which position is included in opponent stats that are aggregated together. A globally unique ID for this team.

The aggregated season stats for this team's opponents. Indicates whether the game is over and the stats for this player have been verified and closed out. Indicates whether player is starting, active, or inactive. PlayID from QuarterID from The unique identifier of the Quarter that this play occurred in. QuarterName from Sequence from The order in which this play happened over the course of the game.

TimeRemainingMinutes from The number of minutes remaining in the Quarter when this play completed. TimeRemainingSeconds from The number of seconds remaining in the Quarter when this play completed. PotentialPoints from The points that would have been potentially scored by the shot attempt if any. Points from ShotMade from Category from The category the play. Type from The type of the play. OpponentID from Opponent from ReceivingTeamID from ReceivingTeam from Description from The PlayerID of the primary player on this play if any.

AssistedByPlayerID from The PlayerID of the player who got a field goal assist on this play if any. BlockedByPlayerID from The PlayerID of the player who blocked the field goal attempt on this play if any. FastBreak from SideOfBasket from The side of the basket that the field goal was attempted from if any. Create a free Team What is Teams? Collectives on Stack Overflow.

Learn more. Asked 5 years, 10 months ago. Active 5 years, 10 months ago. Viewed 4k times. Improve this question. Matt Kyriediculous Kyriediculous 99 2 2 silver badges 12 12 bronze badges.

Add a comment. Active Oldest Votes. Improve this answer. Martin Evans Martin Evans