Ok, I have two datasets: This is a sample of the first (portfolio 1): Brand, Year, Interbrand value (in millions) GVKEY, Ticker Symbol and Sector. Coca Cola 2002 69,637 3144 KO Beverage Coca Cola 2003 70,453 3144 KO Beverage Coca Cola 2005 67,525 3144 KO Beverage Coca Cola 2008 66,667 3144 KO Beverage Coca Cola 2009 68,734 3144 KO Beverage Coca Cola 2010 70,452 3144 KO Beverage Coca Cola 2011 71,861 3144 KO Beverage Dell 2003 10,367 14489 DELL Electron Dell 2004 11,5 14489 DELL Electron Dell 2005 13,231 14489 DELL Electron Dell 2008 11,695 14489 DELL Electron The second dataset looks like this: Date, Ticker Symbol, Stock price, CFACPR 31-1-2002 DELL 27,48999977 1 28-2-2002 DELL 24,69000053 1 28-3-2002 DELL 26,11000061 1 30-4-2002 DELL 26,34000015 1 31-5-2002 DELL 26,85000038 1 28-6-2002 DELL 26,13999939 1 31-7-2002 DELL 24,93000031 1 30-8-2002 DELL 26,62000084 1 30-9-2002 DELL 23,51000023 1 31-10-2002 DELL 28,61000061 1 29-11-2002 DELL 28,60000038 1 31-12-2002 DELL 26,73999977 1 31-1-2003 DELL 23,86000061 1 28-2-2003 DELL 26,95999908 1 31-3-2003 DELL 27,30999947 1 30-4-2003 DELL 28,97999954 1 30-5-2003 DELL 31,37000084 1 30-6-2003 DELL 31,84000015 1 31-7-2003 DELL 33,68000031 1 29-8-2003 DELL 32,61999893 1 30-9-2003 DELL 33,41999817 1 31-10-2003 DELL 36 1 28-11-2003 DELL 34,56999969 1 31-12-2003 DELL 33,97999954 1 30-1-2004 DELL 33,43999863 1 27-2-2004 DELL 32,65000153 1 31-3-2004 DELL 33,61999893 1 30-4-2004 DELL 34,77999878 1 28-5-2004 DELL 35,24000168 1 30-6-2004 DELL 35,81999969 1 30-7-2004 DELL 35,47000122 1 31-8-2004 DELL 34,84000015 1 30-9-2004 DELL 35,59999847 1 29-10-2004 DELL 35,06000137 1 30-11-2004 DELL 40,52000046 1 31-12-2004 DELL 42,13999939 1 31-1-2005 DELL 41,75999832 1 28-2-2005 DELL 40,09000015 1 31-3-2005 DELL 38,41999817 1 29-4-2005 DELL 34,83000183 1 31-5-2005 DELL 39,93000031 1 30-6-2005 DELL 39,45999908 1 29-7-2005 DELL 40,47000122 1 31-8-2005 DELL 35,59999847 1 30-9-2005 DELL 34,20000076 1 31-10-2005 DELL 31,87999916 1 30-11-2005 DELL 30,15099907 1 30-12-2005 DELL 29,95000076 1 31-1-2006 DELL 29,30999947 1 28-2-2006 DELL 29 1 31-3-2006 DELL 29,76000023 1 28-4-2006 DELL 26,20000076 1 31-5-2006 DELL 25,37999916 1 30-6-2006 DELL 24,45999908 1 31-7-2006 DELL 21,68000031 1 31-8-2006 DELL 22,54999924 1 29-9-2006 DELL 22,84000015 1 31-10-2006 DELL 24,32999992 1 30-11-2006 DELL 27,23999977 1 29-12-2006 DELL 25,09000015 1 31-1-2007 DELL 24,21999931 1 28-2-2007 DELL 22,85000038 1 30-3-2007 DELL 23,20999908 1 30-4-2007 DELL 25,20999908 1 31-5-2007 DELL 26,9109993 1 29-6-2007 DELL 28,54999924 1 31-7-2007 DELL 27,96999931 1 31-8-2007 DELL 28,25 1 28-9-2007 DELL 27,60000038 1 31-10-2007 DELL 30,60000038 1 30-11-2007 DELL 24,54000092 1 31-12-2007 DELL 24,51000023 1 31-1-2008 DELL 20,04000092 1 29-2-2008 DELL 19,90010071 1 31-3-2008 DELL 19,92000008 1 30-4-2008 DELL 18,62999916 1 30-5-2008 DELL 23,05999947 1 30-6-2008 DELL 21,87999916 1 31-7-2008 DELL 24,56999969 1 29-8-2008 DELL 21,72999954 1 30-9-2008 DELL 16,47999954 1 31-10-2008 DELL 12,19999981 1 28-11-2008 DELL 11,17000008 1 31-12-2008 DELL 10,23999977 1 30-1-2009 DELL 9,5 1 27-2-2009 DELL 8,529999733 1 31-3-2009 DELL 9,479999542 1 30-4-2009 DELL 11,61999989 1 29-5-2009 DELL 11,56999969 1 30-6-2009 DELL 13,72999954 1 31-7-2009 DELL 13,38000011 1 31-8-2009 DELL 15,82999992 1 30-9-2009 DELL 15,26000023 1 30-10-2009 DELL 14,44999981 1 30-11-2009 DELL 14,11999989 1 31-12-2009 DELL 14,35999966 1 29-1-2010 DELL 12,89999962 1 26-2-2010 DELL 13,23999977 1 31-3-2010 DELL 15,02000046 1 30-4-2010 DELL 16,20000076 1 28-5-2010 DELL 13,32999992 1 30-6-2010 DELL 12,06000042 1 30-7-2010 DELL 13,23999977 1 31-8-2010 DELL 11,77000046 1 30-9-2010 DELL 12,97000027 1 29-10-2010 DELL 14,39500046 1 30-11-2010 DELL 13,22000027 1 31-12-2010 DELL 13,55000019 1 31-1-2011 DELL 13,15999985 1 28-2-2011 DELL 15,82999992 1 31-3-2011 DELL 14,51000023 1 29-4-2011 DELL 15,47000027 1 31-5-2011 DELL 16,07999992 1 30-6-2011 DELL 16,67000008 1 29-7-2011 DELL 16,23999977 1 31-8-2011 DELL 14,86499977 1 30-9-2011 DELL 14,14000034 1 31-10-2011 DELL 15,81000042 1 30-11-2011 DELL 15,76000023 1 30-12-2011 DELL 14,63000011 1 31-1-2002 KO 43,75 1 28-2-2002 KO 47,38999939 1 28-3-2002 KO 52,25999832 1 30-4-2002 KO 55,50999832 1 31-5-2002 KO 55,56000137 1 28-6-2002 KO 56 1 31-7-2002 KO 49,93999863 1 30-8-2002 KO 51 1 30-9-2002 KO 47,95999908 1 31-10-2002 KO 46,47999954 1 29-11-2002 KO 45,63999939 1 31-12-2002 KO 43,84000015 1 31-1-2003 KO 40,45999908 1 28-2-2003 KO 40,22000122 1 31-3-2003 KO 40,47999954 1 30-4-2003 KO 40,40000153 1 30-5-2003 KO 45,56999969 1 30-6-2003 KO 46,40999985 1 31-7-2003 KO 44,97000122 1 29-8-2003 KO 43,52000046 1 30-9-2003 KO 42,95999908 1 31-10-2003 KO 46,40000153 1 28-11-2003 KO 46,5 1 31-12-2003 KO 50,75 1 30-1-2004 KO 49,24000168 1 27-2-2004 KO 49,95999908 1 31-3-2004 KO 50,29999924 1 30-4-2004 KO 50,56999969 1 28-5-2004 KO 51,34999847 1 30-6-2004 KO 50,47999954 1 30-7-2004 KO 43,86000061 1 31-8-2004 KO 44,70999908 1 30-9-2004 KO 40,04999924 1 29-10-2004 KO 40,65999985 1 30-11-2004 KO 39,31000137 1 31-12-2004 KO 41,63999939 1 31-1-2005 KO 41,49000168 1 28-2-2005 KO 42,79999924 1 31-3-2005 KO 41,66999817 1 29-4-2005 KO 43,43999863 1 31-5-2005 KO 44,63000107 1 30-6-2005 KO 41,75 1 29-7-2005 KO 43,75999832 1 31-8-2005 KO 44 1 30-9-2005 KO 43,18999863 1 31-10-2005 KO 42,77999878 1 30-11-2005 KO 42,68999863 1 30-12-2005 KO 40,31000137 1 31-1-2006 KO 41,38000107 1 28-2-2006 KO 41,97000122 1 31-3-2006 KO 41,86999893 1 28-4-2006 KO 41,95999908 1 31-5-2006 KO 44,02999878 1 30-6-2006 KO 43,02000046 1 31-7-2006 KO 44,5 1 31-8-2006 KO 44,81000137 1 29-9-2006 KO 44,68000031 1 31-10-2006 KO 46,72000122 1 30-11-2006 KO 46,83000183 1 29-12-2006 KO 48,25 1 31-1-2007 KO 47,88000107 1 28-2-2007 KO 46,68000031 1 30-3-2007 KO 48 1 30-4-2007 KO 52,18999863 1 31-5-2007 KO 52,99000168 1 29-6-2007 KO 52,31000137 1 31-7-2007 KO 52,11000061 1 31-8-2007 KO 53,77999878 1 28-9-2007 KO 57,47000122 1 31-10-2007 KO 61,75999832 1 30-11-2007 KO 62,09999847 1 31-12-2007 KO 61,36999893 1 31-1-2008 KO 59 1 29-2-2008 KO 58,45999908 1 31-3-2008 KO 60,86999893 1 30-4-2008 KO 58,86999893 1 30-5-2008 KO 57,25999832 1 30-6-2008 KO 51,97999954 1 31-7-2008 KO 51,5 1 29-8-2008 KO 52,06999969 1 30-9-2008 KO 52,88000107 1 31-10-2008 KO 44,06000137 1 28-11-2008 KO 46,86999893 1 31-12-2008 KO 45,27000046 1 30-1-2009 KO 42,72000122 1 27-2-2009 KO 40,84999847 1 31-3-2009 KO 43,95000076 1 30-4-2009 KO 43,04999924 1 29-5-2009 KO 49,15999985 1 30-6-2009 KO 47,99000168 1 31-7-2009 KO 49,84000015 1 31-8-2009 KO 48,77000046 1 30-9-2009 KO 53,70000076 1 30-10-2009 KO 53,31000137 1 30-11-2009 KO 57,20000076 1 31-12-2009 KO 57 1 29-1-2010 KO 54,25 1 26-2-2010 KO 52,72000122 1 31-3-2010 KO 55 1 30-4-2010 KO 53,45000076 1 28-5-2010 KO 51,40000153 1 30-6-2010 KO 50,11999893 1 30-7-2010 KO 55,11000061 1 31-8-2010 KO 55,88249969 1 30-9-2010 KO 58,52000046 1 29-10-2010 KO 61,31999969 1 30-11-2010 KO 63,16999817 1 31-12-2010 KO 65,76999664 1 31-1-2011 KO 62,84999847 1 28-2-2011 KO 63,91999817 1 31-3-2011 KO 66,33999634 1 29-4-2011 KO 67,45999908 1 31-5-2011 KO 66,80999756 1 30-6-2011 KO 67,29000092 1 29-7-2011 KO 68,01000214 1 31-8-2011 KO 70,44999695 1 30-9-2011 KO 67,55999756 1 31-10-2011 KO 68,31999969 1 30-11-2011 KO 67,23000336 1 30-12-2011 KO 69,97000122 1 The second dataset should be linked to the portfolios (have 4 of them). The dataset that I want should have the following elements: All the elements of the first dataset (brand, year and so on) And from the second dataset: Date, stock price for each month (not a total) and CFACPR number.
... View more