Keep track of a particular stock's daily closing price in a spreadsheet
Start today
Other popular Finance workflows and automations
- Keep track of a stock's price at close in a Google spreadsheet
- Change the light to green if stock price rises enough
- Post the closing price of Microsoft to your group at the end of each trading day.
- Stock Price at Market Close
- If today's Bitcoin price (BTCUSD=X) drops by 1%, then push an address
- Signals Das Keyboard when stock price drops by percentage
- Stock tracker for Evernote
- Get alerts when a stock drops by a certain percentage
Useful Finance and Home Connect Fridge Freezer integrations
Triggers (If this)
- Price at closeThis Trigger retrieves the closing price of a stock you specify every time the market closes.
- Refrigerator door openedThis trigger fires every time your refrigerator door has been opened.
- Price rises aboveThis trigger fires every day after the markets close and a stock’s closing price rises above an amount you specify.
- Freezer door openedThis trigger fires every time your freezer door has been opened.
- Price drops belowThis trigger fires every day after the markets close and a stock’s closing price drops below an amount you specify.
- Refrigerator door open too longThis trigger fires every time your refrigerator door was left open too long.
- 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.
- Freezer door open too longThis trigger fires every time your freezer door was left open too long.
- 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.
- Freezer temperature too highThis trigger fires every time your freezer temperature is too high.
- 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 freezer temperature too highThis query returns a list of when your freezer temperature was too high.
- 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 freezer door opensThis query returns a list of when your freezer door has been opened.
- 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 refrigerator door opensThis query returns a list of when your refrigerator door was opened.
- 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 refrigerator door open too longThis query returns a list of when your refrigerator door was left open too long.
- History of closing pricesThis query returns a list of recent closing prices of a stock you specify.
Actions (Then that)
- Set refrigerator temperatureThis action will set the refrigerator temperature.
- Set freezer temperatureThis action will set the freezer temperature.
- Activate refrigerator Super Cooling modeThis action will temporarily cool the refrigerator at maximum power.
- Activate freezer Super Freezing modeThis action will temporarily cool the freezer at maximum power.
- Activate Sabbath modeThis action will activate Sabbath mode (Rest mode) on your appliance. Note that this will disable most other actions for your appliance, including remote temperature control.
- Deactivate Sabbath modeThis action will deactivate Sabbath mode on your appliance.
- Activate Vacation modeThis action will activate Vacation mode (Holiday mode) on your appliance. Note that this will change set point temperature and manually changing it will disable the Vacation mode (Holiday mode).
- Deactivate Vacation ModeThis action will deactivate Vacation mode on your appliance.
- Activate Fresh modeThis action will activate Fresh mode on your appliance. Note that this will change set point temperature and manually changing it will disable the Fresh mode.
- Deactivate Fresh modeThis action will deactivate Fresh mode on your appliance.
- Activate Eco modeThis action will activate Eco mode on your appliance. Note that this will change set point temperature and manually changing it will disable the Eco mode.
- Deactivate Eco modeThis action will deactivate Eco mode on your appliance.
IFTTT helps all your apps and devices work better together