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: 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: www.sheetgo.com/
► Subscribe to Sheetgo's RU-vid channel: ru-vid.com?sub_con...
Any questions? Feel free to comment below!
#Sheetgo #Google #Sheets #functions #GOOGLEFINANCE
2 авг 2024
