Glide Apps Template: Stock Investments Tracker
Updated: Jun 9, 2020
This article describes how you can create a tracker for your investments in the stock market, using Google Sheets and Glide Apps.
You will find this Stock Tracker in the Glide Template Store here.
Using Google Finance as a personal stock tracker is a thing of the past since Google no longer has an app for it. All the other apps that seem like they’re helping you track your personal stock are selling your data to 3rd party applications.
So, if you’re a stock market investor, this blog post is for you.
If you’re a stock market trader or a fund manager or a manager managing wealth for high net worth individuals (HNIs), you may still use this blog post to build an application for your clients.
Yet another stock tracking app?
First and foremost, your brokerage account has confidential data about your investments. Not only is logging into your brokerage account tedious, but it could also sometimes be excruciatingly difficult to use.
From remembering passwords that you need to reset every few days, to leaving your phone unattended, to dealing with an archaic app, to navigating through an app that is covered in banner ads, to unknowingly giving access other aspects of your phone to an app, these apps are fraught with risks.
Besides, the 3rd party applications that you use today to track your investment could be selling data about you and your investments. With data privacy and security being a hot topic now more than ever, you need to be a little more aware of what happens with your data when you share it with 3rd party applications.
As a result, you should take the extra effort to avoid being compromised, especially when the data is related to your financial well-being and investments. And if you can, you should build your own tools, especially when the tools to do that are easily available today.
Toolkit to build a Stock Market Tracker
Build your tracker using GOOGLEFINANCE in Google Sheets.
Track your investments using a mobile app developed using GlideApps.
All you will need to build a tracker in Google Sheets is the following:
A basic understanding of how to structure a Google Sheet.
A complete understanding of the =GOOGLEFINANCE() function in Google Sheets.
Structuring a Spreadsheet in Google Sheets
A basic structure of the spreadsheet to track your stock investments is shown below.
Understanding GOOGLEFINANCE in Google Sheets
The complete documentation of GOOGLEFINANCE can be found here.
The sample spreadsheet shared above contains placeholders for all the important metrics related to a particular stock, namely, but not limited to:
The idea is to retrieve the desired metrics (columns I to Z) for a stock using GOOGLEFINANCE.
For e.g., to retrieve price of APPLE’s stock, use the following formula:
The spreadsheet also calculates the total Buy Cost, the Current Value, and the absolute ROI (columns AA to AC) for any particular stock you’ve entered information for.
A few snapshots of the Mobile App can be found at the beginning of this blog post.
You can check out a live demo of the app here. It is highly recommended that you open this link on your phone, and save the page as a bookmark on your Phone Home screen to get it to work exactly like an App.
Watch this tutorial to learn how to develop a functional version of this app, using GlideApps.
Create your Mobile Stock Tracker using GlideApps
Installing the App on your Phone
Once the app is ready, click Share app from the navigation menu on the left, and click Copy link to app from the top-right.
Open this link on your phone in a browser. You will be then shown instructions to add a link to this app as an icon on your phone, which will make it resemble a mobile app.
It’s not very hard to take control of your data and build tools for yourself when amazing tools like Google Sheets and Glide Apps are available. Go ahead and build one for yourself.