Checking the history of my total portfolio value including cash

Q&A
1

Hi Evan,

I’m wondering if there’s a way to see the historical total value of my portfolio, including the cash component.

I understand from the blog post “Cash Balance 3.0” (https://blog.stocks.cafe/817/cash-balance-3-0-add-cash-to-portfolio/) that the Portfolio Reports don’t include cash because they require accurate historical data.

Is there any other way to view the historical trend of my total portfolio value with cash included?

Thanks for your help

2

Hi John,

Sorry, it is not possible as far as I remember because as you mentioned, the cash balance is not stored historically.

Evan

3

Hi Evan,

Thanks for the quick reply.

I have a follow-up question: Would using the “Custom Asset” feature be a potential workaround?

My thought is to create a custom asset called “Cash” and then manually input its value through transactions. For example, I could create a buy transaction to represent my cash holdings. My hope is that this would allow the cash value to be included and tracked historically within the main portfolio reports.

Based on the blog (https://blog.stocks.cafe/817/cash-balance-3-0-add-cash-to-portfolio/)it seems like this might be possible, but I wanted to ask if you foresee any issues with this approach. For instance, the blog recommends tracking custom assets in a separate portfolio because they don’t have daily values unless updated manually, which might affect some metrics.

Would this be a reasonable way to get a historical view of my total portfolio value (including cash), or are there other limitations I should be aware of?

Thanks again,
John

4

Hi John,

  1. That might be a potential approach.

  2. It will reduce the volatility of your portfolio since CA do not have daily values. However, it is fine in this case since cash do not have volatility.

  3. I suggest you test this approach with a few data points before spending time to populate all your data points.

Cheers,
Evan

5

Hi Evan,

That’s great to hear. Thanks for confirming that this approach should work and for the tip about testing it with a few data points first. I’ll give that a go.

Cheers,
John

1 Like