log data daily

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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:
 
Back
Top