Support Board

Date/Time: Tue, 07 May 2024 20:28:55 +0000

Post From: Problem with study data being replaced with zeroes when chart tagged for recalculation

[2015-11-28 05:18:02] Link To Thread - Link To Post [Go To First Post]
User941434 - Posts: 39
I have a "spreadsheet system for trading" for a chart in a chartbook that has a study output for "Time and Sales Bid & Ask" output at columns AA and AB. There is also a "Study Price/Overlay" for another chart(for a different stock symbol) that outputs the "Time and Sales Bid & Ask" study for the second stock at columns AD and AE. Every time the chart is tagged for recalculation all the bid and ask prices in all the rows in columns AA though AE get replaced with zeroes? Is there anyway to copy and paste these columns as values in the spreadsheet or protect them in some way so they do not get recalculated with the Main Price graph data columns when a chart is tagged for recalculation? I am using moving averages on these two studies in columns AA-AE so when the cells in columns AA-AE get turned to zeroes each morning when I load SC it reeks havoc on my trading model. Thanks!