Access Google Finance data in Sheets

कदम 1
Create a new sheet in Google Sheets ‘sheets.new’.

कदम 2
To access the finance data, click on a cell and start your query by entering:=GOOGLEFINANCE(“The full query requires the following:=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

कदम 3
Add the ticker to the query:=GOOGLEFINANCE(“GOOG”“GOOG” is the ticker and can be replaced with any of the stock tickers from the 53 stock exchanges listed in Google Finance.

कदम 4
Add the attribute that you want the details of:=GOOGLEFINANCE("GOOG","price",This example shows that we’re interested in “price” for the stock GOOG. Other attributes you can examine are: "priceopen", "high", "low", "volume", "marketcap", “tradetime", “datadelay", “volumeavg", "pe", "eps", “high52", "low52".

कदम 5
Add the date period that you are interested in:=GOOGLEFINANCE("GOOG","price", DATE(2018,1,1), DATE(2018,12,31),

कदम 6
Now, add the timing interval:=GOOGLEFINANCE("GOOG","price", DATE(2018,1,1), DATE(2018,12,31),"DAILY")In this example, we’ve chosen DAILY but you can also look at WEEKLY prices.

कदम 7
To complete the query, click enter. The sheet will pull in the data we have requested. In this example, it will be the daily closing price for Alphabet’s (GOOG) stock price every day in the year 2018.