Uploads and appends an xts into a UCTS in the Datastream Database
UCTSAppend(
tsData,
TSCode = "",
MGMTGroup = "ABC",
freq = c("D", "W", "M", "Q", "Y"),
seriesName,
Units = "",
Decimals = 2,
ActPer = c("N", "Y"),
freqConversion = c("ACT", "SUM", "AVG", "END"),
Alignment = c("1ST", "MID", "END"),
Carry = c("YES", "NO", "PAD"),
PrimeCurr = "",
overwrite = TRUE,
mydsws = dsws$new(),
strUsername = ifelse(Sys.getenv("DatastreamUsername") != "",
Sys.getenv("DatastreamUsername"), options()$Datastream.Username),
strPassword = ifelse(Sys.getenv("DatastreamPassword") != "",
Sys.getenv("DatastreamPassword"), options()$Datastream.Password),
strServerName = "https://product.datastream.com",
strServerPage = "/UCTS/UCTSMaint.asp"
)TRUE if the upload has been a success, otherwise an error message
- an xts (or timeseries object that can be converted to one) to be uploaded.
The mnemonic of the target UCTS
Must have managment group. Only the first characters will be used.
The frequency of the data to be uploaded
the name of the series
Units of the data - can be no more than 12 characters - excess will be trimmed to that length
Number of Decimals in the data - a number between 0 and 9 - if outside that range then trimmed
Whether the values are percentages ("N") or actual numbers ("Y")
How to do any FX conversions
Alignment of the data within periods
whether to carry data over missing dates
the currency of the timeseries
if TRUE then existing data in the UCTS will be overwritten
a dsws object that can be passed in. Use this to avoid creating another dsws object in the same session.
your Datastream username
your Datastream Password
URL of the Datastream server
page on the datastream server
This function checks if there is a pre-existing timeseries already in Datastream. If there is then it will append the xts onto the existing series. If there are any overlapping dates then depending on the setting of overwrite then the new data will overwrite the existing data in the UCTS