get_blocked_position: Fetch blocked holdings data

In optimist/inhouse: In-house all-purpose functions used at CI Estrategias

Description

Construct a mysql query for the selected dates and contrato and sends it to the sql database 'posbloq'

Usage

get_blocked_position(fecha, contrato = NULL)

Arguments

contrato	A character or integer vector with the number of contratos
date	A vector of dates that can be of class character or Date but is expected to be in the format aaaa-mm-dd

Details

Blocked holdings are those cannot be rebalanced since they belong to client decisions outsided our investment strategies. This function will return a data.frame with blocked holdings information from one or several dates When no contrato is given, it will fetch the information of every contrato

Value

A data.frame with the holding of the given contratos in the selected dates. If no contrato is given, it will return the information of every contrato.

Examples

get_blocked_position("2015-12-31")

optimist/inhouse documentation built on May 24, 2019, 3:56 p.m.