log data daily
 

I have a sheet that will calculate the value of a portfolio based on current
stock prices. I want to be able to have it record the value at the end of
each day in a list to be plotted etc... Any suggestions?

log data daily
 

Create a BeforeClose (or BeforeSave or both) event sub which saves the date
and the value of a portfolio into the list (e.g. in columns A,B of a "history
sheet"!

Regards,
Stefi

€žParker€� ezt Ã*rta:

I have a sheet that will calculate the value of a portfolio based on current
stock prices. I want to be able to have it record the value at the end of
each day in a list to be plotted etc... Any suggestions?