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..........
Menu
calculation of F&O profit or loss
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?
Recent Topics :
- CA FINAL FR FINANCIAL INSTRUMENTS (Ind AS 109) Dou
- 70:30 GST rule for solar EPC: partial scope (struc
- TDS on Redevelopers hardship allowance received no
- Who will take FSSAI AND TRADE LICENSE: owner or te
- E Way Bill in respect of Without Bringing Material
- FAST DS 2026 query
- Consultation
- E-way notices for FY 22-23
- Gst file not created
- Regarding 3CEB query
Related Topics :
CAclubindia
