How to use Google Finance Function in Google Sheets (GOOGLEFINANCE function)

Hi! Welcome to another one of our Google Sheets tutorial from TeqTog. Today we are going to write a tutorial article on how to use Google finance function in Google Sheets feature.

Let us get started then!

What Google Finance Function Is?

Firstly, let us learn what this feature exactly enables us to. Google Finance is basically a feature found in Google Sheets which allows the user to directly source real time financial information and currency data from the market. This function also allows latest information about stocks and shares.

Moreover, it recalls historical market information about securities.

Benefits of Google Finance

Before I can guide you on how you can use this feature called Google Finance, I have put together a brief summary on the multiple advantaged Google Finance will offer you. Let me discuss those with you first.

i. Google Finance has a feature called “World Market”. From here, you can view how markets are performing across the globe in different countries.

This is a great way to visit markets in different locations and get an idea about their conditions; which will help exporting and importing business making trade decisions.

ii. Google Finance also has a part about currencies, called the “Currency Section”. This section displays the valuations of different currencies compared with each other.

iii. Google Finance also has bond yields. (Bonds yields are a way of determining the return that an owner/ investment will receive on a bond)

iv. In addition, Google Finance has a part called “Sector Summary” where it will show you the state of various industries from a global perspective.

For instance, you can analyze the performance of industries such as, healthcare, civil, power, fashion or technology.

v. If you want to understand the stock market, Google Finance can also provide you with latest information on the stock market.

For example, it can show the Price to Earnings ratio; which is a helpful tool to recognize share valuations and make predictions.

vi. Moreover, this feature from Google Sheets is also much needed for investors for all the right reasons. See below to know more:

  • For those of you who are planning on making investments, Google Finance can be your best guides on making those decisions. Google Finance has a feature called the “fundamentals tab” which stores all kinds of information. From information such as market volatility, market caps to price to earnings ratio; the fundamentals tab has all kinds of ready information you may require to make wise investment decisions.
  • There is also a way to keep information regarding all your investments hidden in Google Finance. You can apply the fraction formula and maintain confidentiality over your investments; even if you need to view them from our workplace.
  • If you have your eyes on some shares but are not ready to acquire them in the moment; Google Finance can also help you with maintaining a list of shares you want to buy, for you to remember later. This is known as to “bench stocks” and you can trace them on a “pending basis”.
  • You can also operate a mechanism on Google Finance, through which you can dump all of your holdings you currently own and Google Finance will keep a track on them for you.

How to use Google Finance Function in Google Sheets

Open an Account in Google Finance

Here are a few, easy steps where I  can walk you through on how to open an account on Google Finance:

  1. First you would need to have an account on Google. (Gmail)
  2. Simply go to Google Finance through your Gmail account.
Google Finance in Google home page

3. You will find a “Create a Portfolio” on the middle part of the page.

How to use Google Finance Function in Google Sheets

4. Give your own portfolio name.

Create a Portfolio and give it a name

5. Select “Save” to done the process.

Done the Creatation of Portfolio

6. For adding investments, select “Add Investments”

How to Navigate through Google Finance in Google Sheets: GOOGLEFINANCE function

With the help of Google Finance, suppose you want to review prices per share.

  1. Open a new spread sheet in Google Sheets
  2. Type in the following in an empty cell: “GOOGLEFINANCE”. It is important that you type all in caps lock jut the way I presented, otherwise, the spread sheet will not be able to take your command.
  3. Then in intervals, add the following and, all of them should have a comma in between them.
  4. You will first see a ticker symbol option. Fill it out by typing abbreviation of the type of share you want to extract information on. Suppose, you want to study the trend in price per share of Google; then type in GOOG in quotation marks.
  5. Then after a comma, type in the nature you want to analyze. For instance, type in price. Make sure it is in quotation marks.
  6. Again after a comma, type in DATE and, give the date in numerical order.

In this case, you have to give two kinds of date. First date will be the date that you want Google Finance to begin extracting information. Second date will be the date till which that information is extracted.

To give an example, you want Google Finance to show you prices per share from first of January 2020 till thirty first of December 2020. So, you will have to type, DATE (2020,1,1), DATE(2020,12,31)

How to Navigate through Google Finance in Google Sheets

7. Give the frequency t which you want to study the trend.

Google Finance to show you prices per share
Google Finance to show you prices per share2

Summary of Jargons Explained

Here I have put together a set of terminologies which might be useful for you when you are working with Google Finance. It is important to understand the purpose of each function in the overall “GOOGLEFINANCE function”, because you want to get the accurate results according to what you are looking to work with.

GOOGLEFINACE(ticker,”attribute”,start DATE(numerical date), DATE(numerical date),”frequency”)

1. Ticker:

Shares and other securities are traded on the stock exchange publicly and openly. Since, there are thousands of companies who trade their share on the stock market, Google Finance requires a command which will help it identify the specific share, regarding which you need formation.

This is what this ticker part of the function means. It is an unique identification code which helps extract information on a share that is traded publicly on the stock exchange. For instance, GOOG is the ticker for the technology company Google LLC.

2. Attribute:

Attribute is the type of information you want to extract on the shares. This is mainly the trend of the characteristic you wish to analyze.

For instance, you want to review the price per share. Therefore, type in price in the attribute space. The attribute command has to be written in text form, so, whatever word you give, make sure you enclose the word with quotation marks.

In addition, whichever attribute you may want to see, Google Finance will extract the information on price either way.

(Attribute is an optional input)

3. Start Date:

This input is necessary when you are looking for historical data. For instance, you wish to view the price per share from a particular date.

Then, you have to fill out the start date space and type in that date.

By doing so, Google Finance will understand the date from which it needs to collect the information. This is an optional input, like the attribute input; however, if you skip this space, then you will be presented with the relevant information from today (meaning the day it is today)

4. Num Dayslend Date:

This input sets out a time frame between which Google Finance is required to collect the stock related information.

This is an optional input to give. However, you should note that if you leave the num_dayslend_date blank but, fill out the start date, then Google Finance will retrieve stock information for that day (start date) only.

5. Interval:

This parameter is necessary if you want to choose to review the frequency, between each change, in the attribute you selected to see about the share.

There are only two options for interval, and those two are daily or weekly.

Attribute and Historical Attribute

For your better understanding, here is a list of attributes which are available to get information on, using Google Finance:

  1. Price – This one is pretty obvious, right? This attribute shows information on the latest price of shares.
  2. Priceopen – Priceopen tell you about the opening price in the stock market.
  3. High – This is the highest price of the day you are on.
  4. Low – This is the lowest price of the day you are on.
  5. Tradetime – Tradetime displays the time there had been a trade on the stock exchange.
  6. Datadelay– This is the difference between the time for which you are getting an information and the current real-time.
  7. Marketcap – Marketcap is the potion of capitalization of the share market.
  8. Volume – Volume is the volume of shares which have been traded on the current day.
  9. PE and EPS – Price-Earnings Ratio and Earnings-Per-Share ratio.
  10. High52 – You can see the highest price of share in the last 52 weeks.
  11. Low52 – The lowest the price had fallen in the last 52 weeks.
  12. Open and close – These tell you about the price which was t the market open and market close.
  13. High, low and volume – These are the highest and lowest a price had been and, the volume of trade which had taken place during a particular period of time.

Here is some more Google Sheets guides on:

Related More Articles

Leave a Comment