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 :
- Free CA Foundation Study Material - PYQs with Sugg
- INCOME TAX
- Moving from old to new tax regime after notice
- Need urgent help on notice
- ITR-3 - F&O Loss adjusted against business inc
- Error - Blank Rows in Schedule SI (ITR-2)
- Dividend from co-operative society
- SECTION 139(10) OF THE COMPANIES ACT, 2013 CASE
- TDS u/s.194C returns filed in ITR-1
- TDS on Property - Form 26QB Related
Related Topics :
CAclubindia
