The question I have refers to annualised standard deviation.
For example, I have various funds monthly returns data for the period 1980-2019. Some of them report data for e.g. 13, 19, 43, 56 months and so on. Given that the particular fund is not straight 12, 24, 36 months and so on, can I still use the formula
= standard deviation (entire time series of a fund 1)*square root of 12
Unless I should do a count of all available monthly returns and write the formula:
=stdev.p(range)*sqrt(counta(range)) i.e. (standard deviation * the square root of the count of monthly returns of a particular fund)
The 2nd question on the back of that is, what if the returns are quarterly, would the square root of 4 suffice (even if I have e.g. 5, 6, 7 and more quarters of data for a particular fund?)