kenlsk
5 posts
msg #150070
- Ignore kenlsk
modified |
1/2/2020 11:19:53 AM
Hi,
I'm trying to make the following function a negative value:
relative strength(^IXIC,45)
Is there a multiplication function in stockfetcher?
Thanks.
Regards,
Kiem
|
nibor100
1,048 posts
msg #150073
- Ignore nibor100 |
1/2/2020 12:28:40 PM
You can use "multiplied by" in an add column statement or a general statement and the simple asterix symbol inside a Set statement.
Ed S.
|
Village Elder
231 posts
msg #150078
- Ignore Village Elder |
1/2/2020 4:06:31 PM
Just use this:
Multiply by (-1) within the set{} statement as suggested.
|
kenlsk
5 posts
msg #150085
- Ignore kenlsk |
1/3/2020 9:07:31 AM
Thanks nibor100 and Village Elder.
The asterix symbol works.
Regards,
Kiem
|
nibor100
1,048 posts
msg #150089
- Ignore nibor100 |
1/3/2020 11:23:38 AM
@kenisk,
I assumed you were asking for the multiplier term because you were in fact going to multiply by -1 so I only gave you a list of multiplier options as SF handles these differently based on whether or not they are phrases, (which apparently is the preferred SF syntax)
In the example filter below, each pair of lines illustrates 1st what SF returns if mathematical symbols are used and 2nd what SF returns if equivalent math like phrases are used.
As a bonus example, the last pair shows how a simple add column command can actually filter the results by itself
While I have not tested it yet I'm hoping that it might help reduce the filter complexity issues that we occasionally run into with multiple nested Set statements.
I've not tested any of the other math symbols yet versus replacement math phrases. If anyone else can shed some light on those please do.
Thanks,
Ed S.
|