Excel NLR ETF Dashboard

Thom Hartle – September 30, 2025

This post details an Excel dashboard for tracking the performance of the US stock holdings of the VanEck Uranium + Nuclear Energy ETF (symbol: NLR).

NLR invests in companies building nuclear plants and reactors, uranium miners, utilities generating nuclear electricity, and nuclear technology firms.

This table details NLR Holdings (Company Name, Ticker, Exchange, as of 9/24/2025)

NameTickerExchange
Oklo IncOKLONYSE (U.S.)
Constellation Energy CorpCEGNASDAQ (U.S.)
Cameco CorpCCJNYSE (U.S.) / TSX (Canada)
BWX Technologies IncBWXTNYSE (U.S.)
Centrus Energy CorpLEUNYSE American (U.S.)
NuScale Power CorpSMRNYSE (U.S.)
Denison Mines CorpDNNNYSE American (U.S.) / TSX (Canada)
Public Service Enterprise Group IncPEGNYSE (U.S.)
NexGen Energy LtdNXENYSE (U.S.) / TSX (Canada)
Uranium Energy CorpUECNYSE American (U.S.)
NAC Kazatomprom JSCKAPLondon Stock Exchange (LSE), GDRs
PG&E CorporationPCGNYSE (U.S.)
CGN Power Co Ltd1816Hong Kong Stock Exchange (HKEX)
Energy Fuels IncUUUUNYSE American (U.S.) / TSX (Canada)
Paladin Energy LtdPDNAustralian Securities Exchange (ASX)
Nano Nuclear Energy IncNNENASDAQ (U.S.)
ČEZ a.s.CEZPrague Stock Exchange
Yellow Cake PlcYCALondon Stock Exchange (LSE)
Fortum OyjFORTUMNasdaq Helsinki (Finland)
Kepco E&C (Korea)52690Korea Exchange (KRX)
CGN Mining Co Ltd1164Hong Kong Stock Exchange (HKEX)
Deep Yellow LtdDYLAustralian Securities Exchange (ASX)
Silex Systems LtdSLXAustralian Securities Exchange (ASX)
Encore Energy CorpEUNASDAQ (U.S.)
Boss Energy LtdBOEAustralian Securities Exchange (ASX)

At the end of this post are two downloadable Excel dashboards, one has an image background, and one has a black background.

The dashboards have two charts; the top chart is dynamically ranked displaying today's net percent change, and the bottom chart displays the dynamically ranked annual percent change.

f1

The top section of the quote display allows you to enter your own symbols.

The second section displays the stocks dynamically ranked by today's percentage net change. The third section displays the stocks dynamically ranked annual percent change.

f2

Quote data includes today's net change as a ratio to the 21-day Average True Range study. Next to today's traded volume is a column that calculates the ratio of today's volume versus the 21-day average of the volume. This ratio column gives you a sense of how active today's trading is relative to recent history. Readings of 100% and higher indicate active trading.

A key feature next to each company name is a link to Yahoo Finance. Clicking the News link will take you to the Yahoo page for that symbol. Note that this could take approximately 30 seconds to open in a browser. Turning off Extensions in your browser will make this happen faster.

If you open another Excel spreadsheet, then this dashboard will no longer be the active spreadsheet. The macro that updates the links and ranks the stocks by performance will stop. To start the macro, simply click the News toolbar button in the first column.

Requires CQG Integrated Client or CQG QTrader, data enablements for the NYSE and Nasdaq stocks. Excel 2016 or more recent locally installed, not in the cloud.

This post was assisted by AI and reviewed by Thom Hartle.

Downloads

Disclaimer

Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.