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