EE_getETSfromJY: Get ETS object from JY database

In QianMazi/MaziBox:

Description

Get ETS object from JY database

Usage

EE_getETSfromJY(SheetName, key.df, extra.condition = NULL,
  stock.column = "InnerCode", stock.decode = "InnerCode",
  date.column = "InfoPublDate")

Arguments

SheetName	The sheet name string of the data.
key.df	The key data frame.
extra.condition	The extra qr string could be add to the SQL.
stock.column	The column name which indicating the stockID in the sheet
stock.decode	The column name in decode sheet which is used to decode the stockID.
date.column	The column name string of the date in the data.

Value

A dataframe with date, stockID and vars.

Examples

# Fetching the ETS of investors' activities.
key.df <- rbind(buildkey("SerialNb"))
tmpdat <- EE_getETSfromJY(SheetName = "LC_InvestorRa", key.df)
# Fetching the ETS of shares transfering.
key.df <- rbind(buildkey("TranShareType",1040),
                buildkey("TranMode",1202),
                buildkey("IfSuspended"),
                buildkey("TransfererEcoNature",1096,1),
                buildkey("ReceiverEcoNature",1096,2))
tmpdat <- EE_getETSfromJY(SheetName = "LC_ShareTransfer", key.df)

QianMazi/MaziBox documentation built on May 8, 2019, 3:49 a.m.