Portfolio Allocation Sharp Ratio Comparisson


I am trying to back test several different allocations and compare sharp ratios etc.
I have access to portfolio charts but that doesn’t give you real name ETFs or sharp. I have also tried Curvo but not everything I want is there. Had a go at making a spreadsheet in google sheets but then finding for some ETFs data missing and it’s odd as it’s recent data or jumps in data for ETFs which are clealy trading eg: BCOG

Any suggestion on how to achieve the end goal much appreciated thanks