I need Fetch Nifty50 stocks real Time data on my Google Sheet or Excel Sheet

Trading
1

Hello Sir/Madam,

I need Nifty 50 All Stocks real time data on my excel file using my API key with stocks lable.
Stocks label: Open Price, High Price, Low Price, Last Trade Price, Volume.
I will share sample screenshot i think its easily clear what I want.

**Sample Screenshot:
**

image
image1578×509 26.8 KB

4

You can do this on google sheet without token. use google finance function.

1 example: =GOOGLEFINANCE(“NSE:WAAREEENER”,“price”)

5

I know about this …. its not show real time data.. I need real time data.. google finance show 15-20 min delay data …