connect.and.query: Part1 : Get Dataset from MySQL to R(Database Connetion...

Description Usage Arguments Examples

Description

These functions allow you to query data from Database, this function is the foundation of other database Connection Function

Usage

1
connect.and.query(query, type = "get")

Arguments

tests

————

Examples

 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
connect.and.query = function(query, type = "get")
GET.value.lookup = function(table = "scaling", col2lookup = "Scaling_Ratio", col.name = "Date", col.value)
GET.n.until = function(column, table, n, DATE)
GET.column = function(table, column)
GET.rt.dateRange = function(first_day, last_day, tickers = slec.tickers, table = "daily_return")
GET.rt = function(tickers = "SHV,SHY,IEI,AGZ,STIP,TIP", table, DATE, days.all = 504, delim = ",")
excludeSheet
applyPreference = function(features, excludeSheet, riskTolerance="Low", investmentHorizon="Short")
check.and.print = function(x)
check.dateRange = function(dataset, column = "Date")
check.valid.tickers = function(tickers, first_day, last_day, lookback.days)
as.Date.n = function(x)
SD.year2day = function(SD_year, is.percent = FALSE)
SD.day2year = function(SD_day)
rt.quater2year = function(rt_quater)
rt.year2quater = function(rt_year)
percent = function(x){x / 100}
YTM2adjust_rt = function(YTM)
shorten.rts = function(dataset, exclude = "Date")
adjusted_rt2proj_rt = function(adjusted_rt, daily_rt, DATE, days.lookBackMmt=105, days.excludeMmt=21)
cov.period = function(DATE, days.lookBackSD = 504, daily_rt)
cov.matrix2 = function(cov_period, SR)
opti.wets.donlp2 = function(SD_1year.max=3.5, rt_1quater.min=-3, proj_rt, cov_matrix2, stress_rt, stress_drawdown=15)
opti.wets = function(daily_rt, forward_rt, DATE, days.lookBackSD=504, days.lookBackMmt=105, days.excludeMmt=21, SD_1year.max=3.5, rt_1quater.min=-3,forward_rt_type = "adjusted",stress_rt, stress_drawdown)
portfolio.SD = function(weights, cov_matrix2)
portfolio.rt = function(weights, rt_)
global.bounds = function(SD, limit)
notebook.declare = function(daily_rt)
compound = function(notebook, thisDay, cov_period.thisDay, returns.thisDay)
check.if.rebalance = function(SD_thisDay, lowerBound, upperBound)

yuezhengjessica/RoboPackage documentation built on May 3, 2019, 2:55 p.m.