How to Create Your Own Google Sheets Stock Tracker

These years, people are using apps for everything from trailing their weightiness loss goals to stemm trading. Even though using such apps makes your job much more relaxed, IT gathers a lot of our personal information, which is not secure. If you wish to monitor lizard some specific stocks for investment in them, it is e'er not a safe solution to have apps. Instead, you commode easily make your stock tracker on Google Sheets, yet if you get into't suffer any coding experience.

Let us pick up how to use Google Sheets as a stock tracker for free-soil.

Self-complacent

How to Create a Elemental Google Sheet Stock Tracker?
Create an Advanced Stock Tracker with Google Sheets
Find Historical Hackneyed Price Data on Google Sheets
Create Stocks Chart Graph connected Google Sheets

How to Create a Basic Google Sheet Stock Tracker?

Google Finance lets you see plowshare toll and securities market trends. Google integrates Google Finance with the Google Sheets with the subprogram GOOGLEFINANCE. Today, we are going to use this function to create a Google Shrou ancestry tracker.

Net ball's assume that you would like to watch, say, 10-20 stocks for few months earlier investing. Now, let's see how to create a basic line portfolio tracker on Google Sheets.

Google sheets get stock price

First, create a new sheet by navigating to sheets.google.com.
Incoming, add columns: Company Name, Banal symbol, Price.
Then, minimal brain damage the company names and their symbols connected the respective columns. You can search along Google to get their symbols.
Clack on the cell subordinate the Price column, against the first immortalize.
Click on the text field future to "fx" and type the following formula:
=GOOGLEFINANCE(ticker, "price").
For example, =GOOGLEFINANCE(MSFT, "price").
Hit Enter.

You can now find out the current stock price of the company you listed.

In this example, column B lists the stock symbols. So, if you type the following formula =GOOGLEFINANCE(B3, "price") on cell C3, it will equal populated with the current price of the stock on B3. Then, you dismiss drag that cell to other rows on column C to get stock prices of all other stocks every bit well.

Once you add stock details, you can share the sheets with others besides. It is also possible to share specific tabs in Google Sheets without sharing the intact spreadsheet file.

Find Historical Stock Price Information on Google Sheets

So far, we have just retrieved stock data using the made-up-in formulas. Now, let's essa to create a custom formula. For example, LET's say you would like to analyze the carrying out of a stock o'er a period of time. You can purpose a custom Google Finance formula to find and study arts stock price data happening Google Sheets.

          =          GOOGLEFINANCE          (          ticker          ,          "price"          ,          set about-date,          end-date,          "DAILY"          )

For example, let's say you would like to analyze the execution of Tesla Inc (TSLA) stock in the last 60 days. To get that data, Army of the Pure's customize the formula.

          =          GOOGLEFINANCE          (          "TSLA"          ,          "price"          ,          DATE          (          2020          ,          3          ,          15          )          ,          DATE          (          2020          ,          5          ,          15          )          ,          "DAILY"          )

google sheet get historical stock data

Related:8 Best Google Sheets Add-ons to Meliorate Productivity.

Produce Stocks Chart Chart on Google Sheets

Apart from the table information, you can also convert the historical data into easily understandable graphs and bars. When IT comes to stock trading, showing data in the graph makes more sense. Here is how to convert Google Sheets table data into a graphical record or pie chart.

Google sheet stock data chart

Select all information you require to cook a graphical record chart from.
Click Insert > Chart from the menu bar.
Resize and locomote the graph on Google Sheets.

You can bring with the options to change the chart type, adjust the date range, or do anything you wish. Just in case you do not want to use Google Sheets to track your stock portfolio, thither are plentifulness of Stock tracker apps available for Humanoid and iPhone.

Produce Advanced Stock Tracker with Google Sheets

Do you need to make an in-profundity depth psychology of the stocks? Fortunately, you can extract a lot of information for a particularised stock by using the GOOGLEFINANCE function. E.g., you can easily bring in important real-time data for a share like trading volume, possibility price, 52 weeks malodourous/low price, and more.

To get such advanced data on your stock, you can use extra parameters of GOOGLEFINANCE function. You just need to create additive columns and use up the functions as follows,

=GOOGLEFINANCE(stock ticker, "volume") =GOOGLEFINANCE(ticker, "priceopen") =GOOGLEFINANCE(ticker, "high52") =GOOGLEFINANCE(heart, "low52")

Also, you can get other information like price-to-earnings ratio (P/E), net per share (EPS), and more. There is more you give the sack do with the Google Finance functions to employ Google Sheets as a stock certificate tracker.

Enhanced Google Sheets Inventory Tracker with Formatting

Well, you can improve the stock tracker's appearance and data format with counterfactual formatting. We've nonliteral the capability of the sheet further past adding the tower to indicate the time to buy and time to sell each stock. See the favorable additional formatting we did.

We set the following indicators based happening the simple principle, "Buy happening low & Sell happening high".

Time to trade: Difference between Current Leontyne Price-52 Week high price.
Time to bargain: Difference between Current Price-52 Hebdomad low price.
Up/Down: Deviation betwixt Current Price-Purchase Price.

You can set the Red ink and Green colors to take on cells with conditional formating. This can bring home the bacon you an additional denotation where the parcel value drops approximate to 52-hebdomad low-spirited or 52-calendar week high real prise.

Now, you have successfully created your own stock portfolio tracker on Google Sheets. For quick access, sporting add the sheets to your favorites/bookmarks and track your stocks with a idiosyncratic click anytime you need.

Well, we have shown a simple example of how you can create and manipulation your own Google Sheets stock tracker. You can always add more features based on your requirements to the gunstock tracker successful with Google Sheets.

Disclosure: Mashtips is supported past its audience. As an Virago Associate I earn from pass purchases.