StockFetcher Forums · View by Author: (566 messages)  [ Display By: Date / Subject ]<< 1 2 3 4 5 ... 57 >> 
General Discussion · SF data base missing quite a few ETF symbols, one of them is FCNTX ( Fidelity Contrafund )
glgene
msg #154053
9/17/2020 10:20:49 PM

FCNTX is a mutual fund (not an ETF).

Filter Exchange · Need help - ON weekly chart stocks crossing ema(10) - need filter
glgene
msg #154001
9/11/2020 4:57:35 AM

Note: Above script is with daily pricing chart. Script below is with weekly pricing chart + a few other goodies. -- glgene

Fetcher[
weekly close crossed above weekly ema(10)
draw weekly ema(10)

/* the following lines are optional*/
close above 5
avgvol(20) above 250,000
add column avgvol(20)
set{vola, volume/avgvol(20)}
add column vola{vol/av.vol}
add column separator
add column close 1 week ago{close 1 wk.ago}
add column separator
add column weekly ema(10)
add column weekly ema(10) 1 week ago{1 wk.ago}
add column separator
set{calc, weekly close/weekly ema(10)}
add column calc multiplied by 100{wkly.close/wkly.ema(10)}
add column calc 1 week ago multiplied by 100{1 wk.ago}
/* Above 100= a weekly ema(10) crossover; eg., 102= close is 2% above wkly. ema(10)*/
add column separator
chart-display is weekly
chart-length is 6 months
sort column 13 descending
]




Filter Exchange · Need help - ON weekly chart stocks crossing ema(10) - need filter
glgene
msg #154000
9/10/2020 11:00:23 PM

Try this …

Fetcher[
close crossed above weekly ema(10)
draw weekly ema(10)

/* the following lines are optional*/
close above 5
avgvol(20) above 250,000
add column separator
add column weekly ema(10)
set{calc, close/weekly ema(10)}
add column calc multiplied by 100{close/weekly ema(10)}
/* Above 100= a weekly ema(10) crossover; eg., 102= close is 2% above wkly. ema(10)*/
add column separator
chart-length is 1 months
sort column 7 descending
]



Filter Exchange · Risk-adjusted 1-year return (via Beta)
glgene
msg #153367
modified
8/2/2020 5:02:01 PM

OK, SF experts … please fire away at my SF script below, which attempts to calculate a risk-adjusted return (using Beta) 1-year return of the S&P 500 stocks. The columns are pretty descriptive.
Questions:
1) Is it wrong to use Beta? Or should I use Standard Deviation? Or does neither do the job?
2) How long is the period for the standard Beta calculation in SF? (I'm assuming 1 year.)

My sort column is the risk-adjusted beta 1-year return (descending).

Any constructive input is appreciated. Thank you.
-- Gene in FL

Fetcher[/* Risk-adjusted 1 year return*/
sp500

add column avgvol(50)
set{a, volume/avgvol(50)}
add column a{vol/ avg50}
add column separator
add column weekly roc(1){roc 1 wk.}
add column weekly roc(4){roc 4 wks.}
add column weekly roc(13){roc 3 mos.}
add column weekly roc(26){roc 6 mos.}
add column separator
add column weekly roc(52){roc 1 year}
add column beta
set{b, weekly roc(52)/beta}
add column b{risk-adjusted beta 1 yr. return}
add column separator
add column standard deviation{std.dev}
add column separator
add column pe
add column separator
add column industry
add column separator
add column fi(13)
add column separator

sort column 15 descending
]





Filter Exchange · "Do Not Show Volume Column" in the Filter
glgene
msg #152957
7/5/2020 11:59:16 AM

I have been under the impression that SF’s standard 3 columns were fixed, and couldn’t be deleted:

— Last
— Chg(%)
— Volume

Am I right or wrong?

Gene in FL

General Discussion · Days Ago annoyance and question
glgene
msg #152807
6/26/2020 7:07:06 PM

Same with a 10-day moving average, such as...

Add column MA(10)
It covers 10 “market” days.

Or...

Add column ROC(5)
which covers 5 “market” days
of performance % results.

— Gene in FL


General Discussion · Days Ago annoyance and question
glgene
msg #152803
6/26/2020 4:35:39 PM

Days = trading days, not calendar days.

General Discussion · Find stocks price average percentage change for last 5 days
glgene
msg #152677
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

General Discussion · Find stocks price average percentage change for last 5 days
glgene
msg #152663
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

General Discussion · Find stocks price average percentage change for last 5 days
glgene
msg #152639
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

StockFetcher Forums ·  · << 1 2 3 4 5 ... 57 >>

*** 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.