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?
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