I just put the formula =MEDIAN(cur_val) in the unused cell B1.
...and the text 'Median' in C1. You could also use =AVERAGE(cur_val) in another cell (B4, perhaps?).
Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site
I just put the formula =MEDIAN(cur_val) in the unused cell B1.
Breelander wrote:
It's even easier than that. Look at cell B3 (the 'Portfolio Value') on the High Yield Portfolio sheet. The formula is =SUM(cur_val) where (conveniently) cur_val is the range you need. I just put the formula =MEDIAN(cur_val) in the unused cell B1.
And I really am not trying to be mean.
miner1000 wrote:Whilst parts of this thread are somewhat interesting, I think the main thing to take from these discussions is that one or two on this board perhaps need to get out more. Golf is good and darts not bad if you like a tipple.
And I really am not trying to be mean.
Itsallaguess wrote:If someone could please check the above process in their Excel version and report back if they get it working, that would be great?
Cheers,
ItsallaguessModerator Message:
The setting up or changing hyptuss is not a topic for hyp practical. There is a board for financial software discussions. Raptor.
vrdiver wrote:Any suggestions for a more elegant variant appreciated!VRD
StepOne wrote:vrdiver wrote:Any suggestions for a more elegant variant appreciated!VRD
why not just sort your spreadsheet by total holding value, then just take the mean of the first 20 cells?
Or I would have another column, with a formula which evaluates to the Holding value, if it is greater than or equal large(M:M,20), or zero. i.e.;
=IF(M2>=LARGE(M:M,20),M2,0) - for row 2.
Then, just SUM that column and divide by 20 (probably safer to divide by COUNT(new column) in case the 20th and 21st holdings are exactly the same size)
StepOne
Arborbridge wrote:It seems Raptor's moderation note has fallen on deaf eyes
Over to Financial Software, the man said.
Arborbridge wrote:
It seems Raptor's moderation note has fallen on deaf eyes
Over to Financial Software, the man said.
Itsallaguess wrote:Please keep up the good work that you're doing on the mod side of things, we do appreciate that it's like herding cats at times....
Return to “HYP Practical (See Group Guidelines)”
Users browsing this forum: No registered users and 17 guests