I've been using the ActiveX Excel spreadsheet every day for over a year now and suddenly this morning I'm encountering the following error when I attempt to initiate a market scan: "Error: 162 Historical Market Data Service error message:Error: You cannot combine locations from different regions." Which is odd because I'm not even on the Historical Data page. Any one else encountering this error? I've searched IB's website and unfortunately there's nothing informative on it regarding that message.
Not that anyone would care, but I spoke to someone at the IB API group and got it fixed. Apparently the problem was that in the Location Code column I had "STK.NASDAQ, STK.NYSE, STK.AMEX", and that was causing the problem (though it was working every day for the past year and a half). He told me to change it to "STK.US.MAJOR", and that solved it.