How to put a daily moving average on a monthly chart (and other timeframes)

Optuma Forums Optuma Scripting How to put a daily moving average on a monthly chart (and other timeframes)

This topic contains 1 reply, has 2 voices, and was last updated by Avatar May 3 weeks, 6 days ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #38139
    Darren
    Darren
    • Topics: 42
    • Replies: 288
    • Posts: 330

    We have a tool available called Higher Time Moving Average which allows you to put a moving average on a chart that has been calculated off of a higher time frame, such as a weekly MA on a daily chart, or a monthly MA on a weekly chart.

    Using the Show Plot tool it’s possible to create a moving average based off a lower timeframe (ie a 200 day MA on a monthly chart) simply by changing the Timeframe option to Day:

    Capture

    MA(Day(PERIODAMOUNT=1), BARS=200, CALC=Close)

    Capture

    The same principal can be used for other tools and timeframes, such as a weekly RSI on a daily chart using the Show View tool:

    RSI(Week(PERIODAMOUNT=1), BARS=14)

    Capture

    Note that the RSI appears stepped as the weekly version only has one value which is being applied to 5 daily bars. Once created this weekly version can be dragged over the daily RSI (in blue) to be plotted in the same panel:

    Capture

     

    #54707
    Avatar
    May
    • Topics: 5
    • Replies: 7
    • Posts: 12

    Hi Darren,

    I read through the related explanation on different time frames https://help.optuma.com/kb/faq.php?id=1012 and https://optu.ma/l5j6l.

    I try to plot the RSI Weekly on a daily chart as demonstrated above.  As attached screenshot, it is a daily chart for AAPL.  First Show view shows 10 day RSI and 10 week RSI (in step).  Second Show view shows the same 10 week RSI (with Bar by Bar enabled).  Cursor is on 6 Sept 2019 (Friday), I expect the 10 week RSI in both Views are the same weekly value 64.837 as it is the last day of the week.  However, 10 week RSI (with Bar by Bar enabled) value is 60.579 which is the 10 day RSI instead???   The chart shows that 10 week RSI (with Bar by Bar enabled) has the same value as 10 day RSI on each day.  Please advise.

    Script for 10 week RSI (in step):

    d1 = RSI(Week(PERIODAMOUNT=1, BARBYBAR=False));

    plot1 = d1;

    plot1.Plotstyle = Line;

    plot1.Colour = Blue;

     

    Script for 10 week RSI (with Bar by Bar enabled):

    d1 = RSI(Week(PERIODAMOUNT=1, BARBYBAR=True));

    plot1 = d1;

    plot1.Plotstyle = Line;

    plot1.Colour = Blue;

     

     

    Attachments:
Viewing 2 posts - 1 through 2 (of 2 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