StockFetcher Forums · Filter Exchange · ETF Filter<< >>Post Follow-up
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,010 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.

Fetcher[
/* Plot the return based on the start of the month */
set{var1, DATE(MONTHSTART,open)}
set{diff1, close - var1}
draw var1 on plot price
set{diff2, diff1/var1}
set{diff, diff2 * 100}
draw diff and plottype{diff,zerobar}

and close is above 3.00 and average volume(30) is above 250000
]



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,010 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



StockFetcher Forums · Filter Exchange · ETF Filter<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.