Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

calculation of F&O profit or loss

CA Varun Arora (CA) (286 Points)

29 November 2010

Can any one has excel sheet for calculation of profit or loss in F&O share market......

if has then please post .....

Thanks in advance to all..........

Reply
Follow
Share

4 Replies

CA Dinesh Shah (Senior Personnel) (203 Points)
Replied 29 November 2010

Enclosed is the format Copy the same to excel & continue ur work NAME OF PARTY/COMPANY ______________________
PROFIT & LOSS FROM TRADING IN FUTURES & OPTIONS FROM ___________ TO ___________
Ctrt No.	x	Purc Exp		PURCHASE			SALES			Profit / Loss	Days
	Particular	Expiry Date	Qty	Date	Rate	Amount	Date	Rate	Amount			X
38547	Nifty Futures	25-Jun				-			-	-	0	SDL
	x											x
	x					-			-	-
	x
	SDG+SDL					-			-	-
	LDG+LDL					-			-	-
	x					-			-	-
	x					-			-	-

	x					-			-	-	LDG
	SDL-Realized Losses in Derivatives Market					-			-	-	SDL
	SDG-Realized Gains in Derivatives Market					-			-	-	SDG
	x					-			-	-
	x					-			-	-

Upgrade to CAclubindia Pro. Subscribe Now!

CA Dinesh Shah (Senior Personnel) (203 Points)
Replied 29 November 2010

Dear Friend, Find the excel upload of the above. The Example s of nifty futures is for ur reference. If u need any further clarification email me todineshshah @ yahoo.com.

/editor_upload/415197943f & o profit & loss.xls