हिंदी | How to get Stock Data in Google Sheets | Google Finance | Hindi
Topic: हिंदी | How to get Stock Data in Google Sheets | Google Finance | Hindi
Sheet Download: https://docs.google.com/spreadsheets/...
English Videos:
Google Finance Basics - • How to get Stock Data in Google Sheets | G...
Build your Own Ultimate Stock Portfolio using Google Finance - • How to Build your Own Ultimate Stock Portf...
Formulas:
Google Finance Formula - GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Sparkline Formula - SPARKLINE(GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])),{"charttype","line";"linewidth",2;"color","6ecc5f"})
If you are investing in the Stock Market or want to keep track of any Stocks. Nothing is better than getting those data into Excel or Google Sheets and doing some research on it. We have prepared one sample portfolio with the help of Google Sheets; you want to know how to do this. Watch this Video.
Video Name: हिंदी | How to get Stock Data in Google Sheets | Google Finance | Hindi
0:00 Introduction
1:14 Google Finance as Service
2:17 Google Finance - Google Sheets - Formula
2:58 Stock Exchange Codes
3:54 Basic Formula
5:21 Codes
8:15 How to use Stock Exchange Code
9:30 Historical Data - Basics
14:27 Historical Data - Auto Update
16:31 Graphical Data - Sparklines
17:58 Average Data
18:59 Build Portfolio
20:36 Thanks
#GoogleFinance #StockMarket #Shares