Is there a way to import time series data directly from yahoo finance to R instead of downloading every time series? Right now I download every single time series in excel then import via read.csv.
Check out package quantmod
e.g. function getSymbols('MSFT',src='yahoo')
Respectively the according vignette.