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
- Error in gstr1 filing for October 25
- Inverted Rate structure .
- Exemption to be climed
- GST TDS u/s 51 Applicability on RBI and it's subs
- Time allowed to buy another asset
- ITR not processed for the FY 2024-25
- Gift of money to my wife.
- Tax Audit If you show Loss
- GST Tax invoice Value Rs..234000
- Can I claim benefit under 54F if I sell my equity
Related Threads
CAclubindia
