Customized NIFTY Option Chain in Google Sheets

I'm seeking a professional who can help me create a NIFTY option chain tailored to my specifications, viewable in a Google Spreadsheet. This spreadsheet should refresh automatically every minute with data sourced from nseindia.com. Key Aspects of the Project: - Data Points: The option chain should incorporate various data points from [login to view URL], including Strike Price, Last Traded Price (LTP), Open Interest (OI), and several others (e.g. COI, OI PCR, COI PCR, Implied Volatility (IV), Time Value). - Formulas and Calculations: The spreadsheet will need to have certain calculations and formulas integrated, namely OI PCR and COI PCR, Time Value computations, and Implied Volatility (IV) calculations. - Include data for Bid Price to observe the highest price a buyer is willing to pay for an option. Ideal Skills: - Proficient in Google Sheets, particularly in setting up auto-refreshing data. - Experience with financial data and creating option chains. - Ability to integrate complex formulas and calculations into spreadsheets. - Knowledge of NIFTY options and the data points from nseindia.com. This project should include visualizations or charts to represent the data effectively.

Project ID: 38868192