Corey,
I ran into the same problem. I have been trying to think of a way to avoid getting hosed by the specialist like this in the future. One of my ideas was to take the "last," right when the market closes, and use that in my spreadsheet as the "previous day's closing price" for the next day. In reviewing the tape and my charts, I noticed that many of the "skewed" trades didn't print until a few minutes after the market closed, sometimes several minutes. My thinking is that if you take the "last", right when the market closes, and plug it into your spreadsheet for the "previous day's closing price," before it has been updated with the "skewed" trades, you may be able to avoid the problem. This might give you a more accurate closing price than if you load the "previous day's closing price" into your spreadsheet in the morning, which is what I have been doing. I haven't tried this yet, but it might work. It would also eliminate the need to go through charts for all your stocks in the morning, comparing the "previous day's closing price" with the "last" price on the chart when the market closed. What do you think?
Scott