FNO turnover calculation in excel

nac

Well-Known Member
#1
I have been manually calculating t/o, but it's hectic. Do anyone have excel sheet/formula to calculate this in FIFO method?

Broker is providing scrip-wise t/o, but I need trade-wise t/o. I have tried several times to write formula in excel, but couldn't figure out this. It's kinda tough.

If anyone know how to write this in excel or have a ready made excel sheet, help me with this.

Thank you. :)
 

canikhil

Well-Known Member
#4
you need to play around a bit using sort function or pivot tables.

it makes a difference if you are doing scrip wise instead of trade wise. there will be difference in the turnover in most of the situations
 
#5
you need to play around a bit using sort function or pivot tables.

it makes a difference if you are doing scrip wise instead of trade wise. there will be difference in the turnover in most of the situations
Zerodha has a facility to give tradewise turnover also as an option.

Smart_trade
 

Relish

Well-Known Member
#8
It will be helpful for others if someone is not on Zerodha.