Support Board

Date/Time: Sun, 14 Dec 2025 09:34:02 +0000

Post From: Spreadsheet Trading Price Cross a fixed level

[2023-04-03 13:08:15] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4299
All of the crossover functions require ranges. This is because the crossover functions must compare the current bar with a previous bar. IOW, there is no intrabar crossover because intrabar values cannot be made persistent in a spreadsheet study; only close of bar values are persistent. If the levels are the same in at least rows 3 and 4, then the crossover functions will do what you want.