nibor100 1,031 posts msg #155757 - Ignore nibor100 |
2/14/2021 10:26:54 AM
1. Many times I start writing a filter with lines such as below
and I get no column with volume times price info but a column with just volume info
2. Then I would revert to writing
Which works fine
3. Earlier this week I was researching an issue in the SF user manual and ran across this line
"add column fast stochastic(15) fast %k 1 week high minus the fast stochastic(15) fast %k 1 week low"
and it dawned on me that maybe an Add Column statement can perform math operations in text only forms on 2 indicators/variables so I tried replacing the " * " with "muliplied by'
and it worked!
4. Since I already knew that I could use an Add Column statement to combine column data output with "filter by" commands I wrote the following my old way
and then the test filter combining the add column with the filter by statement
which also worked!
Maybe everybody already knows that we can code this way, but it seems like a mini breakthrough to me that might help reduce some filter complexity issues we occasionally run into.by reducing the total number of set statements used.
Ed S.
|