I have a column that has evolved over months and I have another spreadsheet with my positions (my stocks, # of stocks, dividends payout and dividend yield). Those won't move. However, some of my stocks pay monthly and others pay quarterly on specific months. So how do I set up a command that will help me create a diagram?
If you want to know portfolio gain, calculate the total return for each position (capital gain/loss + dividends + interest). Sum them all and you have the total return of your porfolio.
Sum the components if you want to break this down into separate categories.
FWIW, all gains come from share price appreciation and if there is any interest. IOW, a dividend does not provide total return.