Reading the Data Tape
How to read a loan tape, understand key data columns, and quickly filter a portfolio down to your investment criteria.
The data tape is the document every deal starts with. It is the spreadsheet a seller provides listing every loan available for purchase along with its loan-level details. The name dates back to when this information was encoded on magnetic tape. Today it arrives as an Excel file -- but the term stuck, and reading it correctly is the skill that separates informed buyers from time-wasters.
There is no industry standard format. Every seller uses their own column headers, abbreviations, and internal codes. A top-20 bank tape looks nothing like a secondary market trader's tape, and both look nothing like a retail marketplace listing. This lesson teaches you what to look for regardless of the source, how to filter a pool down to your investment criteria, and what red flags should stop you before you spend money on due diligence.
What a Tape Contains
A tape is simply a spreadsheet with one row per loan and columns of data describing each asset. A small pool from an individual seller might have 5 loans and 10 columns. A bank portfolio might contain 500 loans and 40+ columns -- many of which are internal fields that mean nothing to an outside buyer.
Your job is to identify the columns that matter for pricing, ignore the noise, and flag gaps where critical information is missing.
The Seven Need-to-Have Fields
These are the columns without which you cannot price a loan or proceed with due diligence. If any of these are missing, you either need to request the data from the seller or gather it yourself before submitting an offer.
| Field | Why It Matters |
|---|---|
| Loan number | The unique identifier that ties every piece of vendor data -- credit reports, BPOs, title reports -- back to the correct asset. If the seller does not provide one, create your own. |
| Lien position | First, second, or unsecured. This single field determines your entire pricing model, your legal remedies, and your risk profile. A second lien with no equity is a fundamentally different asset than a first lien with full collateral coverage. |
| Borrower name | You cannot verify whether a loan is secured, run a credit report, or initiate contact without knowing who owes the debt. |
| Unpaid principal balance (UPB) | The outstanding balance the borrower owes -- and the number your pricing is based on. Most offers are expressed as a percentage of UPB. |
| Property address | Required to determine what the collateral is worth, whether the property is occupied, and what state-specific regulations apply. Without an address, you cannot order a BPO, check tax status, or assess the local market. |
| Last payment date / next due date | Lets you calculate how many months delinquent the borrower is and whether the loan is approaching or past the statute of limitations for collections. |
| Payment amount and terms | For performing or re-performing loans, you need the monthly payment, interest rate, and remaining term to model cash flows. For NPLs, the contractual terms help you evaluate modification options. |
If a tape has all seven fields populated, you have enough to begin preliminary pricing. Everything else either accelerates your research or refines your numbers.
Nice-to-Have Fields
These fields save time but can be gathered independently: secured status scrub (DataTree), senior lien balance (credit report), property tax balance (county assessor), property type (Zillow or assessor), interest rate (collateral file), charge-off balance (calculate from UPB plus missed payments), fair market value (BPO or AVM), and occupancy status (Google Street View or drive-by). If the seller provides them, great -- they accelerate your analysis. If not, you can fill the gaps yourself.
Filtering by Your Buy Box
A tape with 100 loans does not mean 100 opportunities. Your buy box -- the set of criteria that defines what you will and will not buy -- is the filter that turns a raw tape into a shortlist of assets worth analyzing.
Common buy box parameters: lien position (firsts vs. seconds), geography (target states based on foreclosure timelines and legal environments), UPB range (what your capital can support), property type (SFR is the most liquid), payment status (performing vs. non-performing), and delinquency depth (six months of missed payments is a different asset than six years).
Be ruthless with your filter on the first pass. The goal is not to find reasons to buy every loan -- it is to eliminate the ones that clearly do not fit so you can focus your time and money on the ones that might.
Three Types of Tapes You Will Encounter
| Tape Type | What You Get | What Is Missing | Your Action |
|---|---|---|---|
| Bank tape | Borrower data, UPB, payment history, charge-off info, internal status codes | Property values, BPO data, senior lien balances, tax balances, clean vendor-ready data | Ask for a data dictionary; figure out the obvious on your own |
| Secondary market tape | Multiple identifiers, segmented portfolios, credit data with dates, senior lien status, FMV, origination details, tax balances | Even the cleanest tape disclaims accuracy | Shift from data gathering to data verification |
| Retail marketplace listing | Curated single-asset summary with performance status, lien position, UPB, LTV, terms | Bulk data -- does not scale for volume buyers | Watch for pricing anchored to the seller's original purchase price |
Bank tapes require the most cleanup. The UPB might be labeled "First Principal Balance" even on a pool of second liens because that is how the bank's system categorizes loans. Secondary market tapes from funds and aggregators are polished and buyer-friendly -- but "deemed accurate" is not the same as "guaranteed." Retail marketplace listings are the most accessible format for newer investors evaluating one deal at a time.
Using FIXnotes to Shortcut Tape Analysis
The FIXnotes marketplace presents loan data in a standardized, searchable format. Instead of receiving a raw spreadsheet and spending hours cleaning data, you can filter by lien position, state, property type, UPB range, and payment status directly on the platform. The asset-level data is already structured for buyer analysis, which collapses the time between "I received a tape" and "I know which loans to bid on."
This does not replace your own analysis. You still need to verify the data, run your pricing model, and conduct full due diligence on any loan you intend to purchase. But starting with clean, standardized data eliminates the most time-consuming step in the traditional tape review process.
Red Flags on Any Tape
Regardless of the format, certain patterns should trigger deeper investigation or outright skepticism.
| Red Flag | What It Means | What to Do |
|---|---|---|
| Missing or zero UPB | The core pricing metric is absent | Request the data; do not guess |
| No property address | You cannot value the collateral | Eliminate the loan until the address is provided |
| Last payment date more than 6 years ago | May be past the statute of limitations in many states | Research the applicable state statute before bidding |
| Lien position field is blank | You do not know what you are buying | Request clarification; never assume lien position |
| Active bankruptcy code | Complicates acquisition and limits collection options | Confirm status and chapter; consult counsel |
| FICO score with no date | A credit score from five years ago is nearly meaningless | Treat as directional only; order a fresh report |
From Tape to Offer
Reading the tape is step one. The workflow that follows turns raw data into actionable pricing:
- Confirm the seven need-to-have fields. Flag gaps immediately.
- Apply your buy box filter. Eliminate loans that do not fit your criteria.
- Classify by lien position. First liens and second liens require different pricing frameworks -- split them into separate working tabs.
- Calculate equity coverage. For firsts, subtract taxes from fair market value. For seconds, subtract the senior lien balance and taxes from FMV.
- Assess statute of limitations risk. Using the last payment date and the property state, determine collectibility.
- Flag red-flag loans. Some will be eliminated; others will need additional research that factors into pricing.
- Price and submit. The next lesson covers pricing methodologies in detail.
The tape gives you enough to decide whether a loan is worth investigating. It does not give you enough to fund a purchase. Your independent due diligence -- title, credit, property valuation, and collateral review -- is what protects your capital. The tape is the starting line, not the finish line.
Ask questions, share insights, and connect with 1,671+ note investors for free.