Support Board

Date/Time: Tue, 21 May 2024 20:45:29 +0000

Post From: Adding bars high and low

[2021-09-03 16:21:38] Link To Thread - Link To Post [Go To First Post]
User237543 - Posts: 71
Hi John On 23 Aug, you gave me a spreadsheet formula for a 3 day rolling averages of the daily pivot I tried it and it worked! thanks so much Like to ask if I want to do the 5 days rolling averages of the daily pivot, should I just add +(H[-4]+L[-4]+C[-4])/$+(H[-5]+L..........C[-5]/5? I would also like add a 3days rolling averages of the daily pivot s Pivot HIGH and Pivot LOW So I can create 3 lines on my chart: 3 days Rolling avg PP High------------- 3 day Rolling avg PP------------------- 3 days Rolling avg PP Low-------------- (I use the Sierra chart s daily pivot Formula 28) Pivot Point (PP) =(prior High + Prior Low+Prior Close)/3 Daily Range (DR)=Prior High -Prior Low d=(prior High-Prior Low)/2 r=Pivot Point-d Pivot Point High =Pivot Point +r Pivot Point Low =Pivot point -r Can you please advise what input should I use as the formula? Thanks so much for your help Amy