How to get SEC Form 4 Insider Large Sells in Qlik

Rank recent SEC Form 4 open-market insider sells by dollar value: officer and director name, ticker, shares, price, USD value, Rule 10b5-1 plan flag, and EDGAR links. A run saves one row per result.

Set up the Apify actor

Apify is where this run is collected. An actor is the program that collects the rows. A task is that program saved with your settings, so the next section can ask for the latest rows. You need a free Apify account.

01
Open SEC Form 4 Insider Large Sells and click Try for free. Create an Apify account if you do not have one. The Free plan does not ask for a card.

You are on the input form. Keep the sample for this first run.

{
    "daysBack": 14,
    "minValueUsd": 50000,
    "maxItems": 10,
    "maxFilingsToScan": 80,
    "transactionCodes": [
        "S"
    ],
    "includeDirectors": true,
    "includeOfficers": true,
    "includeTenPercentOwners": false,
    "exclude10b51Plans": false
}

03
Leave the proxy setting as it is. Click Start and wait until the run says Succeeded.
04
Open Storage, then Dataset. You should see ticker, issuerName, insiderName, officerTitle.
05
When you want the real list, raise maxItems. The sample cap is only there so the first run stays small.
06
Go back to the input and choose Save as a new task. Name it after this list.
07
Open the task. Copy the task ID from the address bar. Excel, Sheets, Power BI, and the other guides ask for this ID.
08
On the task, open Schedules and add a weekly run if you want fresh rows. Each run pays the start charge and the charge for the rows. The amounts are in the price list on this page.
09
Open Settings, then API & Integrations, and copy an API token. Excel, Sheets, and the other guides put this token in a download link. Anyone with that link can download the rows, so treat it like a password.

How to set up in Qlik

Use the task ID and the API token from Set up the Apify actor, above.

01
In Qlik, choose Add data, then REST.

Paste this address. Replace TASK_ID and YOUR_TOKEN.

https://api.apify.com/v2/actor-tasks/TASK_ID/runs/last/dataset/items?format=json&clean=true&status=SUCCEEDED&token=YOUR_TOKEN

03
Load ticker, issuerName, insiderName, officerTitle, roles. The weekly schedule from Set up the Apify actor, above, refreshes the URL.

Schema

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

Name	Description	Example
`ticker`	Issuer trading symbol	`NVDA`
`issuerName`	Company name	`NVIDIA CORP`
`insiderName`	Reporting person	`Mark A. Stevens`
`officerTitle`	Officer title when present	`Director`
`roles`	Relationship flags	`["director"]`
`transactionDate`	Trade date	`2026-08-12`
`fileDate`	Form 4 filing date	`2026-08-14`
`transactionCode`	Form 4 code	`S`
`shares`	Shares sold	`120000`
`pricePerShare`	Price per share (USD)	`1.0794`
`transactionValueUsd`	Shares × price	`129528`
`is10b51Plan`	Rule 10b5-1 planned trade	`false`
`sharesOwnedAfter`	Shares still owned after	`500000`
`filingUrl`	EDGAR filing index	`https://www.sec.gov/Archives/edgar/data/…`
`scrapedAt`	Scrape timestamp (UTC)	`2026-10-21T12:00:00.000Z`
`sourceUrl`	Same as filing URL	`https://www.sec.gov/Archives/edgar/data/…`

tickerIssuer trading symbolNVDA
issuerNameCompany nameNVIDIA CORP
insiderNameReporting personMark A. Stevens
officerTitleOfficer title when presentDirector
rolesRelationship flags["director"]
transactionDateTrade date2026-08-12
fileDateForm 4 filing date2026-08-14
transactionCodeForm 4 codeS
sharesShares sold120000
pricePerSharePrice per share (USD)1.0794
transactionValueUsdShares × price129528
is10b51PlanRule 10b5-1 planned tradefalse
sharesOwnedAfterShares still owned after500000
filingUrlEDGAR filing indexhttps://www.sec.gov/Archives/edgar/data/…
scrapedAtScrape timestamp (UTC)2026-10-21T12:00:00.000Z
sourceUrlSame as filing URLhttps://www.sec.gov/Archives/edgar/data/…