Watch List Update

Optuma Forums Optuma Scripting Watch List Update

This topic contains 5 replies, has 3 voices, and was last updated by Matthew Matthew 2 months, 1 week ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #51611
    Avatar
    Jonathan
    • Topics: 21
    • Replies: 25
    • Posts: 46

    Hi Forum Members,
    I need some of your help…
    I would like to create a watchlist that automatically updates at when data has been updated in optuma.
    Essentially I am looking to find the biggest gainers of the day, which has a percentage variable, a volume (either % of $) variable.
    At the moment I need to use third party providers like investing.com stock screener to perform this which only takes me 10 seconds to do.
    Though, for the life of me I cannot get this to work in optuma.
    What am I doing wrong?

    #51615
    Matthew
    Matthew
    • Topics: 4
    • Replies: 137
    • Posts: 141

    Hi Jonathan,

    The fastest way to do this in Optuma would be to …

    1. Set up a scan that identifies all codes that have gone up that day.  You would use a simple script to do this like CLOSE() > OPEN()
    2. Export the results to a Watchlist (this will link the WL to the scan so each time it opens it updates automatically).
    3. The Change % column that opens by default in a Watchlist is Close vs previous days close, so remove that and replace it with a custom script column that measures the % gain for the current bar using this:

    4. Change the columns properties to display as a %

    5. Sort the codes by the newly added column so the largest % gainers are at the top.

    End Result looks like this….

    Ex5

    (If you have Enterprise services you can also sort the rows in to Bins and show only those in the highest 10%, 20%, of gains etc.)

    Ex6

    #51623
    Avatar
    Jonathan
    • Topics: 21
    • Replies: 25
    • Posts: 46

    Thanks Matthew,

     

    I attempted to replicate the two provided scripts. I then ran the scan on the whole ASX. Though I received 0 results.

    IS there a pre-loaded script I can use to only display shares above a certain dollar figure?

    Attachments:
    #51639
    Darren
    Darren
    • Topics: 36
    • Replies: 211
    • Posts: 247

    Hi Jonathan,

    Please provide the formula you are using so we can see the problem, but to filter for stocks above eg $1 simply add and CLOSE()>1. If you have ASX Fundamental data on your subscription you can also filter for eg > $25 million market cap using the DATAFIELD() function with market cap:

    DATAFIELD(FEED=FD, FIELD=MarketCapitalization, LATESTONLY=True) > 25

    And if you want to filter out illiquid stocks include eg VOLUME()>50000 so are those that traded above 50,000 shares are included.

    The Change % field is the daily change (on a daily watchlist, or weekly % on a weekly, etc) so if you run the scan and open as a watchlist, add any other columns you want, and sort by Change % and save the workbook. Then when you next open the workbook the scan will automatically run (because it’s linked to the watchlist) and be updated.

    If you need more help we’re happy to arrange a consultation session.

    Capture

    #51651
    Avatar
    Jonathan
    • Topics: 21
    • Replies: 25
    • Posts: 46

    Rules

    Percent Gainers:

    V1 = ((CLOSE() – OPEN()) / OPEN()) ; V1

     

    Rising Shares

    CLOSE() > OPEN()   

    I now want a new variable.

    and CLOSE()>1 – 10

    (If that is the correct way to script it)

     

     

    Attachments:
    #51663
    Matthew
    Matthew
    • Topics: 4
    • Replies: 137
    • Posts: 141

    Hi Jonathan,

    Only the first script in my reply was meant for the scanning manager:

    The other script (% Gainers) was to be applied to the Watchlist as a column, not to be used in scanning (scanning needs a True / False script to run that is why no results were returned).

    With the new variable you can add that to scripting. If you are wanting the Close to be between $1 and $10 the script would be…

     

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.

Pin It on Pinterest

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close