Forums - How to Download IB Activity to Software?

HOME FORUMS BROKERS SOFTWARE BOOKS CONTACT US

Your Account • Become a Member • Help • Search

	Forums ›› Tools of the Trade ›› Trading Software ›› How to Download IB Activity to Software?

Page 1 of 2: 1 2

RedSun

Registered: Sep 2009
Posts: 250

03-19-10 05:27 AM

How do you download daily activities from IB to MS Money or Quicken? The activities are mostly futures, and the downloads do not make much sense. Because of the daily MtM?

Or have to use other software?

Edit/Delete • Quote • Complain

Catoosa

Registered: Sep 2001
Posts: 879

03-19-10 06:02 AM

I export each days trades from the TWS "trades window" to a windows folder. I have to then edit the transaction code of each trade to match the codes used by my Captools software before importing the trades files into Captools. This has worked great for me for many years of using Captools.

Edit/Delete • Quote • Complain

DT1

Registered: Dec 2002
Posts: 200

07-22-12 11:04 AM

Quote from RedSun:

How do you download daily activities from IB to MS Money or Quicken? The activities are mostly futures, and the downloads do not make much sense. Because of the daily MtM?

Or have to use other software?

I now use 'see finance'. The only software i have ever use that imports accurately ib ofx files. I don't trade futures but if you have issues do not hesitate to email the developer. They fixe issues quickly and are keen to add new features requested by customers.

Edit/Delete • Quote • Complain

rwk

Registered: Dec 2003
Posts: 984

07-22-12 01:50 PM

I download my daily and monthly statements in an XML format Excel can read. Then I copy the "Trades" section into an Excel spreadsheet and save that.

Edit/Delete • Quote • Complain

DT1

Registered: Dec 2002
Posts: 200

07-22-12 06:13 PM

Quote from rwk:

I download my daily and monthly statements in an XML format Excel can read. Then I copy the "Trades" section into an Excel spreadsheet and save that.

I started using excel but i wanted a personal finance software. It is cheap and i like being able to download all my accounts in a single tool.

Edit/Delete • Quote • Complain

vicirek

Registered: Dec 2011
Posts: 370

07-22-12 08:39 PM

It is a problem especially around tax time.

I had to develop my own file parser from Quicken format that does correct reporting suitable for tax schedule (Canada).

None of the formats currently in use are good for modern times when there might be thousands of transactions and financial software has its limitations or excessive cost.

Excel comes close to be the best but then there is a lot of manual adjustments to be made (splits, going long/short etc.)

Edit/Delete • Quote • Complain

Page 1 of 2: 1 2

Receive an email whenever a new post is added to this thread by subscribing to it.

Rate This Thread:

Forum Jump:

Conduct Rules - Privacy Policy - Day Trader - Day Trader Forum - Best Trading Software - Sitemap

WHILE YOU'RE HERE, TAKE A MINUTE TO VISIT SOME OF OUR SPONSORS:
Advantage Futures Futures Brokerage & Clearing AMP Global Clearing Futures and FX Trading Bright Trading Professional Equities Trading CTS Futures Trading Software DaytradingBias.com Professional Trading Analytics ECHOtrade Professional Trading Firm	eSignal Trading Software Provider FXCM Forex Trading Services Global Futures Futures, Options & FX Trading Interactive Brokers Pro Gateway to World Markets JC Trading Group Direct Access Trading MB Trading Direct Access Trading	MultiCharts Trading Software Provider NinjaTrader Trading Software Provider OANDA Currency Trading optionshouse Option Trading & Education Rithmic Futures Trade Execution Platform SpeedTrader Direct Access Trading	SpreadProfessor Spread Trading Instruction thinkorswim by TD Ameritrade Direct Access Trading TradersStudio System Building & Backtesting Trading Technologies Trading Software Provider Trend Following Trading Systems Provider