The provision of real-time bars by the TWS API is a new thing, as I understand it, since build 9.2 - I've always used solutions similar to the one you posted Rols, which tracks the live price and constructs bars purely from that. The problem with your sheet is that it looks at the price every...