Charting Equity Curve in Xcel with IB Import

[chops_a_must]

Just a question.

How do I get the IB export data into a format to be able to chart an equity curve on a trade by trade basis?

I can export, and I can do the excel charting. It's the bit in between I'm lost on. I can't seem to find anything on the IB site to help.

Do I have to do the formatting myself?

 

[MS+Tradesim]

Just a question.

How do I get the IB export data into a format to be able to chart an equity curve on a trade by trade basis?

I can export, and I can do the excel charting. It's the bit in between I'm lost on. I can't seem to find anything on the IB site to help.

Do I have to do the formatting myself?

Sorry, but I don't understand your question.

Are you using a DDE setup?

 

[IFocus]

Chops are you exporting in csv ?

 

[chops_a_must]

Sorry, but I don't understand your question.

Are you using a DDE setup?

Yeah, I think so.

Just going through the exporting trades instructions in IB.

Seeing if there is a way to get it into a different format to graph, from there...

 

[MS+Tradesim]

The following only applies if you're trying to use DDE into Excel. If you're manually exporting data from TWS into Excel then don't worry about this.

Have you got the API software installed and running?
http://individuals.interactivebrokers.com/en/p.php?f=api&p=b&ib_entity=llc

Have you turned on DDE in the TWS platform under the API menu?

You can download their DDE sample spreadsheet here:
http://www.interactivebrokers.com/download/TwsDdeBeginners.xls

I've been fiddling and customising some of this in my IB papertrader account. This might give you the "in-between" stuff you're looking for (which I confess I still don't grasp ) For example, I've set up some cells which track currencies in real time and position size accordingly. You could set up the spreadsheet to track orders so it shouldn't be hard to turn that data into whatever you want to chart.

The "Old Style Account-Portfolio" tab in the above spreadsheet has a "Realized PNL" column. Im guessing that would be useful??

Dunno if that helps.

 

[chops_a_must]

It almost gives me exactly what I want MS... but for some reason it isn't importing into any of the P&L columns.

This is what I'm trying to do:

http://tremblinghandtrader.typepad.com/trembling_hand_trader/2008/02/technical-anlys.html

I notice on the ordinary export setting in IB, I can check a realized P&L box, but for some reason, that isn't exporting.

It would be all I need to do what I want.

 

[MS+Tradesim]

Can't access TWS over the weekend so I can't even have a go.

 

[crown]

Was there a conclusion to this thread?

I to would like to have my TWS trades charted in excel as they are executed (As other ASF members have done), but am finding the info on how to complete this task difficult.

Any pointers or reference to links would be helpful.