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 300, 50 ;
NHL Preview 2024-25 144 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  
301
Buf
D
23
73
11
18
29
0.40
0
53
74
12
20
32
$
302
Van
LW
22
65
5
11
16
0.25
-29
12
67
10
22
32
303
Car
D
30
81
6
31
37
0.46
21
8
80
6
26
32
304
Wpg
D
29
82
5
28
33
0.40
9
63
81
6
26
32
$
305
NYI
RW
26
0
—
—
—
0.00
—
—
80
17
14
31
$
306
Sea
LW
32
62
13
17
30
0.48
-15
24
65
15
16
31
+
307
Ret
RW
35
70
13
15
28
0.40
-22
27
74
15
16
31
$
308
Fla
LW
26
82
12
15
27
0.33
1
26
82
15
16
31
Z
309
Van
RW
29
68
10
17
27
0.40
17
41
78
13
18
31
310
Cgy
RW
24
63
8
16
24
0.38
14
109
72
12
19
31
311
Car
C
36
80
10
20
30
0.38
-14
44
79
12
19
31
312
Car
RW
32
82
14
18
32
0.39
-1
36
82
12
19
31
313
Wpg
C
31
81
12
23
35
0.43
17
57
82
11
20
31
314
Europe
LW
25
0
0
0
0
0.00
64
10
21
31
$
315
SJ
RW
19
0
—
—
—
0.00
—
—
70
9
22
31
316
Wsh
D
24
31
3
6
9
0.29
-7
18
75
5
26
31
$
317
Van
D
28
82
4
26
30
0.37
28
44
82
3
28
31
$
318
Sea
RW
23
61
13
6
19
0.31
6
24
75
15
15
30
$ +
319
LA
LW
28
82
20
21
41
0.50
3
47
79
15
15
30
320
Wpg
RW
30
82
11
16
27
0.33
14
6
75
13
17
30
$
321
Det
C
30
79
13
20
33
0.42
-2
26
80
12
18
30
322
CBJ
D
30
67
9
19
28
0.42
-10
51
72
8
22
30
+
323
Van
C
30
68
6
22
28
0.41
4
31
72
7
23
30
+
324
Det
D
21
16
1
1
2
0.13
0
4
77
6
24
30
325
Tor
D
33
80
9
23
32
0.40
10
76
81
5
25
30
Z
326
TB
D
35
74
3
29
32
0.43
19
31
75
4
26
30
327
Ott
LW
28
73
14
13
27
0.37
4
16
76
15
14
29
328
CBJ
LW
29
74
9
17
26
0.35
-5
75
77
12
17
29
329
Bos
RW
28
81
11
14
25
0.31
7
104
80
12
17
29
$
330
VGK
LW
26
72
8
11
19
0.26
-11
39
78
11
18
29
$
331
SJ
C
30
79
10
20
30
0.38
0
14
81
11
18
29
332
NJ
LW
35
51
12
11
23
0.45
-6
8
71
10
19
29
$ +
333
Edm
D
29
81
10
22
32
0.40
3
79
79
9
20
29
334
Bos
LW
22
16
1
3
4
0.25
-3
6
70
8
21
29
$
335
Col
D
26
59
3
15
18
0.31
0
10
70
6
23
29
+
336
Ott
D
23
71
2
22
24
0.34
5
12
76
4
25
29
Z
337
NYI
RW
23
75
15
10
25
0.33
2
14
79
16
12
28
$
338
Pit
LW
20
0
—
—
—
0.00
—
—
75
15
13
28
R
339
Col
RW
28
57
13
12
25
0.44
13
34
74
12
16
28
$ +
340
Europe
LW
33
70
9
15
24
0.34
8
20
74
12
16
28
$
341
NYR
C
23
44
8
4
12
0.27
-6
12
66
8
20
28
342
Phi
D
28
81
10
34
44
0.54
-20
48
81
8
20
28
343
Chi
D
20
76
5
10
15
0.20
-39
20
79
7
21
28
Z
344
Min
D
31
62
7
20
27
0.44
22
16
72
6
22
28
+
345
CBJ
D
27
82
5
27
32
0.39
-11
20
82
4
24
28
$
346
-
C
30
28
2
7
9
0.32
-7
7
72
15
12
27
$ +
347
Ret
LW
35
47
4
19
23
0.49
-14
25
65
12
15
27
+
348
Chi
C
36
74
17
20
37
0.50
-29
57
71
12
15
27
349
Buf
LW
32
69
14
18
32
0.46
-9
81
72
12
15
27
$
350
Tor
RW
33
52
10
11
21
0.40
16
18
76
12
15
27
+