Hello,

I have a Pivot Table with some stock options information. The Row Fields are the Date, the Column Fields are the Strike, and the Data Items are the Bid and the Ask. The information I want is the Bid of the Strike - the Ask of the Strike that immediately greater and on the same date (i.e) the strike immediately to the right of the current strike.

It would be nice if I had a table or pivot table with only the derived information I am looking for, but it would be okay if this information was mixed in with the rest of the information in the Pivot Table.

Is there a way to easily do this? I can think of a few options, but none are very elegant. I am having a hard time attaching the file, if anyone needs to see it, tell me and I will figure out a way to attach it.

Thanks in advance.