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 |
||||||||||||
| 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.
Enclosed is the exce files for ur record.
can anyone help me in calculating turnover and the profit/Loss in the sheets attached?
Recent Threads
- UNCLAIMED TDS REFUND QUERY
- Rcm payable which head
- Query of GST
- Long Term Capitalgains on sale of residential prop
- How Salaried Individuals Can Reduce Capital Gains
- NSTPI registration
- GST PAID IN DELHI
- How to Trade Forex in India?
- TDS - requirement of TDS by individual under presu
- Normal Register in GST in delhi in gujarat no rece
Related Threads
CAclubindia
