# Does anyone Track their Portfolio with another Application?

**URL:** <https://forum.alpaca.markets/t/does-anyone-track-their-portfolio-with-another-application/5038>\
**Category:** Alpaca Trading\
**Created:** [March 19, 2021, 4:26pm UTC](https://forum.alpaca.markets/t/does-anyone-track-their-portfolio-with-another-application/5038 "2021-03-19T16:26:44Z")\
**Posts on this page:** 1\
**Showing post:** 20

<div class="post-metadata">

**Author:** ![Xavier\_Robitaille](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.alpaca.markets/xavier_robitaille/32/2364_2.png) [@Xavier\_Robitaille](https://forum.alpaca.markets/u/Xavier_Robitaille)\
**Post date:** [October 18, 2021, 5:04pm UTC](https://forum.alpaca.markets/t/does-anyone-track-their-portfolio-with-another-application/5038/20 "2021-10-18T17:04:47Z")

</div>

> [@covariancematrix](#):
>
> Would it be possible to reconcile trades in my account back to ~ August 4 (after LB/BBWI corporate actions)?

It should now work. The easiest way to get your history is to reset your portfolio and re-import your transaction history from scratch:

1. Top Right Menu \>\> Profile \>\> “Reset my Account”
2. Top Left Menu \>\> “Refresh Linked Accounts”

Note that it can take up to ~1 minute to update your portfolio given the large number of transactions (optimizations are in the pipeline to speed things up).

> [@covariancematrix](#):
>
> I’ve had difficulty validating and analyzing my trading results with Alpaca. Sometimes Alpaca’s equity report and portfolio history endpoint are not updated for 2-3 days at a time (this seems to coincide with high market volatility) and I cannot fully analyze what is driving the returns during those periods.

We’ve developed a PL Attribution report to help users slice and dice their PL:

- `position_pl = position_as_of_start_date x market_change`
- `new_trades_pl = PL of trades in period startDate:endDate`

and, because you only have activities of type “FILL” for this period:

- `PL = mtm_end_date - mtm_start_date = position_pl + new_trades_pl`

Also note that:

- note that the current version of this spreadsheet assumes all activities are of type “FILL” (which are the only activities you have in your portfolio).
- both sources of PL (i.e. Position PL & New Trades PL) are broken down by symbol so that you can pin point where your profit or losses are coming from.
- PL in cell F7 should reconcile with PL in cell F12 (if you’re analyzing PL over a period of several days, these may not reconcile e.g. if there are too many transactions for the number of rows in our spreadsheet)
- also note that you will be the first beta user of this spreadsheet, so bear with us if any kinks need to be ironed out.

[https://docs.google.com/spreadsheets/d/1y00Yf4h\_9ubAsy43s0WShHAS5WdJn4vEXeGWFxAgDZ8/edit#gid=2046997999](https://docs.google.com/spreadsheets/d/1y00Yf4h_9ubAsy43s0WShHAS5WdJn4vEXeGWFxAgDZ8/edit#gid=2046997999)

 ![FF_PL_Attribution](https://us1.discourse-cdn.com/flex020/uploads/alp/original/2X/b/b362ec506d52a0587991e31fd638cee814f17040.jpeg)

---

_[View the full topic](https://forum.alpaca.markets/t/does-anyone-track-their-portfolio-with-another-application/5038)._
