Market Value by Day by Quarter.

[aviator]

Hi Mark,

My brokerage house has changed the way fees are calculated. Instead of using market values at the end of a quarter, they now calculate fees daily based on each days market value. At the end of the quarter the rolled up daily fees are deducted.

The Portfolio Value report has no date range. What's the best way to capture daily market values at the sub-portfolio level? What I'm really looking for is the average daily market value for a specified date range (in this case, the preceding quarter).

[Mark]

Hi aviator,

If you're using the Professional or Advisor version, you can define your own Custom report field to calculate this. Use an equation like:

AVERAGE(STARTDAYS() ,ENDDAYS() ,End_value ,0 )

which will give you the average closing value for the date range of the report, excluding weekends. So, just set your report dates for the last quarter.

If you're using the Personal version, you could export the daily portfolio value amounts using "File / Export / Other / Portfolio Value...". This would dump the daily portfolio values to a CSV file which could be used in a spreadsheet to calculate whatever you want. You can also export any graph data points to a CSV file, so you could plot the Portfolio Value graph for the date range you want, and use "File / Export / Other / Graph Data Points...".

[Djobydjoba]

Wow, a lot of views on this 5 days old topic!

[Mark]

That's interesting, not sure how that happened...