IPO Performance

Optuma Forums Optuma Scripting IPO Performance

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #53683
    Darren
    • Topics: 73
    • Replies: 923
    • Posts: 996

    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:

    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.

    Capture

     

    Save the attached workbook for the US example above.

    Attachments:
    2 users thanked author for this post.
    #53707
    Jonathan
    • Topics: 43
    • Replies: 62
    • Posts: 105

    Thanks!

    #59795
    Darren
    • Topics: 73
    • Replies: 923
    • Posts: 996

    Here’s an updated workbook with 2020 US IPOs.

    Attachments:
    1 user thanked author for this post.
    #59891
    Jonathan
    • Topics: 43
    • Replies: 62
    • Posts: 105

    Here’s an updated workbook with 2020 US IPOs.

    Aussie IPOS 😉

    #59893
    Darren
    • Topics: 73
    • Replies: 923
    • Posts: 996

    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.
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest