Finance Price at close. Google Docs Append to a document.

Keep track of a stock's price at close in a Google spreadsheet

6.5k
Connect

This Applet will add the closing price for the stock of your choice to a spreadsheet in your Google Drive. Remember: if you analyze the data, crack the code and figure out how to make big $$$ — we get a cut! 🤑

Create your own Finance and Google Docs 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.

15 triggers, queries, and actions

New document added

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 when a new document is added to a Google Drive folder. Note: only works for docs created after the Applet is turned on.

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 documents added

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 new documents were added to a Google Drive folder.

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.

Append to a document

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 append to a Google document as determined by the file name and folder path you specify. Once a file’s size reaches 2MB a new file will be created.

Create a document

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 Google document at the path you specify.

Append to a document

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 append to a Google document as determined by the file name and folder path you specify. Once a file’s size reaches 2MB a new file will be created.

Create a document

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 Google document at the path 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 documents added

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 new documents were added to a Google Drive folder.

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 document added

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 when a new document is added to a Google Drive folder. Note: only works for docs created after the Applet is turned on.

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.

More on Finance and Google Docs

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.

Learn more

More integrations with Finance

About Google Docs

Google Docs brings your documents to life with smart editing and styling tools to help you easily format text and paragraphs. Applets let you create new documents, add to existing ones, or monitor specific folders for when new docs are added.

Learn more

More integrations with Google Docs