Contract Notes Data

#1
Do any of you guys know a way to pull contract notes data into Excel. This has been a headache for me since my auditor requires the entire data from all contract notes.
I trade intraday as well as positional. So I have a lot of contract notes. I only maintain 'Trade Results' in excel and not the whole Contract Note.

I need a way to pull entire contract note data including bifurcations into Brokerage, STT, Exch Transaction Charges, GST, SEBI Turnover Fee, etc. into Excel.

Is there a tool to do it quickly?
 
#2
Do any of you guys know a way to pull contract notes data into Excel. This has been a headache for me since my auditor requires the entire data from all contract notes.
I trade intraday as well as positional. So I have a lot of contract notes. I only maintain 'Trade Results' in excel and not the whole Contract Note.

I need a way to pull entire contract note data including bifurcations into Brokerage, STT, Exch Transaction Charges, GST, SEBI Turnover Fee, etc. into Excel.

Is there a tool to do it quickly?
Your Contract Notes is in what file format currently?
 

yusi

Well-Known Member
#3
I need a way to pull entire contract note data including bifurcations into Brokerage, STT, Exch Transaction Charges, GST, SEBI Turnover Fee, etc. into Excel.

Is there a tool to do it quickly?
You could look into MProfit, free or paid. It does a good job of importing CNs from a variety of brokers and formats. The variety of reports are good enough for the auditor, and can also be exported to Excel. CN charges are accounted as STT, GST/S. Tax, Stamp Charges, Trans. Charges, and Other Charges.
 

Similar threads

Zerodha – Open Paperless Account

Open online account with Zerodha. Free delivery trading and Max Rs 20 for Intraday, F&O, Currency and Commodity Trading. Intraday High leverage with MIS, CO and BO.

Name:Phone:
Email:City:
State:
Are you a day trader?