Extract data from broker statments

1. Can you download your trading summary in CSV format? You should be able to.
2. Do you monotonously manipulate that data in a spreadsheet?
3. Do you then output to a PDF file?
4. Would you like to automate the process?
   
5. Are you interested in Python coding? Python beginner level is fine.

If so then this thread I started under my old ET user-name (otm-options) might interest you:
Completed Python Script - CSV to PDF with Pyfpdf


My broker allows me to download my transaction history for any time period during the last 2 years in CSV format - I then use the script to output a polished PDF file ready for printing. CSV directly to PDF in less than a second.

 

Thank you all for answers. I am able to export trades from rjobrien for the last 2 years in csv format.

This is useful information but PDF broker statement contains much more information, like margin, all the fees, commissions, charges for interest, market data and CQG services. In the past I simply imputed manually all the numbers into excel. Later I developed broker statement PDF parser that does it automatically for me. I was thinking that such tool would be very interesting for futures traders. What you think?

 

Nitro Pro pdf reader will convert pdf to Excel. It does have trouble with some files but it will work ok with most pdf's.

 

Hi, I tried Nitro PDF, it does convent pdf into excel but file is useless as columns and rows are not detected correctly. Below is the screenshot:

 

I compared to my parser and I can see data is extracted correctly:


I do not know may many RJO customers are here but according to NFA/CFTC report
http://www.cftc.gov/idc/groups/public/@financialdataforfcms/documents/file/fcmdata1215-xls.xlsx
RJ OBRIEN ASSOCIATES LLC has ~4 billion in customer seg. assets.
Thy are biggest retail futures broker I think.

 

You can post-process the excel file i.e. clean it up in excel using the excel parsing tools and text functions

 

What parser are you using to clean up the file?

 

I developed my own parser. I placed it online at http://tradinganalyser.com/
Use login/pass: demouser/demouser

It produces file as the one I attach

 

Thanks, I was looking at something like that. Will give it a try.

 

Hi, please try it. You can also analyze your profit by each traded instrument. If you have questions please ask.