Ian Gow iangow

The code below depends on some tables in my crsp schema, including crsp.rets, crsp.anncdates, and crsp.trading_dates. It also depends on a custom aggregate function (product) I have in PostgreSQL.

library(dplyr)
#> 
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#> 
#>     filter, lag

Go here for the latest.

Within RStudio, create a new RStudio project in a new directory.
Initialize the directory for Git: Do git init in the directory from the command line. (Perhaps this can be done within RStudio.)
Create a file index.Rmd with content from here.
Create a file _bookdown.yml with content similar to this.
Click "Build Website" on the Build tab in RStudio (it may be necessary to close RStudio and open the .Rproj file to get this).
On GitHub for this repository, go to Settings, GitHub Pages, then select "master branch /docs folder" as the source.

Voila.

	library(googlesheets)
	library(ggplot2)
	library(tidyr)
	library(dplyr, warn.conflicts = FALSE)

	gs <- gs_key("1vMzccNDQnGPLuNmRHe80okvEGZtHQt4xHFBscAZn5hc")

	scores <- gs_read(gs)
	scores

	#!/usr/bin/env bash
	cd ~/git
	git clone [email protected]:postgres-plr/plr.git
	cd plr
	R_HOME="/Library/Frameworks/R.framework/Resources" USE_PGXS=1 PG_CONFIG="/opt/local/lib/postgresql96/bin/pg_config" make
	sudo R_HOME="/Library/Frameworks/R.framework/Resources" USE_PGXS=1 PG_CONFIG="/opt/local/lib/postgresql96/bin/pg_config" make install

	rsync -avz hackintosh:/Volumes/2TB/data/streetevents_project/ \
	/Volumes/2TB/data/streetevents_project/ --include=*.xml --delete

	wget https://cran.rstudio.com/bin/macosx/R-4.0.3.pkg
	sudo installer -pkg R-4.0.3.pkg -target /
	rm R-4.0.3.pkg

	old_lib <- "/Library/Frameworks/R.framework/Versions/3.5/Resources/library"
	install.packages(list.files(old_lib))