如何使用 R 获取所有 S&P500 公司代码列表?

2024-06-28

我想在R中制作FOR语句来一次性分析股票数据。

但我不知道如何获得 S&P 公司代码列表。

请让我知道解决方案。

谢谢。

library(rpart)
library(rpart.plot)
library("quantmod")
startDate = as.Date("2012-01-01")
endDate = as.Date("2014-01-01") 
getSymbols("005930", src = "google", from = startDate, to = endDate) 

如果您使用 Bloomberg/Reuters 或任何其他数据提供商,那么您可以简单地在 Excel 中获取您想要的任何内容,然后将其读取到 R,然后继续下载历史数据。如果您无法访问此类商业数据提供商,那么其中一种方法是网络抓取(我相信维基百科足够可靠,但请仔细检查):

library(rvest)
url <- "https://en.wikipedia.org/wiki/List_of_S%26P_500_companies"
SP500 <- url %>%
  html() %>%
  html_nodes(xpath='//*[@id="mw-content-text"]/div/table[1]') %>%
  html_table()
SP500 <- SP500[[1]]
Tix <- SP500$`Ticker symbol`
Tix

截至今天,标准普尔 500 指数成分股:

> Tix
  [1] "MMM"   "ABT"   "ABBV"  "ACN"   "ATVI"  "AYI"   "ADBE"  "AMD"   "AAP"  
 [10] "AES"   "AET"   "AMG"   "AFL"   "A"     "APD"   "AKAM"  "ALK"   "ALB"  
 [19] "ARE"   "ALXN"  "ALGN"  "ALLE"  "AGN"   "ADS"   "LNT"   "ALL"   "GOOGL"
 [28] "GOOG"  "MO"    "AMZN"  "AEE"   "AAL"   "AEP"   "AXP"   "AIG"   "AMT"  
 [37] "AWK"   "AMP"   "ABC"   "AME"   "AMGN"  "APH"   "APC"   "ADI"   "ANSS" 
 [46] "ANTM"  "AON"   "APA"   "AIV"   "AAPL"  "AMAT"  "ADM"   "ARNC"  "AJG"  
 [55] "AIZ"   "T"     "ADSK"  "ADP"   "AN"    "AZO"   "AVB"   "AVY"   "BHI"  
 [64] "BLL"   "BAC"   "BK"    "BCR"   "BAX"   "BBT"   "BDX"   "BBBY"  "BRK.B"
 [73] "BBY"   "BIIB"  "BLK"   "HRB"   "BA"    "BWA"   "BXP"   "BSX"   "BMY"  
 [82] "AVGO"  "BF.B"  "CHRW"  "CA"    "COG"   "CPB"   "COF"   "CAH"   "CBOE" 
 [91] "KMX"   "CCL"   "CAT"   "CBG"   "CBS"   "CELG"  "CNC"   "CNP"   "CTL"  
[100] "CERN"  "CF"    "SCHW"  "CHTR"  "CHK"   "CVX"   "CMG"   "CB"    "CHD"  
[109] "CI"    "XEC"   "CINF"  "CTAS"  "CSCO"  "C"     "CFG"   "CTXS"  "CLX"  
[118] "CME"   "CMS"   "COH"   "KO"    "CTSH"  "CL"    "CMCSA" "CMA"   "CAG"  
[127] "CXO"   "COP"   "ED"    "STZ"   "COO"   "GLW"   "COST"  "COTY"  "CCI"  
[136] "CSRA"  "CSX"   "CMI"   "CVS"   "DHI"   "DHR"   "DRI"   "DVA"   "DE"   
[145] "DLPH"  "DAL"   "XRAY"  "DVN"   "DLR"   "DFS"   "DISCA" "DISCK" "DISH" 
[154] "DG"    "DLTR"  "D"     "DOV"   "DOW"   "DPS"   "DTE"   "DD"    "DUK"  
[163] "DXC"   "ETFC"  "EMN"   "ETN"   "EBAY"  "ECL"   "EIX"   "EW"    "EA"   
[172] "EMR"   "ETR"   "EVHC"  "EOG"   "EQT"   "EFX"   "EQIX"  "EQR"   "ESS"  
[181] "EL"    "ES"    "RE"    "EXC"   "EXPE"  "EXPD"  "ESRX"  "EXR"   "XOM"  
[190] "FFIV"  "FB"    "FAST"  "FRT"   "FDX"   "FIS"   "FITB"  "FE"    "FISV" 
[199] "FLIR"  "FLS"   "FLR"   "FMC"   "FL"    "F"     "FTV"   "FBHS"  "BEN"  
[208] "FCX"   "GPS"   "GRMN"  "IT"    "GD"    "GE"    "GGP"   "GIS"   "GM"   
[217] "GPC"   "GILD"  "GPN"   "GS"    "GT"    "GWW"   "HAL"   "HBI"   "HOG"  
[226] "HRS"   "HIG"   "HAS"   "HCA"   "HCP"   "HP"    "HSIC"  "HSY"   "HES"  
[235] "HPE"   "HLT"   "HOLX"  "HD"    "HON"   "HRL"   "HST"   "HPQ"   "HUM"  
[244] "HBAN"  "IDXX"  "INFO"  "ITW"   "ILMN"  "IR"    "INTC"  "ICE"   "IBM"  
[253] "INCY"  "IP"    "IPG"   "IFF"   "INTU"  "ISRG"  "IVZ"   "IRM"   "JEC"  
[262] "JBHT"  "SJM"   "JNJ"   "JCI"   "JPM"   "JNPR"  "KSU"   "K"     "KEY"  
[271] "KMB"   "KIM"   "KMI"   "KLAC"  "KSS"   "KHC"   "KR"    "LB"    "LLL"  
[280] "LH"    "LRCX"  "LEG"   "LEN"   "LVLT"  "LUK"   "LLY"   "LNC"   "LKQ"  
[289] "LMT"   "L"     "LOW"   "LYB"   "MTB"   "MAC"   "M"     "MNK"   "MRO"  
[298] "MPC"   "MAR"   "MMC"   "MLM"   "MAS"   "MA"    "MAT"   "MKC"   "MCD"  
[307] "MCK"   "MDT"   "MRK"   "MET"   "MTD"   "KORS"  "MCHP"  "MU"    "MSFT" 
[316] "MAA"   "MHK"   "TAP"   "MDLZ"  "MON"   "MNST"  "MCO"   "MS"    "MOS"  
[325] "MSI"   "MUR"   "MYL"   "NDAQ"  "NOV"   "NAVI"  "NTAP"  "NFLX"  "NWL"  
[334] "NFX"   "NEM"   "NWSA"  "NWS"   "NEE"   "NLSN"  "NKE"   "NI"    "NBL"  
[343] "JWN"   "NSC"   "NTRS"  "NOC"   "NRG"   "NUE"   "NVDA"  "ORLY"  "OXY"  
[352] "OMC"   "OKE"   "ORCL"  "PCAR"  "PH"    "PDCO"  "PAYX"  "PYPL"  "PNR"  
[361] "PBCT"  "PEP"   "PKI"   "PRGO"  "PFE"   "PCG"   "PM"    "PSX"   "PNW"  
[370] "PXD"   "PNC"   "RL"    "PPG"   "PPL"   "PX"    "PCLN"  "PFG"   "PG"   
[379] "PGR"   "PLD"   "PRU"   "PEG"   "PSA"   "PHM"   "PVH"   "QRVO"  "PWR"  
[388] "QCOM"  "DGX"   "RRC"   "RJF"   "RTN"   "O"     "RHT"   "REG"   "REGN" 
[397] "RF"    "RSG"   "RAI"   "RHI"   "ROK"   "COL"   "ROP"   "ROST"  "RCL"  
[406] "CRM"   "SCG"   "SLB"   "SNI"   "STX"   "SEE"   "SRE"   "SHW"   "SIG"  
[415] "SPG"   "SWKS"  "SLG"   "SNA"   "SO"    "LUV"   "SPGI"  "SWK"   "SPLS" 
[424] "SBUX"  "STT"   "SRCL"  "SYK"   "STI"   "SYMC"  "SYF"   "SNPS"  "SYY"  
[433] "TROW"  "TGT"   "TEL"   "FTI"   "TSO"   "TXN"   "TXT"   "TMO"   "TIF"  
[442] "TWX"   "TJX"   "TMK"   "TSS"   "TSCO"  "TDG"   "RIG"   "TRV"   "TRIP" 
[451] "FOXA"  "FOX"   "TSN"   "UDR"   "ULTA"  "USB"   "UA"    "UAA"   "UNP"  
[460] "UAL"   "UNH"   "UPS"   "URI"   "UTX"   "UHS"   "UNM"   "VFC"   "VLO"  
[469] "VAR"   "VTR"   "VRSN"  "VRSK"  "VZ"    "VRTX"  "VIAB"  "V"     "VNO"  
[478] "VMC"   "WMT"   "WBA"   "DIS"   "WM"    "WAT"   "WEC"   "WFC"   "HCN"  
[487] "WDC"   "WU"    "WRK"   "WY"    "WHR"   "WFM"   "WMB"   "WLTW"  "WYN"  
[496] "WYNN"  "XEL"   "XRX"   "XLNX"  "XL"    "XYL"   "YUM"   "ZBH"   "ZION" 
[505] "ZTS" 
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

如何使用 R 获取所有 S&P500 公司代码列表? 的相关文章

随机推荐

  • nAnt 是否仍受支持并适用于 .net 3.5/VS2008?

    我正在使用 MSBuild 来构建我的东西 我想通过构建服务器使用 CruiseControl net 现在 CCNET 经常引用 nAnt 但看起来 ccnet 可以通过项目配置和 msbuild 完成 nant 可以完成的大部分工作 另
  • Python对象实例中的dict不包含该类的方法

    当创建对象的实例时 它的字典不包含类方法 一个例子是 class A object def init self value self value value def some func self pass instance A some v
  • Kivy 中的脉动背景颜色

    我是 kivy 的新手 但我真的很坚持这一点 有没有办法在画布上有类似于 CSS 中的这种效果的脉冲背景 https codepen io LukeAskew pen gabgom https codepen io LukeAskew pe
  • 使用 TOX 运行 Flake8 测试时出现 Unicode 错误

    我是 Tox 新手 我想将其设置为在我的项目上运行 flake8 测试 但当我尝试运行 tox 时 我不断收到 unicode 错误 UnicodeDecodeError ascii codec can t decode byte 0xe2
  • 如何编写基于线程的并行列表迭代?

    我需要一个如何使用 ocaml 线程编写并行 iter 函数的示例 我的第一个想法是有一个与此类似的函数 let procs 4 let rec part part i lst match lst with gt hd tl gt let
  • Hashie::Mash 从字符串恢复

    我在这个问题上很挣扎 我已经存储了一个Hashie Mash到一个字符串中 我很难将其恢复为哈希值 这是字符串 map Hashie Mash ncreated at Mon Jul 30 15 42 20 0000 2012 nid 22
  • IOS 7 中的外部蓝牙键盘集成

    我需要在应用程序中支持外部键盘功能 并且需要在应用程序中检测到 Alt Tab Tab 等组合键以触发某些事件 在 IOS 6 中我已经重写了 void sendEvent UIEvent anEvent 函数在UIApplication
  • Spring属性文件设置默认值

    我的 war 文件之外有一个属性文件 系统管理员使用该文件来关闭某些系统功能 它在我的本地计算机上运行得很好 但是当我们部署到开发环境时 属性文件未上传 应用程序无法启动 我想知道是否有一种方法可以在我的 applicationContex
  • Twitter Bootstrap 按钮在 IE8 中无响应

    IE 对我来说是个谜 我的网络应用程序可以在 Safari Firefox Chrome 甚至 iPhone 和 iPad 上运行 但当涉及到 IE 时 我根本无法理解遵守给定标准有多么困难 无论如何 足够的咆哮 我的 Twitter 引导
  • 有没有例子展示如何编写 DirectShow 转换过滤器?

    我想捕获当前帧及其前一帧进行分析并生成一个新帧来显示 是说我必须写一个变换DirectShow过滤器吗 但我是 DirectShow 的新手 我被MSDN的大量文档弄糊涂了 所以我想知道是否有任何简单的例子来展示如何做到这一点 谢谢 厨师
  • 在 Bitbucket API 中,如何获取所有许可用户的列表?

    我看过Bitbucket API 文档 https developer atlassian com bitbucket api 2 reference resource 和这篇文章BitBucket 获取所有贡献者列表 https stac
  • 如何创建 Azure.AsyncPageable 进行模拟?

    我想模拟一个返回一个 C 方法Azure AsyncPageable 这个类只有受保护的构造函数 所以我不能直接实例化它 有没有办法从其他集合 例如IAsyncEnumerable或者只是一个List 您可以创建Page物体using Pa
  • 如何将一串空格分隔的数字拆分为整数?

    我有一根绳子 42 0 例如 并且需要获取两个整数的数组 我可以做一个 split在一个空间上 The obvious approach to this problem is a common combination of simple t
  • Jackson:在反序列化时获得空引用

    我正在使用 spring mvcrestful服务 通过添加依赖项 我的其余控制器会自动generate json从我的response entities 依赖性 jackson 2 9 0 compile com fasterxml ja
  • 在 Javascript 变量声明中使用逗号[重复]

    这个问题在这里已经有答案了 我刚刚遇到以下代码 function showMatch str reg var res matches while true matches reg exec str if matches null break
  • 激活 IInterceptor 时出错...仅通过 COM?

    TL DR Kernel Get
  • S3 - 访问控制允许来源标头

    有没有人设法添加Access Control Allow Origin到响应头 我需要的是这样的 img src http 360assets s3 amazonaws com tours 8b16734d 336c 48c7 95c4 3
  • DateTime.Now 相当于 TimeOnly 和 DateOnly?

    NET 6 C 10 推出TimeOnly and DateOnly结构体 分别表示仅时间和日期 老好人DateTime结构总是有一个Now静态属性将为您提供当前日期和时间 我期待着两者TimeOnly and DateOnly结构具有类似
  • 在线程中访问 UI

    当我尝试更改 UI 属性 特别是启用 时 我的线程抛出 System Threading ThreadAbortException 如何在线程中访问 UI 您可以使用BackgroundWorker 然后像这样更改UI control In
  • 如何使用 R 获取所有 S&P500 公司代码列表?

    我想在R中制作FOR语句来一次性分析股票数据 但我不知道如何获得 S P 公司代码列表 请让我知道解决方案 谢谢 library rpart library rpart plot library quantmod startDate as