StockFetcher Forums · General Discussion · IPO Filter<< 1 2 >>Post Follow-up
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
390 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).

Fetcher[
symlist(ABNB)
]



nibor100
723 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:

Fetcher[
symlist(msft)
]



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
390 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
352 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
7,885 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?

Fetcher[volume 100 days ago equals 0 for last 100 days
close > 100

chart-time is 105 days
]




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
7,885 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
7,885 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.


StockFetcher Forums · General Discussion · IPO Filter<< 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 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.