UCTSAppend: Append a xts to an existing UCTS timeseries in Datastream
In DatastreamDSWS2R: Provides a Link Between the 'LSEG Datastream' System and R

UCTSAppend

R Documentation

Append a xts to an existing UCTS timeseries in Datastream

Description

Uploads and appends an xts into a UCTS in the Datastream Database

Usage

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"
)

Arguments

`tsData`	- an xts (or timeseries object that can be converted to one) to be uploaded.
`TSCode`	The mnemonic of the target UCTS
`MGMTGroup`	Must have managment group. Only the first characters will be used.
`freq`	The frequency of the data to be uploaded
`seriesName`	the name of the series
`Units`	Units of the data - can be no more than 12 characters - excess will be trimmed to that length
`Decimals`	Number of Decimals in the data - a number between 0 and 9 - if outside that range then trimmed
`ActPer`	Whether the values are percentages ("N") or actual numbers ("Y")
`freqConversion`	How to do any FX conversions
`Alignment`	Alignment of the data within periods
`Carry`	whether to carry data over missing dates
`PrimeCurr`	the currency of the timeseries
`overwrite`	if TRUE then existing data in the UCTS will be overwritten
`mydsws`	a dsws object that can be passed in. Use this to avoid creating another dsws object in the same session.
`strUsername`	your Datastream username
`strPassword`	your Datastream Password
`strServerName`	URL of the Datastream server
`strServerPage`	page on the datastream server

Details

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