Programing Excel to Exit trades

[syswizard]

Quote from Joab:

It really seems like a simple thing that I want done but I can't believe what a pain in the butt it's been so far.
btw, I only have 2-3 positions on at a time and I don't get why the platform can calculate the open PnL and why excel just can't use that figure per open trade?

You hit it EXACTLY Joab....their API is weak in this regard. Now If they had an OPENPOSITIONS worksheet that they posted to, this whole thing would be a snap....probably 10 lines of code max.