vintager
transforms source data stored in PostgreSQL or Oracle database into vintage analysis format. From detailed list of units (e.g. loans) and events (e.g. repayment), vintage curves are calculated.
library(devtools)
install_github("vintager", username="tomasgreif")
library(vintager)
drv <- dbDriver("PostgreSQL")
# Use real values!
pgCon <- dbConnect(drv, user = 'usr', dbname="db", password = 'secret',
host = 'localhost', port = 5432)
createTimeDistanceFunction(connection = con, loadData = TRUE)
vintager
can work with the following data design:
TBD
In the basic form, you can just use:
drv <- dbDriver("PostgreSQL")
# Use real values!
pgCon <- dbConnect(drv, user = 'usr', dbname="db", password = 'secret',
host = 'localhost', port = 5432)
vintageUnitSQL <- "select * from vintage_units"
performanceEventSQL <- "select * from performance_events"
getVintageData(vintageUnitSQL, performanceEventSQL, con = con)
For additional details see help:
help(getVintageData)
help(plotVintageData)
help(printVintageData)
help(aggregateVintageData)
help(createTimeDistanceFunction)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.