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