The page allow user to upload a file to calculate implied volatility and greeks of the options. The file must be in csv fomat and contains the following header:
We have named the columns according to the field name. User may download the sample data to see how the csv file looks like or how it looks like in an MS Excel file before conversion to csv. Once the file is uploaded, the calculation will start, the table will be updated and user may download the file to use the result for whatever purposes. There may be cases in which the calculation does not return any value. In our case , it is the call option with a strike of 1,510 expiring on July 30, 2020. The main reason is that, the value of an option should be at least the in the money value which is 80 (1590 - 1510), but the settlement is only 77.20.
Based on our sample data, we failed to see a smile or frown on the options which can be due to several factors such as liquidity and settlement based on arbitrary method/value. Your set of data may reveal something else.
Charts are provided for a quick visualisation of the data. Filters are used to properly chart the data and applied to two fields - expiry and poc, which are placed in the respective column header. Our sample data in the table comes with a sample filters which illustrate example of filter values for the respective column. Click 'Update Charts' to view the result. Clear the filter if you wish to view all the data in the table.
A surface chart has also been constructed for the calculated implied volatilities from the sample/uploaded data. Please ensure that the filter for poc is set to either 'call' or 'put'.