pls provide me google shet
1 Like
Hi Sandeepā¦ looking forward to know how we can import F&O live data which has OI.
Is there any trick/code available, to fetch live data from nse server to google sheet or excel?
it would be great if found any solution to import Most Active Underlying & Spurts in Open Interest .
currently using Download (.csv) button to download the data & upload on google sheet which is a manual process taken 2 mins & should be repeated atleast 3 time per day for me.
Hi,
Please help me, I want to import NSE option chain data to my google sheet. I find your response, so I ask for your response. Your provided url is not working. Please help me.
After such a long time, I finally understood,
- Excel data is best way as Google sheets canāt fetch direct stock options or future data.
- Youāll have to use Google App Script, which will delay data feed.
- Iāve finally prepared an excel file which can fetch live data from Nse, all types, no cookies issue, live data as per requirements.
- Since .xlsm or macro enabled or VBA enabled files canāt be run on android, thatās the only regret I have but I am using software to view my system on phone.
Hello sir, I want Excel sheet where I can find high open interest of stock buy side and sell side. 7 stock each. Can you help me . My email id is [email protected]
can we import us stockās open interest and implied volatility in google sheet using google finance Please share if you know
It is not possible to get data from NSE in google sheet. And even if the data comes, it has to be taken from the money control, but even in that, the data does not automatically refresh. But in Microsoft Excel, you can pull data in a very easy way and at the same time you can also analyze it and it also refreshes the data automatically. If anyone doesnāt know how to pull data or want to create some strategy in Excel, then you can watch all the videos by going to the link given below.
1 Like