[R] tidyquant error downloading symbols for Index

[David Winsemius]

> On Aug 6, 2017, at 5:10 PM, Sparks, John James <jspark4 at uic.edu> wrote:
> 
> Hi R Helpers,
> 
> I recently tried to take advantage of the ability to download all the
> tickers in the S&P 500 using the functionality of tidyquant, but it threw
> an error.
> 
> For summary, the set of commands that I ran was
> 
> library(tidyquant)
> tq_index_options()
> tq_index("SP500")
> sessionInfo()
> 
> 
> R feedback including error message and sessionInfo are provided below.
> 
> Guidance would be appreciated.
> 
> --John J. Sparks, Ph.D.
> 
> 
>> library(tidyquant)
> Loading required package: lubridate
> 
> Attaching package: ‘lubridate’
> 
> The following object is masked from ‘package:base’:
> 
>    date
> 
> Loading required package: PerformanceAnalytics
> Loading required package: xts
> Loading required package: zoo
> 
> Attaching package: ‘zoo’
> 
> The following objects are masked from ‘package:base’:
> 
>    as.Date, as.Date.numeric
> 
> 
> Package PerformanceAnalytics (1.4.3541) loaded.
> Copyright (c) 2004-2014 Peter Carl and Brian G. Peterson, GPL-2 | GPL-3
> http://r-forge.r-project.org/projects/returnanalytics/
> 
> 
> Attaching package: ‘PerformanceAnalytics’
> 
> The following object is masked from ‘package:graphics’:
> 
>    legend
> 
> Loading required package: quantmod
> Loading required package: TTR
> Version 0.4-0 included new data defaults. See ?getSymbols.
> Learn from a quantmod author:
> https://www.datacamp.com/courses/importing-and-managing-financial-data-in-r
> Loading required package: tidyverse
> Loading tidyverse: ggplot2
> Loading tidyverse: tibble
> Loading tidyverse: tidyr
> Loading tidyverse: readr
> Loading tidyverse: purrr
> Loading tidyverse: dplyr
> Conflicts with tidy packages
> -----------------------------------------------------
> as.difftime(): lubridate, base
> date():        lubridate, base
> filter():      dplyr, stats
> first():       dplyr, xts
> intersect():   lubridate, base
> lag():         dplyr, stats
> last():        dplyr, xts
> setdiff():     lubridate, base
> union():       lubridate, base
> 
> Attaching package: ‘tidyquant’
> 
> The following object is masked from ‘package:dplyr’:
> 
>    as_tibble
> 
> The following object is masked from ‘package:tibble’:
> 
>    as_tibble
> 
> There were 14 warnings (use warnings() to see them)
>> tq_index_options()
> [1] "RUSSELL1000" "RUSSELL2000" "RUSSELL3000" "DOW"         "DOWGLOBAL"
> [6] "SP400"       "SP500"       "SP600"       "SP1000"
>> tq_index("SP500")
> Getting holdings for SP500
> # A tibble: 0 x 0
> Warning message:
> In tq_index("SP500") : Error at SP500 during download.
> Error: .onLoad failed in loadNamespace() for 'rJava', details:
>  call: fun(libname, pkgname)
>  error: No CurrentVersion entry in Software/JavaSoft registry! Try
> re-installing Java and make sure R and Java have matching architectures.

Looks like your Java installation is not correct. Unfortunately I see no details that would support commentary on this question. Googling with that error message test brings up quite o bit of material.

-- 
David.
> 
>> sessionInfo()
> R version 3.3.2 (2016-10-31)
> Platform: x86_64-w64-mingw32/x64 (64-bit)
> Running under: Windows 7 x64 (build 7601) Service Pack 1
> 
> locale:
> [1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United
> States.1252
> [3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C
> [5] LC_TIME=English_United States.1252
> 
> attached base packages:
> [1] stats     graphics  grDevices utils     datasets  methods   base
> 
> other attached packages:
> [1] tidyquant_0.5.3               dplyr_0.7.2
> [3] purrr_0.2.3                   readr_1.1.1
> [5] tidyr_0.6.3                   tibble_1.3.3
> [7] ggplot2_2.2.1                 tidyverse_1.1.1
> [9] quantmod_0.4-10               TTR_0.23-2
> [11] PerformanceAnalytics_1.4.3541 xts_0.10-0
> [13] zoo_1.8-0                     lubridate_1.6.0
> 
> loaded via a namespace (and not attached):
> [1] Rcpp_0.12.12     cellranger_1.1.0 plyr_1.8.4       bindr_0.1
> [5] forcats_0.2.0    tools_3.3.2      jsonlite_1.5     nlme_3.1-131
> [9] gtable_0.2.0     lattice_0.20-35  pkgconfig_2.0.1  rlang_0.1.1
> [13] psych_1.7.5      curl_2.8.1       parallel_3.3.2   haven_1.1.0
> [17] bindrcpp_0.2     xml2_1.1.1       httr_1.2.1       stringr_1.2.0
> [21] hms_0.3          grid_3.3.2       glue_1.1.1       R6_2.2.2
> [25] Quandl_2.8.0     readxl_1.0.0     foreign_0.8-69   modelr_0.1.1
> [29] reshape2_1.4.2   magrittr_1.5     scales_0.4.1     rvest_0.3.2
> [33] assertthat_0.2.0 mnormt_1.5-5     colorspace_1.3-2 stringi_1.1.5
> [37] lazyeval_0.2.0   munsell_0.4.3    broom_0.4.2
> 
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.