Forum Discussion
Investment Tracker YTD Return Error
I'm using the Investment Tracker template and most stocks entered work fine. There are a few, like Vanguard Tot Bd;ETF (XNAS:BND) that produce a #FIELD! error in the Return columns (YTD, 1m, 1y, etc). How to fix?
2 Replies
Perhaps you may share template you use? Microsoft has at least two investment tracker templates.
SergeiBaklan I'm not even sure how I stumbled into this template or what it's called but attached is what it looks like. I would guess whatever feed the template is using for the stock information doesn't contain the data but that just seems odd since the questionable stocks do have the data. See second attachment for error and examples. Notice the "Last Trade Time" field shows differently too.
