Login Page - Create Account

Support Board


Date/Time: Sat, 15 Nov 2025 23:05:53 +0000



Post From: Problems with Continuous Contracts

[2025-11-11 18:15:54]
TopGunTrader - Posts: 236
I used the spreadsheet formula if command to show the day of week and time of day for my stats it does work as you can see in picture the colors show up on that particular day and time.

When it fails is the PREVIOUS period. Also the delta is completely wrong on continuous contracts for PREVIOUS contracts.

Maybe the way I'm using spreadsheet formula to find and show ONLY day of week and time of day wasn't meant to work.

Is there a correct way to put day of week and time of day range and delta into spreadsheet study so I can copy to Excel and create stats that give me an edge?

As you can see in pic the weekday and time work fine UNTIL the previous contract is put on.

Notice the 2 contract periods deltas don't match look at A there's almost no delta from 8/22 to 9/11 but on top chart on the NQU25 contract its just fine. There's no doubt doing a continuous contract does not show correct delta for previous contracts on the NQZ25 chart.
imageCapture.PNG / V - Attached On 2025-11-11 18:13:46 UTC - Size: 327.05 KB - 13 views