Calculate Year to Date Investment Returns in Excel with STOCKHISTORY Function

Calculate the year-to-date returns for investments using the STOCKHISTORY function in Excel. #excel #returns #ytd #year-to-date #stockhistory

[eliedenii]

Excellent tip but you should mention STOCKHISTORY requires Office 365

[CurtisBooksMusic]

Is there a way to do this so that the ending date automatically fills to today or yesterday? Ideally I'd like to add trailing 3/6/12 month returns without having to change the date everytime. Isd that possible?