Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Excel Help with calculating averages with custom input
Thanks, I'll check it out. I'm using Tradestation so I'm not sure if that'll work.
Aside from that, I'm not averaging from the chart, but outputs on the performance report for trade information. I have to manually modify excel printouts, because referencing trade information in Easy Language is a mystery to me.
"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."
You're awesome. Thanks...I'm running into all sorts of problems. My server doesn't have Excel, so I have to export in .mht format, which includes all the other data in the spreadsheet. So copying and pasting is a challenge to begin. THEN, if that weren't enough, I have to try to pull out data that skips rows, and I haven't been able to figure out how to paste with it skipping the blank rows. I click on paste special and check the block that indicates skip blanks, but it still pastes.
"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."
Many thanks for the help. The forumula is working...partially. It's working fine to adjust the start based off the MA input (if I input 5, it starts filling values at the 5th row, if I put in 20, it starts filling values at row 20) however, the calculations are not outputting proper averages. I'm scratching my head....because it's verbatim what you posted, and yours is calculating fine.
"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."
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 calculating correctly on mine, so can you post your file so I can look at it?
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.
"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."