Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 08:54:21 +0000



Post From: Study help needed please

[2013-04-06 13:42:34]
Sawtooth - Posts: 3952
Using the Spreadsheet Study study on a daily chart, try this:

To grab the ATR from the previous Friday and repeat it each day of the following week, put this in K3:
=IF(AND(WEEKDAY(A4)=6,A3-A4>1),AA4,K4)

To grab the ATR from the last day of the previous month and repeat it each day of the following month, put this in L3:
=IF(DAY(A3)=1,AA4,L4)

These formulas assume the ATR study is in column AA.

To grab the High of the first day of the current month and repeat it each day of the current month, put this in M3:
=IF(MONTH(A3)>MONTH(A4),C3,M4)

To grab the Low of the first day of the current month and repeat it each day of the current month, put this in N3:
=IF(MONTH(A3)>MONTH(A4),D3,N4)

With these values, you should be able to draw the lines you want.
Date Time Of Last Edit: 2013-04-06 13:42:59