Create Email stock alert with Google Apps script | Simple Triggers

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

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

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

Wonderful, short and informative video. Thanks a ton.

Can you make video on whatsapp message instead of email??

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 ?

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

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

Amazing thing for me

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

how to set alerts drop drops in percent?

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

TypeError: Cannot read property 'getSheetByName' of null (line 3, file "Code")

1 function stockPrice() {
2 var sh1=SpreadsheetApp.getActiveSpreadsheet();
3 var MSFTPrice=sh1.getSheetByName("Sheet1").getRange(7,8).getValue();
4 Logger.log(MSFTPrice);
5 }

What abt Indian stock price?

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

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?

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.

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

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?