-
Notifications
You must be signed in to change notification settings - Fork 1
/
test_tq_Rblpapi_bds.Rmd
75 lines (59 loc) · 1.85 KB
/
test_tq_Rblpapi_bds.Rmd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
---
title: "test_tq_Rblpapi_bds"
output: github_document
author: 'Art Steinmetz'
---
# testing Tidyquant Rblpapi integration
validate some variations on <code>bds()</code>
```{r}
devtools::install_github("business-science/tidyquant")
library(tidyverse)
library(stringr)
library(dplyr)
library(lubridate)
library(Rblpapi)
library(tidyquant)
library(reprex)
library(Rblpapi)
paste("Using tidyquant version",packageVersion('tidyquant'))
```
#initial test
# from Rblpapi docs using Rblpapi::bdp(), not tq_get()
```{r}
# Get BBG Descriptive Data
## Not run:
## simple query
blpConnect()
output_bds<-bds("GOOG US Equity", "TOP_20_HOLDERS_PUBLIC_FILINGS")
output_bds
```
#using tq_get
The parameter names for bds() differ slightly from bdp() and bdh().
<code>securities</code> becomes <code>security</code> and that blows up piping in the ticker symbols. <code>fields</code> becomes <code>field</code>
#Pipe in first parameter with the ticker
```{r}
my_bloomberg_data <- c('GOOG US Equity') %>%
tq_get(get = "rblpapi",
rblpapi_fun = "bds",
field = c("TOP_20_HOLDERS_PUBLIC_FILINGS")
)
```
#try assigning x.
```{r}
my_bloomberg_data <- tq_get(x = 'GOOG US Equity',
get = "rblpapi",
rblpapi_fun = "bds",
field = c("TOP_20_HOLDERS_PUBLIC_FILINGS")
)
my_bloomberg_data
```
Commented out because otherwise execution halts. Error message shown below.
```{r}
# my_bloomberg_data <- tq_get(security = 'GOOG US Equity',
# get = "rblpapi",
# rblpapi_fun = "bds",
# field = c("TOP_20_HOLDERS_PUBLIC_FILINGS")
# )
```
`Error in tq_get(security = "GOOG US Equity", get = "rblpapi", rblpapi_fun = "bds", :
argument "x" is missing, with no default`