Use the swap uploader on SWPM to save the deals and "CUSIP" them (starts with "S" and has a Corp tail). I believe you can then reference them through the Excel add-in by the "CUSIP"
Another way using Excel is if you have an Anywhere subscription, you can make use of the Derivatives toolkit and structure/price/analyze your swaps all in the sheet.
I've built an Excel Add-in (https://www.excelpricefeed.com/) which enables retrieval of data from Yahoo Finance (as well as other data providers). The Add-in currently provides live and historic prices to Excel cells via simple formulas such as:
=EPF.Yahoo.Historic.Close("TSLA", "1 May 2019")
It also has a UI for bulk downloading ...