How to use the GOOGLEFINANCE formula in Google Sheets

How to use the GOOGLEFINANCE formula in Google Sheets


hello I am Mitchel from Sheetgo and today I’m
going to teach you how to use the google finance formula in Google sheets.
so, the Google finance formula helps us to get an insight of stock prices and
compile relevant stock information on your spreadsheet which means that this
is a very useful formula for data analysts so in this case I want to know
the lowest the highest and the last month stock prices of Apple the ticker of
Apple’s AAPL so that’s why I put in a AAPL instead of Apple so I’m going to use
the Google finance formula and every company does have another ticker so if
you want to find out which is the ticker of a company you need to search for it
throughout web so I’m selecting AAPL and I want to know the lowest stock price
but first I will put on the AAPL into dollar signs so I could drag it to the
right without changing the formula if you find this difficult this video is
based on a blog post so if you want to read more please click on the link down
below in the description and don’t forget to subscribe to our Channel
and secondly I want to know the lowest value so that’s why I’m putting on
low and put it into brackets and as you can see your lowest stockprice of today
is 183.66 and drag it to the right as i want to know the highest stockvalue as well and the highest stockvalue is 186.22 so now I want to know
last month stock prices which are a bit more difficult but we are using the same
formula so using the same equation Google Finance same ticker which is a
AAPL which corresponds to Apple this time I want to know price so price
corresponds to stockprice and I want to know the stock price of Apple so price, and I’m going to use it today formula
so we have made a video about the today formula and it is based on a blog
post so if you want to read more about the today formula please click on the
link down below in the description so I’m going to use today and I going to
use today minus 30 which means last month stockprices so minus 30 put it into
brackets and as you can see the Google finance formula successfully determined
the stock prices of last month well why there are only 19 stockprices? not
all of the stockprices are updated in the weekend so some of the surprises aren’t
in this formula so that’s why there are only 19 stockprices instead of 30 so this
is how I use the Google finance formula I want to thank you for your time and if
you liked video please put the thumbs up goodbye!

5 Comments

  • pao hue

    September 5, 2018

    GOOGLEFINANCE have XAGUSD and XAUUSD?

    Reply
  • AnantaSesaDas

    October 30, 2018

    only the default attribute works and only without typing it in, no optional attributes work. i am using ios11 sheets and it is oct `18.

    Reply
  • Nirmal Suthar

    February 25, 2019

    /Why google finance formula is not working on my computer?

    Reply
  • Yogendra Shrivastav

    March 29, 2019

    Sir , i have a google sheet using google finance formulae of say current market price , 52 high etc .
    I want the sheet to remain updated moment to moment ( reg cmp ) .
    How to do it , please guide .

    Reply
  • lozko karamitev

    June 16, 2019

    This was great, been searching for "stock market historical data minute" for a while now, and I think this has helped. Ever heard of – Fenason Zeyames Idea – (do a search on google ) ? Ive heard some extraordinary things about it and my partner got cool success with it.

    Reply

Leave a Reply