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