How to use the GOOGLEFINANCE function in Google Sheets (WITH 5 EXAMPLES)
The GOOGLEFINANCE function allows you to import real-time financial and currency market data straight into Google Sheets.
► Read more about GOOGLEFINANCE's different usages: https://blog.sheetgo.com/google-sheet...
This function imports data from the Google Finance web application, which provides daily stock prices, news from the currency and financial markets, and other information on market trends. Google Finance can be accessed from the Google menu like all other Google applications, or simply by searching for a stock on Google, which will bring up the Google Finance information relating to that stock. As well as enabling you to track current stocks and shares information, it can also be used to retrieve historical securities data.
____________________________________________
Video breakdown:
00:00 - 00:34: Introduction & syntax
00:35 - 1:40: Example 1: GOOGLEFINANCE listed attributes for AAPL ticker
1:41 - 2:20: Hardcode each attribute into the formula
2:21 - 3:24: Example 2: Obtain historical stock information of a single day
3:25 - 4:31: Example 3: GOOGLEFINANCE output in 1 cell (combine GOOGLEFINANCE with INDEX)
4:32 - 5:11: Example 4: Obtain historical stock information over a period of time
5:12 - 5:27: Analyze stock data with charts
5:28 - 5:59: Example 5: Live currency conversion rates
6:00 - 6:13: Links & tips
____________________________________________
► Visit us: https://www.sheetgo.com/
► Subscribe to Sheetgo's Youtube channel: https://youtube.com/c/Sheetgo?sub_con...
Any questions? Feel free to comment below!
#Sheetgo #Google #Sheets #functions #GOOGLEFINANCE
Watch video How to use the GOOGLEFINANCE function in Google Sheets (WITH 5 EXAMPLES) online without registration, duration hours minute second in high quality. This video was added by user Sheetgo 25 January 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 75,015 once and liked it 1 thousand people.