rbotstats.Rmd

---
title: "Bet Statistics"
output: html_document
runtime: shiny
---

```{r setup, include=FALSE}
knitr::opts_chunk$set(echo = F)
```
```{r echo = F}
#
# parameters
#
filename <-
  paste0("data/dbdata2016-02-16T21-33.RData")

#
# packages
#
library(proto)
library(gsubfn)
library(RSQLite)
library(sqldf)

#
# functions
#
```
## Database
```{r}
#
# init
#
load(filename)
#names(ticksdf)[names(ticksdf) == "number"] <- "PeriodNumber"
#names(ticksdf)[names(ticksdf) == "Last"] <- "LastFixtures"
names(ticksDF)<-gsub("[.]","_",names(ticksDF))
df <- sqldf("Select distinct lineid, leaguename, HomeTeamName, AwayTeamName, moneyline_home, moneyline_away, moneyline_draw from ticksDF group by lineid")
knitr::kable(df, format = "markdown")
#d<-unique(ticksDF[,-c(1,16,17)])
#idx<-which(diff(d[,1])==0)

#find most early games starting time - last
#strptime(ticksDF[,2],format="%Y-%m-%dT%H:%M:%SZ")-ticksDF[,1]

# stats
#print(paste("File:",filename))

```

This R Markdown document is made interactive using Shiny. Unlike the more traditional workflow of creating static reports, you can now create documents that allow your readers to change the assumptions underlying your analysis and see the results immediately. 

To learn more, see [Interactive Documents](http://rmarkdown.rstudio.com/authoring_shiny.html).

## Inputs and Outputs

You can embed Shiny inputs and outputs in your document. Outputs are automatically updated whenever inputs change.  This demonstrates how a standard R plot can be made interactive by wrapping it in the Shiny `renderPlot` function. The `selectInput` and `sliderInput` functions create the input widgets used to drive the plot.

```{r eruptions, echo=FALSE}
inputPanel(
  selectInput("n_breaks", label = "Number of bins:",
              choices = c(10, 20, 35, 50), selected = 20),
  
  sliderInput("bw_adjust", label = "Bandwidth adjustment:",
              min = 0.2, max = 2, value = 1, step = 0.2)
)

renderPlot({
  hist(faithful$eruptions, probability = TRUE, breaks = as.numeric(input$n_breaks),
       xlab = "Duration (minutes)", main = "Geyser eruption duration")
  
  dens <- density(faithful$eruptions, adjust = input$bw_adjust)
  lines(dens, col = "blue")
})
```

## Embedded Application

It's also possible to embed an entire Shiny application within an R Markdown document using the `shinyAppDir` function. This example embeds a Shiny application located in another directory:

```{r tabsets, echo=FALSE}
shinyAppDir(
  system.file("examples/06_tabsets", package = "shiny"),
  options = list(
    width = "100%", height = 550
  )
)
```

Note the use of the `height` parameter to determine how much vertical space the embedded application should occupy.

You can also use the `shinyApp` function to define an application inline rather then in an external directory.

In all of R code chunks above the `echo = FALSE` attribute is used. This is to prevent the R code within the chunk from rendering in the document alongside the Shiny components.