Exemplo n.º 1
0
def generate_robust_report(fund_matrix, out_file):
    """
    @summary generates a report using robust backtesting
    @param fund_matrix: a pandas matrix of fund time series
    @param out_file: filename where to print report
    """
    html_file  =  open(out_file,"w")
    print_header(html_file, out_file)
    converter.fundsToPNG(fund_matrix,'funds.png')
    html_file.write("<H2>QSTK Generated Report:" + out_file + "</H2>\n")
    html_file.write("<IMG SRC = \'./funds.png\'/>\n")
    html_file.write("<IMG SRC = \'./analysis.png\'/>\n")
    html_file.write("<BR/>\n\n")
    print_stats(fund_matrix, "robust funds", html_file)
    print_footer(html_file)
Exemplo n.º 2
0
def generate_robust_report(fund_matrix, out_file):
    """
    @summary generates a report using robust backtesting
    @param fund_matrix: a pandas matrix of fund time series
    @param out_file: filename where to print report
    """
    html_file = open(out_file, "w")
    print_header(html_file, out_file)
    converter.fundsToPNG(fund_matrix, 'funds.png')
    html_file.write("<H2>QSTK Generated Report:" + out_file + "</H2>\n")
    html_file.write("<IMG SRC = \'./funds.png\'/>\n")
    html_file.write("<IMG SRC = \'./analysis.png\'/>\n")
    html_file.write("<BR/>\n\n")
    print_stats(fund_matrix, "robust funds", html_file)
    print_footer(html_file)
Exemplo n.º 3
0
def reportFunctionality(funds, symbols, filename=sys.stdout):
    if (len(symbols) != 0):
        funds2 = runOther(funds, symbols)
        arg2 = 1
    else:
        arg2 = 0

    if (filename == sys.stdout):
        html_file = sys.stdout
    else:
        html_file = open(filename, "w")

    #top
    html_file.write("<HTML>\n")
    html_file.write("<HEAD>\n")
    html_file.write("<TITLE>QSTK Generated Report from " +
                    readableDate(funds.index[0]) + " to " +
                    readableDate(funds.index[-1]) + "</TITLE>\n")
    html_file.write("</HEAD>\n\n")
    html_file.write("<BODY><CENTER>\n\n")

    years = du.getYears(funds)

    html_file.write("<H2>Performance Summary for " + sys.argv[1] + "</H2>\n")
    html_file.write("For the dates " + readableDate(funds.index[0]) + " to " +
                    readableDate(funds.index[-1]) + "\n")

    html_file.write("<H3>Yearly Performance Metrics</H3>\n")

    html_file.write("<TABLE CELLPADDING=10>\n")
    html_file.write("<TR><TH></TH>\n")
    for year in years:
        html_file.write("<TH>" + str(year) + "</TH>\n")
    html_file.write("</TR>\n")

    #yearly return
    html_file.write("<TR>\n")
    html_file.write("<TH>Annualized Return:</TH>\n")
    for year in years:
        retur = getYearReturn(funds, year)
        html_file.write("<TD>\n")
        print >> html_file, "%.2f\n" % (retur * 100)
        html_file.write("%</TD>\n")
    html_file.write("</TR>\n")

    #yearly winning days
    html_file.write("<TR>\n")
    html_file.write("<TH>Winning Days:</TH>\n")
    for year in years:
        # change to compare to inputs - ratio=tsu.getYearRatio(funds,year)
        if (arg2 != 0):
            win = getWinningDays(funds, funds2, year)
            html_file.write("<TD>\n")
            print >> html_file, "%.2f\n" % (win * 100)
            html_file.write("%</TD>\n")
        else:
            html_file.write("<TD>No comparison.</TD>\n")
    html_file.write("</TR>\n")

    #max draw down
    html_file.write("<TR>\n")
    html_file.write("<TH>Max Draw Down:</TH>\n")
    for year in years:
        drop = getYearMaxDrop(funds, year)
        html_file.write("<TD>\n")
        print >> html_file, "%.2f" % (drop * 100)
        html_file.write("%</TD>\n")
    html_file.write("</TR>\n")

    #yearly sharpe ratio using daily rets
    html_file.write("<TR>\n")
    html_file.write("<TH>Daily Sharpe Ratio:</TH>\n")
    for year in years:
        ratio = tsu.getYearRatio(funds, year)
        html_file.write("<TD>\n")
        print >> html_file, "%.2f\n" % ratio
        html_file.write("</TD>\n")
    html_file.write("</TR>\n")

    #yearly sharpe ratio using monthly rets
    html_file.write("<TR>\n")
    html_file.write("<TH>Monthly Sharpe Ratio:</TH>\n")
    for year in years:
        ratio = getYearRatioUsingMonth(funds, year)
        html_file.write("<TD>\n")
        print >> html_file, "%.2f\n" % ratio
        html_file.write("</TD>\n")
    html_file.write("</TR>\n")

    html_file.write("</TABLE>\n")
    html_file.write("<BR/>\n\n")

    vals = funds.values
    vals2 = np.append(vals, funds2.values, 2)

    df = DataMatrix(index=funds.index, data=funds.values, columns=['fund'])
    df2 = DataMatrix(index=funds2.index, data=funds2.values, columns=['other'])
    df['other'] = df2['other']

    corrcoef = numpy.corrcoef(funds.values[0:-1], funds2.values)
    html_file.write("<H3>Correlation=")
    print >> html_file, "%.2f\n" % corrcoef[0][1]
    html_file.write("<H3>\n")
    html_file.write("<BR/>\n\n")

    #montly returns
    mrets = tsu.monthly(funds)
    html_file.write("<H2>Monthly Returns</H2>\n")
    html_file.write("<TABLE CELLPADDING=10>\n")
    html_file.write("<TR>\n")
    html_file.write("<TH></TH>\n")
    month_names = du.getMonthNames()
    for name in month_names:
        html_file.write("<TH>" + str(name) + "</TH>\n")
    html_file.write("</TR>\n")

    i = 0
    for year in years:
        html_file.write("<TR>\n")
        html_file.write("<TH>" + str(year) + "</TH>\n")
        months = du.getMonths(funds, year)
        for month in months:
            html_file.write("<TD>\n")
            print >> html_file, "%.2f\n" % (mrets[i] * 100)
            html_file.write("%</TD>\n")
            i += 1
        html_file.write("</TR>\n")
    html_file.write("</TABLE>\n")
    html_file.write("<BR/>\n\n")

    #fund value graph
    fundlist = []
    fundlist.append(funds)
    fundlist.append(funds2)
    converter.fundsToPNG(fundlist, 'funds.png')
    html_file.write("<IMG SRC=\'./funds.png\'/>\n")
    html_file.write("<BR/>\n\n")

    #end
    html_file.write("</CENTER></BODY>\n\n")
    html_file.write("</HTML>")
def reportFunctionality(funds, symbols,filename=sys.stdout):
	if(len(symbols)!=0):
		funds2=runOther(funds,symbols)
		arg2=1
	else:
		arg2=0

	if(filename==sys.stdout):
		html_file=sys.stdout
	else:
		html_file = open(filename,"w")
	
	#top
	html_file.write("<HTML>\n")
	html_file.write("<HEAD>\n")	
	html_file.write("<TITLE>QSTK Generated Report from "+readableDate(funds.index[0])+" to "+readableDate(funds.index[-1])+"</TITLE>\n")
	html_file.write("</HEAD>\n\n")
	html_file.write("<BODY><CENTER>\n\n")
	
	years=du.getYears(funds)

	html_file.write("<H2>Performance Summary for "+sys.argv[1]+"</H2>\n")
	html_file.write("For the dates "+readableDate(funds.index[0])+" to "+readableDate(funds.index[-1])+"\n")


	html_file.write("<H3>Yearly Performance Metrics</H3>\n")


	html_file.write("<TABLE CELLPADDING=10>\n")
	html_file.write("<TR><TH></TH>\n")
	for year in years:
		html_file.write("<TH>"+str(year)+"</TH>\n")
	html_file.write("</TR>\n")

	#yearly return
	html_file.write("<TR>\n")
	html_file.write("<TH>Annualized Return:</TH>\n")
	for year in years:
		retur=getYearReturn(funds,year)
		html_file.write("<TD>\n")
		print >>html_file, "%.2f\n" % (retur*100) 
		html_file.write("%</TD>\n")
	html_file.write("</TR>\n")

	#yearly winning days
	html_file.write("<TR>\n")
	html_file.write("<TH>Winning Days:</TH>\n")
	for year in years:
		# change to compare to inputs - ratio=tsu.getYearRatio(funds,year)
		if(arg2!=0):
			win=getWinningDays(funds,funds2,year)
			html_file.write("<TD>\n")
			print >>html_file, "%.2f\n" % (win*100)
			html_file.write("%</TD>\n")
		else:
			html_file.write("<TD>No comparison.</TD>\n")
	html_file.write("</TR>\n")

	#max draw down
	html_file.write("<TR>\n")
	html_file.write("<TH>Max Draw Down:</TH>\n")
	for year in years:
		drop=getYearMaxDrop(funds,year)
		html_file.write("<TD>\n")
		print >>html_file, "%.2f" % (drop*100)
		html_file.write("%</TD>\n")
	html_file.write("</TR>\n")

	#yearly sharpe ratio using daily rets
	html_file.write("<TR>\n")
	html_file.write("<TH>Daily Sharpe Ratio:</TH>\n")
	for year in years:
		ratio=tsu.getYearRatio(funds,year)
		html_file.write("<TD>\n")
		print >>html_file, "%.2f\n" % ratio
		html_file.write("</TD>\n")
	html_file.write("</TR>\n")


	#yearly sharpe ratio using monthly rets
	html_file.write("<TR>\n")
	html_file.write("<TH>Monthly Sharpe Ratio:</TH>\n")
	for year in years:
		ratio=getYearRatioUsingMonth(funds,year)
		html_file.write("<TD>\n")
		print >>html_file, "%.2f\n" % ratio
		html_file.write("</TD>\n")
	html_file.write("</TR>\n")
	
	html_file.write("</TABLE>\n")
	html_file.write("<BR/>\n\n")

	vals=funds.values;
	vals2=np.append(vals,funds2.values,2)


	df=DataMatrix(index=funds.index,data=funds.values, columns=['fund'])
	df2=DataMatrix(index=funds2.index,data=funds2.values,columns=['other'])
	df['other']=df2['other']

	corrcoef=numpy.corrcoef(funds.values[0:-1],funds2.values)
	html_file.write("<H3>Correlation=")
	print >>html_file, "%.2f\n" % corrcoef[0][1]
	html_file.write("<H3>\n")
	html_file.write("<BR/>\n\n")


	#montly returns
	mrets=tsu.monthly(funds)
	html_file.write("<H2>Monthly Returns</H2>\n")
	html_file.write("<TABLE CELLPADDING=10>\n")
	html_file.write("<TR>\n")
	html_file.write("<TH></TH>\n")
	month_names=du.getMonthNames()
	for name in month_names:
		html_file.write("<TH>"+str(name)+"</TH>\n")
	html_file.write("</TR>\n")

	i=0
	for year in years:
		html_file.write("<TR>\n")
		html_file.write("<TH>"+str(year)+"</TH>\n")
		months=du.getMonths(funds,year)
		for month in months:
			html_file.write("<TD>\n")
			print >>html_file, "%.2f\n" % (mrets[i]*100)
			html_file.write("%</TD>\n")
			i+=1
		html_file.write("</TR>\n")
	html_file.write("</TABLE>\n")
	html_file.write("<BR/>\n\n")

	#fund value graph
	fundlist=[];
	fundlist.append(funds)
	fundlist.append(funds2)
	converter.fundsToPNG(fundlist,'funds.png')
	html_file.write("<IMG SRC=\'./funds.png\'/>\n")
	html_file.write("<BR/>\n\n")
	
	#end
	html_file.write("</CENTER></BODY>\n\n")
	html_file.write("</HTML>")