Support Board

Date/Time: Sun, 28 Apr 2024 06:59:06 +0000

Post From: Spread Sheet formula to establish if the sheet is presently being outputted to from chart

[2018-11-13 08:42:34] Link To Thread - Link To Post [Go To First Post]
enemyspy - Posts: 304
Thank you. So what happens is the study is used in a number of different ways. Sometimes it is used on 1 chart and other times it is used on 30 charts. No issues with creating the static sheets and naming them. No issues with adjusting for gaps in chart sequence either. Not really wanting to delete up to 50 sheets manually every time I re open a chart book though. The best solution I have right now is that the bid and ask are usually 0 in the j columns of sheets that are not associated with a chart. This eliminates most of the inapplicable data from my static sheets But not always. Can you think of a way to identify true of false if the data in a sheet is changing (connected to a chart)? Date Time Of Last Edit: 2018-11-13 08:45:41