Risk-Dial Portfolio Builder Help

Turn a Fidelity stock screener export into a 20-stock portfolio at the risk level you choose. Load the file, set the dial, shape the sectors, and export the result to Excel.

Watch the walkthrough

2 minutes 39 seconds, with narration, an on-screen cursor and captions. It covers every control in the order you would use them.

Filmed with an earlier 85-stock screen of real companies. The sample files below are fictional, so the names and counts you see will differ from the video; the controls work the same way.

Narration: AI-generated voiceCaptions: turn on with the CC buttonDownload the MP4
Read the transcript

Introduction 0:00

The Risk-Dial Portfolio Builder turns a Fidelity stock screener export into a twenty-stock portfolio, at whatever risk level you choose. Everything runs in your browser. Here's how to use it.

Load your screener file 0:13

Click Load screener file, and choose the Excel file that Fidelity's stock screener exports. The app reads every tab and merges them by ticker. The header confirms the file name and how many tabs it found.

The stock funnel 0:27

The strip across the top is the funnel. Eighty-five stocks loaded. Eighty-three have an S and P quality score. Fifty-four passed every screen. And twenty were selected.

The risk dial 0:40

The risk dial runs from zero, conservative, to one hundred, aggressive. Drag it, type a score, or use the quick buttons. At ten, the portfolio's beta falls to about point six five. At ninety, it rises to about one point one. The colored band shows which level you are in.

Fixed or slider criteria 0:58

Every screen has a tag. Slider means the dial controls it. Fixed means it keeps your value. Max P E is fixed. Set it to thirty, and stocks above thirty times earnings, or with no earnings, drop out at every risk level. Here, fifty-five passing stocks become thirty-nine.

Score weights 1:18

Score weights rank the stocks that pass. Blue factors are defensive: quality, low beta, low volatility, value and yield. Red factors are growth: earnings growth, past returns and analyst sentiment. Turning the dial shifts weight from blue to red.

Sector allocation 1:35

Under Sector allocation, you can drop a sector, cap how many stocks it holds, or give it a target weight. Here, utilities get fifteen percent. The Sectors tab shows the result, with an orange tick at the target, and lists every criterion in use.

Sort, scroll and exclude 1:51

In Holdings, click any heading to sort, and click again to reverse. The ticker and company stay pinned while you scroll sideways. Click the X to exclude a stock. Verizon goes, and American Electric Power takes its place.

Full screen and methodology 2:06

The Full screen tab lists every stock in the file, with its score and the reason it was left out. Methodology and sources explains each criterion, its conservative and aggressive values, and the research behind it.

Export to Excel 2:21

When you are done, click Export to Excel. The workbook holds the portfolio with share counts per million dollars, the sector mix, the criteria, the methodology, and the full scored screen. Treat it as a starting point for review, not investment advice.

Quick start

Everything runs in your browser. The file you choose is read on your device and is not uploaded.

  1. Load your screener file.Click Load screener file… and pick the spreadsheet your Fidelity stock screener exports (.xls or .xlsx). The app reads every tab and merges them by ticker. The app opens empty. To explore first, use Try it in the app on one of the sample files.
  2. Check the funnel.The strip at the top shows how many stocks loaded, how many have an S&P Quality score, how many passed every screen, and how many were selected. An orange note lists any data the file lacks.
  3. Set the risk dial.Drag the slider, type a score from 0 to 100, or click a quick button. 0–14 is Conservative, 15–37 Moderately Conservative, 38–62 Moderate, 63–85 Moderately Aggressive, 86–100 Aggressive.
  4. Fix what you want held.Each criterion and score weight has a tag. slider means the dial sets it; 🔒 fixed keeps your value. Click the tag to switch. Number of stocks, max per sector and Max P/E start fixed.
  5. Shape sectors and holdings.Under Sector allocation, drop a sector, cap how many stocks it holds, or give it a target weight. In Holdings, click a heading to sort and ✕ to exclude a stock.
  6. Export.Click Export to Excel for a workbook with the portfolio, sector mix, criteria, methodology and the full scored screen. Prices come from your file, so check them against live quotes before you trade.

Sample screener files

Three fictional screener files you can load to see how the app behaves. Company names, tickers and figures are invented; the files copy the layout of a Fidelity stock screener export, saved as .xlsx so this page can serve them. Fidelity's own .xls files load the same way. Results below are what the app shows when the sample first opens.

1. Broad screen, 468 stocks

A broad screen: eleven sectors and every score factor. Beta is 3-yr; margin is net profit margin for the most recent quarter.

Tabs
5
Funnel
468 → 467 → 272 → 20
Beta
3-yr for all
Wtd beta
0.66
Try it in the app

2. Dividend payers, 85 stocks

A narrower screen, laid out like the one in the video. 5-yr beta and gross margin; no Interest Coverage on the scoring tabs.

Tabs
5
Funnel
85 → 83 → 47 → 20
Beta
5-yr (3-yr for 2 stocks)
Wtd beta
1.05
Try it in the app

3. Minimum columns (CSV)

30 stocks with only the columns the screens need. Most score factors are missing, so ranking leans on quality, beta, volatility and yield. Only 17 stocks fit within the screens and sector limits, so the app shows a warning.

Tabs
1 (CSV)
Funnel
30 → 30 → 18 → 17
Beta
5-yr
Wtd beta
0.95
Try it in the app

Try it in the app opens the app with that sample already loaded. To load it yourself instead, download it, open the app, click Load screener file… and choose the file.

File format

The app is built for Fidelity's stock screener export: an .xls or .xlsx workbook with one row per stock on each tab. It also reads CSV and other spreadsheets that use the same header names. Headers must match exactly. Rows without both a Symbol and a Company Name are skipped, which drops the notes Fidelity adds at the bottom of each tab. When a stock appears on several tabs, the first value found for each column is used.

What it isHeaderUsed for
Ticker requiredSymbolMerging tabs and identifying each stock.
Name requiredCompany NameDisplay. Rows without it are ignored.
S&P Quality requiredS&P Global Market Intelligence QualityQuality screen and score. Stocks without it are screened out.
Beta requiredBeta (5 Yr Annualized), else Beta (3 Yr Annualized), else Beta (1 Year Annualized)Beta screen and low-beta score. The app uses the longest one each stock has and tags shorter ones (e.g. "3Y").
Volatility requiredStandard Deviation (1 Yr Annualized)Std dev screen, low-volatility score and inverse-volatility weighting. Accepts 0.21 or 21%.
Market cap requiredMarket CapitalizationSize screen. Accepts $249.05B, $850M or $1.2T.
Sector recommendedSectorSector limits and targets. Missing sectors become "Unclassified".
Price recommendedSecurity PriceShares per $1M in the report and export.
Score factors optionalS&P Global Market Intelligence Financial Health, …Growth Stability, Interest Coverage (Most Recent Qtr), …Valuation, Dividend Yield, EPS Growth (Proj This Yr vs. Last Yr), Total Return (1 Yr Annualized), Total Return (3 Yr Annualized), Total Return (5 Yr Annualized), Equity Summary Score (ESS) from LSEG StarMine, PEG RatioScore weights. Any factor missing from the whole file is dropped and its weight shared among the rest; an orange note says which.
P/E optionalP/E (Price/TTM Earnings)The Max P/E screen and the report.
Profit margin optionalProfit Margin (TTM), else Profit Margin (Most Recent Qtr), else Gross Profit Margin (TTM)Shown in Holdings and the export, not scored. The column heading says Net margin, Net margin (MRQ) or Gross margin to match the file.
Other optionalIndustryShown in the export.

Frequently asked questions

No questions match. Try a shorter word.

The basics
What does the app do?

It screens the stocks in your file, scores the ones that pass, and picks the best-scoring 20 (or however many you set) within your sector limits. It then weights them by score and, toward the conservative end, by low volatility, keeping each position between a minimum and maximum weight.

Is my file uploaded anywhere?

No. The app reads the file and does all the math in your browser. Nothing is sent or stored. Reloading the page clears it.

Is this investment advice?

No. It is a quantitative starting point for review. Screener data is historical and delayed, and the cut-offs and weights are judgment calls. See the Methodology & sources tab in the app for where each one comes from.

The risk dial
What does the slider change?

Every criterion and score weight tagged slider. Each moves in a straight line between a conservative value at 0 and an aggressive value at 100. For example, max 1-yr std dev goes from 40% to 70%, the low-beta weight from 15 to 0, and the projected EPS growth weight from 0 to 15.

Conservative portfolios are ranked on quality, financial strength, interest coverage, low beta, low volatility, value and yield, with calmer stocks given bigger positions. Aggressive ones are ranked on earnings growth, past returns and analyst sentiment, with positions sized by score alone.

What is the difference between "slider" and "fixed"?

A slider item is reset every time you move the dial. A 🔒 fixed item keeps whatever value you gave it. Click the tag to switch. When you switch an item back to slider, it jumps to the dial's current value.

Number of stocks, default max per sector and Max P/E start fixed. Per-sector settings are never changed by the dial.

Why are Max beta, Min Quality and Financial Health different when the app first opens?

They open at their highest values (beta 2.0, quality 40, Financial Health weight 15) by design. The first time you move the dial, they switch to the dial's values. So the opening view is not the same as the dial's Moderate setting at 50.

Does "Moderate" mean the portfolio has moderate risk?

The label only names where the dial sits. Check the summary figures for the result, mainly the weighted beta and standard deviation. With sample 1, portfolio beta runs from about 0.3 at the conservative end to about 0.8 at the aggressive end.

Does P/E affect the risk level?

Not directly: Max P/E is fixed and starts at 0, meaning no limit. When you set it, stocks above the limit, or with no or negative earnings, are excluded at every risk level. P/E does enter the ranking indirectly through the Valuation weight (higher when conservative) and the Low PEG weight (higher when aggressive).

Files and data
Which file do I need?

The spreadsheet your Fidelity stock screener exports, with its Basic Facts, Performance & Volatility, Valuation and Analyst Opinions tabs. More columns give a richer score, but the app only needs the ones marked required in File format.

The orange note says some factors are "not in this file"

Your screener export didn't include those columns. The app drops those factors and shares their weight proportionally among the others, so scores still add up. To include them, add the matching columns to your Fidelity screen's views before exporting.

Why does a beta show "3Y" or "1Y"?

The 5-year beta wasn't available for that stock or that file, so the app used the 3-year, or failing that the 1-year. The note above the summary figures counts how many stocks use each basis, and the export has a Beta Basis column.

Can I use a file from another broker?

Yes, if you rename its headers to the ones in File format and save it as CSV or Excel. Sample 3 shows the minimum layout.

The portfolio
Why are there fewer than 20 stocks?

Not enough stocks passed the screens within the sector limits. A warning under the table says so. Loosen a screen (std dev, beta, market cap, quality or P/E), raise the max per sector, or include a sector you dropped.

Why isn't a particular stock in the portfolio?

Open the Full screen tab. Every stock has a status: Selected, or the reason it was left out, such as "Std dev > 55%", "No S&P Quality data", "Sector max reached" or "Passed screens; below cutoff".

How are the position weights worked out?

A blend of score and low volatility. At the conservative end half the weight comes from inverse volatility (calmer stocks get more); at the aggressive end it is all score. Each position is then held between the minimum and maximum weight, and the total scaled to 100%.

How do sector targets work?

A sector with a target gets exactly that share, split among its stocks in proportion to their weights. Sectors without targets share what is left. If targets add up to more than 100%, they are scaled down and a note appears. A target can push single positions above the per-stock maximum.

What does "At least one per included sector" do?

It guarantees a place for the best-scoring stock from each sector that has an eligible stock, before filling the rest by score. Turn it off for a pure score ranking. Setting a sector's Max to 0 also removes it.

How do I bring back a stock I excluded?

Delete its ticker from the Manual exclusions box. Clicking ✕ on a holding adds it to that box.

Output
What is in the Excel export?

Five sheets: Portfolio (holdings, weights, dollars and shares per $1M, all metrics, and a weighted-average row), Sector Mix, Criteria, Methodology and Full Screen Scored. The file name includes the dial score, e.g. Portfolio_Risk50_Moderate_20.xlsx.

Export to Excel doesn't download

The app asks you to confirm the download first; check for that prompt. Some embedded viewers block downloads. Use Copy as CSV and paste into a spreadsheet, or open the app in a regular browser tab.

Can I trade from the share counts?

Treat them as a guide. They use the prices in your screener file, which may be stale. Recalculate with live quotes and your actual account size before placing orders.