StockFetcher Forums · View by Author: fotchstecker (187 messages) ·  [ Display By: Date / Subject ]<< 1 2 3 4 5 ... 19 >> 
General Discussion · Did this ever exist? "Appears in watchlist" in results...?
fotchstecker
msg #150156
1/6/2020 11:08:53 PM

Thanks, xarlor. No, I've done that plenty. I'm looking for a way to indicate in results if a symbol exists in one or more watchlists.

I think the second outline at this link is most like what I mean, but I haven't tested it yet:

https://www.stockfetcher.com/forums/Filter-Exchange/How-to-get-multiple-sectors-filter-to-work/149227

General Discussion · Did this ever exist? "Appears in watchlist" in results...?
fotchstecker
msg #150150
modified
1/6/2020 2:19:02 PM

I thought this was possible, but I'm not finding an example.

Within general results, is it possible to show (using a column) whether a ticker also appears in a saved watchlist?

Let's say I have a watchlist called "preferred shorts" with AAPL, GOOG, MSFT, and SPY. Can I show a 1 (true) in a column called "in preferred shortlist" to indicate when a filter's results include these tickers?

Thanks to any ideas.

General Discussion · How? average gap DOWN value | and average gap UP value | over X days
fotchstecker
msg #150087
1/3/2020 10:38:50 AM

It does indeed, I believe. I really appreciate your help on it. Thank you.

General Discussion · How? average gap DOWN value | and average gap UP value | over X days
fotchstecker
msg #150069
modified
1/2/2020 10:47:46 AM

Hi, nibor. I really appreciate the reply and help. Here's my extrapolation for "downs" based on your example:
Submit
Fetcher[
set{GapDowns,count(close-to-open gap < 0,12)} add column gapdwns

set{xgap2, open - close 1 day ago} add column xgap2
set{xgapdn, count(xgap2 < 0, 1)} add column xgapdn

set{xxgap2, xgap2 * xgapdn}
set{gapsumdn, sum(xxgap2,12)} add column gapsumdn

set{gapsdnavg, gapsumdn/gapdowns} add column gapsdnavg
]




General Discussion · How? average gap DOWN value | and average gap UP value | over X days
fotchstecker
msg #150057
12/31/2019 9:39:16 PM

{bump}
anyone have any ideas on this?
I know there are some very strong filter folks out there. Sadly, I'm not to be counted among you.
HNY to all!

General Discussion · How? average gap DOWN value | and average gap UP value | over X days
fotchstecker
msg #150042
modified
12/28/2019 3:54:16 PM

I've been working on this for a couple of days using all the examples I can find, including custom statements as well SF's built-in gap expressions. I haven't done it yet.

Does anyone know how to output a value for:

1. The average gap DOWN (price diff between open and previous day close is < 0) over the past 100 days?

2. The average gap UP (price diff between open and previous day close is > 0) over the past 100 days?

I'm able to easily find the absolute gap change value, but can't output values for only GAPS-UP and GAPS-DOWN.

Seems like it should be easier in SF, but I'm struggling with it. Any ideas?


General Discussion · count days and output "true" in columns?
fotchstecker
msg #150040
modified
12/28/2019 3:22:50 PM

not right yet. this is just averaging the counts.

set{Xgapped, open - close 1 day ago}
set{Xgapup, count(Xgapped > 0, 1)}
set{avg_chg_up,sum(Xgapup,100) / 100}
add column avg_chg_up

set{Xgapped1, open - close 1 day ago}
set{Xgapdn, count(Xgapped1 < 0, 1)}
set{avg_chg_dn,sum(Xgapdn,100) / 100}
add column avg_chg_dn



market is etf

General Discussion · count days and output "true" in columns?
fotchstecker
msg #150028
modified
12/27/2019 4:19:33 PM

Hi, xarlor -- happy almost new year. yes, absgap is part of a set statement.

Do you know how to calculate separate averages for gaps up and gaps down? I can use abs to calculate "any gap", but I need to know the idividual average gap size for gaps-down and then for gaps-up.

This is where a gap would be the change between the open and the close of the previous day (1 day ago).


--average gap UP over last 10 days

--average gap DOWN over last 10 days

...both in dollars.

General Discussion · ETF list cmd
fotchstecker
msg #150008
12/24/2019 11:54:18 AM

Hello, Stockfetcher:
Please remove CMD (Cantel Medical) from the ETF list. It's not an ETF (so far as I can tell).

General Discussion · count days and output "true" in columns?
fotchstecker
msg #149973
12/22/2019 2:13:31 PM

Thank you, Xarlor. I appreciate it very much.

Is the following valid for substituting an average for the static percent value? I want to check how many days over the last X days the gaps were greater than the 100-day average absolute value of gaps. I get output for the below but I'm not certain it's correct for the evaluation I want.

set{SinceLastGap,days(close-to-open gap > cma(absgap, 100),60)}
SinceLastGap > -1
add column SinceLastGap

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

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