For anyone looking for quick excel download of indexes like S&P 500, FTSE 100 with real time price, change %, PE ratio and market cap information, I am posting a google sheet link that you can utilize for your work.
Indexes
S&P 500 Symbol,Name,Sector,Exchange,Price,Change,Percentage,PE,EPS,Market Cap
FLS,Flowserve Corporation,Industrials,NYSE
IVZ,Invesco Ltd.,Financials,NYSE
LB,L Brands Inc.,Consumer Discretionary,NYSE
AIV,Apartment Investment & Management,Real Estate,NYSE
RHI,Robert Half International,Industrials,...
I use it for my own personal investing. I though it will be useful for the wider community. Let me know your thoughts and if you like anything to be added to the sheet please contact me.
I will be updating the sheet with latest information and adding more indexes as time goes.