Each file = one fund Only needs Date & NAV columns All metrics auto-computed
Supports .xlsx · .xls · .csv
☑
Select funds to analyse
Click funds in the sidebar (any number)
Computing metrics...
Snapshot
Rolling Returns
Time Series
Conditional Returns
Map Columns -
Data Preview (first 5 rows)
Column Mapping
Date Column
The NAV date / period column
NAV Column
Net Asset Value (₹ per unit)
Please select both Date and NAV columns.
Add Favorite from MF API
Search by fund name or enter a scheme code directly
Search fund name
Example: HDFC Top 100 or Parag Parikh Flexi Cap
MF scheme code
Scheme Code
Auto-fills when you select a search result
Group
Optional - empty auto-fills from MF API category
Please enter a valid scheme code or pick a search result.
Map Holdings Workbook
Import your current portfolio and project scenario ranges
Data Preview (first 5 rows)
Column Mapping
Scheme Name
Fund or scheme name from your portfolio statement
Units
Optional - used if current value is missing
Invested Value
Optional - shown for context in the summary table
Current Value
Preferred base value for forward scenario projection
Portfolio Holding Date
NAV comparison uses the latest available date before this date
Please select at least Scheme Name and either Current Value or Units.
Edit fund
Rename or move this fund to another sidebar group
Scheme
Code:
Group
Leave empty to use Ungrouped
Rolling Return Detail
Underlying rolling-return rows
Portfolio Holding Date
Set the date for this import - NAV comparison uses the prior trading day
Holding Date
Default is today. Change this if you are importing a statement from an earlier date - the NAV match will use the latest available NAV before this date.
Find & assign fund
Search MF API and assign the correct fund to this holding
Holding
Search MF API
Add holding
Search a mutual fund first, then enter your holding details
Search MF API
Selected Fund
Holding Name
Units
Invested Value
Current Value
Please select a fund and enter at least units or current value.