Keep track of a stock's price at close in a Google spreadsheet
Start today
Popular Finance and Google Docs workflows and automations
Useful Finance and Google Docs integrations
Triggers (If this)
- Price at closeThis Trigger retrieves the closing price of a stock you specify every time the market closes.
- New document addedThis trigger fires when a new document is added to a Google Drive folder. Note: only works for docs created after the Applet is turned on.
- Price rises aboveThis trigger fires every day after the markets close and a stock’s closing price rises above an amount you specify.
- Price drops belowThis 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 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 documents addedThis query returns a list of when new documents were added to a Google Drive folder.
- 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