teoteoVN
9 posts
msg #105030
- Ignore teoteoVN |
2/18/2012 3:25:32 AM
Dear SF,
I use this filter, and run it on 18-Jan-2012
add column weekly high
symlist(AApl)
date offset 0: weekly high 526.29
date offset 5: weekly high 497.62
date offset 10: weekly high 460
date offset 15: weekly high 454.45
date offset 20: weekly high 420.45 WRONG (should be 431.37)
date offset 25: weekly high 427.75
Is this a serious bug or I did something wrong ???
|
stockfetcher
979 posts
msg #105031 |
2/18/2012 7:27:31 AM
Hi,
You'll want to specify the type of high. Your phrasing was essentially showing the high of close (close is the default). The following should resolve the issue:
and add column high 1 week high
symlist(AAPL)
and date offset 20
|
teoteoVN
9 posts
msg #105032
- Ignore teoteoVN |
2/18/2012 9:34:46 AM
ok I got it, so is it wrong to use "weekly high" to specify the high of the week.
|
teoteoVN
9 posts
msg #105034
- Ignore teoteoVN |
2/18/2012 10:09:02 AM
btw, just got this from SFUserguide 2.0
- weekly close: the last daily close for the week
- weekly open: the first daily open for the week
- weekly high: the highest traded price during the week
- weekly low: the lowest trading price during the week
- weekly volume: the sum of all shares traded during the week
I am confused now, look like it is only wrong when we put these terms into the column, isn't it?
|
teoteoVN
9 posts
msg #105035
- Ignore teoteoVN |
2/18/2012 10:16:23 AM
symlist(AAPL)
add column weekly low {wL}
add column low 1 week low {1wL}
add column weekly low 1 week ago {wL1ago}
add column low 1 week low 1 week ago {1wL1ago}
date offset 15
I tried to apply your rule to the low and I got the other way
weekly low is correct and low 1 week low is wrong.
Please help to clarify.
|