Out of many tools that Google provides, Google Finance is considered to be one important tool for all investors and brokers. This service provides wealth of information about all companies. It provides vital information like live stock price, highest and lowest, percent of change in prices.
It allows you to create an account and monitor organization/company stock quotes by adding it to your Portfolio. But in order to get hold of the information you have to be online and logged into your account. Wouldn’t it be great if there was a way to keep you automatically notified via alerts? It does offer emails alerts but you have to create RSS feed and use Google Alerts to achieve it as SMS alerts are not supported.
There are lots of other services/tools that lets you get notification of Stock prices on your mobile but most of them charge for that. So here is a tool which will let you get free Stock price alerts via SMS from Google Finance itself. It’s capable of monitoring three different companies at a given time and will send you SMS notifications to your mobile every 1 hour. The limit of only three companies at maximum is because of the message length restriction imposed by Google. In case you need Email notifications too, do let me know in comment section, I will let you know how to enable it. Below are instructions on how to get started.
Get Free SMS alerts of Live Stock Price from Google Finance
Step 1: Configure your Google Calendar to set SMS as default reminder channel
You can follow the instructions available at linking your mobile with Google Calendar for SMS notification from our previous article. Once done continue to next step.
Step 2: Setup of the Project on your Google Drive account
1. Log in to your Google Drive account.
2. Open this Google Finance Free Stock Price Alerts project (V2.0).
3. Make a copy of it by selecting File-> Make a copy. Then select Tools-> Script editor
4. Grant access by selecting Run-> AUTHORIZE. Now click the continue button from the pop up then click Accept.
5. Select File-> Manage Versions. Then click save new version and press OK.
6. Now select Publish-> Deploy as web app and click Deploy. The app is ready now. Copy the generated URL and paste it in the address bar and hit enter. You can bookmark it for easy access.
Note: If you were previously using the old version of the script make sure you disable it by clicking stop alerts from it.
Usage Instructions:
– This tool is capable of monitoring three Stock Symbols at a time.
– Finding Stock symbols: You can find symbol of any company of your interest by visiting Google Finance and searching with company name. Copy that symbol and paste into the tool.
You might also like: Get Free SMS Alerts for New Emails on Gmail and Get Free Cricket Score Alerts on your Mobile
– Enter the Ticker symbols of your interest and click Create Alerts. Enter at least one symbol(Ticker Symbol 1) is mandatory.
– Now on Stock Price alerts will be sent to your mobile every 1 hour.
– You can stop receiving notifications by clicking Stop Alerts.
So, did you like the tool? Did it work for you? Have any features to suggest? Feel free to drop in with your views.
Hi,
I have tried your code it does work but only for US stock. i am sure you can set it up for more than three stocks and also for London stock. Hav a loo at jstock at http://jstock.sourceforge.net/. they have set it up for unlimted sms alerts using yahoo data and google calendar api.
I await your reply.
Regards
larry
Thanks for your comment. But the tool works regardless of any country. I have personally tested and wrote them myself 😉 Request you to try again. Google Finance API doesn’t impose any such restriction hence the tool should obviously work with any country stock.
Screenshot showing stock price of BT Group(London) and Reliance Communications(India)
By the way thanks for the resource. Looks interesting will give it a try.
Ok . thanks. I was just typing in the stock ticker without LON: What about answer to my other question? “i am sure you can set it up for more than three stocks and also for London stock. Have a loo at jstock at http://jstock.sourceforge.net/. they have set it up for unlimited sms alerts using yahoo data and Google calendar api. preceding it with LON:.
What about answer to my other question”
As it’s mentioned under the usage instructions you must use the exact symbol as given by Google Finance. As far only three stocks restriction it is due to message length restriction imposed by Google Calendar.
Yes indeed I will check out that tool and will let you know my honest opinions 🙂
Not interested in hourly updates but am interested in regular updates maybe twice a day. Have other updates set up with price triggers but would like to monitor stocks twice a day when they’re within their price triggers. I noticed on around line 74 the code is written for triggers everyHours(1). I can’t change this in the original file assuming because code is protected but have tried changing it to (4) in copied version before saving. After publishing, web page still shows updates every hour. Not sure what I’m doing wrong here. Should be able to change this to any number or even daily updates once a day.
One other thing is around line 112 under creating event. I assume this is when the sms text is created and sent,, what is the 30000 number. What does 30000 stand for in real time. Can this be altered to maybe grab a price quote at a specific time of day and then generate an sms alert shortly thereafter?
May have figured it out. On copied file version, edited html script line 156 to … notifications every 6 hours.
On gs script page, changed line 74 to (6) hopefully to run alert every 6 hours instead of 1.
Not sure if this is right but will try. At least the web page looks correct now. If this works, will tailor to what I need.
Joel,
Way to go! Do share this article if you liked it 😉
Second question from above. The script for creating a new event about “createEvent(smsmessage,new Date(now+30000)”… what does the 30000 represent?? nanoseconds? In other words, does the code generate the sms message 30 seconds after reaching this step in the code? What I’m ultimately looking for is to set up messaging for certain stocks for their prices shortly after the opening bell so I can keep an eye on them throughout the day if they’re getting close to a price trigger.. eg. Receive a quote daily from XYZ stock, 30 minutes after the opening bell.
Yes, it will create alerts 30 seconds after that step is reached.
I have gone through and edited the code slightly in hopes of achieving a different style. However I hit a speed bump. On lines 110-113 I changed to be:
setTime(1368712800000) instead of getTime()
and removed the +30000 from the function to end the delay.
As well as line 74 to be 24 hours instead of 1.
I assumed that starting at 10:00 AM (EST) I would receive a text alert every day from there on out, however I am getting nothing. Do you have a possible solution?
It works! Thank you very much.
I set it up for 3 Indian stocks less than an hour ago, and have already received my first SMS alert. You are a genius. Please keep me updated on your future projects.
Aviator,
You are most welcome. Thanks for those words! Do share this article on social networks if you found it useful.
Yes, indeed will keep you posted on my future works 😉
You can stay in touch by liking us on FB: https://www.facebook.com/techawakening
Subscribing to Email Newsletter: http://techawakening.org/go/newsletter
Hi Shun,
It is awesome. Can we put some conditions on stocks cross some value, then we should get the alert
Thanks
Karthik
Thanks Karthik. Yes possible. But that would require some customization for which you can request for support here: https://gumroad.com/techawakening#vpmBe
Hi SS,
Thanks for the tool. I am interesting in getting email alerts than SMS. What modifications are required to create email alert tool?
Thanks.
DS
Please drop an email to admin@techawakening.org. I will tell you how to. Cheers!
Plz…plz..plz…
I’m always getting emails like “Summary of failures for Google Apps Script: Copy of Gmail SMS Alerts – Techawakening.org” What i hve to do …?
Help me dear Shunmugha Sundaram.
My email id is :rmkrish025@gmail.com
Thank you.
Gud n8
Ramakrishna,
You need not worry about that. Please refer this comment: http://techawakening.org/free-sms-alerts-new-email-on-gmail-with-google-docs/1130/#comment-684 to disable it.
Thanks yar thankyou verymuch…
Gud n8 & sweetdreams……………!!!!!!!!!!
Instead of getting SMS alerts every 1 hour m getting it every 6 hours, while event created in my calendar every 1 hour. What is the issue?
Instead of getting SMS alerts on every 1 hour, I am getting SMS alerts on every 6-8 hours, while event is created in my calendar every 1 hour, where is the problem, please check and inform about any possible solution.
Hello,
Please tell me the code for the we can put some user defind name instead Symbol in sms code so it can send little more stocks in a sms which we can input when adding symbols.
Like this
NHPC:22.55,NOCIL:2650,RP:92.65
not like this
BOM:500730:22.55 BOM:533098:26.50 BOM:532939:92.65
so we can get 5 stocks instead 3.
Ankit,
Code is open sourced. Please tweak it yourself.
Hello,
I am not a coder so that i don’t know how to edit code for this. so that i asking you for that code.
Hi sir,All scripts are super & its working fine, I hav created stock alert and m getting sms alerts but the problem is m getting alerts every 1 minute even though time is set correctly and also I dint find stop alert option in this script.. pl help.
Just click the red stop alerts button.
Thank you for providing such wonderful app. I have one query…after installing the project in my drive, and configuring 3 stocks of my choice, I am able to receive SMS every hour. After market has closed at 3:30 pm I have still received 4 messages and assume that this will continue now henceforth irrespective if market is open/closed/holiday.
Is there any way to have these alerts ONLY in market hours ? Else it will soon start to become annoying and one will be forced to stop using such a wonderful app.
Thanks in advance
Girish,
Thanks! That’s a very good point. Is the market closing time averagely same across various countries? If so I will update the app with a generic solution. Looks like 6.30 PM will be the best time to stop sending alerts.
Reference: http://en.wikipedia.org/wiki/List_of_stock_exchange_opening_times
HI,
Has the timing being incorporated? Do we need to download the project once again and publish it to have this feature enabled? Also I noticed that for the last 2 days, I am receiving truncated quotes – let me explain –
I have configured 3 quotes say NIFTY, AXIS & TATAMOTORS. What ever be the order of this scrips that I enter in the 3 boxes provided, the last one (TATAMOTORS in the above example) is received only without the price..the closing line @ Wed 8 OCt 2014..etc is received which means the message is not truncated at the operator end 🙂
Also for last 2 days the messages are coming at an interval of 6 hours which means only 4 messages in 24 hours..
Can you please check on this one as well
Thanks once again
Girish,
Probably because of this https://plus.google.com/+EricKoleda/posts/FrULXhYq29G. Couldn’t help it 🙁
As you know, your brilliant script is now completely dead, following Google’s “sunsetting” of the FinanceApp function (see: https://developers.google.com/apps-script/sunset ).
But the GoogleFinance function in Google spreadsheet still works (and isn’t deprecated, as far as I know), see: http://googledocs.blogspot.co.uk/2010/08/tips-tricks-googlefinance-in-google.html
Maybe you could add a simple spreadsheet to your Google Drive project and pull the stock price(s) from there, instead of from the FinanceApp function?
I don’t know how to do that, nor if it’s even possible, but I’d bet you could figure it out if it is possible :).
Thanks for trying, if you do. And thanks for providing this great script, while it lasted, if you don’t.
Susan,
Oh ya! Thanks for the awesome tip. I finally came up with a workaround 🙂 Have released version 2.0, please follow the updated steps and give a try. Let me know the feedback.
And do spread the word on social networks. Would appreciate that.
Works a treat, thanks :). Lots of my friends used the previous version as well, so I’ll pass on the good news. Thanks for the hat tip, too.
My pleasure. To be frank never knew that this app had a good number of users, nice to know. Do spread the word on social networks too 🙂
4. Grant access by selecting Run-> AUTHORIZE. Now click the authorize button from the pop up then click Grant access and finally press close.
Sir,
Here I did not find the “Grant access” to be click. Please let me know clear.
Thanks
Sunil,
Instructions updated. Please start over and follow the steps.
Have tried the new workaround you’ve made. Am anxious and hopeful will work as well as the old one. I had tweaked the old script to give me 1 update per day 1 hour after the market opened. I changed this script to do the same so will have to wait to see if it works in a couple of days. Thanks much for your continued work on this script and for figuring out a workaround.
Joel,
Thanks a lot for the feedback. If you won’t mind please share with us the updated script 🙂 New feature I will be working on is to send alerts only during market hours.
Do would appreciate if you could like/share this article to help reach more people.
Still no luck. Am getting script error messages from “apps-scripts-notifications @ google . com”. Tried going back to your original script without adding the tweaks I mentioned earlier and copied and pasted as per your instructions. Continued errrors every hour like clock work. ERROR MESSAGE “TypeError: Cannot call method “getActiveCell” of null. (line 165, file “Techawakening”)”. TRIGGER “time-based”.
Problem seems to be in the spreadsheet portion of your code. Not sure if problem lies in your code or in the copy that I create from your template. I am able to get current stock prices via Google Sheets so I know sheets are working, and connection is fine. Is it possible the active cell is either protected or otherwise unavailable to access?
Joel,
Have actually addressed that issue. Can you please delete the old sheet and start over with the new one.
It’s working for Susan
Sorry, didn’t see where that was previously addressed. Did all you asked and will see if successful. Glad it’s working for Susan. Hopefully 3rd time is a charm.
Sorry Shunmugha, it seems I spoke too soon. Mine ran successfully the first time, but not since, and I get exactly the same error report as Joel.
Any idea what might be wrong? Have you kept one running successfully?
Hmm, I think it might be a duplication issue with the old version. Even though I had deleted the old one, it looks like the associated script was still running!
And looking at the version history (i.e. my copy’s editing version history, not the original v.1 and v.2), when the ‘old’ v.1 trigger fired, it amended my copy of the ‘new’ v.2 sheet and borked it.
So (given in full for future reference, assuming this fix holds) I restored the v.1 from the Google Drive/Trash; opened it in Sheets; used Tools/Script Editor then Resources/Current Project’s Triggers (or just click the Clock icon on the Toolbar) to see the triggers; deleted the trigger(s) shown; closed the Script Editor; and deleted the v.1 copy again. (I think I could have also deleted the v.1 techawakening.gs too, while the Script Editor was open, but I decided to leave it, hopefully now dormant, just in case).
Then I opened v.2 in Sheets; used Tools/Script Editor then Resources/Current Project’s Triggers to see the triggers; and changed the getStockprice trigger to run every 1 minute. It’s been running successfully for about half an hour. (I think there’s a limit to the number of SMS’s Calendar will send per time period, so they stopped after the first three minutes, but the events are still appearing in Calendar, so I think the SMS’s will resume in due course).
So I then changed the trigger to once per day between 5pm and 6pm, and we’ll see it all works now.
Shunmugha, I don’t know yet if this a perfect fix, but in any event I *think* your installation instructions should probably include how to thoroughly delete and/or disable old versions. It’s just bizarre that the script keeps firing, even when the sheet is in the trash.
Anyway, I’ll report back with further success or failure shortly.
Actually it’s a know issue happening for few users, trigger still being fired from deleted sheet. Deleting trigger is the best option. I will update the instructions.
So for now is V2 working for you properly or still getting exceptions which Joel mentioned? I happened to push a fix for the very same issue in development stage itself after which I didn’t see any errors.
V2 is working in that it’s populating my Calendar with live stock prices, and generating no errors. But SMS’s have stopped: I presume because of volume throttling (do you know how many it will send per hour/day?).
So I’m waiting to see if it’ll successfully fire as now set between 5pm-6pm GMT (about 2 1/2 hours from now), without interference from the zombie V1 trigger, and if that will generate an SMS. So it will probably be tomorrow morning GMT before I can confirm that all is well. Or possibly the day after if I’ve blown my daily SMS limit already (which seems unlikely). Fingers crossed …
But sadly Google documentation does not give any info on what’s SMS limit per day. Hope you come back with a positive answer 🙂
I suppose if you included a version number in each of the names of each part of your project, that would both avoid zombie trigger clashes, and help diagnosing problems (because the Google Error Alerts include the name of the malfunctioning scripts, which are currently the same for V1 and V2)?
Good point. Happened to rename the sheet but forgot to rename the script internally. Updated now.
Nothing received yesterday, but worked perfectly today. No errors; stock price added to calendar at 5.27pm (using 5pm-6pm trigger setting); and SMS arrived immediately.
So I’d say V2 is a success! 🙂
Thanks again for updating this cool tool.
Let’s hope Joel has got it going too …
Awesome! Thanks for the continuous feedback’s. Hopefully even Joel should have got it working.
In case you missed it, do check our other projects too: http://techawakening.org/projects/
Happy Halloween!
Actually, I have not gotten it right yet, although I am much closer. The script error I wrote about earlier seemed to be tied to another error message I received.
“”ReferenceError: “FinanceApp” is not defined. (line 89, file “Techawakening”)””.. I needed to change this trigger as I found out from Google help that “script triggers” have also been deprecated. The fix was to amend line 89.
Old code line 89…
{
var triggers = ScriptApp.getScriptTriggers();
New code line 89…
{
var triggers = ScriptApp.getProjectTriggers();
Once I found this and corrected the code, the line 165 “getActiveCell error” went away as well.
This has now allowed the code to run and send the info. I have changed the time of the trigger on line 100 from 1 to 24 to have it run once per day. All that is left is to figure out the timing. Currently, it is triggering to run in the middle of the night in my time zone. I am interested in it running once per day 1 hour after the market opens, which is how I had it set before. I think I found out how but will need a few days next week to dial it in if I’m right. If I get it correct, I will post all my changes and instructions later. Shunmugha, it would help if I knew your time zone… I’m guessing it is GMT +5 or 6 but That’s just a guess. That’s seems to be the root of the time trigger for me. Anyways, I will continue to work it out either way. THanks for all your help.
Why don’t you delete all triggers and the old sheet as well and start over with the new one. Have addressed time zone issue as well. You can manually check from File-> Project Properties-> Time Zone. Configure if needed.
Shunmugha,
Thanks so much for all your work. Yes, it is working now exactly as I want it. I don’t want to mess with it anymore for fear I might mess it up. I am getting a daily update once per day at 10:40am. Exactly what I wanted. Your latest effort with the STARTSERVICE code seems to be the ticket. Once I set up the latest version, it ran like a dream with no errors. I switched to once per day after a couple days to limit the updates but it was still running in the middle of the night by default. I changed the time trigger per Susan’s advice and voila—– It’s been running now for 3 days at 10:40am EST,,,perfect. Thanks again for all your recent effort to work out the bugs. Very happy indeed.
Let’s party. Happy to hear that! Would appreciate if you could like/tweet the article and spread the word. And would love to see you like our Facebook page too 😉
https://www.facebook.com/techawakening
Good to see article. Will it work for specific price alert. For Example I want to buy reliance when it falls below Rs 800 or can say I want to sell/ book profit when it goes above 1100. So I want sms or email alerts when reliance trigger those prices. Hope you you understand my question.
It’s requires code customization.
Your script is great. Can you enhance it to only do alerts when the price reach a certain level?
Thanks. That will require some tweak. Please write to admin@techawakening.org. I can help you with that.
Good work buddy
Thanks a lot, i am looking for a more specific script which can alert me only when the price i set is triggered. That should be more useful when i try to sell. Because 1 hour is too long for anything to happen during volatile markets. A script of that kind will be of more help.
Thanks once again!!
For any customization write to admin@techawakening.org. Thanks!
Are you still maintaining this project? Any chance of you updating the code so stock price triggers can be set, without having to alter any code?
The SMS facility seems to be discontinued by Google Calendar. Can you please share the Gmail notification of live share prices? Thanks in advance!
Love your apps. I would like to receive the alert when the stock goes beyond or below a certain price. Do you have an app to do this?