IPO Performance

[Darren]

Use the FIRST() function in a watchlist to calculate IPO performance.

To calculate the opening price of the first bar use FIRST(OPEN()), which can then be used to calculate the performance in a column or Show View:

IPO=FIRST(OPEN()); (CLOSE()-IPO)/IPO

1 2 3 4

IPO=FIRST(OPEN()); (CLOSE()-IPO)/IPO

The IPO Date column is FIRST(BARDATE()) with the Column Type set to Date.

Note: by default the watchlist will load data for the last year only. To get the first values from more than a year ago change the watchlist’s Date Range property to Everything.

 

Save the attached workbook for the US example above.

Attachments:

You must be logged in to access attached files.

2 users thanked author for this post.

Joshua Jones, Jeffrey A.

[Jonathan]

Thanks!

[Darren]

Here’s an updated workbook with 2020 US IPOs.

Attachments:

You must be logged in to access attached files.

1 user thanked author for this post.

Jonathan

[Jonathan]

Darren wrote:

Here’s an updated workbook with 2020 US IPOs.

Aussie IPOS 😉

[Darren]

Hi Jonathan,

Have you signed up for our weekly blog email? I updated the Aussie IPOs is last week’s post:

https://www.optuma.com/blog/

1 user thanked author for this post.

Jonathan

[Raphael]

Hello Darren, how are you?

I did it for Brazilians IPO stock, but i have a issue. Its capturing today date instead of IPO date.
I´m using same formula as you FIRST(BARDATE()) and also using bloomberg data. (attachted)

Do you have any idea whats wrong?

Attachments:

You must be logged in to access attached files.

[Darren]

Hi Rafi,

I think the issue is because of the way watchlists update with realtime data. I’ll see if we can get that looked at, but in the meantime the only work-around would be to use our End-of-Day Brazilian data, or turn off the connection to Bloomberg before opening the workbook.

[Author]

Posts