Keep track of a stock's price at close in a Google spreadsheet
Other popular Finance workflows and automations
-
6.48K
-
-
Keep track of a particular stock's daily closing price in a spreadsheet
1.99K
-
-
Daily exchange rate report between any two currencies via email
807
-
-
Send me an #email when #stock price rises above a threshold.
130
-
-
Daily Closing Price add into Email Digest
10
-
-
Get an email when a particular stock drops below a certain price
1.43K
-
-
Change the light to green if stock price rises enough
18
-
-
Change the light to red if stock price drops too much
12
-
-
美元/人民币汇率提醒
12
-
Build your own Finance and OneDrive automations
Triggers (If this)
-
New file in folder
This Trigger fires every time a new file is created in the folder you specify.
-
Price at close
This Trigger retrieves the closing price of a stock you specify every time the market closes.
-
New photo in folder
This Trigger fires every time a new photo is created in the folder you specify.
-
Price rises above
This trigger fires every day after the markets close and a stock’s closing price rises above an amount you specify.
-
New tagged photo in folder
This Trigger fires every time a new photo with the tag you specify is created in the folder you specify.
-
Price drops below
This trigger fires every day after the markets close and a stock’s closing price drops below an amount you specify.
-
New file matching regex in folder
This trigger fires every time a new file whose filename matches the regular expression you specify is added to the folder 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.
-
New file matching search in folder
This trigger fires every time a new file whose filename or file contents contains the words you specify is added to the folder 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.
-
New file or folder shared with me
This trigger fires every time a new file or folder is shared with you
-
Today's exchange rate report
This Trigger retrieves today's current exchange rate for any two currencies at the time you specify.
New file in folder
This Trigger fires every time a new file is created in the folder you specify.
Price at close
This Trigger retrieves the closing price of a stock you specify every time the market closes.
New photo in folder
This Trigger fires every time a new photo is created in the folder you specify.
Price rises above
This trigger fires every day after the markets close and a stock’s closing price rises above an amount you specify.
New tagged photo in folder
This Trigger fires every time a new photo with the tag you specify is created in the folder you specify.
Price drops below
This trigger fires every day after the markets close and a stock’s closing price drops below an amount you specify.
New file matching regex in folder
This trigger fires every time a new file whose filename matches the regular expression you specify is added to the folder 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.
New file matching search in folder
This trigger fires every time a new file whose filename or file contents contains the words you specify is added to the folder 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.
New file or folder shared with me
This trigger fires every time a new file or folder is shared with you
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 files uploaded in folder
This query returns a list of recent files created in the folder you specify.
-
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.
-
History of file matching search uploaded in folder
This query returns a list of recent files whose filename or file contents contains the words you specify is added to the folder you specify
-
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 files or folders shared with me
This query returns a list of recent files or folders shared with you
-
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 photo uploaded in folder
This query returns a list of recent photos created in the folder you specify.
-
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 photos with a tag uploaded in folder
This query returns a list recent photos with the tag you specify is created in the folder you specify.
-
History of closing prices
This query returns a list of recent closing prices of a stock you specify.
-
History of file matching regex uploaded in folder
This query returns a list recent files whose filename matches the regular expression you specify is added to the folder you specify
History of files uploaded in folder
This query returns a list of recent files created in the folder you specify.
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.
History of file matching search uploaded in folder
This query returns a list of recent files whose filename or file contents contains the words you specify is added to the folder you specify
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 files or folders shared with me
This query returns a list of recent files or folders shared with you
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 photo uploaded in folder
This query returns a list of recent photos created in the folder you specify.
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 photos with a tag uploaded in folder
This query returns a list recent photos with the tag you specify is created in the folder you specify.
History of closing prices
This query returns a list of recent closing prices of a stock you specify.
History of file matching regex uploaded in folder
This query returns a list recent files whose filename matches the regular expression you specify is added to the folder you specify
Actions (Then that)
-
Create text file
This action will create a new text file at the path you specify
-
Append to a text file
This Action will append to a text file as defined by the file name and folder path you specify
-
Add file from URL
This Action will download a file at a given URL and add it to OneDrive at the path you specify. NOTE: 30 MB file size limit.
Create text file
This action will create a new text file at the path you specify
Append to a text file
This Action will append to a text file as defined by the file name and folder path you specify
Add file from URL
This Action will download a file at a given URL and add it to OneDrive at the path you specify. NOTE: 30 MB file size limit.
How to connect Finance and OneDrive
Find or create an Applet
Start by discovering an automation to connect or customizing your own. It's quick and easy.Connect IFTTT to your accounts
Securely connect your Finance and OneDrive accounts.Finalize and customize your Applet
Review your trigger and action settings. Your Applet is ready to go!
IFTTT helps all your apps and devices work better together