Support Board

Date/Time: Wed, 27 Nov 2024 13:32:06 +0000

Post From: help with spreadsheet #CREF! with reference cell value

[2023-08-24 08:57:53] Link To Thread - Link To Post [Go To First Post]
User651753 - Posts: 77
I am trying to create a spreadsheet trade study. I want to start with a "base" price of $100 and create an entry only if the price has stayed between $40 range ($80> $120) when the price increases to $150 I want to increase the "base" price by $50 price so now the study will continue to trade while around $130> $170 ( if the price decreases to $50 I want to trade $30>$70) I116 = "base price" J116 = 100 I117 = "change base target" J117 = 50 I120 = "is current price higher base + change" J120 = =if(J113>(J116+J117),"YES","NO") I121 = "is current price below base + change" J121 = =if(J113<(J116-J117),"YES","NO") I122 = "what to do with base" J122 = =if(J120="YES","increase",if(J121="YES","decrease","do nothing")) I123 = "new base" J123 = =if(J122="increase",J116+J117,if(J121="decrease",J116-J117,0)) I want J116 = J1232 but then I get #CREF!


Attachment Deleted. up down system.scss - Attached On 2023-08-24 08:54:57 UTC - Size: 38.22 KB - 235 views SierraChart_64_F3JorMRsJc.png / V - Attached On 2023-08-24 08:55:24 UTC - Size: 8.31 KB - 77 views