I have to analyse NSE option chain data ( Nifty and Bank Nifty) and need to pull down data in every 15 minutes starting from 10:00 a.m on wards like 10:00 a.m, 10:15 a.m, 10:30 a.m till 03:00 p.m. I have to fetch data from NSE for 12 strike prices ( 6 strike prices each above and below the spot price @10:00 am) , i;e means 13 rows data to be pulled down from nse and stored in respective rows in the sheet namely "Nifty Option Chan" for Nifty Option chain data and form Nifty Bank Option chain data in the sheet namely "Nifty Bank". At 10:00 am first 13 rows data to be pulled and stored in the time slot mentioned for 10:00 am data. Then the data fetched at 10:15 am to be stored in the time slot mentioned for 10:15 am data both for the sheets of nifty and bank nifty. So the earlier data i;e was fetched at 10:00 am will remain unchanged and stored as it was fetched. The same process will be repeated till 3:00 p.m. As there is data lag in 2-3 minutes hence, the function to be triggered 2-3 minutes later. Say data for 10:00 am to be pulled down at 10:03 am and so on. For your understanding please find the google sheet herewith . Till data I am managing pull down of option chain data manually. But now wish to automate it.