DataReader

I have an issue with this command

S = DataReader(["IBM", "GOOG", "SI"], "yahoo", datetime(2007,7,1), datetime(2013,6,30))['Adj Close']

The first argument must be a name, not a list, so, how did you manage to get this working? or how could I joing these three set of datas?

I = DataReader("IBM", "yahoo", datetime(2007,7,1), datetime(2013,6,30))['Adj Close']

G = DataReader("GOOG", "yahoo", datetime(2007,7,1), datetime(2013,6,30))['Adj Close']

S = DataReader(["SI", "yahoo", datetime(2007,7,1), datetime(2013,6,30))['Adj Close']

Thanks in advance

[olafSmits]

Hi,
So you don't necessarily need a single name on the first argument. A list of stocks is fine.

However, that particular command is currently not working. The reason is that Google recently performed a stock split, see e.g. here:

http://investorplace.com/2014/04/goog-google-stock-split/

The old GOOG stock split into two stocks: GOOGL and GOOG. As far as yahoo.finance is concerned GOOG didn't exist before March this year, hence the error you get when you try to load the stock from 2007.

To fix it you should replace GOOG by GOOGL in the DataReader command.

As for your other question: to join two dataframes you can use the join method. Suppose:

I = DataReader("IBM", "yahoo", datetime(2007,7,1), datetime(2013,6,30))[['Adj Close']]
G = DataReader("GOOGL", "yahoo", datetime(2007,7,1), datetime(2013,6,30))[['Adj Close']]

Note the double brackets here: this makes sure that I and G are DataFrame objects. A single bracket turns them into a Series object (which you cannot join as easily).

Next set the column names
I.columns = "IBM"
G.columns = "GOOGL"

and perform a join:

F = I.join(G)

That's it.