Keep track of a stock's price at close in a Google spreadsheet
Start today
Other popular Finance workflows and automations
6.5k- Change the light to red if stock price drops too much
12 - Signals Das Keyboard when stock price rises by percentage
16 - Get notified of stock price decreases4.6k
- Dow Jones Notification >29
- Get the latest exchange rate between two currencies829
- How strong is your currency in another country? Log the exchange rate every day4.4k
- Get alerts when a stock rises above a price15
- Stock rise pushover.23
Useful Finance and Sensatio integrations
Triggers (If this)
Price at closeThis Trigger retrieves the closing price of a stock you specify every time the market closes.
Sensor Data exceeds LimitThis event is fired when there is new sensor data that exceeds a defined upper limit- Price rises aboveThis trigger fires every day after the markets close and a stock’s closing price rises above an amount you specify.
- Sensor Data below LimitThis event is fired when there is new sensor data that falls below a defined lower limit
- Price drops belowThis trigger fires every day after the markets close and a stock’s closing price drops below an amount you specify.
- Sensor TimeoutThis event is fired when there is no new sensor data for a specified amount of time.
- Today's price rises by percentageThis 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 percentageThis 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 reportThis 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 priceThis 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 when Sensor data dropped below a limitThis event was fired when there was new sensor data that fell below a defined lower limit Note: this query will only return future events after this Applet is created.
- History of a stock rising above a priceThis 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 percentageThis 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 percentageThis 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 pricesThis query returns a list of recent closing prices of a stock you specify.
IFTTT helps all your apps and devices work better together