## NSE Nifty Derivatives OI analysis using Python and Excel

NSE Nifty Derivatives OI analysis using Python and Excel

NSE Nifty Derivatives OI analysis using Python and Excel

This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal. Below you can find the

Any changes you make to the data set are not automatically picked up by the pivot table. Refresh the pivot table or change the data source to update the pivot table with the

Use the solver in Excel to find the number of units to ship from each factory to each customer that minimizes the total cost. Formulate the Model The model we are going to

Use the SUBTOTAL function in Excel instead of SUM, COUNT, MAX, etc. to ignore rows hidden by a filter or to ignore manually hidden rows. Rows Hidden by a Filter 1. For example,

When working with tables in Excel, you can use structured references to make your formulas easier to understand. For example, we have the following table. 1. Select cell E1, type Bonus, and press

Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or

You can insert slicers in Excel to quickly and easily filter pivot tables. However, using the report filter gives the exact same result. Below you can find a two-dimensional pivot table. Go back

Use the solver in Excel to find the shortest path from node S to node T in an undirected network. Points in a network are called nodes (S, A, B, C, D, E

This example shows you how to use conditional formatting to shade alternate rows. Shading every other row in a range makes it easier to read your data. 1. Select a range. 2. On

Sensitivity analysis gives you insight in how the optimal solution changes when you change the coefficients of the model. After the solver found a solution, you can create a sensitivity report. 1. Before

This article teaches you how to reverse a list in Excel. For example, we want to reverse the list in column A below. 1. Enter the value 1 into cell B1 and the

This example teaches you how to run a linear regression analysis in Excel and how to interpret the Summary Output. Below you can find our data. The big question is: is there a

This article teaches you how to randomize (shuffle) a list in Excel. For example, we want to randomize the list in column A below. 1. Select cell B1 and insert the RAND() function.

A quadratic equation is of the form ax2 + bx + c = 0 where a ≠ 0. A quadratic equation can be solved by using the quadratic formula. You can also use Excel’s Goal

This example teaches you how to apply a number filter and a text filter to only display records that meet certain criteria. 1. Click any single cell inside a data set. 2. On

Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series. To create a pie chart of the 2017 data series,

This example teaches you how to remove duplicates in Excel. Go here to only find duplicates. 1. Click any single cell inside the data set. 2. On the Data tab, in the Data

This example teaches you how to create a thermometer chart in Excel. A thermometer chart shows you how much of a goal has been achieved. To create a thermometer chart, execute the following

Use a scatter chart (XY chart) to show scientific XY data. Scatter charts are often used to find out if there’s a relationship between variable X and Y. Straight Lines To

Outlining data makes your data easier to view. In this example we will total rows of related data and collapse a group of columns. 1. First, sort the data on the Company column.

A pivot chart is the visual representation of a pivot table in Excel. Pivot charts and pivot tables are connected with each other. Below you can find a two-dimensional pivot table. Go back

This example teaches you how to create a Pareto Chart in Excel. The Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes. In this

This example teaches you how to add a trendline to a chart in Excel. 1. Select the chart. 2. Click the + button on the right side of the chart, click the arrow next

This example teaches you how to group pivot table items. Learn how to group products and how to group dates by quarters. Below you can find a pivot table. Go back to Pivot

To quickly enter a GETPIVOTDATA function in Excel, type an equal sign (=) and click a cell in a pivot table. The GETPIVOTDATA function can be quite useful. 1. First, select cell B14 below

This example teaches you how to find and highlight duplicates (or triplicates) in Excel. Go here to remove duplicates. 1. Select the range A1:C10. 2. On the Home tab, in the Styles

This example teaches you how to perform an F-Test in Excel. The F-Test is used to test the null hypothesis that the variances of two populations are equal. Below you can find the

This example teaches you how to apply exponential smoothing to a time series in Excel. Exponential smoothing is used to smooth out irregularities (peaks and valleys) to easily recognize trends. 1. First, let&

This example teaches you how to add error bars to a chart in Excel. 1. Select the chart. 2. Click the + button on the right side of the chart, click the arrow next

You can use the Analysis Toolpak add-in to generate descriptive statistics. For example, you may have the scores of 14 participants for a test. To generate descriptive statistics for these scores, execute the

This example teaches you how to apply a date filter to only display records that meet certain criteria. 1. Click any single cell inside a data set. 2. On the Data tab, in

Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas. You can create a one variable data table or a two variable data table.

Icon Sets in Excel make it very easy to visualize values in a range of cells. Each icon represents a range of values. To add an icon set, execute the following steps. Select

This example teaches you how to insert a calculated field or calculated item in a pivot table. Below you can find a pivot table. Go back to Pivot Tables to learn how to

It’s perfectly ok to drag more than one field to an area in a pivot table. We will look at an example of multiple row fields, multiple value fields and multiple

Excel does not offer Gantt as chart type, but it’s easy to create a Gantt chart by customizing the stacked bar chart type. Below you can find our Gantt chart data.

Did you know that you can use pivot tables to easily create a frequency distribution in Excel? You can also use the Analysis Toolpak to create a histogram. Remember, our data set consists

Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis. Use a scatter chart (XY

This example teaches you how to create a histogram in Excel. 1. First, enter the bin numbers (upper levels) in the range C4:C8. 2. On the Data tab, in the Analysis group,

To create a heat map in Excel, simply use conditional formatting. A heat map is a graphical representation of data where individual values are represented as colors. To create a heat map, execute

A gauge chart (or speedometer chart) combines a Doughnut chart and a Pie chart in a single chart. If you are in a hurry, simply download the Excel file. This is what the

This example teaches you how to calculate the moving average of a time series in Excel. A moving average is used to smooth out irregularities (peaks and valleys) to easily recognize trends. 1.

Use the solver in Excel to find the maximum flow from node S to node T in a directed network. Points in a network are called nodes (S, A, B, C, D, E

To view all conditional formatting rules in a workbook, use the Conditional Formatting Rules Manager. You can also use this screen to create, edit and delete rules. 1. Select cell A1. 2. On

This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor or one-way ANOVA is used to test the null hypothesis that the means of

A row or column of numbers that are plotted in a chart is called a data series. You can plot one or more data series in a chart. To create a column chart,

Data bars in Excel make it very easy to visualize values in a range of cells. A longer bar represents a higher value. To add data bars, execute the following steps. 1. Select

The correlation coefficient (a value between -1 and +1) tells you how strongly two variables are related to each other. We can use the CORREL function or the Analysis Toolpak add-in in Excel

Sometimes multiple conditional formatting rules in Excel conflict. A higher rule always wins. This example illustrates two different results. 1. The value 95 is higher than 80 but is also the highest value