0
In Google Sheets, I can use the GOOGLEFINANCE
function to get a number of stock data points including:
price
volume
eps
I have used the GOOGLEFINANCE
function on market data points for the Dow (ticker .DJI
), S&P (.INX
), and NASDAQ(.IXIC
). Specifically, I have successfully gotten the close
points from GOOGLEFINANCE
using:
=INDEX(GOOGLEFINANCE(".INX","close",DATE(2018,01,01),2,2))
(See school finance project on Google Sheets here)
Is it possible to get the eps
data point for a market in Google Sheets? Ultimately, I want to get the Shiller PE or CAPE ratio. In order to do that, I need EPS.