calculation of F&O profit or loss

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..........

Replies (4)

 

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                                  -                                -                      -      

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

Enclosed is the exce files for ur record.

can anyone help me in calculating turnover and the profit/Loss in the sheets attached?

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details