Keep track of a particular stock's daily closing price in a spreadsheet
Start today
Triggers (If this)
Queries (With)
Other popular Finance workflows and automations
-
-
Keep track of a stock's price at close in a Google spreadsheet
-
Send me an #email when #stock price rises above a threshold.
-
Receive a push notification about a rising stock via Pushover
-
Change the light to green if stock price rises enough
-
Stock rise pushover.
-
If a particular stock is down 5%, send me an email!
-
Get the latest exchange rate between two currencies
-
Get alerts when a stock drops below a price
Useful Finance and Rachio Smart Hose Timer integrations
Triggers (If this)
-
Price at close
This Trigger retrieves the closing price of a stock you specify every time the market closes.
-
Valve Opened
This trigger fires every time a valve opens.
-
Price rises above
This trigger fires every day after the markets close and a stock’s closing price rises above an amount you specify.
-
Valve Closed
This trigger fires every time a valve closes.
-
Price drops below
This trigger fires every day after the markets close and a stock’s closing price drops below an amount you specify.
-
Today's price rises by percentage
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.
-
Today's price drops by percentage
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 exchange rate report
This Trigger retrieves today's current exchange rate for any two currencies at the time you specify.
![Price at close Price at close](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
Price at close
This Trigger retrieves the closing price of a stock you specify every time the market closes.
![Valve Opened Valve Opened](https://assets.ifttt.com/images/channels/127675409/icons/monochrome_regular.webp)
Valve Opened
This trigger fires every time a valve opens.
![Price rises above Price rises above](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
Price rises above
This trigger fires every day after the markets close and a stock’s closing price rises above an amount you specify.
![Valve Closed Valve Closed](https://assets.ifttt.com/images/channels/127675409/icons/monochrome_regular.webp)
Valve Closed
This trigger fires every time a valve closes.
![Price drops below Price drops below](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
Price drops below
This trigger fires every day after the markets close and a stock’s closing price drops below an amount you specify.
![Today's price rises by percentage Today's price rises by percentage](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
Today's price rises by percentage
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.
![Today's price drops by percentage Today's price drops by percentage](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
Today's price drops by percentage
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 exchange rate report Today's exchange rate report](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
Today's exchange rate report
This Trigger retrieves today's current exchange rate for any two currencies at the time you specify.
Queries (With)
-
History of a stock dropping below a price
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.
-
Valve Status
This query returns the current valve status.
-
History of a stock rising above a price
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 a stock dropping by percentage
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 today's price rises by percentage
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.
-
History of closing prices
This query returns a list of recent closing prices of a stock you specify.
![History of a stock dropping below a price History of a stock dropping below a price](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
History of a stock dropping below a price
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.
![Valve Status Valve Status](https://assets.ifttt.com/images/channels/127675409/icons/monochrome_regular.webp)
Valve Status
This query returns the current valve status.
![History of a stock rising above a price History of a stock rising above a price](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
History of a stock rising above a price
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 a stock dropping by percentage History of a stock dropping by percentage](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
History of a stock dropping by percentage
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 today's price rises by percentage History of today's price rises by percentage](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
History of today's price rises by percentage
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.
![History of closing prices History of closing prices](https://assets.ifttt.com/images/channels/22/icons/monochrome_regular.webp)
History of closing prices
This query returns a list of recent closing prices of a stock you specify.
IFTTT helps all your apps and devices work better together