← Back to Templates

Returns Analysis - MTD, YTD, 3 month

Description

Returns Analysis - MTD, YTD, 3 month thumbnail

Reports return over several windows at once for a list of holdings: seven day, fifteen day, one month, month to date and quarter to date, each from its own MarketXLS formula. Reading them together separates a name that has drifted up steadily from one that jumped last week, which any single period figure hides. Sector and industry tags let the same table be collapsed into group performance. Drop your tickers into the first column and every return column fills in when the workbook refreshes with the add-in connected.

Template Screenshots

Returns Analysis - MTD, YTD, 3 month screenshot 1