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?
 
giena32 said:
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?
More...

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:
upload_2016-3-6_12-4-39.png
 
Hi, please try it. You can also analyze your profit by each traded instrument. If you have questions please ask.
 
You must log in or register to reply here.
Back
Top