New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.

Syntax setup

My goal is to scan for stocks within a certain dollar amount (more than $5 and less than $40) and stocks with weekly options

Help with modification would be great appreciated

Current scan:

[type = stock] AND [Daily SMA(20,Daily Volume) > 100000]
and [group is SP500]
and [optionable is true]

Best Answer

  • markdmarkd mod
    edited May 9 Accepted Answer
    and [close > 5]
    and [close < 40]

    I don't think you can limit the scan to stocks with weekly options - you will get everything that has any kind of option. It might be possible to make a weekly options list from other sources. Check the CBOE website -they may have a spreadsheet you can download and then upload the symbols to a list, then include the list at the top of the scan (leave the other conditions there also).

    update:

    Here's the page on CBOE - download link at the top. Filter for "Equities".

    http://www.cboe.com/products/weeklys-options/available-weeklys

    There may be more than 500, so you might have to make more than one list. If you do, your scan would be:


    // begin scan
    [type = stock] AND [Daily SMA(20,Daily Volume) > 100000]
    and [group is SP500]
    and [optionable is true]

    and

    [

    [favorites list is list 1] // maybe symbols from A-M

    or

    [favorites list is list 2] // ...symbols from N - Z

    ]

    and [close > 5]
    and [close < 40]

    // end scan.

    Or, you could see whether all the stock in the SP500 have weekly options. My guess is they do, in which case, you don't have to modify your scan beyond testing the closing prices.

Answers

  • Much Appreciated for all your assistance.
    paul334
Sign In or Register to comment.