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..........
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..........
|
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?
T R SOOD & CO
New Delhi
CA Inter
View Details
CMNITY HIRE
New Delhi
Others
View Details
CAclubindia
