# Average/Group Average

Hi All-

I'm trying to calculate the average number of trades per account over a period of time.

I already have a formula (created on the worksheet itself) that provides the number of trades -  unique count. But when I try to do a group_average formula, that data point doesn't appear. I also am not able to replicate it  within the answer to try and get it to do a group average.

Any suggestions?

Thanks,
Brette

13replies Oldest first
• Oldest first
• Popular
• Are you adding the data point on its own?

Try and add it with the date column

Also try group_average(trades per account, date)

Like 1
• To add to Marc Price:

Are the results from the formula correct when you switch to table view?

Like 1
• Marc Price I've tried adding it on its own and using the group_average formula but it didn't work. i even tried doing a group_count (trade number, account number) and do an average on that, but it didn't work either.

Like
• Mike Batovsky I'm not sure what you mean. I've only been using the table view so far.

Like
• Brette Husar

Sorry for the confusion Brette,

I was not sure if you were say it was not showing up on the chart as a data point after you added the formula. It sounds like you are saying the calculations that have been tried so far do not return with the answer you are looking for.

Like
• Mike Batovsky Mike Batovsky No worries! its a big confusing all around. This is all just in the grid/table format.  And you are correct, nothing I've tried so far seems to be working as i would expect. I'm currently in the process of copying the working and trying to add some calculations there too.

Like
• Brette Husar

To better understand the ask, taking the TS functions out of the equation what does the calculation look like on paper?

An example might be:

For each account

Take the count of unique trades by day / the number of days in the month = the daily average # of trades by account.

Like
• Mike Batovsky no problem.

I'm looking at a 6 month period of trade activity. Every account would have whatever number of trades during that period. I am looking to find the average number of trades by account.

Does that make sense?

Like
• Brette Husar

If the above are my numerator what should be used as the denominator to get the average?

Like
• Mike Batovsky 2000 (total trades)/2 (companies)

Like 1
• Count (trades) / unique count  (company name)

Like 2
• Marc Price I think that worked! Should've stuck with basic math instead of a fancy formula!. Ha! Thank you!

Like 3
• Brette Husar Great!

happy you got to it in the end

Like
Like Follow