Nifty Options-New file-July 2021

Nifty Options-New file-July 2021

Find the all new Nifty options file (Version 17Jul2021)
Fill the cells that are with yellow background. The file is not connected with any data feed. So one should manually enter the values and update high/low etc. Instead of overwriting values, please copy the whole sheet
using move/copy option and rename it.

Cells to be filled.
B2 = Trading day’s date (for eg:12-Jul-21)
C2 = Weekly expiry date (for eg: 15-Jul-21)
C5 = Month end expiry date (for eg: 29-Jul-21)
G1 = Nifty (Or Bank nifty to use the same file for Bank nifty options)

B4 = Open price of Nifty future
B5 = Close price (available on trading day’s morning before market open)
B6 = Yesterday morning close price (take it from NSE site or from previous day’s sheet)
B7 = Yesterday’s high
B8 = Yesterday’s Low
B9 = Yesterday’s open
B10 = Day before yesterday’s close price

B49 = Daylow (Please update the low whenever NF low changes)
B50 = Dayhigh (Also update the high whenever the NF hits new high on a day)

Scroll down to row 113. Please see the options listed in H113, H115, H117, h119, H132, H134 & H136.
Fill the open prices of all 8 options in cells A113, A115, A117, A119, A132, A134 & A136 respectively.
Also fill the high and low in B114 & C114, B116 & C116, B118 & C118, B120 & C120, B133 & C133, B135 & C135, B137 & C137 of those options.
As soon as we enter open price of an option, it will show two possible entry prices in B132, B134 etc and also Stoploss in C132, C134 etc respectively. Importantly it will show a “strength point” on below cell, once an entry price is entered. If the high crosses ‘strength point’, it will be in favour of option buyers. If the price didn’t cross ‘strength point’, then it will be good for option writers.

K147 is important. If it shows “Real SL”, then it will help to stop losses on highly volatile days.

Must read cells
M148 – it will show whether to exit or keep the first CE option
M149 – it will show whether to exit or keep the first PE option
M150 – it will show whether to exit or keep the second CE option
M151 – it will show whether to exit or keep the second PE option

A157, A158, A159 & A160 will show day range for Weekly expiry option

D163, D164, D165 and D166 will tell whether to hold BTST or not.

You can see the auto calculated CPR (BC & TC) in i83

Disclaimer – Only for paper trade.
If you find this sheet useful, please consider to donate for my work. ( OR

Version: 17jul2021

Nifty Trading Lite sheet-30July version

Nifty Trading Lite sheet-30July version

Nifty lite excel sheet.
Updated on 30-July-2019

Important cells are E14, E15, A17, B17, B18 & A46.
Sometimes E58, E59 will give some insight.

Published: 30/Jul/2019 11:17 pm

Nifty trading Excel Sheet

Nifty trading Excel Sheet

Download the latest Excel sheet for Nifty paper trading. Last updated on 30-Aug-2019 (Nifty future Sep 2019 contract)

If you find it useful, please pay for my coffee..(Payment is not needed for downloading the file. After testing the file, if you think my work is helpful, then you can pay for my coffee)
As a courtesy, I will notify you whenever a new version is uploaded.

Please check back for updated files.

Version: 30aug2019

PM Kisan application-Kerala-Malayalam

PM Kisan application-Kerala-Malayalam

Pradhan Manthri Kisan Samman Nidhi application form in Malayalam for Kerala state farmers.
File in PDF format.
Download, print and submit at nearest State Agriculture office along with copies of Land tax receipt, Ration card, Bank passbook etc.
Small Farmers holding upto 2hectares of land are eligible.


Excel sheet for Silvermini MCX-New

Excel sheet for Silvermini MCX-New

Download Excel sheet for Silvermini paper trading in MCX.

Latest major changes-
Cell E11 shows very vital info about Stoploss and targets. Hence wait for it to appear on some day to know the trend. Never trade against the trend.

Disclaimer-Not for real trading. Use only for learning purpose.

Last updated on 06-Feb-2019 (before market closing its not EOD data)


Crudeoil MCX entry point excel sheet (New)

Crudeoil MCX entry point excel sheet (New)

Crudeoil trade learner excel file. Read the comments given in certain cells. You have to manually enter all figures shown in yellow colour (Cells B4 to B13).
Cell E11 is very vital cell for new file. If it says F12 is SL, sell crude with strict SL at F12+1 point extra.

Prepared for crude oil MCX learners. Useful on paper trading. Don’t use in real trading.

If you have a question how to trade crudeoil in MCX, download this excel file and learn an easy way.
Come back and check later for updated files with latest formulas.

Last update: 06-Feb-2019 (before market closing time. So doesn’t contain EOD data)