S&P 500

Live
Returns the stock market index that tracks 500 large companies listed on stock exchanges in the United States.

Example usage

=StandardAndPoors500(6) - Returns last 6 Observations.
=StandardAndPoors500("2022-01-15","2022-10-15") - Returns observations from 15th of January 2022 to 15th of October 2022
=StandardAndPoors500("status") - Returns status of the data i.e. Units, currency, history etc
=StandardAndPoors500() - Returns a table of all observations
=StandardAndPoors500("2022-01-15") - Returns first previous observation from 15th of January 2022
=StandardAndPoors500("lp") - Returns last observation. LP is last period
=StandardAndPoors500("lp-2") - Returns last three observations
=StandardAndPoors500("lp-10") - Returns last eleven observations

Assets

Economy