Mar-23-2021, 12:13 AM
(This post was last modified: Mar-23-2021, 12:13 AM by stylingpat.)
Ha thanks, I figured it out. It was kinda simple. Here's the solution for anyone else facing the same problem.
df1 = pd.DataFrame(historicalData[0:1000000]) df2 = pd.DataFrame(historicalData[1000000:2000000]) df3 = pd.DataFrame(historicalData[2000000:3000000]) df4 = pd.DataFrame(historicalData[3000000:4000000]) df5 = pd.DataFrame(historicalData[4000000:5000000]) df6 = pd.DataFrame(historicalData[5000000:6000000]) writer = pd.ExcelWriter('15 Year Backtest.xlsx', engine='xlsxwriter') df1.to_excel(writer, sheet_name='Sheet1') df2.to_excel(writer, sheet_name='Sheet2') df3.to_excel(writer, sheet_name='Sheet3') df4.to_excel(writer, sheet_name='Sheet4') df5.to_excel(writer, sheet_name='Sheet5') df6.to_excel(writer, sheet_name='Sheet6') writer.save()Now if I can just sort out this threading problem... Its like after an hour, the program forgets its running... Or to be more accurate, one of the threads just forgets what its supposed to do after a period of time.