How to get S&P500 and NASDAQ index from Google Spreadsheet

You can get the S&P500 and NASDAQ index using the Google finance fuction from the Google Spreadsheet.

 

S&P500 index is published by Standard & Poor's and an index made by 500 major US companies. NASDAQ is a market for venture companies to finance. Technology stocks such as Apple, Microsoft and Google that we know a lot are listed on NASDAQ. You can compare your investment portfolio and return on investment through the above index.

 

You can get S&P500 and NASDAQ index information by putting the following function valuse in the cells of the Google Spreadsheet.

 

1. Real-time (real-time price information may be delayed up to 20 minutes)

S&P500

=GOOGLEFINANCE("INDEXSP:.INX", "price")

 

NASDAQ

=GOOGLEFINANCE("INDEXNASDAQ:.IXIC", "price")

 

 

2. Closing price on a specific day

S&P500

=GOOGLEFINANCE("INDEXSP:.INX","close",DATE(2020,4,29))

 

NASDAQ

=GOOGLEFINANCE("INDEXNASDAQ:.IXIC","close",DATE(2020,4,29))