IPO Performance

[Darren Topics: 37Replies: 238Posts: 275]

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.

[Jonathan Topics: 27Replies: 38Posts: 65]

Thanks!

[Jonathan Topics: 27Replies: 38Posts: 65]

I must be doing something wrong as its all blank for US shares…?

I’ve tried to import the data and reset the US data history.

Was a good idea though.

[Darren Topics: 37Replies: 238Posts: 275]

Hmm I think it might be because I was using a slightly different data source… Try deleting the symbols from the watchlist (highlight them all and hit the delete key, just like in Excel) and then type the symbols to add them again, and see how you go.

[Author]

Posts