Twitter Charts 2

Optuma Forums Optuma General Discussion Twitter Charts 2

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

    Following on from this thread here are details for charts posted on our Twitter account. Comment in the Tweet and we’ll post the details here.

    For example, to calculate the average drawdown for the members of an index, as per this Tweet: https://twitter.com/Optuma/status/1471137257969135621?s=20

    This was calculated using the Drawdown Percent function DDP() in the custom Market Breadth module, with the Breadth Action set to Average.

    By default, the DDP() function will calculate distance from the 1 year high.

    Capture

    Once calculated, the data can be viewed in the Breadth Data tool below the price chart:

    Capture

    2 users thanked author for this post.
    #66957
    Deepak
    • Topics: 91
    • Replies: 76
    • Posts: 167

    Hii Sir,

    It seems ismember is not working on this any reason.

    Regards,
    Deepak

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

    Hi Deepak,

    The ISMEMBER() function only works with true/false conditions, not when calculating averages.

    3 users thanked author for this post.
    #67357
    Darren
    • Topics: 73
    • Replies: 923
    • Posts: 996

    Breakout scan: https://twitter.com/Optuma/status/1482727843171868672?t=JzBy3BTgpMf_3_i2Z3lAzw&s=19

    1 user thanked author for this post.
    #67583
    Tim
    • Topics: 30
    • Replies: 29
    • Posts: 59

    Can you post the script for the slope of the linear regression.

    https://twitter.com/Optuma/status/1491725380251750405

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

    If you type ‘linear’ in the script editor window then all suggestions will pop up, including LRSLOPE():

    Capture

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

    VIX curve chart: https://twitter.com/Optuma/status/1503686929652408322?s=20&t=1bCnrW9A03LrLGX9BhgMig

    Save workbook attached (requires access to the CBOE Indices data).

    Attachments:
    #68097
    Darren
    • Topics: 73
    • Replies: 923
    • Posts: 996

    Day of the Week formulas: https://twitter.com/Optuma/status/1520384472356560896

    The DAYOFWEEK() function assigns a value to each week day, with Sundays assigned a 1, Mondays = 2, etc. As such, to mark all Fridays on a chart use DAYOFWEEK()==6 in a Show Bar. This will show all Fridays with a fall greater than 3%:

    1 user thanked author for this post.
    #68207
    Darren
    • Topics: 73
    • Replies: 923
    • Posts: 996

    5 Consecutive Down Weeks: https://twitter.com/Optuma/status/1523622055534419968

    The Days Down DD() function counts the consecutive bars a value (the close by default) has been lower (Days Up DU() does the opposite).

    On a weekly timeframe DD()==5 will signal when there have been 5 consecutive weekly lower closes, which was used in the signal test.

    For 5 consecutive lower highs use DD(HIGH())==5

    The Days Down tool can be used on a chart (currently 6 weeks for the SPX):

    Capture

     

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

    To calculate how long ago the close was at the latest low (or high) – and the dates they occured: https://twitter.com/Optuma/status/1537704403205079040

    Worst Change Since:

    Lowest Close Since:

    Weeks Since Low

    To find the high dates instead, change the < to >. Sample weekly watchlist attached that can be saved as a layout and applied to any other lists.

    Capture

    Attachments:
    2 users thanked author for this post.
    #68647
    Thomas
    • Topics: 131
    • Replies: 183
    • Posts: 314

    Hi Optuma team,

    can you publish the script for the Twitter chart “ATH Drawdown” (https://twitter.com/Optuma/status/1539727679586443265)?

    As always many thanks for your excellent support.

    Best wishes,
    Thomas

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

    Hi Thomas – use the Drawdown tool set to 100 year lookback (the all-time high calculation is wrong and is being fixed).

    https://help.optuma.com/kb/faq.php?id=1237

    1 user thanked author for this post.
    #68669
    Thomas
    • Topics: 131
    • Replies: 183
    • Posts: 314

    Hi Darren,

    The story goes on. Can you publish the scripts for your two interesting Twitter charts here?

    Many thanks for your great inspirations and support.

    Best wishes,
    Thomas

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

    Hi Thomas,

    The pre-Covid high values were defined using the HIGHESTHIGH function between January 1st and March 13th 2020, and getting the percent difference from the latest close:

    The custom bar colours use this:

    To count the days since any value was that high (eg closing price, RIC, RSI, Volume, etc) change the D1 function here, as required:

    1 user thanked author for this post.
    #68787
    Thomas
    • Topics: 131
    • Replies: 183
    • Posts: 314

    Hi Darren,

    you published a real cool chart on Twitter (https://twitter.com/Optuma/status/1549447224324755456?cxt=HHwWgMC8wdGC34ArAAAA).

    Would you please be so kind again to explain how you created this chart?

    Am I right that I need the “Column Chart” feature in the Professional and Enterprise edition of Optuma to create your chart?

    But anyway, please just explain how you created the chart with all the necessary scripts.

    I use the following script in a watchlist to calculate the maximum drawdown:

    With this script I get the maximum drawdown for the SPX of -24.52%, in your chart you have for the maximum drawdown a value of -23.69%.
    What is the reason for this difference?

    Best wishes,
    Thomas

Viewing 15 posts - 1 through 15 (of 32 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest