StockFetcher Forums · Filter Exchange · add a column<< >>Post Follow-up
reeseman
30 posts
msg #100382
Ignore reeseman
4/23/2011 7:46:10 AM

Is there away to have a columns to tell you how much a stock or etf gain or loss by weeks. simply looking to make different columns for each week. ( 1 week - 4 week columns.)

four
5,087 posts
msg #100383
Ignore four
4/23/2011 7:59:09 AM

Fetcher[
set{wk1ago, close 1 week ago}
set{wk4ago, close 4 weeks ago}
set{diff, wk1ago - wk4ago}
set{percent_chg, diff / wk4ago}
add column separator
add column percent_chg
add column wk1ago
add column wk4ago
add column diff
]



welliott111
98 posts
msg #100401
Ignore welliott111
4/24/2011 9:25:39 AM

Run after close Fridays for accurate weekly info

Fetcher[

etf

set{wkchng,weekly close minus weekly open}
set{1wkago,weekly close 1 week ago minus weekly open 1 week ago}
set{2wkago,weekly close 2 weeks ago minus weekly open 2 weeks ago}
set{3wkago,weekly close 3 weeks ago minus weekly open 3 weeks ago}

add column wkchng
add column 1wkago
add column 2wkago
add column 3wkago

chart-display is weekly
]



Kevin_in_GA
4,599 posts
msg #100403
Ignore Kevin_in_GA
4/24/2011 11:30:40 AM

Fetcher[
symlist(spy)
add column weekly roc(1,1) {1 week % gain}
add column weekly roc(2,1) {2 week % gain}
add column weekly roc(3,1) {3 week % gain}
add column weekly roc(4,1) {4 week % gain}
]



StockFetcher Forums · Filter Exchange · add a column<< >>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.