Calculating Trailing Avg 3 Yr Price/Book Ratio?

Hello everybody,

I’m trying to calculate a three-year trailing average price-to-book ratio (P/B). Is there a way to do this?

This would be used as part of a ranking system, one part of which would compare a stock’s current P/B to its historical three-year trailing average P/B.

Thanks in advance for the help.

Best,
Graham

Portfolio123 doesn’t really have a good way to reference average annual and quarterly stock price data. The bars and lags (i.e., trading days) in the price moving averages cap out at 500 – there are about 753 (i.e., ~251 trading-days/year * 3 years) bars in three years of data. It would really be nice if there were a better/easier way to access average historical price and market cap data.

But if you’re willing to accept two years, you could do something like:

Avg(SMA(250,WeeksIntoQ5), SMA(250,WeeksIntoQ5+250))/LoopAvg(“BookVal(CTR,TTM)/Shares(CTR,TTM)”,2,0,1)

Or…

Avg( SMA(250,WeeksIntoQ5)/(BookVal(0,TTM)/Shares(0,TTM)), SMA(250,WeeksIntoQ5+250)/(BookVal(4,TTM)/Shares(4,TTM)) )

or you could even break it down quarterly…

Makes sense. Thanks for the creative work around Primus. I’ll give it a try.