by GaryRussell » Wed Oct 26, 2022 9:51 am
Most of the time it will be the same prices, but as both worksheets will be updated on separate threads it's possible updates will be missed on either worksheet. When the market is busy there can be up to 50 updates per second. If Excel is still being updated when the next refresh occurs, then that refresh will be skipped on one or both worksheets. Therefore, I cannot guarantee both worksheets will have exact same data each refresh.