Support Board
Date/Time: Fri, 07 Feb 2025 20:00:00 +0000
Post From: Adding bars high and low
| [2021-09-03 16:21:38] |
| 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 |