Read,Write and Extracting Live Stocks Quotes in Excel with the Help of Google Sheet API Python

Please Follow the Video for Proper Instructions then Code Input:

import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope=['https://spreadsheets.google.com/feeds']
creds=ServiceAccountCredentials.from_json_keyfile_name('AD.json',scope)
client=gspread.authorize(creds)

sheet=client.open('ALGO').sheet1

sheet.update_acell('A1','Ticker')
sheet.update_acell('B1','Price')
sheet.update_acell('C1','Open')
sheet.update_acell('D1','High')
sheet.update_acell('E1','Low')
sheet.update_acell('F1','Volume')
sheet.update_acell('G1','Close')

In Formulae Block place this For Close Price =GOOGLEFINANCE("NSE:"&A2,"closeyest")

For Open Price: =GOOGLEFINANCE("NSE:"&A2,"priceopen")

For High Price: =GOOGLEFINANCE("NSE:"&A2,"high")

For Low Price: =GOOGLEFINANCE("NSE:"&A2,"low")

For LTP Price: =GOOGLEFINANCE("NSE:"&A129,"price")

--End of Code Input--

Please Share us On Various Social Media Platform