The Opening Gap % pivot table report in TraderSync helps traders assess how their trades perform based on the market’s opening behavior, specifically the SPY index.

For each trade, TraderSync calculates the Opening Gap Percentage by comparing the SPY’s previous day close to the next day’s open. This percentage indicates how much the market gapped up or down at the open, which often reflects overnight sentiment or news.

Formula:

Opening Gap % = ((SPY Open Today – SPY Close Yesterday) / SPY Close Yesterday) * 100

For example, if SPY closed at 400 yesterday and opened at 404 today:

Opening Gap % = ((404 – 400) / 400) * 100 = 1%

TraderSync assigns this gap percentage to each trade based on the trade’s date. You can then use the pivot report to identify how your trades perform under different gap conditions — for instance, if you tend to profit more when the market opens higher vs. lower.