Check security listing status when your Airtable tracker changes
After updating your tracking structure, confirm the listing status of securities your workflow depends on and surface any entries that need attention.
Trigger
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Action
Listing Status
Tool to fetch listing status of us stocks and etfs. use when you need active or delisted securities as of a date.
Why this helps
A changed research tracker can preserve outdated security assumptions unless someone remembers to verify whether a listing is active or delisted.
- Check active or delisted status for US stocks and ETFs.
- Use a specified date for the status lookup.
- Flag possible tracker follow-up without manually searching each symbol.
Setup
Build it in a few focused steps.
- 1Connect Airtable and Alpha Vantage once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name the listing check.
- 3Describe in one instruction which securities to check, the as-of date, and how to summarize any status needing attention.
- 4Pick the Airtable Base Schema Changed trigger and choose where run reports go.
- 5Test with one real schema change and verify the symbols and date in the report.
Questions about this workflow
Does this cover every global exchange?
The listed action checks listing status for US stocks and ETFs.
What date does the check use?
The action supports checking status as of a date. Specify the date or date-selection rule in the automation instruction.
Will a schema change tell Notis which securities to check?
Not necessarily. The event describes base schema changes, not a set of ticker symbols. Provide the symbols or a clear source rule in your prompt.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtable to Alpha vantage. A trigger fires from one place; an action lands in another.
Airtable triggers
Alpha vantage actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get All Commodities Price Index
Tool to retrieve the global price index of all commodities. use when you need monthly, quarterly, or annual aggregated price index data for commodities.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
ALUMINUM
Tool to fetch global aluminum prices. use when you need monthly, quarterly, or annual lme aluminum price data.
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Balance Sheet
Tool to return annual and quarterly balance sheets for a company. use when you need detailed fiscal statements for analysis.
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Brent Crude Oil Prices
Tool to fetch brent crude oil prices. use when you need daily, weekly, or monthly brent price data.
User Profile Changed
Triggers when the connected Airtable user's profile information changes.
Global Coffee Price
Tool to retrieve the global coffee price series. use when you need historical monthly, quarterly, or annual coffee prices.
View Created
Triggers when a new view is created in an Airtable base.
COPPER
Tool to fetch global price of copper in monthly, quarterly, and annual intervals. use when you need historical copper price series for analysis.
View Deleted
Triggers when a previously known Airtable view is deleted.
Corn
Tool to retrieve global price of corn in monthly, quarterly, and annual intervals. use after verifying api key when you need historical corn price data.
View Metadata Changed
Triggers when an Airtable view changes its name or type.
COTTON
Tool to retrieve global cotton prices in monthly, quarterly, and annual intervals. use when you need historical cotton price data.
Connect any two apps with Notis in the middle.
Airtable and Alpha vantage, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Alpha vantage.