As the formula’s example:
The average Pr2Sales ratio for the past 3 years can be calculated as FHistAvg(“Pr2SalesTTM”,39,4)
If I want to get the 5/10yrs ratio number, which one is correct
5yrs: FHistAvg(“Pr2SalesTTM”,65,4) or FHistAvg(“Pr2SalesTTM”,20,13)
10yrs: FHistAvg(“Pr2SalesTTM”,130,4) or FHistAvg(“Pr2SalesTTM”,40,13)
If above are not correct, how to write the ratio formula?
Marco, thanks a lot!
But I want to get the 5/10 years average value, is it the same one?
And the number of samples must be between 2 and 156 for FHistAvg, I couldn’t use it.