Stocks and stats

Does anyone have an easy way of getting basic stats for stocks in a spreadsheet?

Let’s say I have a list of stock symbols in column C of a google sheet. How can I pull P/E and forward PE for this stock in, say, columnds D and E?

You can pull stock prices.

PE: GOOGLEFINANCE(“NASDAQ:GOOG”, “PE”)
Forward P/E: I don¨t know

1 Like