I have a productivity problem, where I am trying to take all this un-formatted text, say dow 30 stocks with 20 years of returns,
and I want to click copy and paste into say, EXCEL. However, it just pastes the text into 1 column and many rows with lots of spaces.
My overall goal is to export it as a TAB delimited file or CSV to import into another editor, say to wrap it up into a R zoo or xts matrix format with date as the index, so I can actually multiply matrices.
OBVIOUSLY --- one work around is to use QUANDL or QUANTMOD to import Yahoo Finance data directly into R by fetching or scraping the website. The problem is, I want this data to be the EXACT data in this particularly enormous data set I'm working with, which is particular and not on yahoo finance or quandl.
The only workaround so-far I've found is to paste all the data into NOTEPAD and just manually put a comma or tab at each number and row column. It's incredibly slow and unproductive, it's a time killer and I would really be grateful for a better way to work around this problem from some of the quant community.
Thanks