Sir please guide me how do i record and save option chain data and most active contract data for analysis. I have made automate excel sheet for option chain which is refreshing in every 3 minutes but not save time to time. same case in most active contracts data.
premium decay analysis is also time consuming for due to manual entries.
please suggest any remedy to auto records and save data in excel