- 首先,需要引入pandas和yfinance库,并下载S&P 500指数的数据:
import pandas as pd
import yfinance as yf
data = yf.download("^GSPC", start="1962-01-01", end="1982-12-31")
- 然后,可以使用pandas中的loc方法从数据中提取1962年到1982年之间的所有开盘价数据:
opening_prices = data.loc["1962-01-01":"1982-12-31","Open"]
- 最后,可以将这些数据输出到一个csv文件中:
opening_prices.to_csv("S&P-500 Opening Prices (1962-1982).csv", header=True)
完整代码如下:
import pandas as pd
import yfinance as yf
data = yf.download("^GSPC", start="1962-01-01", end="1982-12-31")
opening_prices = data.loc["1962-01-01":"1982-12-31","Open"]
opening_prices.to_csv("S&P-500 Opening Prices (1962-1982).csv", header=True)