def __saveToExcel(self): if len(self.__itemId) > 0: if self.__currentLoadType == "puts": data = self.__google_api.getPuts() else: data = self.__google_api.getCalls() finalData = [] finalData.append(list(self.__cols)) pickCol = pickColumns(data) for ind, fData in enumerate(pickCol): finalData.append(fData) dialogOption = { "filetypes" : [("All Files", ".*"), ("Excel File", ".xls")], "parent" : self.__root, "initialfile" : EXCEL_INITIAL_FILENAME } fname = tkFileDialog.asksaveasfilename(**dialogOption) if fname: writeToExcel(finalData, fname)
def __loader(self, loadType): if self.__google_api.fetchData(): #pass #tkMessageBox.showinfo(TkOptionGUI.DEFAULT_GUI_TITLE, "Option Chain Successfully Loaded") self.__currentLoadType = loadType self.__clearTreeView() if loadType == "puts": data = self.__google_api.getPuts() else: data = self.__google_api.getCalls() finalData = pickColumns(data) for ind, fData in enumerate(finalData): self.__itemId.append(self.__treeview.insert('',ind, '', values=tuple(fData))) expiry = self.__google_api.getExpiry() self.__root.title("%s (%s/%s/%s)" % (TkOptionGUI.DEFAULT_GUI_TITLE, expiry['m'], expiry['d'], expiry['y'])) else: self.__currentLoadType = TkOptionGUI.DEFAULT_LOAD_TYPE tkMessageBox.showerror(TkOptionGUI.DEFAULT_GUI_TITLE, "Cannot Fetch Option Chain Data")