MarkdaleMGMT / ReportingDashboard

Resources & Code to support our PowerBI reporting dashboard
0 stars 0 forks source link

Investment vs Benchmark Chart #8

Closed RiskingTime closed 7 months ago

RiskingTime commented 9 months ago
yumengwang0515 commented 8 months ago

For Canadian and US, in one chart or separated charts? total return?

RiskingTime commented 8 months ago

each investment should be in its own chart and compared to a relevant benchmark

yumengwang0515 commented 8 months ago

fixed

yumengwang0515 commented 8 months ago

using vlookup

  1. -cashflow
  2. initial value negative
  3. sum of cashflow
  4. xirr * date diff/365
  5. adding each new irr to initial value starting from 100