Can Tradestation stream the Nasdaq continuous futures data @NQ to Excel? I need to see the current day's one minute close prices beginning at 18:01 (6 pm) and covering 24 hours (1440 minutes) through 17:59 (5:59 pm). The data I use for comparison in Excel is 30 rows (days) by 1440 columns (minutes).The @NQ data gets wiped clean each day and doesn't need to be stored.
Here's what I hope will be a clearer statement: Is there a way to stream Nasdaq E-mini futures prices in Excel? I need the current day's 1 min close prices beginning at 18:01 and added to an adjacent horizontal cell every minute through the 24 hour trading day. The time series that gets built through the day will be used to correlate with a set of factors in Excel that is 30 rows (tickers) by 1440 columns (minutes) by the end of the trading day. The futures data gets wiped clean each day and doesn't need to be stored.
Will each cell be carrying a formula? If so, depending on size, 1440 columns will probably be too much overload would be my opinion.
How would I fill a single cell? I can find ways to bring the column total down to something manageable.