Hi,
I am creating a log of trades in the stock market (file attached). Now I need to plot the portfolio value on each date. However, trades might not be happening everyday. Is there a way I can get a value for my networth each day ? It would also be nice to display the annualised return as a callout on the netwroth curve.
Thanks.
An easy way may be to produce a helper column for each stock as modeled in the attached copy of the file. The helper columns are populated using:Formula:
Please Login or Register to view this content.
Column is then populated using: =SUM(K2:M2)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks