donheff
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
I just invented some designators for fund type based on my own assessment I then add up the %of portfolio for all funds in those types for calculating my AA -- basically, it is a manual, subjective calculation. I add up equities and bonds and then break those up by small cap, value, and international. Fairly close but not scientific.How do you get YTD info and fund type? Are these special functions or different parameters of GoogleFinance function?
YTD is a GF function -- =GoogleFinance(B7,"returnytd") where B7 is the ticker cell for the fund in row 7. There are other functions I use, like 12 mth distribution yield -- =GoogleFinance(B7,"yieldpct") and 1 yr total return -- =GoogleFinance(B7,"return52"). I look at those to evaluate which funds should be tapped for periodic withdrawals.
The key current price value returned every evening to track portfolio values is -- =GoogleFinance(B7;"closeYest"). Like others, I periodically update the numbers to reflect changes due to distributions. Some people do this automatically but I don't like giving any other sites access to my fund sites so I update manually every few months.
I borrowed the concept from a sheet someone here posted years ago and then modified it to give me what I am interested in.