I would like to add a row every day at midnight to my Google Sheet containing two columns: 1st the current date, 2nd the cell value from another sheet (portfolio value). I.e.: I want to make a graph to see the development of my stock portfolio value over time. I read somewhere that you could do it with the script editor, but couldn't find a good enough example for me to understand.

I am thankful for any help and comments. Cheers!

I would like to add a row every day at midnight to my Google Sheet containing two columns: 1st the current date, 2nd the cell value from another sheet (portfolio value). 
I.e.: I want to make a graph to see the development of my stock portfolio value over time. 
I read somewhere that you could do it with the script editor, but couldn't find a good enough example for me to understand.