StockFetcher Forums · View by Author: (189 messages)  [ Display By: Date / Subject ]<< 1 2 3 4 5 ... 19 >> 
General Discussion · * GRIPE *
fotchstecker
msg #150499
modified
1/24/2020 2:19:22 PM

"Okay, I got it! These guys are in DAVOS and they're NOT kidding.
QE FOREVER!!!"

Not sure this is any real monpol understanding. QE entails credit swaps, short term asset swaps, and debt roll. About a month ago dollar borrow rates jumping like nuts and one could literally observe the repo operations in play which had the sole effect of giving market liquidity *because* of the borrow rate. When bonds are removed from circulation, liquidity is supplied to the market. Hate to be the bearer of good news because I know how depressing that can be, but this just means that it makes it easier for people to acquire money. QE != "easy money' policies, even though, like, "QE" has become a dog whistle for people to bark at. Recall, anyhow, Janet talking about QH, not QE.

General Discussion · Did this ever exist? "Appears in watchlist" in results...?
fotchstecker
msg #150494
1/24/2020 9:07:36 AM

Nibor my account was off for a few days and I just re-enabled it. I really appreciate your reply. I'll test these today. Much thanks.

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.

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