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")
