Replace: for i in range(1, 31): with: for d in Data[1:31]: #since you have range(1,31). Do Data[1:] if you just want to skip the first OneDate.append(d[0]) OneClose.append(d[4]) This usually happends when Data array has less than 31 indices. Also ensure d array has atleast 5 items, else d[4] will also throw a similar error. Use: … Read more
You can use yahoo’s symbol lookup like so: http://d.yimg.com/autoc.finance.yahoo.com/autoc?query=yahoo&callback=YAHOO.Finance.SymbolSuggest.ssCallback Where query is the company name. You’ll get something like this in return: YAHOO.Finance.SymbolSuggest.ssCallback( { “ResultSet”: { “Query”: “ya”, “Result”: [ { “symbol”: “YHOO”, “name”: “Yahoo! Inc.”, “exch”: “NMS”, “type”: “S”, “exchDisp”: “NASDAQ” }, { “symbol”: “AUY”, “name”: “Yamana Gold, Inc.”, “exch”: “NYQ”, “type”: “S”, “exchDisp”: … Read more
Try pandas.ExcelWriter In [1]: import pandas as pd pd In [2]: pd.ExcelWriter? … Init signature: pd.ExcelWriter(cls, path, engine=None, **kwargs) Docstring: Class for writing DataFrame objects into excel sheets, default is to use xlwt for xls, openpyxl for xlsx. See DataFrame.to_excel for typical usage. In [6]: pd.DataFrame.to_excel? —– If passing an existing ExcelWriter object, then the … Read more