How to get Nasdaq Deficient and Delinquent Companies

Nasdaq-listed symbols currently flagged Deficient, Delinquent, Bankrupt, or related financial-status codes from the official symbol directory. nasdaqtrader.com is one page of it. A run reads that public list and saves one row per result.

One row per result

A row has Symbol, Company Name, Market Category, Financial Status. The columns are listed in the schema on this page.

New rows from that site

Each run reads nasdaqtrader.com again. Put it on a schedule and the next file is the latest rows from that site.

Nasdaq Deficient and Delinquent Companies in Excel, Sheets, or Power BI

The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.

Schema

Examples come from the actor sample, not a live result.

Name	Description	Example
`symbol`	Symbol	`AAME`
`companyName`	Company Name	`Atlantic American Corporation - Common Stock`
`marketCategory`	Market Category	`G`
`financialStatus`	Financial Status	`E`
`financialStatusLabel`	Financial Status Label	`Delinquent`
`isEtf`	Is Etf	`false`
`sourceUrl`	Source Url	`https://www.nasdaqtrader.com/dynamic/symdir/nasdaqlisted.txt`
`scrapedAt`	Scraped At	`2026-09-22T12:26:24+00:00`

symbolSymbolAAME
companyNameCompany NameAtlantic American Corporation - Common Stock
marketCategoryMarket CategoryG
financialStatusFinancial StatusE
financialStatusLabelFinancial Status LabelDelinquent
isEtfIs Etffalse
sourceUrlSource Urlhttps://www.nasdaqtrader.com/dynamic/symdir/nasdaqlisted.txt
scrapedAtScraped At2026-09-22T12:26:24+00:00