SELECT nhl_players.last_name , nhl_players.first_name , nhl_players.player_id , nhl_players.birth_date , FLOOR(DATEDIFF('2024-10-10', nhl_players.birth_date) / 365) AS age , nhl_players.rookie , IF(nhl_players.player_id in (0), 'UFA', nhl_teams.team_code) AS team_code , nhl_positions.position_abbreviation , nhl_career_stats_skaters.team_code_finished , spofo_mag_projections.mag_top400_rk AS db_rank , ed_sportscodes.tsf_global AS tsf_global , (spofo_mag_projections.g + spofo_mag_projections.a) AS predicted_points , spofo_mag_projections.g AS predicted_goals , spofo_mag_projections.a AS predicted_assists , spofo_mag_projections.gp AS predicted_GP , IF(nhl_career_stats_skaters.gp IS NULL, '0', nhl_career_stats_skaters.gp) AS actual_GP , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.g) AS actual_goals , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.a) AS actual_assists , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.pts) AS actual_points , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.plus_minus) AS actual_plus_minus , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.pts / nhl_career_stats_skaters.gp) AS actual_pts_per_gp , IF(nhl_career_stats_skaters.gp IS NULL, '—', nhl_career_stats_skaters.pim) AS actual_pim , spofo_mag_projections.injury_concern , spofo_mag_projections.must_draft , spofo_mag_projections.contract_year , spofo_mag_projections.fantasy_tags_gte FROM spofo_mag_projections LEFT JOIN nhl_players on nhl_players.player_id = spofo_mag_projections.player_id LEFT OUTER JOIN nhl_career_stats_skaters ON nhl_career_stats_skaters.player_id = spofo_mag_projections.player_id AND (nhl_career_stats_skaters.date_desc = '2023-24' AND nhl_career_stats_skaters.league = 'NHL' AND nhl_career_stats_skaters.date_sort = '2023.9' AND nhl_career_stats_skaters.line_desc = 'normal') LEFT JOIN ed_sportscodes ON spofo_mag_projections.player_id = ed_sportscodes.tsf AND ed_sportscodes.league_id = 'hockey' LEFT JOIN nhl_positions ON nhl_players.position_1 = nhl_positions.position_id LEFT JOIN nhl_teams ON nhl_players.team_id = nhl_teams.team_id WHERE TRUE AND spofo_mag_projections.season = '2024-25' AND spofo_mag_projections.gp IS NOT NULL AND spofo_mag_projections.mag_top400_rk < 401 AND nhl_positions.position_abbreviation != 'G' ORDER BY spofo_mag_projections.mag_top400_rk ASC LIMIT 0, 50 ;
NHL Preview 2024-25 138 SportsForecaster.com
Top 400 Skaters
Get spreadsheets at SportsForecaster.com

$→ Contract year • +→ Injury concern • K→ Must-draft player • Z→ Sleeper • R→ Rookie

Ages as of October 10, 2024

2023-24 2024-25 Forecast
  Name Team Pos Age GP G A P P/GP +/- PIM GP G A P  
1
Edm
C
27
76
32
100
132
1.74
35
30
81
43
103
146
K
2
Col
C
29
82
51
89
140
1.71
35
42
80
56
73
129
K
3
TB
RW
31
81
44
100
144
1.78
8
22
82
39
88
127
K
4
Edm
C
28
81
41
65
106
1.31
26
76
82
57
69
126
K
5
Dal
RW
27
80
42
62
104
1.30
19
50
82
48
64
112
$ K
6
Bos
RW
28
82
47
63
110
1.34
21
47
82
49
58
107
K
7
Fla
RW
26
80
26
62
88
1.10
19
88
81
40
64
104
K
8
Tor
C
27
81
69
38
107
1.32
31
20
79
62
40
102
K
9
VGK
LW
27
69
26
59
85
1.23
21
18
81
34
66
100
$ + K
10
NYR
LW
32
82
49
71
120
1.46
18
24
82
35
62
97
K
11
Van
C
25
82
34
55
89
1.09
20
12
82
36
60
96
12
Tor
RW
28
82
40
58
98
1.20
1
24
82
42
53
95
K
13
Col
D
25
77
21
69
90
1.17
15
16
80
24
71
95
K
14
TB
C
28
81
46
44
90
1.11
-16
14
81
49
45
94
K
15
Dal
LW
25
82
29
51
80
0.98
19
22
81
36
58
94
16
Min
LW
27
75
46
50
96
1.28
11
36
82
51
42
93
K
17
Car
C
27
78
36
53
89
1.14
34
36
80
38
54
92
18
Ott
C
22
75
18
52
70
0.93
-17
28
80
38
54
92
19
Nsh
LW
30
82
48
46
94
1.15
16
43
79
41
49
90
20
Pit
C
37
82
42
52
94
1.15
7
40
80
37
53
90
$ K
21
NYR
W
31
81
37
66
103
1.27
32
58
81
31
59
90
22
NJ
C
23
62
27
47
74
1.19
-12
12
75
34
55
89
+ K
23
NJ
RW
26
82
27
56
83
1.01
-6
12
82
30
58
88
24
Edm
D
24
81
18
64
82
1.01
34
32
82
21
67
88
$ K
25
Nsh
D
34
82
23
62
85
1.04
12
45
82
20
67
87
K
26
Uta
LW
26
78
33
43
76
0.97
-20
32
82
36
50
86
27
StL
C
25
82
26
60
86
1.05
9
48
80
29
56
85
28
Van
D
25
82
17
75
92
1.12
38
38
82
14
71
85
K
29
Fla
C
29
73
23
57
80
1.10
33
24
75
26
58
84
K
30
Wpg
LW
27
65
34
27
61
0.94
-6
6
82
43
40
83
+
31
Edm
RW
32
80
54
23
77
0.96
36
48
78
43
39
82
32
TB
LW
30
67
30
47
77
1.15
25
22
77
42
40
82
+
33
Ott
LW
25
81
37
37
74
0.91
1
134
82
40
42
82
34
Nsh
W
34
79
40
41
81
1.03
-21
34
82
37
45
82
35
Mtl
C
25
82
33
44
77
0.94
-14
36
82
35
47
82
36
Wpg
C
31
74
25
47
72
0.97
19
57
80
28
53
81
37
NYR
C
31
81
26
46
72
0.89
15
30
82
32
48
80
38
Dal
C
27
80
30
35
65
0.81
26
22
79
31
49
80
39
Dal
C
21
82
32
33
65
0.79
14
38
82
40
38
78
$
40
Min
RW
23
75
29
40
69
0.92
5
48
80
36
42
78
41
Det
RW
22
82
31
41
72
0.88
-12
30
81
36
42
78
42
NJ
C
25
71
27
40
67
0.94
-5
12
80
30
48
78
+
43
VGK
C
27
63
31
37
68
1.08
4
27
70
36
41
77
+
44
StL
RW
26
82
31
36
67
0.82
-12
22
80
36
40
76
45
Det
C
28
68
33
36
69
1.01
5
39
75
35
41
76
+
46
Chi
C
19
68
22
39
61
0.90
-44
28
81
31
45
76
+ K
47
NYI
C
27
80
23
57
80
1.00
-4
34
81
24
52
76
48
LA
LW
28
82
29
44
73
0.89
1
62
82
34
41
75
49
StL
W
29
80
27
36
63
0.79
3
48
81
32
43
75
50
Car
RW
22
81
33
34
67
0.83
23
14
81
35
39
74