roca1018
163 posts
msg #153561
- Ignore roca1018 |
8/14/2020 8:09:57 AM
I am looking to monitor a set of ETF's for % price increase/decrease for monthly periods. The symlist
is not a problem. For example price increase from 6/1/20 to 6/30/20. Any help would be appreciated.
Thanks much,
Rich
|
nibor100
1,044 posts
msg #153570
- Ignore nibor100 |
8/14/2020 11:33:23 AM
Here's a messy start , whenever the line changes in price graph, get the value from the Diff chart immediately below, which will be the %return from the Open price of the month to the closing price of the month.
All intermediate values on chart below are % return from that specific day of the month to the beginning of the month.
Ed S.
|
roca1018
163 posts
msg #153587
- Ignore roca1018 |
8/15/2020 8:08:53 AM
Ed,
Thanks for your post. I am not a coder so I have done something very simplistic with 9 ETF's
using date offsets (ie date offset is 10 equals 7/31/20) and a date offset of yesterday and then
adding columns of the two. I just have to tweak the longer offset each day and save it. I am looking
at monthly trends.
Rich
|
nibor100
1,044 posts
msg #153591
- Ignore nibor100 |
8/15/2020 9:55:38 AM
@Rich,
You may be a better coder than you think, because I can't figure out how to code 2 date offsets in one filter and then add their columns together....
Also, I don't understand how a 10 day offset relates to: % price increase/decrease for monthly periods?
Thanks,
Ed S.
|
roca1018
163 posts
msg #153601
- Ignore roca1018 |
8/16/2020 6:53:56 AM
Ed,
At the time I wrote I was interested in comparing price at the end of last month (7/31) to the price on the
prior day so that is why the date offset was 10 at that time. After creating my symlist I simply added add
column price 10 days ago and add column price 1 day ago. My goal is to compare 9-10 ETF's on a
monthly basis for the purpose of making end of the month decisions. I'm also figuring that I could quickly
look at longer periods (ie 3 months) by changing the offsets. I am very impressed with folks that are good coders but sometimes get lost in a hurry.
Thanks again,
Rich
|