I managed to display oi data to gsheets but how to get it updated automatically. Also what’s the refresh rate(time) of nse api. Can they block my ip? How to avoid it?
The refresh rate of NSE API is actually 10 mins.
The data you see in NSE website on the OI is also delayed by 5 mins. But it doesn’t make huge impact.
NSE blocks IP if you scrap repeated within 3 mins. To avoid it, obviously, scrap in 3-5 mins. Use a randomizer.
time.sleep(random(180,240))