Hi,
I've got a sheet in which I am ranking returns for 61 stocks against each other, assigning 1-61 to each, on a daily basis. This is repeated every day and in my sheet currently I'm doing this from 1/1/2000 - present.
I had no issues with spreadsheet speed until I updated my rank calculation to factor in ties. After doing that a simple sheet update results in a maxed out i7, 8 core CPU with 8 gigs of ram and an SSD hard drive taking somewhere between 10-20 minutes to recalculate.
Any ideas?
Here is the formula I've got in place currently (an example from one cell):
=IFERROR(RANK(BR224,$BR224:$DY224,0)+COUNTIF($BR$195:BR224,BR224)-1,"")
and what I had previously where my CPU's were maxed out for 2 seconds after a change as opposed to 20 minutes:
=RANK(BR224,$BR224:$DY224,0)
Thank you all for your continual help on this forum!
I've got a sheet in which I am ranking returns for 61 stocks against each other, assigning 1-61 to each, on a daily basis. This is repeated every day and in my sheet currently I'm doing this from 1/1/2000 - present.
I had no issues with spreadsheet speed until I updated my rank calculation to factor in ties. After doing that a simple sheet update results in a maxed out i7, 8 core CPU with 8 gigs of ram and an SSD hard drive taking somewhere between 10-20 minutes to recalculate.
Any ideas?
Here is the formula I've got in place currently (an example from one cell):
=IFERROR(RANK(BR224,$BR224:$DY224,0)+COUNTIF($BR$195:BR224,BR224)-1,"")
and what I had previously where my CPU's were maxed out for 2 seconds after a change as opposed to 20 minutes:
=RANK(BR224,$BR224:$DY224,0)
Thank you all for your continual help on this forum!
