Shiny Finance with Tidyquant (NEW EXCEL IN R) | Learning Lab 30 (Full Version)

#Tidyquant 1.0.0 was just released - with new #Excel features now available in #R including:
Pivot Tables
Vlookups
Sum-Ifs
Net Workdays
Business Calendars & Holiday Sequences
100+ Excel Functions ported to R

[LAUNCHING in 2020] Advanced Time Series Forecasting in R course. Become the times series domain expert in your organization. Get notified about this course when it comes out here: https://mailchi.mp/business-science/t...

[Weekly R-tips] Every Tuesday receive a new, worked out R example using practical datasets. Whether it's shortcodes, how to use newly released libraries and functions, and other ways to help you be more efficient and "in the know" Sign up here: https://learn.business-science.io/fre...

[Learning Labs] Every two weeks I host a FREE & LIVE webinar on advanced, intermediate, or cutting-edge topics in data science, Shiny app development, or machine learning. Always includes a code demo. Get notified so you don’t miss out: https://mailchi.mp/business-science/w...


Table of Contents:
Agenda - 5:56
Shiny App Demo - Drag N' Drop Pivot Table - 7:22
Why Make the App in R Shiny? 15:44
Why Bring Excel to R? 20:59
Code Demo - 30:47
01 - Getting Financial Data from Tidyquant - 32:28
02 - Pivot Tables - 41:18
03 - Vlookups - 51:04
04 - Summarize By Time - 55:36
05 - Excel Functions - Sum-Ifs, Net Workdays, Holidays - 59:18
Excel Date, Holidays, & Net Work Days - 1:08:31
Financial Calcs - NPV, IRR, FV, etc - 1:12:24
Shiny APP - 1:14:39
Pro-Tips - 1:15:41
Learning Path - 1:19:03

Want the Drag 'N Drop Shiny Pivot Table App?
Join Learning Labs PRO here: https://university.business-science.i...

SPECIAL OFFER 15% OFF 4-COURSE R-TRACK - Promo Code: learninglabs
https://university.business-science.i...