Excel Help with calculating averages with custom input - Psychology and Money Management | futures io social day trading
futures io futures trading


Excel Help with calculating averages with custom input
Updated: Views / Replies:1,399 / 15
Created: by RM99 Attachments:2

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Reply
 2  
 
Thread Tools Search this Thread
 

Excel Help with calculating averages with custom input

  #11 (permalink)
Membership Revoked
Catalunya Spain
 
Futures Experience: Advanced
Platform: ninja trader, ofav6, investor RT
Broker/Data: Amp/cqg, mirus/zen-fire, dtn iqfeed
Favorite Futures: ES
 
Posts: 72 since Sep 2010
Thanks: 207 given, 61 received

EQUITY RECORDER

Hi,

I have been working in somenthing similar, but i have the same problem for change the sma. I post a file for someone can help.

Thanks

RM99 View Post
Not sure why the row and column markers didn't come through, but the status bar is hilighted on cell B5 (the first value in the 2nd Column...column B).

I've scratched my head, because I can see the IF (logic) operator and I'm pretty sure I'm understanding the convention logic...it's saying..."IF the value is null, then output "" (blank)" if the value is not null, then output the average of ......Column A, then it calculates the start row, and the end row.

But I can't even reverse engineer where it's getting the value. I've tried to see if it's averaging the wrong set of values, if it's cutting the average sample short, or adding extra...etc.

I'm really scratching my head.......but the convention is working swimmingly, if I put 20 into the input cell, it begins populating values at B20 (and leaves B1 through B19 blank) it's just giving me the wrong output values.


Attached Files
Register to download File Type: xls equity recorder.xls (40.5 KB, 9 views)
Reply With Quote
 
  #12 (permalink)
Fortitudo et Honor
Austin, TX
 
Futures Experience: Advanced
Platform: TradeStation
Favorite Futures: Futures
 
Posts: 882 since Mar 2011
Thanks: 128 given, 703 received

Figured it out.

Instead of a comma, the average function should be separated by a colon.......

Thanks for your help, it's working perfectly now. I transposed it wrong and used a comma instead of a colon and just my luck, it didn't give me an error.

"A dumb man never learns. A smart man learns from his own failure and success. But a wise man learns from the failure and success of others."
Reply With Quote
The following user says Thank You to RM99 for this post:
 
  #13 (permalink)
Fortitudo et Honor
Austin, TX
 
Futures Experience: Advanced
Platform: TradeStation
Favorite Futures: Futures
 
Posts: 882 since Mar 2011
Thanks: 128 given, 703 received


Not that you haven't helped enough already,

But I'd like to do a second average of the average to smooth out the MA.

So I'm adding a second input cell (next to the 1st iteration).

It's working, but it's averaging the null values from the first row (essentially, if I use a 20 MA and then try to calculate a 20 MA of that MA, it's spitting out values at row 20 and using the first 19 null values from the MA column).

How can I modify the IF statement to exclude the null values from the previous column?

"A dumb man never learns. A smart man learns from his own failure and success. But a wise man learns from the failure and success of others."
Reply With Quote
 
  #14 (permalink)
Elite Member
las vegas
 
Futures Experience: Intermediate
Platform: Sierra Chart
Broker/Data: Velocity/IB
Favorite Futures: 6E
 
Posts: 1,147 since Feb 2010
Thanks: 304 given, 836 received


RM99 View Post
Not that you haven't helped enough already,

But I'd like to do a second average of the average to smooth out the MA.

So I'm adding a second input cell (next to the 1st iteration).

It's working, but it's averaging the null values from the first row (essentially, if I use a 20 MA and then try to calculate a 20 MA of that MA, it's spitting out values at row 20 and using the first 19 null values from the MA column).

How can I modify the IF statement to exclude the null values from the previous column?

=If(Row(B1) < $G$1*2-1, "", IF(ISERROR(AVERAGE(INDIRECT(("B"&ROW(B1)-$G$1+1)):B1)), "Null",AVERAGE(INDIRECT(("B"&ROW(B1)-$G$1+1)):B1)))

Reply With Quote
 
  #15 (permalink)
Elite Member
las vegas
 
Futures Experience: Intermediate
Platform: Sierra Chart
Broker/Data: Velocity/IB
Favorite Futures: 6E
 
Posts: 1,147 since Feb 2010
Thanks: 304 given, 836 received


DAYTRADERPROFESIONAL View Post
Hi,

I have been working in somenthing similar, but i have the same problem for change the sma. I post a file for someone can help.

Thanks

Did you get it working?

Reply With Quote
 
  #16 (permalink)
Membership Revoked
Catalunya Spain
 
Futures Experience: Advanced
Platform: ninja trader, ofav6, investor RT
Broker/Data: Amp/cqg, mirus/zen-fire, dtn iqfeed
Favorite Futures: ES
 
Posts: 72 since Sep 2010
Thanks: 207 given, 61 received

Hi vegasfoster,

i'm trying but without success. When i apply the formula i have and error. i'm lost.

Thank's


vegasfoster View Post
Did you get it working?


Reply With Quote

Reply



futures io > > > Excel Help with calculating averages with custom input

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Linda Bradford Raschke: Reading The Tape

Elite only

Adam Grimes: TBA

Elite only

NinjaTrader: TBA

January

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bill Williams Moving Averages. Rambo1123 NinjaTrader 15 June 21st, 2015 07:07 AM
Moving Averages - How do you use them? Fat Tails The Elite Circle 152 October 1st, 2012 05:23 PM
The Big Money's Moving Averages RODLM The Elite Circle 1 June 6th, 2010 04:29 PM
Moving averages yiman Traders Hideout 9 January 28th, 2010 11:19 AM
Indicator For Area Between Two Moving Averages adrian Traders Hideout 14 October 6th, 2009 05:49 PM


All times are GMT -4. The time now is 09:20 AM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts
Page generated 2017-12-13 in 0.10 seconds with 20 queries on phoenix via your IP 54.82.56.95