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

Broker Special Offers

Intraday Higher Leverage

Save up to 90% in brokerage and get higher leverage for intraday trades.

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