How to Host an R Shiny App on AWS EC2 via Shiny Server and RStudio Server on a Windows Machine

Shinyapps.io is a great free resource for hosting your first Shiny app. However, the server space and computing power is quite limited. Upgrading to the cheapest option is $9/month which is more expensive than most web hosting companies. So is there another option to be able to host your Apps without making a dent in …

How to Host an R Shiny App on AWS EC2 via Shiny Server and RStudio Server on a Windows Machine Read More »

Pulling Stock Data and Creating an Efficient Frontier in Excel

I mentioned in a previous post on how to get (nearly) live stock data from Google Finance. However, if you start pulling data from different markets, daily historical rates won’t make sense as different markets are closed on different days. This causes problems when trying to figure out the correlation between stocks. A solution to …

Pulling Stock Data and Creating an Efficient Frontier in Excel Read More »