NexusFi: Find Your Edge


Home Menu

 





Exponential moving average in the SpreadSheet


Discussion in Sierra Chart

Updated
    1. trending_up 890 views
    2. thumb_up 2 thanks given
    3. group 2 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread

Exponential moving average in the SpreadSheet

  #1 (permalink)
 Cabdoctor 
Sacramento CA/USA
 
Experience: Intermediate
Platform: TOS, Sierra Chart
Trading: Emini ES
Posts: 10 since Jul 2019
Thanks Given: 2
Thanks Received: 0

I'm trying to input an exponential moving average in the Spreadsheet trader. I know the equation is
Exponential moving average =(K x (C – P)) + P

Where,

K = exponential smoothing constant
C= current price
P= previous periods exponential moving average (simple moving average used for first periods calculation)

But what I would like to do is make K based off a cell that is taking the spread of current high/low, so (C3-D3), so it would be dynamic.

P would be a constant set off another cell that should not change.

How could I do this and have it output to a cell?

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Futures True Range Report
The Elite Circle
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
Better Renko Gaps
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
GFIs1 1 DAX trade per day journal
17 thanks
  #2 (permalink)
 
LonnieMSP's Avatar
 LonnieMSP 
Minneapolis
 
Experience: Intermediate
Platform: Sierra Chart
Broker: Optimus Futures, TT
Trading: ES, NQ, CL, GC, FGBL, 6E, various others
Posts: 31 since May 2019
Thanks Given: 395
Thanks Received: 61

https://www.sierrachart.com/index.php?page=doc/SpreadsheetExampleFormulasAndUsage.php

Reply With Quote
Thanked by:
  #3 (permalink)
 Cabdoctor 
Sacramento CA/USA
 
Experience: Intermediate
Platform: TOS, Sierra Chart
Trading: Emini ES
Posts: 10 since Jul 2019
Thanks Given: 2
Thanks Received: 0




When all else fails...read the manual

Started this thread Reply With Quote




Last Updated on November 25, 2019


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts