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 200, 50 ;
NHL Preview 2024-25 142 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  
201
StL
LW
23
38
6
3
9
0.24
-1
29
81
23
20
43
+
202
CBJ
RW
23
53
16
13
29
0.55
-3
6
81
21
22
43
+
203
Van
LW
26
79
16
17
33
0.42
14
20
82
19
24
43
$
204
Fla
C
28
69
20
21
41
0.59
17
100
70
18
25
43
$ +
205
Tor
W
29
80
9
38
47
0.59
10
118
81
13
30
43
Z
206
Ana
RW
35
63
18
18
36
0.57
-15
54
71
25
17
42
207
NYI
LW
29
73
24
18
42
0.58
-8
34
77
22
20
42
208
Wsh
LW
23
80
18
15
33
0.41
-20
34
82
22
20
42
209
Buf
RW
23
27
9
10
19
0.70
-1
8
73
18
24
42
$ + Z
210
Phi
LW
19
0
—
—
—
0.00
—
—
78
18
24
42
211
Ana
C
31
79
11
30
41
0.52
-20
86
76
15
27
42
212
Cgy
D
30
82
20
32
52
0.63
2
51
82
13
29
42
213
Ott
D
27
51
9
21
30
0.59
-3
22
72
10
32
42
+
214
Van
D
26
81
5
43
48
0.59
33
38
76
8
34
42
215
Buf
LW
19
71
11
19
30
0.42
-3
36
78
16
25
41
216
Pit
W
29
74
17
19
36
0.49
16
28
77
15
26
41
217
TB
C
32
80
11
22
33
0.41
-11
62
82
13
28
41
$
218
Fla
D
28
79
10
29
39
0.49
56
43
81
11
30
41
Z
219
CBJ
LW
24
75
18
16
34
0.45
-6
52
81
20
20
40
$
220
TB
C
29
82
24
22
46
0.56
-16
27
82
20
20
40
221
Col
W
28
80
17
23
40
0.50
-8
61
81
19
21
40
222
Mtl
LW
23
55
15
19
34
0.62
-11
18
78
18
22
40
+
223
Min
RW
32
76
23
32
55
0.72
13
12
70
16
24
40
224
VGK
W
33
76
13
27
40
0.53
3
18
74
16
24
40
$
225
Bos
RW
20
33
5
10
15
0.45
4
6
78
15
25
40
+ Z
226
Fla
C
23
78
13
22
35
0.45
19
46
80
15
25
40
Z
227
Tor
C
30
82
13
26
39
0.48
-9
69
80
15
25
40
228
Fla
D
30
67
8
23
31
0.46
-15
34
73
9
31
40
+
229
Edm
D
34
79
11
34
45
0.57
44
47
75
8
32
40
230
Cgy
D
27
78
9
30
39
0.50
-11
47
79
8
32
40
231
Buf
D
21
76
6
27
33
0.43
8
28
80
7
33
40
232
VGK
RW
22
82
16
12
28
0.34
-15
14
80
23
16
39
$
233
Buf
C
25
50
16
14
30
0.60
-6
22
58
20
19
39
+
234
Wpg
LW
32
77
18
16
34
0.44
12
34
80
20
19
39
235
Van
C
25
10
0
6
6
0.60
0
4
70
18
21
39
+
236
NYI
RW
33
82
30
24
54
0.66
-16
26
71
18
21
39
$
237
Ott
W
22
72
13
13
26
0.36
10
66
77
18
21
39
$ + Z
238
Dal
RW
22
1
0
0
0
0.00
0
0
80
14
25
39
$
239
Mtl
C
23
2
0
2
2
1.00
2
0
69
13
26
39
+
240
Sea
D
30
66
8
25
33
0.50
1
46
77
11
28
39
+
241
Phi
D
23
82
10
20
30
0.37
-13
44
82
11
28
39
$ Z
242
Col
RW
29
51
7
8
15
0.29
-1
4
74
19
19
38
$
243
Pit
LW
30
74
23
21
44
0.59
11
25
70
18
20
38
$ Z
244
Europe
RW
27
76
18
25
43
0.57
-5
22
75
18
20
38
$
245
Min
C
30
74
21
24
45
0.61
4
72
77
18
20
38
246
NJ
RW
31
81
14
23
37
0.46
13
33
82
15
23
38
247
Edm
RW
27
59
9
22
31
0.53
-10
16
75
14
24
38
$ +
248
Cgy
C
35
82
15
24
39
0.48
-4
24
82
13
25
38
249
Uta
W
30
82
13
32
45
0.55
-15
26
82
11
27
38
$
250
Edm
D
28
63
12
9
21
0.33
-2
44
77
10
28
38
+ Z