NexusFi - Search Results

Showing results 1 to 4 of 4
Search: Posts Made By: vegasfoster

Forum: Psychology and Money Management

July 31st, 2012, 03:02 PM

Replies: 15

Excel Help with calculating averages with custom input

Views: 3,031

Posted By vegasfoster

Did you get it working?

Did you get it working?

Forum: Psychology and Money Management

July 31st, 2012, 02:58 PM

Replies: 15

Excel Help with calculating averages with custom input

Views: 3,031

Posted By vegasfoster

=If(Row(B1) < $G$1*2-1, "",...

=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)))

Forum: Psychology and Money Management

July 31st, 2012, 12:03 PM

Replies: 15

Excel Help with calculating averages with custom input

Views: 3,031

Posted By vegasfoster

I may not be understanding what you are trying to...

I may not be understanding what you are trying to do, because if you enter 20 then why you would want to calculate on anything less than 20? Apart from that, I double checked that the averages are...

Forum: Psychology and Money Management

July 31st, 2012, 09:57 AM

Replies: 15

Excel Help with calculating averages with custom input

Views: 3,031

Posted By vegasfoster

Assuming data starting in E1, average calculation...

Assuming data starting in E1, average calculation starting in F1, and parameter in G1, formula compatible with all versions would be

=IF(ISERROR(AVERAGE(INDIRECT(("E"&ROW(E1)-$G$1+1)):E1)),...

Showing results 1 to 4 of 4

What unexpected challenges have you encountered while trading on a "Funded Trader" platform?

Limited trading instruments
High platform usage fees
Lack of support or mentorship
Unrealistic rules and requirements
No significant challenges
Something else (discuss in thread)

View Results Discuss Poll