IPOs buying after three days
Author: sebastian04
Creation Date: 9/13/2006 2:41 PM
profile picture

sebastian04

#1

I would like to buy an IPO the third day after it was brought to the market and sell it after 90 bars.

How can I code this?
profile picture

Cone

#2
Make sure that you have all the stock history and select "All Data" in the Data Loading Control.

CODE:
Please log in to see this code.
profile picture

sebastian04

#3
Thanks very much Cone
you were really quick.

Your code does exactly what I meant!

And you gave me a nice lecture in coding.
profile picture

gbullr

#4
Is there another way of Identifying IPOs other than bar 1? I am asking because there may be cases where bar 1 is just when history begins for a certain ticker.

Thanks.

profile picture

Eugene

#5
Finding an IPO's founding date does not seem to be a straightforward task. Basically, it's a question of where to look for a clue. The typical OHLC data does not contain a field that makes you (reliably) tell if the 1st date was the inception of the ticker. Some data feeds may have it (don't ask me which ones).

So, you can either assume that the 1st bar was the founding date, or look up for an external source of IPO data. Like this one: Founding dates for 9,396 firms going public in the U.S. during 1975-2011. Too bad it does not contain any tickers to refer to - only the IPO company names.
profile picture

Eugene

#6
I'm onto something:

IPO LIST broken by year, starting from 2000

Complete with ticker and date. The "only" thing left to do is to grab and parse these lists. ;)

The $64K question is, what does the date per se give you?
profile picture

gbullr

#7
Thanks.

Considering my programming skills, by the time I figure out how to "parse" something it will be the year 2100.

The date gives you the first date on which a stock was traded and w/ that rare event hopefully w/ the help of WL a profitable way to trade those events.

Plenty of studies abound about the performance of IPOs.... just trying to create a profitable strategy around the event.





profile picture

Eugene

#8
I'll see what can be done, when time permits.
profile picture

gbullr

#9
Thank you .

As a starting point if I may offer the suggestion of somehow marking IPO bar on new IPO pricing from FIDO datasets.

I will also make and attempt w/ the lists above to see if I can find a ticker search page and feed them the CO. names and see if it returns the ticker.

Thanks for your help.

I will have the list of IPOs from 2000 on excel by tomorrow.

I have the excel. Would you like me to post it?

profile picture

Eugene

#10
Thanks, no Excel required. I'm considering building a class for grabbing the data (ticker, IPO date and offer price), parsing, and caching. Just like we're already doing for upcoming earnings events and Google Trends in Community Components, it'll be possible to mark the IPO bar. Seems feasible (Apr/May 2012).
profile picture

gbullr

#11
Thanks.

if I may make another suggestion to capture lock up period end if possible.

Where do I find info on google trends thing.

Thanks.

profile picture

Eugene

#12
Where's lock-up period in the data provided by 123jump.com? There does not seem to be.

Google Trends can be found in the Wiki.
profile picture

Eugene

#13
Follow-up.

Early next month, a new class will be added to Community.Components. The class will support grabbing and parsing the IPO data lists collected by 123jump.com, transparently caching the data on disk. A new object will be returned containing the entered symbol's IPO date, underwriter, offer price, and company name.

An accompanying Wiki example will illustrate how to get these details in your Strategy for any given symbol in a couple of lines.
profile picture

Eugene

#14
Here we go!

* Updated Community Components
* IPOData class reference
* A sample IPO Buy Strategy to download in Wealth-Lab (from "Open Strategy" dialog, click "Download...") and to play with.