Google sheets track the value of a cell on a daily basis

I'm trying to create a log/historical sheet that tracks the the value of a live cell ("C4") on a daily basis. I've attached an image of what I want the output to look like. The sheet name is "PRThistory" and the cell which changes on a daily basis is "C4". I've already tried running my own code however I havevn't been successful. I hope someone can help me out on this. Thanks.

function HistoryLog() {

var ss = SpreadsheetApp.getActiveSpreadsheet();

var sheet = ss.getSheetByName("PRThistory");

var source = sheet.getRange("C4");

var values = source.getValues();

values[0][0] = new Date();

sheet.appendRow(values[0]);

};

Image: https://i.stack.imgur.com/Jeu3S.jpg

from Recent Questions - Stack Overflow https://ift.tt/3dFHZoj
https://ift.tt/eA8V8J