Google Finance - Stock market data to your spreadsheet on Google Sheets
🌟🌟NEW FREE ENGLISH QUIZZES🌟🌟
https://whizbusters.teachable.com/p/e...
💰2000 questions
💰Basic, Intermediate, Advanced Level
💰Word Quizzes + Sentence Quizzes
💰Video Solutions for each answer
💰No login required
💰Enhanced your English vocabulary anywhere and anytime
***************************************************************************************************** In this video I provide a comprehensive tutorial about the GOOGLEFINANCE function in Google Sheets. I begin with the purpose, and syntax. By using examples, I explain each parameter and the output from various combinations of the different parameters.
Time Stamps
00:00:00 Objective
00:00:14 What is the purpose and output of the GOOGLEFINANCE function?
00:00:54 Syntax
00:02:18 First Parameter of the GOOGLEFINANCE function is the ticker. This is explained with examples with NASDAQ:GOOG NASDAQ:AAPL NASDAQ:AMZN, how it can be referenced and the recommended way of inputing this parameter. Comparison of the first parameter with values from https://www.google.com/finance/ in real time
00:04:16 Second parameter of the GOOGLEFINANCE function is the attribute. All attributes for real-time data explained with an example
00:07:30 Attributes used to get historical data with the GOOGLE FINANCE Function explained with examples. The 3rd parameter start_date is explained with examples
00:09:09 Attributes used to get historical data with the GOOGLE FINANCE Function explained with examples. The 4th parameter end_date is explained with examples
00:10:27 Fifth parameter is the interval and it is explained with examples. Weekly interval explained and interpreted. Attributes used to get historical data with the GOOGLE FINANCE Function explained continued.
00:13:30 Attribute ALL from the GOOGLEFINANCE function explained with examples. Example of how to extract each value from the array returned when attribute ALL is used, with the INDEX and GOOGLEFINANCE functions together
00:16:13 Important note of error when omit the EXCHANGE before the ticker - explained with an example
00:19:04 Important points to note about the GOOGLEFINANCE function
INDEX function: • EXTRACT values and arrays from a tabl...
FUNCTIONS: • Playlist
PROBLEMS: • Playlist
ORGANIZE DATE: • Playlist
Let’s connect on social:
Instagram: /
More information about the GOOGLEFINANCE function: https://support.google.com/docs/answe...
#GoogleSheets #trading #stocks #englishlanguage #worddefinition #learnenglish #englishvocabulary #pronunciationguide #languagelearning
