pa247
143 posts
msg #147797
- Ignore pa247 |
5/15/2019 5:36:34 PM
Im trying to figure out the next step in this formula but not being successful.
I'd need to find which is the greater of the variables below. Thanks much
set{td1, todays high - todays low }
set{td2,todays high - yesterdays close}
set{td3,yesterdays close - todays low }
|
SAFeTRADE
644 posts
msg #147798
- Ignore SAFeTRADE |
5/15/2019 6:44:15 PM
|
xarlor
581 posts
msg #147801
- Ignore xarlor |
5/16/2019 2:17:35 PM
pa247, StockFetcher doesn't like your syntax. Use this instead:
|
pa247
143 posts
msg #147803
- Ignore pa247
modified |
5/16/2019 3:06:12 PM
deleted.
|
pa247
143 posts
msg #147804
- Ignore pa247 |
5/16/2019 3:33:24 PM
@xarlor... thanks!
Im still doing something wrong because now var2 always equals 1, which cant be correct. Need some more help please.
|
graftonian
1,089 posts
msg #147806
- Ignore graftonian |
5/16/2019 4:24:18 PM
PA, Try this
set{var1, cema(higher_one, 14)}
|
SAFeTRADE
644 posts
msg #147808
- Ignore SAFeTRADE
modified |
5/16/2019 4:50:29 PM
Filter works fine. Look at the columns. Use as you intended.
Safetrade
|
pa247
143 posts
msg #147811
- Ignore pa247 |
5/16/2019 9:06:42 PM
Thanks all. Got it now.
|
nibor100
1,031 posts
msg #147840
- Ignore nibor100 |
5/19/2019 11:38:51 AM
a few observations:
a. I don't believe the last filter posted is working as intended as the phrase "yesterdays close' seems to be interpreted by SF as today's closing value.
b. if you add columns for each of the values used in the computations you'll see what I mean, (high, low, close 1 day ago, yesterdays close, todays low, etc.)
c. It looks like pa247 is calculating Wilder's True Range for the most current day, a simpler approach might be to use SFs Average True Range function with a period of 1 day:
ATR(1)
with the added benefit of making the filter much shorter.
Hope this helps,
Ed S.
|
pa247
143 posts
msg #147847
- Ignore pa247 |
5/20/2019 2:58:28 PM
@Ed S.
thank you! much better and doesnt crap out on me every other run. I have one more step im trying after the atr and it seems to work good.
thanks for the help
Paula
|