Support Board

Date/Time: Sat, 20 Apr 2024 01:17:10 +0000

Post From: user2user question regarding excel formula - not a technical SC issue.

[2013-08-13 22:41:15] Link To Thread - Link To Post [Go To First Post]
namlem - Posts: 94
tomgilb, thanks for coming for a help! it's a nice tip and it works, but in some cases it's not enough.. for example, within an hour I have 4 15 minutes bars, formula gives FALSE[P6],TRUE[P5],FALSE[P4],TRUE[P3], the arrows will be painted on Q5 and Q3 bars.. 2 times.. at the same I don't want them to be painted next X bars, because I treat those as a one signal. So, I must correct my condition, by adding that arrows/signals not necessary go in a row, gaps can happen.. I hope I made myself clear. PS. also your suggestion requires additional column in a sheet. I stared my sheet when only 16 columns were available, so currently I will not have for each existing formula/column one new column. It's not very important, as soon as SC releases Non.-NET platform I will rewrite the code.