Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Daily Portfolio Movements ... no Start Value
Hi Vidas,
I am encountering the following issues with the "DAILY" worksheet. Typically, I check the performance of my holdings on a weekly and monthly basis. The same I did the week of 4/27 and 4/30. Through 4/27 everything worked ok, but on 4/30 the worksheet missed the "Start Value" which resulted in the effect that the "Capital Gain" is the value of my entire holdings. From 5/4 (weekly) everything worked ok again.
What could be the reason for that? As far as I can see, all data files contain quotes for 4/30.
Thank you, rgds.
Ralph
I am encountering the following issues with the "DAILY" worksheet. Typically, I check the performance of my holdings on a weekly and monthly basis. The same I did the week of 4/27 and 4/30. Through 4/27 everything worked ok, but on 4/30 the worksheet missed the "Start Value" which resulted in the effect that the "Capital Gain" is the value of my entire holdings. From 5/4 (weekly) everything worked ok again.
What could be the reason for that? As far as I can see, all data files contain quotes for 4/30.
Thank you, rgds.
Ralph
Comments
Your hint got me on the right track. It was not the missing quotes, but two missing dates in the "DATES" file. I am getting to understand this amazing tool every day better. Thanks for your quick support.
Rgds.
Ralph