StockFetcher Forums · General Discussion · Find stocks price average percentage change for last 5 days<< >>Post Follow-up
nsrikiran
3 posts
msg #152626
Ignore nsrikiran
6/13/2020 11:03:10 PM

Hi ,

Would some please help me to find stocks price average percentage change for last 5 days
and filter percentage change > 0

dwiggains
417 posts
msg #152630
Ignore dwiggains
modified
6/14/2020 8:43:32 AM

Fetcher[
close > 1
average volume (20) > 258000

set{change, close / close 5 days ago}
add column change
sort column 5 descending
]



see ya
david

glgene
568 posts
msg #152639
Ignore glgene
modified
6/14/2020 10:53:05 PM

Would some please help me to find stocks price average percentage change for last 5 days
and filter percentage change > 0

Fetcher[
/* next 2 lines from previous script*/
close > 1
average volume (20) > 258000

add column separator
add column close 5 days ago{closing price 5 days ago}
roc(5) above 0
add column roc(5){% gain past 5 days}
sort column 7 descending
]



Gene in FL

glgene
568 posts
msg #152663
Ignore glgene
modified
6/16/2020 9:47:23 PM

Added volume and industry to my script above

Fetcher[
/* next 2 lines from original script reply*/
close > 1
average volume (20) > 258000

Add column avgvol(50){avgvol(50)}
Set{vol, volume/avgvol(50)}
Add column vol multiplied by 1{vol/ v.avg}
Add column separator
Add column industry

add column separator
add column close 5 days ago{price 5d ago}
roc(5) above 0
add column roc(5){ROC(5)%}
sort column 11 descending
]


Gene in FL

glgene
568 posts
msg #152677
Ignore glgene
modified
6/18/2020 7:35:46 PM

Here are 2 more additions to my previous script:

1) There is a "count" of the # of up Days over the past 5 days (0-5). It is a summation count of #2 below.
2) D1 thru D5 represents Days 1-5; a "1" means it was an up day; "0" it was a down day.

Fetcher[
/* next 2 lines from original script reply*/
close > 1
average volume (20) > 258000

Add column avgvol(50){avgvol(50)}
Set{vol, volume/avgvol(50)}
Add column vol multiplied by 1{vol/ avg50}
Add column separator
Add column industry

add column separator
add column close 5 days ago{price 5d ago}
roc(5) above 0
add column separator
add column roc(5){ROC(5d)%}
add column separator

sort column 12 descending

/*Up Days calculation below*/
set{p0, count(close > close 1 day ago,1)}
set{p1, count(close 1 day ago > close 2 days ago,1)}
set{p2, count(close 2 days ago > close 3 days ago,1)}
set{p3, count(close 3 days ago > close 4 days ago,1)}
set{p4, count(close 4 days ago > close 5 days ago,1)}

set{z, p0 + p1}
set{zz, z + p2}
set{zzz, zz + p3}
set{zzzz, zzz+ p4}
add column zzzz{Days+}
add column separator

add column p0{d1}
add column p1{d2}
add column p2{d3}
add column p3{d4}
add column p4{d5}
add column separator
]


Gene in FL

StockFetcher Forums · General Discussion · Find stocks price average percentage change for last 5 days<< >>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 2018 - 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.