I am importing from a csv, and I need some help grabbing the data that I need. Essentially, it is a csv file containing investment retus, and each investment has two columns (One with the date, and one with the retus). The format of the columns are below:
Investment1 Investment2
6/1/2013 -0.043 1/1/2014 0.08
7/1/2013 0.003 2/1/2014 0.01
8/1/2013 0.14 3/1/2014 -0.09
9/1/2013 0.09 4/1/2014 0.015
10/1/2013 0.03 5/1/2014 0.03
11/1/2013 0.02 6/1/2014 0.05
12/1/2013 0.04 7/1/2014 -0.15
As you can see, the investment retus are from oldest to newest, however, all investments contain data for at least the last 12 months. I am trying to accomplish two things here: 1.) Auto populate the "Retu" column header with the header from its preceding column. 2.) I need to grab the prior 12 months worth of data per security.
I would post some code, but I have no idea where to begin other than reading in the csv file. Thanks so much!