Keep Track of the Stock Market with Google Sheets

Accordingly, Google Sheets owns a convenient function called GOOGLEFINANCE, which allows you to track the status and every stock market fluctuations in real time. First you need to get the stock code (the code representing a specific stock, in English called the ticker symbol) that you may need to track. For example, Apple's stock symbol is AAPL, Microsoft's stock is MSFT.

To facilitate the tracking, you create a stock code table corresponding to each company that you may need to track, such as the following:

Stock code table

In Google Sheets, we can use the function = GOOGLEFINANCE to enter stock data. To get started, just click a cell and enter the function. There is no need to enter the full company name for each stock symbol. Here is the formula we will use:

=GOOGLEFINANCE('mã cổ phiếu',"name")

In the example below, we use the formula in cell A2 to match "Volkswagen AG" with the stock symbol VLKAY. Then, simply drag the formula down to get the corresponding company name for each stock ticker.

Company name corresponds to each stock ticker.

Current Stock Value

To get information about the stock price you may need to track at the moment, use the following function:

=GOOGLEFINANCE('mã cổ phiếu',"price")

You can enter the stock symbol you may need to track in parentheses or click a cell containing the stock symbol in the list above. In the screenshot below, you will see the formula syntax is used. Once the results are out, simply scroll down to get the stock price for each company.

Current share price

This is the current share price, and will be constantly updated by Google Sheets.

Get Stock Value Information from a Specific Time Period

To retrieve information about stock values from a specific time period in the past (from day to day), simply use this formula:

GOOGLEFINANCE('mã cổ phiếu', 'price' , 'ngày_tháng_bắt_đầu', 'ngày_kết_thúc|số_ngày', [DAILY])

Such as:

=GOOGLEFINANCE("F", "price", DATE(2017,1,1), DATE(2017,2,11), "DAILY")

In which, 'F' is a stock code of Ford, 'price' is the stock value, the next 2 values are the start date and end date (year, month, day), DAILY is the value calculated according to day. We have the following table:

Stock value information by time period

Now, you have a list of stock prices at a given time.