How to Build Your Own Faith Screener in Excel (And Why You Shouldn't)

Every few months, someone asks me how to build a halal or Christian BRI screener in Excel. Usually it's a spreadsheet enthusiast who wants to understand the mechanics, or someone frustrated with existing tools. I respect the impulse. Understanding the underlying math is genuinely valuable.

This guide walks through how to actually do it, with real formulas. Then at the end, I'll tell you honestly why you probably shouldn't bother and what to use instead.

What you're actually building

A faith-based stock screener takes financial data and applies rules to determine compliance. The core components:

Data source: Where the financial data comes from
Sector filter: Industry codes to exclude
Ratio tests: Debt, interest income, impermissible revenue
Framework logic: Which thresholds to use
Output: Pass/fail verdict and details

Each of these has Excel implementations. None of them is technically hard. The hard part is getting good data.

Step 1: Data source

Excel can pull stock data several ways:

Google Finance via Google Sheets: The GOOGLEFINANCE function pulls basic price and fundamental data. Works, but limited fields (no sector revenue breakdowns, no detailed balance sheet items).

Manual data entry: Download financial statements from SEC EDGAR (for US stocks) or equivalent regulators elsewhere, and copy-paste into your spreadsheet. Accurate but painfully slow.

Excel's STOCKS data type: Excel 365 has a stocks data type that pulls basic data. Similarly limited to Google Finance.

Third-party add-ins: Services like Stockopedia, Morningstar, or YCharts have Excel plugins. Paid, sometimes expensive, but much more comprehensive.

API scraping: If you're comfortable with Power Query and APIs, you can pull from Alpha Vantage, Financial Modeling Prep, or other data APIs directly into Excel. Most powerful option but requires technical skill.

For this guide, I'll assume you're using a mix of GOOGLEFINANCE and manual entry for the detailed fields.

Step 2: Sector exclusion

Create a list of prohibited sectors based on your faith framework. For Islamic screening, this might include:

Alcoholic beverages
Tobacco
Conventional banking and insurance
Pork production
Gambling
Adult entertainment
Weapons manufacturing (depending on methodology)

Store this in a named range called prohibited_sectors. In a new column next to your ticker list, use a VLOOKUP or COUNTIF to flag matches:

=IF(COUNTIF(prohibited_sectors, [@sector]) > 0, "FAIL", "PASS")

For Christian BRI, substitute your prohibited list (abortion providers, pornography producers, etc.). For Catholic USCCB, your list will emphasize different concerns. The mechanics are the same; the list changes.

Step 3: Debt ratio test

Most Islamic screening methodologies test debt against market capitalization or total assets. Example formula for AAOIFI-style (debt to market cap under 33 percent):

=IF([@total_debt] / [@market_cap] < 0.33, "PASS", "FAIL")

For frameworks using 36-month average market cap (S&P Shariah, DJIM), you need to compute the rolling average separately:

=AVERAGE(OFFSET([@market_cap], 0, 0, -36, 1))

Then use that average in the ratio test. This requires you to have a history of monthly market cap data, not just the current value.

Step 4: Interest income test

Impermissible income under 5 percent of total revenue:

=IF([@interest_income] / [@total_revenue] < 0.05, "PASS", "FAIL")

Getting the interest income number accurately is harder than it sounds. It's not always broken out clearly in income statements. For non-financial companies, it's often hidden in "other income" or "non-operating income." You have to read the notes to financial statements to extract it.

Step 5: Illiquid assets / accounts receivable test

Different methodologies use different versions of this. AAOIFI might test accounts receivable to total assets under 70 percent. S&P Shariah tests accounts receivable to 36-month average market cap under 49 percent. FaithScreener handles these differences at runtime; in Excel, you pick one methodology and hard-code it.

=IF([@accounts_receivable] / [@total_assets] < 0.70, "PASS", "FAIL")

Step 6: Composite pass/fail

After all your individual tests, aggregate them into a single compliance verdict:

=IF(AND([@sector_test] = "PASS", [@debt_test] = "PASS", [@interest_test] = "PASS", [@receivables_test] = "PASS"), "COMPLIANT", "NON-COMPLIANT")

If any single test fails, the stock is non-compliant under that methodology.

Step 7: Purification calculation

For dividend purification, calculate the percentage of company income that's non-compliant and apply that to your dividend:

=[@dividend_received] * ([@non_compliant_income] / [@total_income])

This gives you the amount to donate to charity to purify the dividend.

The working spreadsheet

If you put all of this together, you have a functioning screener. Columns for each test, rows for each ticker, and a composite pass/fail at the end. For 10 or 20 stocks you track closely, it's workable.

For 100 stocks, it's tedious. For 1,000 stocks, it's impossible without automation. For 100,000 stocks, you're not using Excel.

The real problems with DIY

Now let me tell you why I don't recommend this for most people.

Data quality

Financial data sources disagree with each other, sometimes meaningfully. Total debt on one source might exclude operating leases that another source includes. Interest income might be reported differently. Market cap might be calculated with different share counts (basic, diluted, outstanding on record date, current outstanding).

Professional screening services normalize this. They have data engineering teams who reconcile sources and apply consistent definitions. Your Excel file doesn't.

When your spreadsheet says "debt to market cap = 32 percent," is that actually the right number? If the underlying data is off by 5 percent, your compliance verdict is wrong on every borderline stock.

Update frequency

Public companies report quarterly. If you're manually updating your spreadsheet, you're doing the data entry four times a year per stock. For 20 stocks, that's 80 data updates per year. For 100 stocks, 400 updates.

You will skip updates. You will forget. Your spreadsheet will drift from reality within a quarter or two and you won't notice until something embarrassing happens.

Methodology drift

Shariah methodologies evolve. AAOIFI updates standards periodically. DJIM adjusts their calculation methods. S&P Shariah makes changes. If your spreadsheet hard-codes 2023 methodology and it's now 2026, you're screening with outdated rules.

Professional tools update methodology continuously. Your spreadsheet only updates when you remember to update it.

Edge cases

Real companies have weird financial structures. Joint ventures, minority interests, discontinued operations, special purpose vehicles. Screening methodologies have rules for how to handle these. Those rules are complicated and your Excel formulas probably don't implement them correctly.

For most stocks, simple formulas work. For the 5 to 10 percent of stocks with complex structures, simple formulas produce wrong answers. You won't know which 5 to 10 percent until a scholar tells you your "compliant" holding wasn't actually compliant.

Time cost

Even if your spreadsheet is perfect, maintaining it takes hours per week. Those hours have value. If you're earning a professional salary, the time cost of maintaining a DIY screener exceeds the cost of a professional tool by an order of magnitude. This is just basic economics.

Methodology choice

Most DIY spreadsheets implement one methodology. Professional tools like FaithScreener let you toggle between AAOIFI, DJIM, MSCI Islamic, S&P Shariah, and FTSE Shariah at runtime. Implementing all five in your spreadsheet is a major project. Most people pick one and call it done.

When DIY is actually useful

I'm not saying spreadsheets are useless. There are specific cases where DIY is the right answer:

You want to learn the mechanics. Building a screener teaches you how the math actually works. That's valuable even if you never use your spreadsheet for real decisions.

You're a student or researcher. Academic work on Islamic finance or BRI sometimes requires custom methodology implementations that no commercial tool offers.

You have unusual criteria that no tool implements. If your personal values include screens that no commercial tool applies (maybe you want to exclude companies that do business in certain countries for political reasons), DIY is the only way.

You want to audit a commercial tool. Building your own screener for 10 stocks you care about lets you verify whether a commercial tool's answers match your expected numbers. Good sanity check.

You enjoy the process. Some people genuinely like spreadsheet work. If it's a hobby, have at it.

For everyone else, use a professional tool.

The honest recommendation

For 95 percent of faith-based investors, building your own screener in Excel is a bad use of time. The data is hard to source accurately, the maintenance burden is high, methodology implementation is error-prone, and commercial tools exist that are either free or cheap.

Here's what I'd actually do:

Use FaithScreener at faithscreener.com for free screening across 124,000+ stocks, 42 markets, and 9 frameworks.
For stocks you care about deeply, verify critical data points by pulling the financial statements yourself. This is a sanity check, not a replacement.
If you want to understand methodology, read the published standards (AAOIFI, DJIM, S&P Shariah) directly rather than reverse-engineering them in Excel.
Maintain a portfolio tracking spreadsheet for your actual holdings, but use the screener output as your compliance source of truth, not your own formulas.

This gets you the educational benefit of understanding the math without the maintenance burden of running your own screening infrastructure.

A working starter template

If you want to experiment anyway, here's a minimal viable Excel screener structure:

Column A: Ticker
Column B: Sector (pulled via GOOGLEFINANCE or manual)
Column C: Market Cap
Column D: Total Debt
Column E: Total Revenue
Column F: Interest Income
Column G: Accounts Receivable
Column H: Total Assets
Column I: Sector test (COUNTIF against prohibited list)
Column J: Debt ratio = D / C
Column K: Debt test = IF(J < 0.33, "PASS", "FAIL")
Column L: Interest ratio = F / E
Column M: Interest test = IF(L < 0.05, "PASS", "FAIL")
Column N: Composite = IF(AND(I, K, M), "COMPLIANT", "NON-COMPLIANT")

Fill this in for 10 test stocks with manual data from SEC filings. You'll learn a lot in the process. Then delete the file and use FaithScreener for your real decisions.

Verdict

Building your own screener in Excel is educational, labor-intensive, error-prone, and probably pointless for real investing decisions. Commercial tools have solved this problem better than you can.

If you want to understand the mechanics, build a small spreadsheet with 10 stocks as a learning exercise. If you want to actually screen your portfolio, use FaithScreener at faithscreener.com for free access to 124,000+ stocks, 42 markets, and 9 frameworks with professional data pipelines and methodology implementations. The combination of learning by doing plus using professional tools for real decisions is the smart move.

Common questions

Can I automate the data updates in Excel? Yes, with Power Query, API connections, and scheduled refreshes. This turns a manual project into a more automated one, but requires technical skill most people don't have.

What about Google Sheets? Same principles apply. Google Sheets has GOOGLEFINANCE which is convenient for basic data, but the detailed financial statement data you need for proper screening isn't available through simple functions.

Can I share my DIY screener with others? Yes, but you're exposing them to whatever bugs and methodology errors your formulas contain. Probably not a good idea.

What if I want to screen stocks no commercial tool covers? FaithScreener covers 124,000+ stocks across 42 markets. If your stock isn't in there, it's a thinly traded or obscure security where compliance data is hard to source regardless of tool choice.

Is there a pre-built template I can start from? You can find templates online, but most are outdated or use simplified methodologies. Better to build your own for learning purposes or use a real tool.

DIY is a valid learning exercise. It's a bad primary tool for real investing decisions. Use professional screeners (free or paid) and spend your Excel energy on portfolio tracking and personal finance management, not compliance data that's already been computed elsewhere.