Support Board
Date/Time: Sat, 23 Nov 2024 22:51:52 +0000
Post From: user2user question regarding excel formula - not a technical SC issue.
| [2013-08-13 22:41:15] |
| 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. |