StockFetcher Forums · General Discussion · Weekly SF knowledge Quiz and/or Weekly Tip<< 1 2 >>Post Follow-up
nibor100
1,042 posts
msg #140598
Ignore nibor100
1/2/2018 3:11:56 PM

The purpose of this thread is to document SF capabilities that I find/ or have found, so when I forget them I can easily find them by searching this thread; and

to hopefully provide some useful info about the myriad of SF capabilities to new members, and those members who generally don't take the time to explore sw capabilities.

Quiz #1:

a. What common trade statistic is available in StockFetcher that is not listed in Indicators, nor Filter Phrases, and doesn't come up in Filter Assist?

b. Can you provide a filter example of its use?

Thanks,
Ed S.


Lapre506
48 posts
msg #140622
Ignore Lapre506
1/3/2018 11:36:55 AM

Awesome thread idea. As to the quiz.. I do not know the answer. But I did notice SF does not support VWAP which is disheartening. I saw TRO tried to create it back in 2003. Luckily I can get it on my other trading platform. So any chance VWAP is the answer and I just haven't figured it out yet?

nibor100
1,042 posts
msg #140627
Ignore nibor100
1/3/2018 2:41:33 PM

@ Lapre506,

VWAP is an excellent try and your approach to solving it is using a path of inquiry that could lead to the right answer, but to my knowledge VWAP isn't currently available in SF.

Perhaps this one was a little too difficult/obscure to be the first quiz so here's a clue.

The recently departed member, K of G, would be able to answer almost immediately.

Thanks,
Ed S.

four
5,087 posts
msg #140629
Ignore four
1/3/2018 3:35:36 PM

do these work

https://www.stockfetcher.com/forums/General-Discussion/VWAP-Any-ideas/112677/-1/112678

nibor100
1,042 posts
msg #140667
Ignore nibor100
1/5/2018 3:04:01 AM

@four,

1. None of them work for the VWAP I'm familiar with, as it is usually used as an intraday indicator that accumulates during the trading day and starts over with each new day.

A fairly decent webinar explaining VWAP and MVWAP is available this site:

http://videos.worden.com/webinars/PriceVolume032310.html

Anyone can see how they work on FreeStockCharts.com for free, just remember that one must choose a shorter chart time frame than Daily to see the VWAP.

2. The last SF indicator, VMA(Days) shown in that link you posted seems to be equivalent to the MVWAP,
which is available in the SF Indicators thread with some clickable example filters.

I've pasted some of the associated info that you provided below:

"Volume Weighted Moving Average(simple)
Type: Indicator
Parameters: [period]
Usage: • volume weighted moving average(PERIOD)
• VMA(days)
Components: market strength indicator, volume, price close
Example:
• VMA(50) is more than 5 percent below the MA(50)
• VMA(50) has been increasing for 5 days
• VMA(20) crossed above the MA(20) within the last 1 day

Description: The simple volume weighted moving average takes a standard
moving average and uses the daily volume as a weighting
mechanism. The end effect is a moving average that responds to
spikes or lulls in trading activity. "

Thanks,
Ed S.

nibor100
1,042 posts
msg #140673
Ignore nibor100
1/5/2018 12:38:09 PM

Times up for Quiz #1.

1. The answer I was looking for is Max Drawdown.

2. Here is an example filter of its useage:

Fetcher[
show stocks where close is above 40
and add column Maxdd(20)
draw Maxdd(20)
and add column Max Drawdown(20) 1 year high
]



3. Here is SFs response when they created in response to K of G's request for it:

"We have a first-pass at a Max Drawdown function. The basic usage is:
Max Drawdown(period)
MaxDD(period)
This measure will compute the largest drawdown (in percent) over the period specified and draw a line from the high to low close.
...
Additionally, using the record high/low function on StockFetcher, you can find out what the largest n-day drawdown was over a specified period.
...
As with all new features, please let us know if you don't feel this value is computed correctly or have any questions on the data.
Thank you,
StockFetcher Support "

4. Note: it appears for some stocks the calculation is off a little, but probably much better than having nothing for Max Drawdown in SF.

Comments are welcome,
Ed S.





pthomas215
1,251 posts
msg #140685
Ignore pthomas215
1/5/2018 6:57:28 PM

Not sure if this is in the right place really but Kevin from GA posted this backtested filter a few months ago..pretty good 1-3% returns.

Fetcher[close > 2

REVERSERSI(2,90) is above LIMITENTRY
ma(200) crossed below LIMITENTRY within the last 2 days
RSI(2) BELOW 13
Average Volume(30) > 1000000
sort column 15 descending

COUNT(ROC(9,1) BELOW -1,2) ABOVE 1
ROC(50,1) ABOVE 5
CLOSE ABOVE MA(200)


SET{2ATR, 2 * ATR(20)}
SET{ACCOUNTSIZE,25000}
SET{RISKLEVEL, ACCOUNTSIZE*0.005}
SET{LIMITENTRY, MIN(CLOSE,REVERSERSI(2,5))}
SET{SHARESTOBUY1, RISKLEVEL / 2ATR}
SET{SHARESTOBUY, ROUND(SHARESTOBUY1,0)}
SET{POSITIONAMT, LIMITENTRY * SHARESTOBUY}
SET{STOPLOSS, LIMITENTRY - 2ATR}
SET{DIFF, LIMITENTRY - STOPLOSS}
SET{REWARD1, REVERSERSI(2,85) - LIMITENTRY}
SET{R_R, REWARD1 / RISKLEVEL}

ADD COLUMN RSI(2)
ADD COLUMN ROC(9,1) {ROC(9)}
ADD COLUMN ROC(50,1) {ROC(50)}
ADD COLUMN SEPARATOR
ADD COLUMN SHARESTOBUY {SHARES TO BUY}
ADD COLUMN LIMITENTRY {LIMIT ENTRY}
ADD COLUMN REVERSERSI(2,85) {PROFIT TARGET}
ADD COLUMN STOPLOSS {STOP LOSS}
ADD COLUMN R_R {REWARD-TO-RISK}
ADD COLUMN POSITIONAMT {POSITION SIZE IN DOLLARS}

DRAW PRICE LINE AT LIMITENTRY
DRAW PRICE LINE AT REVERSERSI(2,85)
DRAW RSI(2) LINE AT 5
DRAW RSI(2) LINE AT 85
DO NOT DRAW ROC(9,1)
DO NOT DRAW ROC(50,1)
SORT ON COLUMN 5 DESCENDING
CHART-TIME IS 3 MONTHS
]



nibor100
1,042 posts
msg #140689
Ignore nibor100
1/6/2018 8:10:34 AM

@pthomas215,

An excellent place to post that filter as it shows another SF function/indicator that is currently not listed in Indicators, Filter Assist, nor Filter Phrases.

ReverseRSI(period,value)

Below is the most text I could find out about it from SF posts:

"We have a first-pass at the "ReverseRSI" measure that you describe:
Please let us know if you have any questions, or notice any errors/bugs with this new measure.
Thank you!
StockFetcher Support "

Thanks,
Ed S.

pthomas215
1,251 posts
msg #140691
Ignore pthomas215
1/6/2018 1:43:44 PM

Thank you Ed. you can lower the RSI for even better results. to maybe less than 5.

pthomas215
1,251 posts
msg #140696
Ignore pthomas215
1/6/2018 4:44:48 PM

Graftonian the filter wizard, created one of the best filters i have seen. He posted it as "X marks the spot"..

Fetcher[
/* Guppy MMA */
/* X marks the spot */
market is not OTCBB
Average Volume(30) > 100000
close between .50 and 20

/*TRADER GROUP*/
draw EMA(3)
draw EMA(5)
draw EMA(8)
draw EMA(10)
draw EMA(12)
draw EMA(15)

/*INVESTOR GROUP*/
draw EMA(60)
draw EMA(50)
draw EMA(45)
draw EMA(40)
draw EMA(35)
draw EMA(30)
add column separator

/* investor group width */
set{igw, ema(30) - ema(60)}
set{igw2, igw / ema(60)}
set{IGwidth, igw2 * 100}
add column IGwidth

/*trader grp/investor grp separation */
/*The white space between the trader and investor groups*/
set{tradgrpmin, min(ema(3), ema(15))}
set{invgrpmax, max(ema(30), ema(60))}
set{tisep, tradgrpmin - invgrpmax}
set{tisep2, tisep / invgrpmax}
set{TG_IGsep, tisep2 * 100}
add column TG_IGsep
/* white space */
TG_IGsep > 0
/* trader group width */
set{tgw, ema(3) - ema(15)}
set{tgw2, tgw / ema(15)}
set{TGwidth, tgw2 * 100}
add column TGwidth
draw TGwidth
draw TGwidth line at 0


add column separator

set{IGX, days(IGwidth < 0, 200)}
add column IGX

set{TGX, days(TGwidth < 0, 100)}
add column TGX
TGX between -1 and 2
/* new section X marks the spot */
set{x1, 5 day slope of TGwidth}
set{x2, 5 day slope of TGwidth 1 day ago}
x1 > 0
x2 < 0
add column x2
add column x1
draw 5 day slope of TGwidth on plot TGwidth
draw 5 day slope TGwidth 1 day ago on plot TGwidth
set{sort, x1 - x2}
add column sort
sort on column 14 descending
CLOSE > OPEN

/*A couple of bells and whistles for back testing*/
set{entry, close}
set{target, entry * 1.10}
set{ stop, entry * 0.95}
draw price line at entry
draw price line at target
draw price line at stop

chart-time is 100 days
do not draw TGX
do not draw TG_IGsep
do not draw x1
do not draw x2
]



StockFetcher Forums · General Discussion · Weekly SF knowledge Quiz and/or Weekly Tip<< 1 2 >>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.