Excel template for tracking daily portfolio performance

1,161 Views | 1 Replies | Last: 1 yr ago by trip98
H-town ag
How long do you want to ignore this user?
AG
I may be overcomplicating this question ...

I am an active trader using futures, options, and shares. I am wanting to track my daily / monthly portfolio performance in excel and to account for my inflows and outflows. I make about 5-10 cash transactions a month.

Easily I have my daily starting balance, ending balance, and simple return on a daily basis, also with any purchases / redemptions.

I am searching for an excel template to account for a time-weighted return.

Any thoughts?
trip98
How long do you want to ignore this user?
AG
I have a rudimentary Excel file that I put together. But I don't trade as much as I did for a while.
I have one tab that's my total cash in and out. I have another tab for tax impact both short and long-term. Then I have a tab just for stocks and another tab for options
Refresh
Page 1 of 1
 
×
subscribe Verify your student status
See Subscription Benefits
Trial only available to users who have never subscribed or participated in a previous trial.