I am looking for an Excel equation that will permit me to calculate the denominator of the Information Ratio. Instead of using the Standard Deviation (SD) for the denominator, I want to substitute a semi-variance calculation for a set of data points.
What I've come up with so far is this...