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
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.
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.
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.
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 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 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.
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 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.
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.
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.
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.
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.
Everything runs in your browser. The file you choose is read on your device and is not uploaded.
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.
A broad screen: eleven sectors and every score factor. Beta is 3-yr; margin is net profit margin for the most recent quarter.
A narrower screen, laid out like the one in the video. 5-yr beta and gross margin; no Interest Coverage on the scoring tabs.
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.
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.
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 is | Header | Used for |
|---|---|---|
| Ticker required | Symbol | Merging tabs and identifying each stock. |
| Name required | Company Name | Display. Rows without it are ignored. |
| S&P Quality required | S&P Global Market Intelligence Quality | Quality screen and score. Stocks without it are screened out. |
| Beta required | Beta (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 required | Standard Deviation (1 Yr Annualized) | Std dev screen, low-volatility score and inverse-volatility weighting. Accepts 0.21 or 21%. |
| Market cap required | Market Capitalization | Size screen. Accepts $249.05B, $850M or $1.2T. |
| Sector recommended | Sector | Sector limits and targets. Missing sectors become "Unclassified". |
| Price recommended | Security Price | Shares per $1M in the report and export. |
| Score factors optional | S&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 Ratio | Score weights. Any factor missing from the whole file is dropped and its weight shared among the rest; an orange note says which. |
| P/E optional | P/E (Price/TTM Earnings) | The Max P/E screen and the report. |
| Profit margin optional | Profit 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 optional | Industry | Shown in the export. |
No questions match. Try a shorter word.
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.
No. The app reads the file and does all the math in your browser. Nothing is sent or stored. Reloading the page clears it.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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.
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".
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%.
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.
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.
Delete its ticker from the Manual exclusions box. Clicking ✕ on a holding adds it to that box.
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.
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.