Sachin Filinto
New Member
Have been using chandoos's MF tracker for a while. ( https://chandoo.org/wp/2009/12/28/mutual-fund-tracker-excel )
oven a period i have made some enhancements and customization to suit my needs and prefer this excel file over all the other solutions i have tried out.
looking for some guidance on one of the enhancements i have tried to incorporate without any luck.
web query to lookup the latest NAV works as expected, but along with the NAV i would like to have the date which is also downloaded in the web query. This would help me validate the NAV value is current as of that very day.
from what i see the NAV value is looked up from the "NavPivot" tab (named range = fund_navs). however this named range does not contain the date field which is available from the "Latest NAV Sheet" sheet.
I don’t have the expertise to understand how the “fund_navs” named range is pulling data from the "Latest NAV Sheet" sheet.
would appreciate a direction to be able to put the date field.
i could not upload the file as it exceeds the allowed size, hence i have made it available at https://drive.google.com/drive/folders/1gaI7hHw5c8ZKNusGK0Z6snKFk-uwQDEn?usp=sharing
oven a period i have made some enhancements and customization to suit my needs and prefer this excel file over all the other solutions i have tried out.
looking for some guidance on one of the enhancements i have tried to incorporate without any luck.
web query to lookup the latest NAV works as expected, but along with the NAV i would like to have the date which is also downloaded in the web query. This would help me validate the NAV value is current as of that very day.
from what i see the NAV value is looked up from the "NavPivot" tab (named range = fund_navs). however this named range does not contain the date field which is available from the "Latest NAV Sheet" sheet.
I don’t have the expertise to understand how the “fund_navs” named range is pulling data from the "Latest NAV Sheet" sheet.
would appreciate a direction to be able to put the date field.
i could not upload the file as it exceeds the allowed size, hence i have made it available at https://drive.google.com/drive/folders/1gaI7hHw5c8ZKNusGK0Z6snKFk-uwQDEn?usp=sharing