Copy the gray collums down with the signal collums every day. Collum G through W. The N collum would be 0 until todays NDX data, specifically the date and opening price, is inputted.
Sorry, but 2006 chart is working as programmed. It is just programmed shitty.
A quick fix: Open the chart, scroll down to the row with todays date, delete all rows below it, which should be a bunch of 0's. That will make it look better. To update it daily, just copy the rows down every day.