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 350, 50 ;
NHL Preview 2024-25 145 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  
351
StL
C
28
67
14
15
29
0.43
17
16
73
11
16
27
$ +
352
Mtl
LW
21
23
4
5
9
0.39
-2
0
74
11
16
27
+
353
Wsh
D
26
82
14
27
41
0.50
-30
60
69
9
18
27
$
354
NJ
LW
33
71
11
20
31
0.44
-9
37
73
9
18
27
+
355
Buf
D
24
65
5
16
21
0.32
11
66
74
8
19
27
Z
356
NYR
LW
22
81
13
8
21
0.26
-3
56
79
15
11
26
$
357
Wsh
LW
28
49
15
8
23
0.47
4
10
59
12
14
26
+
358
Phi
RW
23
57
11
12
23
0.40
1
10
66
12
14
26
Z
359
SJ
C
24
42
2
7
9
0.21
-10
23
77
12
14
26
360
NYR
LW
32
57
4
11
15
0.26
-3
12
69
10
16
26
+
361
Wsh
LW
27
60
5
12
17
0.28
-8
8
70
10
16
26
$ + Z
362
Uta
C
24
67
8
18
26
0.39
8
50
75
10
16
26
$ +
363
NYI
C
31
82
11
22
33
0.40
-8
13
78
10
16
26
364
Bos
D
23
41
4
9
13
0.32
-2
18
71
8
18
26
$ Z
365
NJ
D
20
60
3
16
19
0.32
-7
33
71
5
21
26
366
SJ
D
25
55
3
20
23
0.42
3
16
72
4
22
26
+
367
Wsh
D
24
68
3
20
23
0.34
-13
24
75
4
22
26
+ Z
368
Europe
D
25
76
3
17
20
0.26
5
36
77
4
22
26
$
369
StL
D
23
12
0
2
2
0.17
-3
0
77
4
22
26
Z
370
Wpg
D
31
82
3
28
31
0.38
46
36
82
4
22
26
371
Mtl
LW
30
78
9
11
20
0.26
-18
74
73
15
10
25
372
Uta
LW
28
74
21
8
29
0.39
-2
35
76
14
11
25
$
373
StL
LW
25
82
14
7
21
0.26
-3
30
81
12
13
25
$
374
StL
RW
32
76
22
23
45
0.59
11
59
60
11
14
25
$ Z
375
Edm
W
20
1
0
0
0
0.00
0
0
63
11
14
25
R
376
Dal
LW
26
77
9
15
24
0.31
0
29
80
11
14
25
$
377
Ott
C
35
82
15
16
31
0.38
-1
32
82
11
14
25
$
378
Chi
C
28
78
12
18
30
0.38
-14
26
68
10
15
25
$
379
Buf
C
25
81
12
18
30
0.37
10
10
82
10
15
25
$
380
NJ
LW
24
76
7
18
25
0.33
-11
41
82
10
15
25
381
Buf
LW
27
67
10
18
28
0.42
11
64
64
9
16
25
$
382
Mtl
D
22
70
6
16
22
0.31
-8
56
74
7
18
25
+
383
StL
D
31
82
10
16
26
0.32
4
23
81
7
18
25
384
LA
D
21
16
2
4
6
0.38
-6
10
65
5
20
25
385
Det
D
32
76
6
25
31
0.41
3
35
73
5
20
25
386
Dal
D
30
82
5
21
26
0.32
17
12
82
4
21
25
$
387
SJ
C
21
7
0
0
0
0.00
-1
0
75
11
13
24
388
Sea
C
31
67
5
10
15
0.22
-23
12
76
10
14
24
+
389
Pit
C
26
62
7
8
15
0.24
11
20
71
9
15
24
+
390
Min
D
34
16
0
5
5
0.31
5
2
66
6
18
24
+
391
Tor
D
23
51
3
8
11
0.22
-22
16
70
6
18
24
392
Ana
D
23
71
2
15
17
0.24
-24
24
74
5
19
24
393
Mtl
D
28
73
4
16
20
0.27
7
44
76
5
19
24
394
Sea
D
22
36
1
8
9
0.25
-5
20
79
5
19
24
$
395
NYR
D
28
77
6
17
23
0.30
9
28
80
5
19
24
$
396
SJ
D
26
78
3
18
21
0.27
-38
36
80
5
19
24
397
NYR
D
27
82
3
22
25
0.30
-5
65
82
4
20
24
$
398
Mtl
RW
32
77
16
15
31
0.40
-24
74
62
10
13
23
399
TB
W
25
54
7
10
17
0.31
11
18
71
10
13
23
$
400
Uta
LW
32
66
7
9
16
0.24
2
51
78
10
13
23
$ +