Create Email stock alert with Google Apps script | Simple Triggers

[@Amarindaz]

Checkout how to build Email Marketing Tool on google sheets 👉 kzbin.info/www/bejne/naqaqqOBepulmMk

[@judewalker3657]

Yes, excellent. This still works 18 months after originally published. Google has changed a couple things about authorizing scripts and creating triggers via a new dashboard, but the information in this video is still almost exactly what you need to do step for step. Very cool. Thanks!

[@shambhavamchoudhary67]

Amazing thing for me

[@neerajgairola1749]

Great video bro, can we also get the alert on WhatsApp or telegram

[@pravinlipare2920]

Wonderful, short and informative video. Thanks a ton.

[@yusufimt1834]

Could You make script for "Alert" when Cell value below zero, it's will be helpful

[@lucksimi3320]

How to set stock price alert on multiple stocks and get sms instead of mail? Thanks

[@tomaudio7415]

Great, thank you !!!it encourages me to do my own coding according to my project purpose

[@anthonymacle1880]

Great video, what if i want to have several stocks ? i under the same project i added 10 files (10 stocks), when i run the script, only the last file is run in the log. I copied past the script and changed the range only i guess i might need to change some other thing like the 'var' ? can you please help me with this ?

[@sajeevm3685]

Hi Very nicely explained ✅ I would want an audio notification when desired price is reached is it possible please make a video for it thanks

[@davidsflips]

Thanks for this video I have been looking all over for a stock alert. Very useful and easy to set up but mabye you can help me out? If I select the trigger to be from spead sheet on change will it email me once the price changes intead of every hour? In time driven I get an email every hour even if the price dosen't change. I only want to be notifed when the price hits the low or high point in the script code?

[@Amarindaz]

Yaa you can change the trigger for value change instead is time driven

[@amirpiltan4095]

Excellent guide, works perfectly.

[@Amarindaz]

Glad to know that . please feel free to subscribe and stay tuned

[@shubhendrasingh7934]

Sir, in triggers I have set time as every minute. So is there any limit or it is unlimited because in a day it will execute 1440 times

[@RiaSig8]

This is super helpful, thanks! But how do you set this up for more than one stock? I tried copy/pasting and referencing a different cell on the same Sheet, but it doesn't seem to be working for me.

[@piyushgh8675]

Hello Sir, Can we write some script that will pull data actively / every second from NSE / BSE website and same will be reflected in spreadsheet? Coz, GoogleFinance method is slow and delayed by upto 20 minutes.

[@penchalaiahjammula183]

This is what Im looking for amazing trick thanks a lot boss thumbsup . . .:D Amarindaz Does it possible to send alert to mobile number or atleast message in google chat?

[@indiadark9780]

If I want to change the desired price then I have to go to the script editor and change it. Is there an option to place the up/down values in a cell in the same sheet?

[@Amarindaz]

Yea possible. You need to add more code with logic to do the same

[@sowndharchinnappa9882]

I want Email Alerts from Google sheets if CMP comes near to my predifined Buy or Sell price is it possible

[@mytube1000javed]

What abt Indian stock price?

[@aliosmanozen196]

great tutorial, thank you

[@Amarindaz]

You're welcome

[@hemant8h]

Hi Actually i need to compare the values which one is share value as u mentioned daily other value is my calculated value saved in other cell. I trying to call other value by your way. But i got o/p as N/A. So do you have any other way to solve?

[@davidsflips]

Could you do a video on just getting an email on the price of the stock? I want to know the price of the stock hourly. Thanks

[@JiweshKumar]

How to save the historical nav of mutual funds in spreadsheet.

[@johnpaul5459]

Hello Amarindaz. This is a great script you have created. Please how do you create script for say give notifications if stock retrace 25% from its highest price?

[@Amarindaz]

You need to find the API that return highest price and compare it with current price

[@johnpaul5459]

@@Amarindaz got it. Atribute is "high52". Many thanks.

[@johnpaul5459]

You really helped me. Thank you!

[@habeeburahman9439]

@@Amarindaz Can i use formula to arrive at the percentage in the sheet and give reference in the script ?

[@Amarindaz]

Yes you can

[@RenatoEsquarcit]

Can somebody help me? If instead a single cell I want to address a range of cells (or an entire colum) what I should do?

[@Seeyan86]

does the script run even while you have not the GSheet opened?

[@Amarindaz]

Yes. It'll run in the cloud and send you the notification

[@Seeyan86]

Cool! And can you tell me the command for ex-dividend date for a given ticker?

[@RPDBY]

how to set alerts drop drops in percent?

[@उपअधीक्षकभूमीअभिलेखकार्या.एएमन]

Nice ....

[@Amarindaz]

Thank you :)

[@68328231]

Email alert if stock runs out... How does the Excel file know if the price has changed on the vendor's website? Is this a file that can be used to track the price and inventory of a particular website?

[@mattlevinson1607]

Vendors may delay prices but that is totally independent of this. This is getting the exact price.

[@0xAob]

This method, I have to open google spreadsheet all the time, Right? To get email notification How to do without open googlespread sheet

[@Amarindaz]

No need. It'll be automatically triggered.