Log daily Finance exchange rates to Google Docs
How this automation works
Track notable stock price drops automatically in Airtable. This Applet runs when your selected stock’s closing price falls by the percentage you specify after markets close, adding a record with the stock’s details to your chosen Airtable base. Perfect for investors who want to monitor performance or log buying opportunities digitally.
If
Trigger ingredients
StockName
StockTicker
Price
InfoUrl
CheckTime
PercentageChange
Then
Action fields
base_id
table_id_or_name
record_content
You might also like...
-
12.5K
-
-
Log daily stock closing prices to Google Docs
6.53K
-
-
Log daily currency exchange rates to Google Sheets
6.4K
-
Related services
Create your own Finance and Airtable workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
14 triggers, queries, and actions
New record created
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.
Price at close
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger retrieves the closing price of a stock you specify every time the market closes.
Price drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every day after the markets close and a stock’s closing price drops below an amount you specify.
Price rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every day after the markets close and a stock’s closing price rises above an amount you specify.
Today's exchange rate report
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger retrieves today's current exchange rate for any two currencies at the time you specify.
Today's price drops by percentage
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every day after the markets close and a stock's price drops from the previous closing price by at least the percentage you specify.
Today's price rises by percentage
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every day after the markets close and a stock's price rises from the previous closing price by at least the percentage you specify.
History of a stock dropping below a price
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a stocks price dropped below an amount you specify. Note: this query will only return future events after this Applet is created.
History of a stock dropping by percentage
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a stocks price dropped below a percentage you specify. Note: this query will only return future events after this Applet is created.
History of a stock rising above a price
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a stocks price rose above an amount you specify. Note: this query will only return future events after this Applet is created.
History of closing prices
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of recent closing prices of a stock you specify.
History of records created
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.
History of today's price rises by percentage
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a stock's price rises from the previous closing price by at least the percentage you specify. Note: this query will only return future events after this Applet is created.
Create a new record
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new record in a table of your choosing.
Create a new record
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new record in a table of your choosing.
History of a stock dropping below a price
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a stocks price dropped below an amount you specify. Note: this query will only return future events after this Applet is created.
History of a stock dropping by percentage
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a stocks price dropped below a percentage you specify. Note: this query will only return future events after this Applet is created.
History of a stock rising above a price
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a stocks price rose above an amount you specify. Note: this query will only return future events after this Applet is created.
History of closing prices
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of recent closing prices of a stock you specify.
History of records created
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.
History of today's price rises by percentage
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a stock's price rises from the previous closing price by at least the percentage you specify. Note: this query will only return future events after this Applet is created.
New record created
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.
Price at close
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger retrieves the closing price of a stock you specify every time the market closes.
Price drops below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every day after the markets close and a stock’s closing price drops below an amount you specify.
Price rises above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every day after the markets close and a stock’s closing price rises above an amount you specify.
Today's exchange rate report
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger retrieves today's current exchange rate for any two currencies at the time you specify.
Build an automation in seconds!
If
Select a trigger the automation will use
Then
Select an action the automation will perform
You can add delays, queries, and more actions in the next step!
More on Finance and Airtable
About Finance
This service triggers Applets based on stock ticker price changes or physical or digital currency exchange rate report. Track your finances and get notified about price changes and drops.
This service triggers Applets based on stock ticker price changes or physical or digital currency exchange rate report. Track your finances and get notified about price changes and drops.
About Airtable
Airtable is the easy way to create your own organizational databases.
Airtable is the easy way to create your own organizational databases.