ely
6 posts
msg #155183
- Ignore ely |
1/4/2021 7:11:46 AM
Hello community,
I am trying to create a filter searching for recent IPOs (say last 200 days). It's definitely not a new topic, and I did my research and tried pretty much all the variants I found, like:
(1)
volume 100 days ago equals 0 for last 100 days
close > 1
(2)
relative strength(^SPX,99) equals 0
(3)
close >= 1
volume >= 100000
volume 3 months ago <= 0
(4)
count(close equals 0, 100) > 70
close > 1
They do retrieve some New Stocks - no doubt, but NON OF THEM managed to find Airbnb IPO (ABNB ticker) which happened in the beginning of December. Any ideas? Anything wrong with that particular stock? Or I am missing something in the code, and there is some smarter way to deal with this task? Thank you in advance!
|
xarlor
587 posts
msg #155186
- Ignore xarlor |
1/4/2021 12:37:48 PM
Those IPO filters are probably okay, the problem is ABNB is not part of the stock universe on SF (yet).
|
nibor100
1,044 posts
msg #155188
- Ignore nibor100 |
1/4/2021 10:43:52 PM
Now for a little of the SF chart magic:
first run the filter below:
Then pull up a chart window of msft
Then replace msft in the top left box with ABNB and select the CHART button
and a chart of ABNB appears, seemingly out of nowhere....
Ed S.
|
xarlor
587 posts
msg #155190
- Ignore xarlor |
1/4/2021 11:21:10 PM
Good catch, nibor.
The disclaimer at the bottom of the SF site:
EOD Data sources: DDFPlus & CSI Data
Seems CSI Data does not have ABNB yet, but DDFPlus (aka BarChart) does. That leads me to believe that chart data is pulled from BarChart while filter data is pulled from CSI Data.
The more you know.
|
snappyfrog
731 posts
msg #155195
- Ignore snappyfrog |
1/5/2021 9:56:11 PM
Interesting
|
ely
6 posts
msg #155198
- Ignore ely |
1/6/2021 4:10:13 AM
Thanks everybody! Appreciate your help. But that's really weird - some data provider doesn't have 80+bn stock in the database!... That's nonsense... I like SF for its' flexibility and functionality but looks like the reliability is in question.
|
karennma
8,057 posts
msg #155199
- Ignore karennma |
1/6/2021 8:58:10 AM
Hi ely,
I'm just "passn' thru" .... and don't scrutinize the board much, so, my apologies if this is NOT what you're looking for ... you wanted ABNB?
|
ely
6 posts
msg #155223
- Ignore ely |
1/8/2021 6:18:48 AM
Thanks karennma, but that one doesn't retrieve ABNB either.. At least on my computer... StockFetcher, any advice on the ABNB case?
|
karennma
8,057 posts
msg #155224
- Ignore karennma |
1/8/2021 7:40:01 AM
Yes, it does. It's right there clear as day.
It's the 1st one - or 2nd stock.
You need to change your SETTINGS.
BRB ...
Let me see which one it is.
|
karennma
8,057 posts
msg #155225
- Ignore karennma
modified |
1/8/2021 7:43:39 AM
In the UPPER right corner, click "Account".
Click "Settings".
Click "Results"
Where it says "Days of trading history required to appear in results" be sure you have a LOW NUMBER (as opposed to "100").
For example, I have "2".
So any IPO that has traded for 2 days or more will appear.
|