When you upload position files into FundApps, these represent a snapshot of what each portfolio looks like on that particular day (as defined by NavDate).
If you upload the same portfolio on different NavDates, both will be saved.
If you upload data for the same portfolio on the same NavDate, the first snapshot will be overwritten by the second snapshot.
Considering some scenarios
Scenario 1 - Day 1 to Day 2
If you upload a file with multiple portfolios:
PortfolioId | NavDate | AssetId | AssetClass | Quantity |
Portfolio1 | 2015-01-03 | Asset1 | Equity | 45 |
Portfolio1 | 2015-01-03 | Asset2 | Equity | 20 |
Portfolio2 | 2015-01-03 | Asset1 | Equity | 10 |
(Note that you can only upload for one NavDate per file)
Then you'll receive results for Portfolio 1 and 2, for the NavDate January 3rd 2015.
You then upload:
PortfolioId | NavDate | AssetId | AssetClass | Quantity |
Portfolio1 | 2015-01-04 | Asset1 | Equity | 50 |
Portfolio1 | 2015-01-04 | Asset2 | Equity | 20 |
Portfolio2 | 2015-01-04 | Asset1 | Equity | 30 |
You'll get results for Portfolio 1 and 2 for the NavDate on January 4th, based on changes in your holdings from January 3rd.
Scenario 2 - Uploading portfolios in an aggregation separately
Continuing from Scenario 1:
Portfolio 1 and 2 are part of an Aggregation that includes Portfolio 3 which has, up to this stage, been missing.
As part of scenario 1, you'd have received a result for Portfolio 1 and 2 (if required, but also the aggregated result. You would have also got a breach on one of our validation rules in the UI that would be saying you've uploaded 2 portfolios, but we're expecting one more (Portfolio 3) before the aggregated check is complete.
When you upload a file for the 4th of January just including Portfolio 3:
PortfolioId | NavDate | AssetId | AssetClass | Quantity |
Portfolio3 | 2015-01-04 | Asset1 | Equity | 5 |
Portfolio3 | 2015-01-04 | Asset2 | Equity | 15 |
The engine will run again and include portfolio 3, so you'll get results for portfolios 1,2, and 3, and also the aggregated result. This time, without a breach about missing portfolios.
Scenario 3 - Uploading the same portfolio more than once a day.
If during the day, you decide to rerun the following file:
PortfolioId | NavDate | AssetId | AssetClass | Quantity |
Portfolio3 | 2015-01-04 | Asset1 | Equity | 2 |
You'll receive updated results again for Portfolio 1, 2, and 3, and the Aggregated result. But this time as if Portfolio 3 only ever had 1 asset in. (It would not update Asset1's quantity from 5 to 1)