karennma
8,057 posts
msg #129047
- Ignore karennma |
6/9/2016 10:03:48 PM
What's the Boolean for this ... please?
Let's say I have 5 columns (in my filter results): s1, s2, s3, s4, s5
How do I tell SF to add >>> s1 + s2 +s3 + s4 + s5, then /5 to give me an average?
Then add the average as column s6.
Thanks in advance.
|
graftonian
1,089 posts
msg #129072
- Ignore graftonian |
6/10/2016 1:13:13 PM
This is the only way to accomplish summing of columns (that ol' 1 math function per set statement).
I keep the code below in MS Word, and use find and replace to modify it to suit. The code, as written return average of open, high, low, and close.
Good luck, and happy week-end.
|
karennma
8,057 posts
msg #129080
- Ignore karennma
modified |
6/11/2016 8:18:20 AM
Hi graftonian,
Thanks for helping me.
My apologies for neglecting to mention this before, but ....
I just noticed the problem is, when the results appear in the columns, they have brackets (in "table" mode").
So, [1] is rsi 1 day ago, [2] is rsi 2 days ago and so on.
I think, somehow, the filter must be written with the brackets? (I tried already.)
For simplicity's sake, we'll use one stock
i.e, -- run this, and you'll see ...
The average rsi(14) would be 63.04.
|
graftonian
1,089 posts
msg #129082
- Ignore graftonian
modified |
6/11/2016 11:13:28 AM
Karen, I think the brackets are a "shorthand" method of displaying "x days ago"
Using SET statements eliminate the brackets
Does this make any sense?
|