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!
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 ?
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?
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.
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?
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?
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.
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?
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?
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?
Checkout how to build Email Marketing Tool on google sheets 👉 th-cam.com/video/gy7ypKE6rbg/w-d-xo.html
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!
Wonderful, short and informative video. Thanks a ton.
Great, thank you !!!it encourages me to do my own coding according to my project purpose
Great video bro, can we also get the alert on WhatsApp or telegram
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
Excellent guide, works perfectly.
Glad to know that . please feel free to subscribe and stay tuned
Amazing thing for me
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
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?
Yaa you can change the trigger for value change instead is time driven
great tutorial, thank you
You're welcome
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.
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?
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?
Yea possible. You need to add more code with logic to do the same
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.
What abt Indian stock price?
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
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
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?
I want Email Alerts from Google sheets if CMP comes near to my predifined Buy or Sell price is it possible
Nice ....
Thank you :)
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?
You need to find the API that return highest price and compare it with current price
@@Amarindaz got it. Atribute is "high52". Many thanks.
You really helped me. Thank you!
@@Amarindaz Can i use formula to arrive at the percentage in the sheet and give reference in the script ?
Yes you can
How to save the historical nav of mutual funds in spreadsheet.
does the script run even while you have not the GSheet opened?
Yes. It'll run in the cloud and send you the notification
Cool! And can you tell me the command for ex-dividend date for a given ticker?
how to set alerts drop drops in percent?
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?
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?
Vendors may delay prices but that is totally independent of this. This is getting the exact price.
This method, I have to open google spreadsheet all the time, Right? To get email notification
How to do without open googlespread sheet
No need. It'll be automatically triggered.