Hi vasa,
Please clarify how u using ECN in spreadsheet?
Regards
VJAY
Sure:
In case I don't make sense just ask
.
First the ECN
must be a .html (opened with a browser) and not a .pdf file (opened with Acrobat Reader).
I have both Excel and Firefox open. In the first is a blank spreadsheet, in the other is my contract note.
With the mouse, I select the part of the ECN note that has stuff like trade time, order number, scrip, etc., etc.
This I copy and paste into the spreadsheet as "html" or "unformatted text".
It depends on your spreadsheet program and browser, which of the two you choose.
In the spreadsheet I also "
demerge" the entire sheet.
After that I can sort by scrip name, intra-day or delivery, etc. and perform sub-totals etc.
I do this so I can apportion service tax, ed. cess, and other charges on a pro rata basis.