Automate net asset value (NAV) calculation on your stock portfolio
Calculate your stock portfolio performance with Net Asset Value based on units in excel
Tracking a stock portfolio in excel (auto update)
Compare the performance of your stock portfolio to S&P 500 using Excel
Calculating NAV-units
Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel CourseMost used functions
COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP functionFormula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup