Index | Recent Threads | Who's Online | Search

New Thread
This topic has been viewed 98 times and has 5 replies
Dezhong
5yrs and 10yrs average Pr2Sales ratio questions.

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?

Thanks in advance!

Apr 4, 2021 9:20:48 AM       
marco
Re: 5yrs and 10yrs average Pr2Sales ratio questions.

Use FHist if you just a factor's value in the past

FHist("Pr2SalesTTM",260) // 5y - 52*5
FHist("Pr2SalesTTM",520) // 10y 52*10

Portfolio123 Staff.

Apr 4, 2021 1:15:09 PM       
Dezhong
Re: 5yrs and 10yrs average Pr2Sales ratio questions.

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.

Apr 4, 2021 5:38:07 PM       
Edit 1 times, last edit by Dezhong at Apr 4, 2021 6:10:03 PM
SpacemanJones
Re: 5yrs and 10yrs average Pr2Sales ratio questions.

Hi, If you want _average_ of the 10 last annual Price/Sales ratio, you might use a calculation using loopavg() as below for the :

loopavg("Pr2Sales(CTR,ANN)",10,0,1)

(I haven't tested the calc, but I think I've typed it correctly)

Apr 4, 2021 7:29:52 PM       
Dezhong
Re: 5yrs and 10yrs average Pr2Sales ratio questions.

Thanks, SpacemanJones.
I think "loopavg" works well in Quarterly data, but what I need is daily ratio.

Apr 4, 2021 8:58:56 PM       
Kimmiles
Re: 5yrs and 10yrs average Pr2Sales ratio questions.

As lead generation and appointment setting go, there is no better way to improve email deliverability for your business than with B2B generation. That's because a B2B business often prefers to work with an expert that they already know and trust.

Apr 9, 2021 3:05:39 AM