looking for Excel add-in to calculate intraday IB P&L

I trade options in the SPX. IB's intraday calculation of P&L is always wrong. It disrupts my harmony when it shows me down 5 digits and I know the position is actually making money. I need a way to view P&L based on the midpoint of option prices. Any suggestions?

 

try their excel file. DDE or whatever it's called. if you didn't like it-you can always modify it to fit your needs.

 

Thanks for pointing me in the direction of the DDE.

 

sure, np